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
<?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() . "<br />\n$order");
die("SQL error");
}
//General mysql query fin
// Headers
$result = mysql_query($order);
for ($i = 0; $i < mysql_num_fields($result); $i++) {
if (mysql_field_name($result, $i) == "id"){
print "<th id=\"title\" style=\"color:#FF0000;\"><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;\">ID</a></th>\n";
}else{
print "<th id=\"title\"><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;\">".mysql_field_name($result, $i)."</a></th>\n";
}
}
echo "</tr>";
// Headers fin
// Form Debut
echo "<tr><form method=\"post\" name=\"action\" action=\"add_row_notes.php\">";
print "<td id=\"submit\"><input type=\"submit\" id=\"envoyer\" value=\" \"></td>\n";
for ($i = 0; $i < mysql_num_fields($result); $i++) {
if (mysql_field_name($result, $i) == "modif"){
print "<td id=\"submit\"><input id=\"submitt\" type=\"text\" size=\"10\" name=\"".mysql_field_name($result, $i)."\" value=\"".date('Y-m-d G:i:s')."\"></td>\n";
}else{
if (mysql_field_name($result, $i) == "note"){
print "<td id=\"submit\"><input id=\"submitt\" type=\"text\" size=\"50\" name=\"".mysql_field_name($result, $i)."\" value=\"".$_SESSION[mysql_field_name($result, $i)]."\"></td>\n";
}else{
if (mysql_field_name($result, $i) == "titre"){
print "<td id=\"submit\"><input id=\"submitt\" type=\"text\" size=\"30\" name=\"".mysql_field_name($result, $i)."\" value=\"".$_SESSION[mysql_field_name($result, $i)]."\"></td>\n";
}else{
if (mysql_field_name($result, $i) == "priorite"){
print "<td id=\"submit\"><select name=\"".mysql_field_name($result, $i)."\"><option value=\"1-Urgent\" selected>1-Urgent</option><option value=\"2-Normal\">2-Normal</option><option value=\"3-Eventuellement\">3-Eventuellement</option><option value=\"4-Autre\">4-Autre</option></select></td>\n";
}else{
if (mysql_field_name($result, $i) == "status"){
print "<td id=\"submit\"><select name=\"".mysql_field_name($result, $i)."\"><option value=\"Ouvert\" selected>Ouvert</option><option value=\"Attente_Discussion\">Attente Discussion</option><option value=\"Fermer\">Fermer</option></select></td>\n";
}else{
if (mysql_field_name($result, $i) == "categorie"){
print "<td id=\"submit\">";
print "<select name=\"".mysql_field_name($result, $i)."\">";
print "<option value=\"**-Franck\" selected>**-test</option>";
print "<option value=\"**-Rocky\" selected>**-test2</option>";
print "<option value=\"Vivants\" selected>Vivants</option>";
print "<option value=\"Inspirations\">Inspirations</option>";
print "<option value=\"Connaissances\">Connaissances</option>";
print "<option value=\"Ensemble\">Ensemble</option>";
print "<option value=\"Outils\">Outils</option>";
print "</select></td>\n";
}else{
print "<td id=\"submit\"><input id=\"submitt\" type=\"text\" size=\"1\" name=\"".mysql_field_name($result, $i)."\" value=\"".$_SESSION[mysql_field_name($result, $i)]."\"></td>\n";
}
}
}
}
}
}
}
echo "</form></tr>";
// Headers Fin
//Grid
$result = mysql_query($order);
$i = 1;
while(($data = mysql_fetch_row($result))!== false){
$i++;
if ($data[1] == ''){$data[1] = "<br>";}else{}
if ($data[2] == ''){$data[2] = "<br>";}else{}
if ($data[3] == ''){$data[3] = "<br>";}else{}
if ($data[4] == ''){$data[4] = "<br>";}else{}
if ($data[5] == ''){$data[5] = "<br>";}else{}
if ($data[5] == ''){$data[6] = "<br>";}else{}
if ($data[5] == ''){$data[7] = "<br>";}else{}
echo("<tr style=\"border:0px;\" onMouseOver=\"this.className='highlight'\" onMouseOut=\"this.className='normal'\">
<td id=\"fields".($i & 1)."\">
<a href=\"delete_row_notes.php?id=" . $data['0'] . "\" title=\"DELETE : Row ID #:" . $data['0'] . "\">
<img src=\"Template/Images/delete.png\" border=\"0\"/></a>
<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;\">
<img src=\"Template/Images/edit_icon.png\" border=\"0\"/></a>
</td>
<td id=\"fields".($i & 1)."\">". $data[0]."</td>
<td id=\"fields".($i & 1)."\">". $data[1]."</td>
<td id=\"fields".($i & 1)."\">". $data[2]."</td>
<td id=\"fields".($i & 1)."\">". $data[3]."</td>
<td id=\"fields".($i & 1)."\">". $data[4]."</td>
<td id=\"fields".($i & 1)."\">". $data[5]."</td>
<td id=\"fields".($i & 1)."\">". $data[6]."</td>
</tr><tr><td colspan=\"8\" id=\"".$data['0']."\"></td></tr>");
}
// Grid fin
//PREV & NEXT debut
echo "<tr><td colspan=\"8\" align=\"center\" id=\"listpage\">";
//only print a "Previous" link if a "Next" was clicked
$prev = $startrow - 30;
if ($prev >= 0)
echo '<a href="'.$_SERVER['PHP_SELF'].'?startrow='.$prev.'" title="Précedante ('.$prev.'/'.$startrow.')" style=\"color:#FFFFFF;\"> ('.$prev.'/'.$startrow.') Précedante</a> ';
$next = $startrow+30;
echo '<a href="'.$_SERVER['PHP_SELF'].'?startrow='.($startrow+30).'" title="Prochaine ('.$startrow.'/'.$next.')" style=\"color:#FFFFFF;\">Prochaine <font style="color:#003300">(</font>'.$startrow.'<font style="color:#003300">-</font>'.$next.'<font style="color:#003300"> / </font>'.$num_rows .'<font style="color:#003300">)</font></a>';
$prev = $startrow - 30;
echo "</td></tr>";
//PREV & NEXT fin
echo "</table></td></tr></table>";
?>
Add_row.php
<?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("<br>Input data is succeed");
} else{
echo("<br>Input data is fail");
}
$time = date("hisu");
?>
<script language="javascript"><!--
location.replace("Notes.php?time=<?PHP echo $time; ?>")
//-->
</script>
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 !
