Add, delete, edit page working for each table automaticly

Peuplarchie · May 30, 2010, 2:25am

Good day to you all,
I’m working on a MySQL database production area.
I don’t yet have access to my SSH connect ion and I’m trying to not use it since it’s for a project orther that my regular.

               I have my adding , deleting and editing script all in separate php pages.

               For each table that I want to be able to play with I have to rename and edit thos pages acordingly.

               Is there a way that I can make only a single adding, deleting and editing page work for each table in all database ?

What is all the people do ?, that is the part I don’t catch.

Here is my pages:

notes.php


      
&lt;?PHP


//check if the starting row variable was passed in the URL or not
if (!isset($_GET['startrow']) or !is_numeric($_GET['startrow'])) {
  //we give the value of the starting row to 0 because nothing was found in URL
  $startrow = 0;
//otherwise we take the value from the URL
} else {
  $startrow = (int)$_GET['startrow'];
}





mysql_connect("localhost","USER","PASSWORD");//database connection
mysql_select_db("DB");	
$order = mysql_query("SELECT * FROM Notes");
$num_rows = mysql_num_rows($order);


// Sort Process debut
$ord = (isset($_GET['ord']) && ($_GET['ord'] == 'ASC' || $_GET['ord'] == 'DESC') ? $_GET['ord'] : 'ASC'); // sets 'desc' as default 
$link = ($ord == 'ASC' ? 'DESC' : 'ASC'); 
if(empty($_GET['coll']))
{
   $_GET['coll'] = "priorite";
}

$col = mysql_real_escape_string(trim($_GET['coll']));
// Sort Process fin





//General mysql query debut
$order = "SELECT * FROM Notes ORDER BY `$col` $ord  LIMIT $startrow, 30";
if($order == false)
{
   user_error(mysql_error() . "&lt;br /&gt;\
$order");
   die("SQL error");
} 
//General mysql query fin  



    
// Headers		
$result = mysql_query($order);
for ($i = 0; $i &lt; mysql_num_fields($result); $i++) {
if (mysql_field_name($result, $i) == "id"){
    print "&lt;th id=\\"title\\" style=\\"color:#FF0000;\\"&gt;&lt;a href=\\"".$_SERVER['PHP_SELF']."?coll=".mysql_field_name($result, $i)."&ord=".$link."&time=".date("hisu")."\\" title=\\"Sort by : ".mysql_field_name($result, $i)."\\" style=\\"color:#000000;\\"&gt;ID&lt;/a&gt;&lt;/th&gt;\
";
}else{
    print "&lt;th id=\\"title\\"&gt;&lt;a href=\\"".$_SERVER['PHP_SELF']."?coll=".mysql_field_name($result, $i)."&ord=".$link."&time=".date("hisu")."\\" title=\\"Sort by : ".mysql_field_name($result, $i)."\\"style=\\"color:#000000;\\"&gt;".mysql_field_name($result, $i)."&lt;/a&gt;&lt;/th&gt;\
";
} 



} 

echo "&lt;/tr&gt;";
// Headers fin










