Fetching from database (a complete example)

by · February 9, 2013

MySql Table Structure (newrecords)

Column Type Null Default Comments
ID int(11)
 No     
Name varchar(20)
 No     
Class varchar(20)
 No     

Complete Example

<!DOCTYPE HTML>
<html>
    <head>
        <title>The Complete Example</title>
    </head>
<body>
<p style="font-weight: bold;">Records</p>
<hr>
<form name="form1" action="">
  <p>
    <label for="Name">Name</label>
    <input type="text" name="Name" id="Name">
  </p>
  <p>
    <label for="Class">Class</label>
    <input type="text" name="Class1" id="Class1">
  </p>
    <p>
    <input type="submit" name="Submit" id="Submit" value="Submit">
  </p>
</form>
<p style="font-weight: bold;"> all entered data </p>
<hr>
<?php
$db_server = mysql_connect("localhost", "username", "password");
if (! $db_server)
    die("Unable to connect to MySQL: " . mysql_error());
mysql_select_db("database_Name", $db_server) or
         die("Unable to select database: " . mysql_error());

if ((isset($_GET['Name'])) && (! empty($_GET['Name'])) && (! empty($_GET['Class1'])) && (! empty($_GET['Class1']))) 
{
    
    $query = "INSERT INTO newrecords(Name,Class) VALUES('" . $_GET['Name'] . "','" . $_GET['Class1'] . "');";

    $result = mysql_query($query);
    if (! $result)
    die("Database access failed:  " . mysql_error());
    else
    echo "record inserted";
}

if ((isset($_GET['delete'])) && (! empty($_GET['delete']))) 
{
    $query = " DELETE FROM `newrecords` WHERE ID =" . $_GET['delete'];
    $result = mysql_query($query);
    if (! $result)
    die("Database access failed:  " . mysql_error());
    else
    echo "record deleted";
}

$query = "SELECT * FROM newrecords";
$result = mysql_query($query);
if (! $result)
die("Database access failed: " . mysql_error());
$rows = mysql_num_rows($result);
if ($rows > 1) 
{
?>
    <table width="100%" border="1">    
<?php
}

for ($j = 0; $j < $rows; ++ $j) {
$row = mysql_fetch_row($result);
?>
 <tr>
		<td><?php echo $row[0]?> </td>
		<td><?php echo $row[1]?> </td>
		<td><?php echo $row[2]?> </td>
		<td><a href="index.php?delete=<?php echo $row[0] ?>">delete</a></td>
		</td>
	</tr> 
<?php
}
?>
</table>
</body>
</html>
Share

You may also like...

Categories