如何解决mysql_fetch_assoc()问题 [英] How to resolve mysql_fetch_assoc() problems
本文介绍了如何解决mysql_fetch_assoc()问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
当我使用下面的代码时,我得到这个错误:
警告:mysql_fetch_assoc():提供的参数不是有效的MySQL结果资源
When i use the code below, im getting this error: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource
返回数据时,任何人都可以修复它吗?谢谢!
when returning the data, anyone can fix it? Thanks!
<?php
$mysql_server_name="localhost";
$mysql_username="";
$mysql_password="";
$mysql_database="";
$conn=mysql_connect($mysql_server_name, $mysql_username,
$mysql_password);
?>
<?php
$result = mysql_query("SELECT * FROM users");
$arrays = array();
while ($row = mysql_fetch_assoc($result)) {
foreach ($row as $key => $val) {
if (!array_contains_key($key)) {
$arrays[$key] = array();
}
$arrays[$key][] = $val;
}
}
?>
<script type="text/javascript">
<?php
foreach ($arrays as $key => $val) {
print 'var ' . $key . ' = ' . json_encode($val) . ";\r\n";
}
?>
</script>
推荐答案
这不是mysql_fetch_assoc问题但查询问题
make it
this is not mysql_fetch_assoc problem but query problem
make it
$sql="SELECT * FROM users";
$result = mysql_query($sql) or trigger_error(mysql_error().$sql);
并查看实际错误
这篇关于如何解决mysql_fetch_assoc()问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文