// Form Debut
echo "&lt;tr&gt;&lt;form method=\\"post\\" name=\\"action\\" action=\\"add_row_notes.php\\"&gt;";
    print "&lt;td id=\\"submit\\"&gt;&lt;input type=\\"submit\\" id=\\"envoyer\\" value=\\"&nbsp;&nbsp;&nbsp;\\"&gt;&lt;/td&gt;\
";
for ($i = 0; $i &lt; mysql_num_fields($result); $i++) {
if (mysql_field_name($result, $i) == "modif"){
print "&lt;td id=\\"submit\\"&gt;&lt;input  id=\\"submitt\\" type=\\"text\\" size=\\"10\\" name=\\"".mysql_field_name($result, $i)."\\" value=\\"".date('Y-m-d G:i:s')."\\"&gt;&lt;/td&gt;\
";
}else{
     if (mysql_field_name($result, $i) == "note"){
     print "&lt;td id=\\"submit\\"&gt;&lt;input  id=\\"submitt\\" type=\\"text\\" size=\\"50\\" name=\\"".mysql_field_name($result, $i)."\\" value=\\"".$_SESSION[mysql_field_name($result, $i)]."\\"&gt;&lt;/td&gt;\
";
     }else{
          if (mysql_field_name($result, $i) == "titre"){
          print "&lt;td id=\\"submit\\"&gt;&lt;input  id=\\"submitt\\" type=\\"text\\" size=\\"30\\" name=\\"".mysql_field_name($result, $i)."\\" value=\\"".$_SESSION[mysql_field_name($result, $i)]."\\"&gt;&lt;/td&gt;\
";
          }else{
               if (mysql_field_name($result, $i) == "priorite"){
               print "&lt;td id=\\"submit\\"&gt;&lt;select name=\\"".mysql_field_name($result, $i)."\\"&gt;&lt;option value=\\"1-Urgent\\" selected&gt;1-Urgent&lt;/option&gt;&lt;option value=\\"2-Normal\\"&gt;2-Normal&lt;/option&gt;&lt;option value=\\"3-Eventuellement\\"&gt;3-Eventuellement&lt;/option&gt;&lt;option value=\\"4-Autre\\"&gt;4-Autre&lt;/option&gt;&lt;/select&gt;&lt;/td&gt;\
";
               }else{
                     if (mysql_field_name($result, $i) == "status"){
                     print "&lt;td id=\\"submit\\"&gt;&lt;select name=\\"".mysql_field_name($result, $i)."\\"&gt;&lt;option value=\\"Ouvert\\" selected&gt;Ouvert&lt;/option&gt;&lt;option value=\\"Attente_Discussion\\"&gt;Attente Discussion&lt;/option&gt;&lt;option value=\\"Fermer\\"&gt;Fermer&lt;/option&gt;&lt;/select&gt;&lt;/td&gt;\
";
                     }else{
                           if (mysql_field_name($result, $i) == "categorie"){
                           print "&lt;td id=\\"submit\\"&gt;";
													 print "&lt;select name=\\"".mysql_field_name($result, $i)."\\"&gt;";
                           print "&lt;option value=\\"**-Franck\\" selected&gt;**-test&lt;/option&gt;";
                           print "&lt;option value=\\"**-Rocky\\" selected&gt;**-test2&lt;/option&gt;";
                           print "&lt;option value=\\"Vivants\\" selected&gt;Vivants&lt;/option&gt;";
                           print "&lt;option value=\\"Inspirations\\"&gt;Inspirations&lt;/option&gt;";
                           print "&lt;option value=\\"Connaissances\\"&gt;Connaissances&lt;/option&gt;";
                           print "&lt;option value=\\"Ensemble\\"&gt;Ensemble&lt;/option&gt;";
                           print "&lt;option value=\\"Outils\\"&gt;Outils&lt;/option&gt;";
                           print "&lt;/select&gt;&lt;/td&gt;\
";
                           }else{
                           print "&lt;td id=\\"submit\\"&gt;&lt;input  id=\\"submitt\\" type=\\"text\\" size=\\"1\\" name=\\"".mysql_field_name($result, $i)."\\" value=\\"".$_SESSION[mysql_field_name($result, $i)]."\\"&gt;&lt;/td&gt;\
";
                           } 
							       } 
                }			           
          }
     }
}
}
echo "&lt;/form&gt;&lt;/tr&gt;";
// Headers Fin


				
//Grid
$result = mysql_query($order);	

