if(get_magic_quotes_gpc()==1){ ?> <html> <head><title>MySQL通用查询程序</title></head> <body> 注意本程序需要将php配置文件(PHP3为php3.ini,PHP4为php.ini)中的magic_quotes_gpc 设成Off或0,修改后请重新启动Apache. </body> </html> <? exit(); } set_magic_quotes_runtime(0); $host = 'localhost'; $db = 'test'; $user = 'test'; $pass = ''; // [ php/inc/str2url.php ] cvs 1.2 function str2url($path){ return eregi_replace("%2f","/",urlencode($path)); } ?> <html> <head><title>MySQL通用查询程序</title></head> <body> <form action="<?echo str2url($PHP_SELF);?>" method="post"> 请输入SQL语句:<br> <textarea name="sql" cols="100" rows="5"><?echo $sql;?></textarea><br> <input type="submit" name="cmd" value="查询"> <input type="submit" name="cmd" value="执行"> </form> <? if($cmd){ $con = mysql_pconnect($host,$user,$pass) or die('无法连接'.$host.'服务器'); mysql_select_db($db,$con) or die('无法连接'.$db.'数据库'); $rst = mysql_query($sql,$con) or die($sql.'出错'); if($cmd=='查询'){ $num_fields = mysql_num_fields($rst); echo '<hr>'; echo '<table border="1" cellpadding="0" cellspacing="0">'; echo '<caption align="center">'.$sql.'</option>'; echo '<tr>'; for($i=0;$i<$num_fields;$i++) echo '<th> '.mysql_field_name($rst,$i).'</th>'; echo '</tr>'; while($row=mysql_fetch_row($rst)){ echo '<tr>'; for($i=0;$i<$num_fields;$i++) echo '<td> '.$row[$i].'</td>'; echo '</tr>'; } echo '</table>'; mysql_free_result($rst); } else echo '有 '.mysql_affected_rows($con).' 行受影响'; } ?> </body> </html>
查看更多关于MySQL通用查询程序-PHP实例的详细内容...