更新时间:2023-02-09 20:40:32
_POST [ DeletePost]){
id =
_POST [ id];
Hi I'm trying to recall data from my database but not all fields are being displayed how can fix it because each time I reload only one or two rows get retrieved from my database...
<?
if ($_POST["DeletePost"]) {
$id = $_POST["id"];
$query = "DELETE FROM ".$dbTable." WHERE id='".$id."'";
mysql_query($query);
echo "ID removed from system: ".$id;
}
if ($_POST["BanIP"]) {
$IP_To_Add = $_POST["ip"];
if(eregi("^[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}$", $IP_To_Add))
{
$sql = "INSERT INTO ".$IPBanTable." (ip) VALUES (\"$IP_To_Add\")";
$result = mysql_query($sql);
} else {
echo "Error: Not a valid IP: ".$IP_To_Add;
}
}
if ($_POST["purge"]) {
$query = "TRUNCATE TABLE ".$dbTable;
mysql_query($query);
echo "StringyChat purged";
}
if(!$_POST["update"] || !$_POST["StringyChat_name"] || !$_POST["StringyChat_message"]) {
} else {
$id = $_POST["id"];
$name = $_POST["StringyChat_name"];
$message = $_POST["StringyChat_message"];
include("emoticon_replace.php");
$query = "UPDATE ".$dbTable." SET StringyChat_name='$name', StringyChat_message='$message' WHERE id='".$id."'";
$result = mysql_query($query, $db) or die("Invalid query: " . mysql_error());
}
if ($_POST["EditPost"]) {
$id = $_POST["id"];
$result = mysql_query("SELECT * FROM ".$dbTable." WHERE id='".$id."'", $db);
$myrow = mysql_fetch_array($result);
?>
<form name="StringyChat_form" method="POST" action="?mode=postman">
Name:<br>
<input name="StringyChat_name" class="StringyChatFrm" type="text" size="20" maxlength="<? echo $name_size; ?>" value="<? echo $myrow["StringyChat_name"]?>">
<br>
Message:<br>
<textarea name="StringyChat_message" class="StringyChatFrm" cols="20" rows="4"><? echo $myrow["StringyChat_message"]?></textarea>
<br>
<input type="hidden" name="id" value="<? echo $id ?>">
<input name="update" class="StringyChatFrm" type="submit" value="Update">
</form>
<?
}
?>
<a href="<? echo $_SERVER['REQUEST_URI']; ?>&m=purge">Purge StringyChat</a><br>
<br>
<?
// Load up the last few posts. The number to load is defined by the "ShowPostNum" variable.
$result = mysql_query("SELECT * FROM ".$dbTable." ORDER BY StringyChat_time DESC",$db);
while ($myrow = mysql_fetch_array($result)) {
$msg = $myrow["StringyChat_message"];
$msg = strip_tags($msg);
$msg = eregi_replace("im#([a-z]{3})", "<img src=\"/stringychat/images/\\1.gif\" alt=\"emoticon\">",$msg);
printf("<div class=\"StringyChatItem\"><h4>%s<br>\n", $myrow["StringyChat_name"]);
printf("%s</h4>\n", date("H:i - d/m/y", $myrow["StringyChat_time"]));
printf("%s</div>\n", $msg);
?>
<form name="form<? echo $myrow["id"];?>" method="post" action="?mode=postman">
<input name="id" type="hidden" value="<? echo $myrow["id"];?>">
<input name="ip" type="hidden" value="<? echo $myrow["StringyChat_ip"];?>">
<input name="EditPost" type="submit" id="EditPost" value="Edit">
<input name="DeletePost" type="submit" id="DeletePost" value="Delete">
<input name="BanIP" type="submit" id="BanIP" value="Ban <? echo $myrow["StringyChat_ip"];?>">
<input name="<?PHP
include "./ip-ban-time-limit.php";
?>
" type="submit" id="1" value="Kick <? echo $myrow["StringyChat_ip"];?> for 1 hour ">
<input name="1d" type="submit" id="1d" value="Kick <? echo $myrow["StringyChat_ip"];?> for 24 hours ">
<input name="7d" type="submit" id="7d" value="Kick <? echo $myrow["StringyChat_ip"];?> for 7 days ">
</form>
<?
}
?>
_POST["DeletePost"]) {
id =
_POST["id"];