The World of PHP : Input Data in Database with Form Part 2

Continuation of Input Data in Database with Form Part 1...

Input Data to Database with Form

Follow steps below to make form for input data into database. Let's follow steps.

1. Write script below use your text editor to make file connection to connect to localhost and select database and then save with name connect.php.

<?php

$server="localhost";

$user="root";

$password="";

mysql_connect("$server","$user","$password") or exit("Failed select DB.");

mysql_select_db("db_exercise") or exit("Failed select DB.");

2. Write script below use your text editor to make form and save with name form_biodata.php.

<html>

<head>

<title>Form Biodata</title>

</head>

<body>

<h3>Form Biodata</h3>

<tr>

</tr>

<tr>

<td>Address</td>

</tr>

<tr>

</tr>

</table>

</form>

</body>

</html>

3. Write script below use your text editor to make file program process input and then save with name process_input.php.

<?php

include("connect.php");

$name=$_POST['name'];

$address=$_POST['address'];

$query="INSERT INTO biodata (name,address) VALUES ('".$name."','".$address."')";

$sql=mysql_query($query);

echo "Data Successfully Added";

echo "<br />";

include("view_data.php");

4. Write script below use your text editor to make view data in database db_exercise and then save with name view_data.php.

<html>

<head>

</head>

<body>

<h2>List Biodata</h2>

<th>Alamat</th>

</tr>

<?php

include("connect.php");

$query= "SELECT id,name,address FROM biodata";

$sql= mysql_query($query) or exit("Error query: <b>".$sql."</b>.");

while($data= mysql_fetch_assoc($sql)){ ?>

<tr>

</tr>

<?php

}

</table>

</body>

</html>

Now let's see output of scripts above.

Output of form_biodata.php.

Typing of data in form form_biodata.php.

Output of after data is inserted from form above.

Function include("view_data.php"); in file process_input.php is use to include the code in the file viwe_data.php in file process_input.php.

Tanks for visit and read my article... See you in my next article...

Learn and learn again...

The World of PHP

Tuesday, November 27, 2012

Input Data in Database with Form Part 2

2 comments: