Skip to main content

User Creation using PHP/MySQL

Username/password Creation in PHP and MySQL. a Simple form is designed to get the username and two passwords the objectives are

1. Both the username and password should contain atleast 6 characters

2. both the passwords should be same

3. upon submitting to the database, the existence of username is checked with the database, if the username already exists, then the user is allowed to select some other, else user is created.

//html file is given below, file name is

<h2>User Registration Form</h2>

<pre>

<form action=”userregis.php” method=”post”>

Enter the username: <input name=”username” type=”text” /> Enter the password: <input name=”password1″ type=”password” />

Confirm the password: <input name=”password2″ type=”password” />

<input type=”submit” value=”create” />

</form>

</pre>

//userregis.php

<?php

include(”dbconnect.php”);

$u=$_POST['username'];

$p1=$_POST['password1'];

$p2=$_POST['password2'];

$query1=”Select * from usertable where user=’$u’”;

$query2=”Insert into usertable values (’$u’,password(’$p1′))”;

if(strlen($u)<6 or strlen($p1)<6)

{

echo “The username and password should contain atleast 6 characters”;

}

else if($p1!=$p2)

{

echo “The Passwords should be same”;

}

else

{

$r1=mysql_query($query1) or die(”Database Selection Failed”);

$num=mysql_num_rows($r1);

if($num==1)

{

echo “The username <h3> $u </h3> is already exists”;

}

else

{

$r2=mysql_query($query2) or die(”Database Insertion Failed”);

if($r2)

echo “Username <h3> $u </h3> is successfully created”;

else

echo “Database Insertion Failed”;

}

}

?>

<?php

include(”dbconnect.php”);

$u=$_POST['username'];

$p1=$_POST['password1'];

$p2=$_POST['password2'];

$query1=”Select * from usertable where user=’$u’”;

$query2=”Insert into usertable values (’$u’,password(’$p1′))”;

if(strlen($u)<6 or strlen($p1)<6)

{

echo “The username and password should contain atleast 6 characters”;

}

else if($p1!=$p2)

{

echo “The Passwords should be same”;

}

else

{

$r1=mysql_query($query1) or die(”Database Selection Failed”);

$num=mysql_num_rows($r1);

if($num==1)

{

echo “The username <h3> $u </h3> is already exists”;

}

else

{

$r2=mysql_query($query2) or die(”Database Insertion Failed”);

if($r2)

echo “Username <h3> $u </h3> is successfully created”;

else

echo “Database Insertion Failed”;

}

}

?>

//dbconnect.php

<?php

$con=mysql_connect(”localhost”,”root”,”abc123″) or die(mysql_error());

$db=mysql_select_db(”dummy”,$con) or die (mysql_error());

?>

Comments

  1. http://www.apachetechnology.net/KC/swphpLogin.aspx

    Please find a good article for creating a simple login & registration page using PHP & MySQL.

    ReplyDelete

Post a comment

Popular posts from this blog

Installing TexLive 2019 in Ubuntu 18.04

Installation of TexLive 2019 in Linux (Ubuntu 18.04 LTS)
TeX (Tech)

Installation of TexLive 2019

Please watch the video for full installation



I used .iso file to download, the Total size is 3.3GB for Linux,

and i used the torrent file to download, it took me just 20 min to download the entire .iso file

Extract the .iso file to a folder and open a terminal

$] sudo ./install-tl
(it goes into a terminal mode, which is faster compared to the GUI Mode)

$] sudo ./install-tl -gui
after the installation, set the PATH, MANPATH and INFOPATH as suggested by LATEX

export PATH=$PATH:/usr/local/texlive/2019/bin/x86_64-linux
export MANPATH=/usr/local/texlive/2019/texmf-dist/doc/man
export INFOPATH=/usr/local/texlive/2019/texmf-dist/doc/info

put these lines in to the /home/pradeepkumar/.bashrc

$] gedit /home/pradeepkumar/.bashrc
We have installed TexLive 2019 and texstudio.

To install texstudio

$] sudo apt install texstudio
The look and feel of TexStudio looks like this image.


texlive, it install everyt…

Implementing a new system call in Kernel version 2.6.32

A system call is used by application or user programs to request service from the operating systems. Since the user programs does not have direct access to the kernel whereas the OS has the direct access. OS can access the hardware through system calls only.The following files has to be modified for implementing a system call/usr/src/linux-2.6.32.5/arch/x86/kernel/syscall_table_32.S/usr/src/linux-2.6.32.5/arch/x86/include/asm/unistd_32.h/usr/src/linux-2.6.32.5/include/linux/syscalls.h/usr/src/linux-2.6.32.5/MakefileNew set of files to be createdCreate a new directory newcall/ inside the path “/usr/src/linux-2.6.32.5/” Create new files Makefile, newcall.c and put them in the /usr/src/linux-2.6.32.5/newcall/ folder Create new user files (in any folder of Linux) to test the system call
testnewcall.c, testnewcall.h (created in /home/pradeepkumar) syscall_table_32.S Find the file /usr/src/linux-2.6.32.5/arch/x86/kernel/syscall_table_32.S and add the following line at the end
"…

Electrical Machine Design (equations)

FactorsDC Machine Transformers Induction Machines Synchronous MachinesOutput EquationPa=CoD2Ln, where Pa=P/h for generators, Pa=P for motorsFor Single Phase
Q=2.22 f Bm Ai Kw Aw d10-3
For Three Phase
Q=3.33 f Bm Ai Kw Aw d 10-3Q=CoD2 L ns
KVA Input Q=
HP * 0.746 / Cos f * hQ=CoD2 L ns
KVA Input Q=
HP * 0.746 / Cos f * h
For Turbo alternators
Q=1.11Bavac KwsVa2 L 10-3/nsOutput CoefficientCo=Bav ac* 10-3where Bav-magnetic loading and ac - electric loadingDNACo=11 Kws Bav ac 10-3Co=11 Kws Bav ac 10-3 Choice of Magnetic LoadingFlux Density in Teeth Frequency of Flux Reversals Size of machineDNAMagnetizing current, Flux Density, Iron lossIron loss, Stability, Voltage Rating, Parallel Operation, Transient ShortCircuit current Choice of Electric LoadingTemperature rise,
speed of machine, Voltage, Armature reaction, CommutationDNAOverload Capacity, Copper losses, Temperature rise, Leakage ReactanceCopper loss, Synchronous reactance, Temperature rise, Stray Load losses,
Voltage rating Flux …