echo $ values ['sqlcolumnname']; 即使vardump $ values可以工作,也不返回显示的值...我试图在屏幕上以可读格式返回这些值。我可能在这里缺少一些简单的东西,但是我对php很陌生...预先谢谢
<?php
mysql_connect("localhost:3306","root","admin");
mysql_select_db("smlc");
$result = mysql_query("SELECT * FROM `service_times`");
$values = mysql_fetch_array($result);
echo $values ['service_times_title'];
echo $values ['service_times_content'];
?>
var_dump的输出是:
array(6) { [0]=> string(1) "1" ["Service_times_id"]=> string(1) "1" [1]=> string(24) "Regular Worship Services" ["Service_times_title"]=> string(24) "Regular Worship Services" [2]=> string(118) "Holy Communion: Sunday 8:30 a.m. & 11:00 a.m. Sunday School: 9:45 a.m. between services Nursery care is available." ["Service_times_content"]=> string(118) "Holy Communion: Sunday 8:30 a.m. & 11:00 a.m. Sunday School: 9:45 a.m. between services Nursery care is available." } string(118) "Holy Communion: Sunday 8:30 a.m. & 11:00 a.m. Sunday School: 9:45 a.m. between services Nursery care is available." string(24) "Regular Worship Services"
当我使用var_dump($ values ['service_times_title']);时 该值返回NULL。我确实尝试循环它没有任何效果。我以为我真的不需要它循环,因为我只需要第一行值。
(这不是从教程中完成的,但是我以前在其他项目中使用过它)再次感谢
谢谢Niko,在查看了Var_dump之后,发现我的列标题缺少Caps。
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句