Php Code: Add and Edit Multiple Database Records

When you have more works with your database than a single adding/editing of a record, it is harder to handle them. By this scrip you are able to add new data and edit current records of your database all at once! It also has automatic setup if the needed database was not available.
just enter your database connection information at top and Enjoy!

<!-- This Script is from www.phpfreecpde.com, Coded by: Kerixa Inc-->
<?php
	$host="localhost"; // Host name
	$username="root"; // Mysql username
	$password=""; // Mysql password

function setup(){
echo('
<p style="color: #008000;	text-align: left;	font-size: 15pt;"">-Automatic setup is started...</p>
');
global $host,$username,$password,$link;
//$link=mysql_connect($host, $username, $password);
$sql= 'CREATE DATABASE info';
if (!mysql_query ($sql, $link)) die('
<p style="text-align: center;	font-size: 20pt;"><span style="color: #FF0000;">Failed to 
create database! </span><br><span style="font-size: 12pt;">&gt;&gt;Please check the parameters and database server&lt;&lt;</span></p>
');
$sql = "CREATE TABLE `info`.`info1` (
`ID` INT NOT NULL ,
`information` TEXT NOT NULL
) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;";

mysql_query($sql) or die('Setup Failed');
echo('
<p style="color: #008000;	text-align: left;	font-size: 15pt;"">-Automatic setup completed successfully. Your Database is ready!</p>
');
}

$link=mysql_connect($host, $username, $password);
if(!$link) die('
<p style="text-align: center;	font-size: 20pt;"><span style="color: #FF0000;">Failed to connect to the database! </span>
<br><span style="font-size: 12pt;">&gt;&gt;Please check the parameters and database server&lt;&lt;</span></p>
');

$db_name="info"; 
$result=mysql_select_db($db_name);
if(!$result){
	setup();
}
if (isset($_GET['type'])){
	$sql="SELECT * FROM info1";
	$result=mysql_query($sql)or die(mysql_error());
	$count=mysql_num_rows($result);
	for($cn=1;$cn<=$count;$cn++){
		$info=$_POST["txtI$cn"];
		$sql2 = "UPDATE `info`.`info1` SET `information` = '$info' WHERE `info1`.`ID` = $cn  LIMIT 1;";
		$result2=mysql_query($sql2) or die(mysql_error());
	}
	$j=1;
	while (isset($_POST["info$j"]) && $_POST["info$j"]!=""){
		$id=$count+$j;
		$info=$_POST["info$j"];
		$sql3="INSERT INTO info1(ID,information)VALUES('$id', '$info')";
		$result3=mysql_query($sql3);
		if (!$result) die (mysql_error());
		$j++;
	}
}
?>

<form method="post" action="<?php echo $_SERVER['PHP_SELF'].'?type=update' ?>">
<table style="border: 1px solid #000000;width: 600" align="center">
	<tr>
		<td style="font-family: 'Times New Roman', Times, serif;font-size: 17pt;text-align: center;width: 151px;color: #2214B9;border-style: solid;border-width: 1px;"><strong>ID</strong></td>
		<td style="font-family: 'Times New Roman', Times, serif;font-size: 17pt;text-align: center;color: #2214B9;border-style: solid;border-width: 1px;">
			<strong>Information</strong></td>
	</tr>
<?php
$sql="SELECT * FROM info1";
$result=mysql_query($sql);
$cntr=1;
while($rows=@mysql_fetch_array($result)){
	$cntr++;
?>
	<tr>
		<td style="width: 151px;border-style: solid;border-width: 1px;text-align: center; height: 47px; font-size: 14pt;">
		<strong><?php echo $rows['ID'] ?></strong></td>
		<td style="border-style: solid;border-width: 1px; height: 47px; padding-left: 8px">
			<input name="txtI<?php echo $cntr-1 ?>" type="text" style="height: 29px; width: 312px" value="<?php echo $rows['information'] ?>">
		</td>
	</tr>
<?php } ?>
<?php 
for ($i=0;$i<=2;$i++){
?>
	<tr>
		<td style="border-style: solid;border-width: 1px;text-align: center;width: 151px; height: 51px; font-size: 14pt;">
		<strong><?php echo $cntr+$i?></strong></td>
		<td style="border-style: solid;border-width: 1px;padding-left: 8px; height: 51px;">
			<input name="info<?php echo $i+1 ?>" type="text" style="width: 314px; height: 28px;">&nbsp;&nbsp;
			<em>*New Row <?php echo $i+1 ?></em></td>
	</tr>
<?php } ?>
</table>

<div style="text-align: center; height: 15px">
	<br>
<input name="Submit" type="submit" value="Save & Update" style="height: 35px">
	<br>
		
<br style="font-size: 8pt"><font face="Tahoma"><a target="_blank" href="http://www.phpfreecode.com/"><span style="font-size: 8pt; text-decoration: none">PHP Free Code</span></a></font></div>
</form>

If you don't know how to use this code or need more information Click here!

Php Best Codes

Php Code: Add and Edit Multiple Database Records

Review

Links