$i = 1;			
while(($data = mysql_fetch_row($result))!== false){
$i++;

if ($data[1] == ''){$data[1] = "&lt;br&gt;";}else{}
if ($data[2] == ''){$data[2] = "&lt;br&gt;";}else{}
if ($data[3] == ''){$data[3] = "&lt;br&gt;";}else{}
if ($data[4] == ''){$data[4] = "&lt;br&gt;";}else{}
if ($data[5] == ''){$data[5] = "&lt;br&gt;";}else{}
if ($data[5] == ''){$data[6] = "&lt;br&gt;";}else{}
if ($data[5] == ''){$data[7] = "&lt;br&gt;";}else{}

  echo("&lt;tr style=\\"border:0px;\\" onMouseOver=\\"this.className='highlight'\\" onMouseOut=\\"this.className='normal'\\"&gt;
	&lt;td id=\\"fields".($i & 1)."\\"&gt;
	&lt;a href=\\"delete_row_notes.php?id=" . $data['0'] . "\\" title=\\"DELETE : Row ID #:" . $data['0'] . "\\"&gt;
	&lt;img src=\\"Template/Images/delete.png\\" border=\\"0\\"/&gt;&lt;/a&gt;
	&lt;a href=\\"editor_row.php?id=".$data['0']."\\" title=\\"Edit : Row ID #:".$data['0']."\\" onclick=\\"load('editor_row.php?id=".$data['0']."','".$data['0']."');return false;\\"&gt;
	&lt;img src=\\"Template/Images/edit_icon.png\\" border=\\"0\\"/&gt;&lt;/a&gt;
	&lt;/td&gt;
	&lt;td id=\\"fields".($i & 1)."\\"&gt;". $data[0]."&lt;/td&gt;
	&lt;td id=\\"fields".($i & 1)."\\"&gt;". $data[1]."&lt;/td&gt;
	&lt;td id=\\"fields".($i & 1)."\\"&gt;". $data[2]."&lt;/td&gt;
	&lt;td id=\\"fields".($i & 1)."\\"&gt;". $data[3]."&lt;/td&gt;
	&lt;td id=\\"fields".($i & 1)."\\"&gt;". $data[4]."&lt;/td&gt;
	&lt;td id=\\"fields".($i & 1)."\\"&gt;". $data[5]."&lt;/td&gt;
	&lt;td id=\\"fields".($i & 1)."\\"&gt;". $data[6]."&lt;/td&gt;
	&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=\\"8\\" id=\\"".$data['0']."\\"&gt;&lt;/td&gt;&lt;/tr&gt;");
}
// Grid fin



//PREV & NEXT debut
echo "&lt;tr&gt;&lt;td colspan=\\"8\\" align=\\"center\\" id=\\"listpage\\"&gt;";
//only print a "Previous" link if a "Next" was clicked
$prev = $startrow - 30;




if ($prev &gt;= 0)
echo '&lt;a href="'.$_SERVER['PHP_SELF'].'?startrow='.$prev.'"  title="Pr&eacute;cedante ('.$prev.'/'.$startrow.')" style=\\"color:#FFFFFF;\\"&gt; ('.$prev.'/'.$startrow.') Pr&eacute;cedante&lt;/a&gt; ';
$next = $startrow+30;
echo '&lt;a href="'.$_SERVER['PHP_SELF'].'?startrow='.($startrow+30).'" title="Prochaine ('.$startrow.'/'.$next.')" style=\\"color:#FFFFFF;\\"&gt;Prochaine &lt;font style="color:#003300"&gt;(&lt;/font&gt;'.$startrow.'&lt;font style="color:#003300"&gt;-&lt;/font&gt;'.$next.'&lt;font style="color:#003300"&gt; / &lt;/font&gt;'.$num_rows .'&lt;font style="color:#003300"&gt;)&lt;/font&gt;&lt;/a&gt;';
$prev = $startrow - 30;
echo "&lt;/td&gt;&lt;/tr&gt;";
//PREV & NEXT fin

echo "&lt;/table&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;";
  
?&gt;

Add_row.php




&lt;?PHP


$id = $_POST['id'];
$_SESSION['id'] = $_POST['id'];
$modif = $_POST['modif'];
$_SESSION['modif'] = $_POST['modif'];
$priorite = $_POST['priorite'];
$_SESSION['priorite'] = $_POST['priorite'];
$status = $_POST['status'];
$_SESSION['status'] = $_POST['status'];
$categorie = $_POST['categorie'];
$_SESSION['categorie'] = $_POST['categorie'];
$titre = $_POST['titre'];
$_SESSION['titre'] = $_POST['titre'];
$note = $_POST['note'];
$_SESSION['note'] = $_POST['note'];


mysql_connect("localhost","USER","PASSWORD");//database connection
mysql_select_db("DB");		

//inserting data order
$order = "INSERT INTO Notes
			(id, modif, priorite, status, categorie, titre, note)
			VALUES
('NULL',
'$modif',
'$priorite',
'$status',
'$categorie',
'$titre',
'$note')";

//declare in the order variable
$result = mysql_query($order);	//order executes
if($result){
	echo("&lt;br&gt;Input data is succeed");

} else{
	echo("&lt;br&gt;Input data is fail");
}

$time = date("hisu");
?&gt;



&lt;script language="javascript"&gt;&lt;!--
location.replace("Notes.php?time=&lt;?PHP echo $time; ?&gt;")
//--&gt;
&lt;/script&gt;

I won’t put my deleting and editing script, but I have added my script for adding a row to the db so you can see more of what I mean.

I hope you will understand my question.

Thanks !

Topic		Replies	Views
All In One - PHP/MYSQL - Add/Edit/Delete Script PHP	2	7855	October 8, 2014
After display the MySQL -> how to be able to edit, delete each row? PHP	3	2208	October 8, 2014
Insert Delete Update in one page PHP	5	26012	October 8, 2014
Php Code To Edit .html Page PHP	9	15146	February 12, 2010
Click link, delete MySQL row PHP	7	30832	October 8, 2014

Add, delete, edit page working for each table automaticly

Related topics