本文介绍了MyMsql不记得所有数据的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧! 问题描述 29岁程序员,3月因学历无情被辞! 您好我正在尝试从我的数据库中调用数据,但并不是所有字段都显示如何修复它,因为每次重新加载只有一行或两行从我的数据库中检索... <? if ($ _POST [ DeletePost]){ $ id = $ _POST [ id]; $ query = DELETE FROM.$dbTable. WHERE id ='。$ id。 '; mysql_query($ query); echo 从系统中删除ID: $ 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); } 其他 { echo 错误:无效的IP:。$ IP_To_Add; } } if ($ _POST [ purge]){ $ query = TRUNCATE TABLE。$ dbTable; mysql_query($ query); echo StringyChat已清除; } 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)或 die( 无效的查询: .mysql_error()); } if ($ _POST [ EditPost]){ $ id = $ _POST [ id]; $ result = mysql_query( SELECT * FROM。$ dbTable。 WHERE id ='。$ id。 ',$ db); $ myrow = mysql_fetch_array($ result); ?> < 表格 名称 = StringyChat_form 方法 = POST 操作 = ?mode = postman > 名称:< br > < 输入 name = StringyChat_name class = StringyChatFrm 类型 = text size = 20 maxlength = < ;? echo $ name_size; ?> value = <? echo $ myrow [ StringyChat_name]? > > < br > 消息:< br > < textarea name = StringyChat_message class = StringyChatFrm cols = 20 行 = 4 > <? echo $ myrow [ StringyChat_message] ?> < / textarea > < br > < 输入 type = hidden 名称 = id value = <? echo $ id?> > < 输入 名称 = update class = StringyChatFrm type = submit value = 更新 > < / form > <? } ?> < a href = <? echo $ _SERVER ['REQUEST_URI']; ?>& m =清除 > 清除StringyChat < / a > < br > < br > <? // 加载最后几篇文章。要加载的数字由ShowPostNum定义变量。 $ result = mysql_query( SELECT * FROM。$ dbTable。 ORDER BY StringyChat_time DESC ,$ db); while ($ myrow = m ysql_fetch_array($ result)){ $ msg = $ myrow [ StringyChat_message]; $ msg = strip_tags($ msg); $ msg = eregi_replace( im# ([az] {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,日期( H:i - d / m / y,$ myrow [ StringyChat_time])); printf( %s< / div> \ n,$ msg); ?> < 表格 名称 = 表格<?echo $ myrow [ id];? > method =postaction =?mode = postman> < 输入 name = id 类型 = 隐藏 value = <?echo $ myrow [ id];? > > < 输入 name = ip 类型 = 隐藏 value = <?echo $ myrow [ StringyChat_ip];? > > < 输入 name = EditPost 类型 = 提交 id = EditPost value = 修改 > < input name = DeletePost type = 提交 id = DeletePost value = 删除 > < 输入 名称 = BanIP 类型 = 提交 id = BanIP value = 禁止<? echo $ myrow [ StringyChat_ip];? > > < 输入 name = <?PHP 包含 ./ ip-ban-time-limit.php; ? > type =submitid =1 value =Kick <? echo $ myrow [ StringyChat_ip]; ?> 1小时> < 输入 名称 = 1d type = submit id = 1d value = 踢<? echo $ myrow [ StringyChat_ip];? > 24小时> < 输入 name = 7d 类型 = 提交 id = 7d value = 踢<? echo $ myrow [ StringyChat_ip];? > 7天> < / form > <? } ?> 解决方案 _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="<?PHPinclude "./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"]; 这篇关于MyMsql不记得所有数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持! 上岸,阿里云!
05-29 04:05
查看更多