مرسی . عزیزان ، اول از همه اینا رو داشته باشید :
<?php
$db_host = "localhost";
$db_name = "mycms";
$db_pass = "";
$db_user = "root";
$db_table = "post";
mysql_connect($db_host,$db_user,$db_pass) or die ("database error");
mysql_select_db($db_name);
?>
<style>
#acrite{
float: right;
height: 300px;
width: 400px;
}
.title
{
height: 50px;
width: 100%;
background: none repeat scroll 0% 0% rgb(204, 204, 204);
border-radius: 5px;
}
.post{
height: 100%;
background: none repeat scroll 0% 0% rgb(204, 204, 204);
margin: 5px 0px;
border-radius: 5px;
}
</style>
<?php
$post_show_quary = "SELECT * FROM $db_table ";
$post_show_quary_run = mysql_query($post_show_quary);
echo("<TABLE BORDER=1 WIDTH=100%>\n");
echo("<TR ALIGN=CENTER VALIGN=MIDDLE BGCOLOR=#CCCCFF>\n");
echo("<TH>Radif</TH><TH>Name</TH><TH>ID</TH>\n");
echo("</TR>\n");
while($row = mysql_fetch_row($post_show_quary_run)){
echo("<TR ALIGN=CENTER VALIGN=MIDDLE BGCOLOR=FFCCCC>\n");
for($i=0;$i<mysql_num_fields($post_show_quary_run) ;$i++)
{
echo("<TD>$row[$i]</TD>");
}
echo("<TR ALIGN=CENTER VALIGN=MIDDLE BGCOLOR=FFCCCC>\n");
}
("</TABLE>\n");
?>
<form action="index.php" method="post">
<label for="title">عنوان</label><input type="text" name="title" id="title"/>
<textarea name="text"></textarea>
<input type="submit" name="sbm" value="send"/>
<input type="submit" name="delet" value="delete"/>
</form>
<?php
if(isset($_POST["delet"])){
$delet = mysql_query("DELETE FROM $db_table WHERE id=1");
$delet_run = mysql_query($delet);
if($delet_run){
echo "ok";
}
else {
echo "error";
}
}
if(@$_POST["sbm"]){
$title = $_POST["title"];
$post = $_POST["text"];
$quray = "INSERT INTO $db_table(title,text) VALUES ('$title','$post')";
$result = mysql_query($quray);
if($result){
echo "ok";
}
else {
echo "error";
}
mysql_close();
}
?>
وقتی این درستور حذف رکورد اجرا میشه ، sorry نمایش داده میشه در صورتی که دستور کار میکنه ، مشکل از چیه ؟
if(isset($_POST["delet"])){
$delet = mysql_query("DELETE FROM $db_table WHERE id=1");
$delet_run = mysql_query($delet);
if($delet_run){
echo "ok";
}
else {
echo "error";
}
}