Skip to main content

My first step to PHP-MySQL

This is a very basic php-mysql tutorial and I will be trying to make it as simple as possible, since I it to be helpful for the first timers. This is the part of program when I was starting to learn Php-mysql. I was just trying to create a html form, get some data filled and then save the data in the database. And also displaying those data back. It was a messy code but I felt glad enough since it was a tangible piece of my learning process. Since then, if anyone asked me some help regarding the startup, i used to provide this code for them to play with. And I thought it will be a good idea if I can share it.

a simple html form

<form name="form1" method="post" action="target.php">
<p class="style1" align="left">
<label>Enter your details:</label>
</p>
<table width="421" bgcolor="#cccccc">
<tbody><tr>
<td width="195">Name:
<input name="cust_name" type="text"></td>
<td width="210">Address:
<input name="cust_address" type="text"></td>
</tr>
<tr>
<td>Select your Gender </td>
<td>
Male
<input name="gender" value="MALE" type="radio">
Female
<input name="gender" value="FEMALE" type="radio"></td>
</tr>
<tr>
<td colspan="2">
</td>
</tr>
<tr>
<td colspan="2"><div align="center">
<input name="Submit" value="Submit" type="submit">
</div></td>
</tr>
</tbody></table>
<p> </p>
<p> </p>
</form>



code for target.php file



// ESTABLISH CONNECTION TO THE MYSQL DATABASE
$connection=mysql_connect("localhost","root","") or die("Error in connecting to the database");
$database="store";

$result=mysql_select_db($database) or die("Error: Database cannot be selected");

//NOW GET THE VALUES FROM THE FORM
$name=$_POST['cust_name'];
//cust_name is the name given to the text field in the html form
$address=$_POST['cust_address'];
$gender=$_POST['gender'];


//Now enter the values in the database table "CUSTOMER_TAB"
$query="insert into customer_tab values('".$name."','".$address."','".$gender."')";
$result=mysql_query($query);

if(!$result){ die("query cannot be executed");}

echo"
<h2>Your information has been received and stored in the database</h2>";


//Now access information from database

$query="select * from customer_tab where name='".$name."' ";
$result=mysql_query($query);

if(!$result){ die("query cannot be executed");}

while($row=mysql_fetch_row($result))
{
echo"<b>Name:</b> $row[0] ";
echo"<b>Address:</b> $row[1] ";
echo"<b>Gender:</b> $row[2] ";
}

//now get out of the database
mysql_close($connection);


To run this, you should follow two steps given below:
A. Creating database
1. The database name is "store"
2. The table name is "customer_tab"
3. The table "customer_tab" contains three fields. they are "name","address", "gender"
First of all, create the table in the database and then proceed to step(B)

B. How to run the code:
1. Get these files in a folder named "sample", copy this folder"sample" in the web directory (i.e. www directory)
2. Start a web browser( eg mozilla firefox)
3. Type "http://localhost/sample/myform.html".
4. The form will appear, fill the form. This form submits its data to the "target.php".
Labels:

Comments

Post a Comment

Popular posts from this blog

Python : split any file (binary) to different pieces and join them

This python program takes an input file and then splits it into different smaller chunks. Next it can collect all the different chunks and join it to get the original file. -------------------------------------------------------- # define the function to split the file into smaller chunks def splitFile(inputFile,chunkSize): #read the contents of the file f = open(inputFile, 'rb') data = f.read() # read the entire content of the file f.close() # get the length of data, ie size of the input file in bytes bytes = len(data) #calculate the number of chunks to be created noOfChunks= bytes/chunkSize if(bytes%chunkSize): noOfChunks+=1 #create a info.txt file for writing metadata f = open('info.txt', 'w') f.write(inputFile+','+'chunk,'+str(noOfChunks)+','+str(chunkSize)) f.close() chunkNames = [] for i in range(0, bytes+1, chunkSize): fn1 = "chunk%s...
2 comments
Read more

Installing NS-3 in Ubuntu

Installing testing it and running NS-3 in Ubuntu 10.04 NS-3 is a discrete-event network simulator basically for simulating Internet systems. #The list of Dependency for ns 3.12(sorry if something is missing): sudo apt-get install gcc g++ python sudo apt-get install gcc g++ python python-dev sudo apt-get install mercurial sudo apt-get install bzr sudo apt-get install gdb valgrind sudo apt-get install gsl-bin libgsl0-dev libgsl0ldbl sudo apt-get install flex bison sudo apt-get install g++-3.4 gcc-3.4 sudo apt-get install tcpdump sudo apt-get install sqlite sqlite3 libsqlite3-dev sudo apt-get install libxml2 libxml2-dev sudo apt-get install libgtk2.0-0 libgtk2.0-dev sudo apt-get install libgtk2.0-0 libgtk2.0-dev sudo apt-get install vtun lxc sudo apt-get install uncrustify sudo apt-get install doxygen graphviz imagemagick sudo apt-get install texlive texlive-pdf texlive-latex-extra texlive-generic-extra texlive-generic-recommended sudo apt-get install python-sphinx dia t...
6 comments
Read more

Display dynamic content in Google Earth using KML

Keyhole Markup Language (KML) is a xml standard which can be used to define what and how to present geographic data in Google Earth and Google Maps. Useful examples to start can be browsed via https://developers.google.com/kml/documentation/kml_tut . I have to display KML data in googleearth. And the KML file has to be loaded dynamically and the updates in the kml file should be shown in the googleearth on the fly. For this we have to Create a Network Link. Goto Add -> Network Link Then specify the details as shown in the figure. To specify the frequency of updating the data, go to Refresh tab. The code for dynamicKML.kml is as follows: junk.kml onInterval 5 Note that, we are using a local file junk.kml   ( junk.kml and dynamciKML.kml reside in the same directory) to define the content to be displayed in the google earth interface. This can even be a remote file in which case we have t...
Post a Comment
Read more