<html>
<head><title></title>
<body>
<?php
if (!isset($_POST['sav_data'])) {
$SQL_Host="localhost";
$SQL_Username="username";
$SQL_Database="database";
$SQL_Password="password";
//Connecting to SQL Server & Opening Database//
$SQL_Connect=mysql_connect($SQL_Host, $SQL_Username,$SQL_Password) or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ($SQL_Database);
$Open_Database=mysql_select_db ($SQL_Database,$SQL_Connect) or die('Cant Choose Database Becouse' . mysql_error());
//Table 1 the whole page//
echo '<table border="0" width="100%" cellspacing="0" cellpadding="0">';
echo '<tr>';
echo "Codes" . "<br />";
echo '</tr>';
echo '<tr>';
//Bringing Data From Database//
$Brg_Data="SELECT * FROM user";
$Brg_Query=mysql_query($Brg_Data);
$Brg_Rows=mysql_num_rows($Brg_Query);
//Table 2 //
echo '<table border="0" width="100%" cellspacing="0" cellpadding="0">';
echo '<tr>';
echo '<td>';
//Table 3 the data table//
echo '<table border="2" width="100%" cellspacing="0" cellpadding="0" bordercolor="#000000">';
echo '<tr>';
echo '<td>';
echo "name";
echo '</td>';
echo '<td>';
echo "phone" ;
echo '</td>';
echo '</tr>';
$i=0;
?>
<form action="<?php $_SERVER['PHP_SELF']; ?>" method="post">
<?php
While ($i < $Brg_Rows){
echo '<tr>';
echo '<td>';
$Import_name=mysql_result($Brg_Query,$i,"name");
echo $Import_name ;
echo '</td>';
echo '<td>';
$Import_phone=mysql_result($Brg_Query,$i,"phone");
?>
<input type=text name="phone<?php echo $i; ?>" value="<?php echo $Import_Code;?>">
<?php
echo '</td>';
echo '</tr>';
$i++;
}
echo '</table>';
//End of Table 3//
echo'</td>';
echo '<td>';
?>
<input type="submit" value="Save" name="sav_data">
</form>
<?php
echo '</td>';
echo '</tr>';
echo '</table>';
//End of table 2//
echo '</tr>';
echo '<tr>';
echo '</tr>';
}
else {
$i2=0;
while ( $i2 < $Brg_Rows ){
$Save_Code=$_POST['phone'.$i2] ;
$DB_Code=mysql_result($Brg_Query,$i2,"phone");
if ($Save_Code=$DB_Code){
$i2++;
echo "No Changes";
}
else {
echo '<h1 align=center>'."Saved Codes".'</h1>'.'<br>';
echo '<table border="2" width="100%" cellspacing="0" cellpadding="0" bordercolor="#000000">';
echo '<tr>';
echo '<td>';
echo "name";
echo '</td>';
echo '<td>';
echo "phone" ;
echo '</td>';
echo '</tr>';
$Up_Code="UPDATE Codes SET phone='".$Save_Code."' WHERE ID='".$i2."'";
$Up_Query=mysql_query($Up_Code);
$DB_phone2=mysql_result($Con_Num,$i,"phone");
echo '<tr>';
echo '<td>';
echo $Import_name;
echo '</td>';
echo '<td>';
echo $DB_phone2;
echo '</td>';
echo '</tr>';
echo '</table>';
$i2++;
}
}
}
?>
</body>
</html>
Thats my code guys but my problem here is how to save