关于php及mysql配合的问题? 你没有connect 和 select db 了吧。。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 当然已经connect和select_db了。在昨天早上还正常,昨天中午就出现问题了,中间数据库结构没做任何改动,而且程序也没有变动!!!因此,我才觉得…… 强行运行?出错仅仅是说返回的$result不是合法的。下面看一下源码吧。在config.inc.php中:<?php $db_server_name="localhost"; $db_server_user="root"; $db_server_password="*********"; $db_database_name="DatabaseName";?>在mysql.inc.php中:<?phprequire("config.inc.php");global $db_server_name,$db_server_user,$db_server_password,$db_database_name,$db_connect_result;$db_connect_result=mysql_connect($db_server_name,$db_server_user,$db_server_password);mysql_select_db($db_database_name);function query($query) { $result=mysql_query($query); return $result;}function get_row($result) { if($row=mysql_fetch_array($result)) { return $row; } else { return FALSE; }}function get_column($row,$column_name) { return $row["$column_name"];}function close_db() { global $db_connect_result; mysql_close($db_connect_result);}?>在程序中:<?phprequire("mysql_db.inc.php");$cookiepath="/";// ###################### Start Cookies #######################if (strlen($username)!=0 and strlen($password)!=0) { $query="select Teacher_name,Teacher_type from Teacher where Teacher_name='".$username."' and Teacher_password='".$password."'"; $result=query($query); if ($row=get_row($result)){ setcookie("teachernumber",get_column($row,"Teacher_number"),mktime(0,0,0,0,0,2020),$cookiepath); setcookie("teacherid",get_column($row,"Teacher_name"),mktime(0,0,0,0,0,2020),$cookiepath); setcookie("teachertype",get_column($row,"Teacher_type"),mktime(0,0,0,0,0,2020),$cookiepath); }}?> 上面的文件名mysql.inc.php应改为:mysql_db.inc.php 不是Teacher_number的原因,可以把setcookie("teachernumber",get_column($row,"Teacher_number"),mktime(0,0,0,0,0,2020),$cookiepath); 这句去掉。 $_GET和$变量有什么区别 怎么解析json取值 就差一点了,URL重写的问题,天杀呀!!!! 有软件地址,怎么批量下载软件?十万火急!!!!!!!!!! 高分请教:PHP如果获得父框架的URL 删除整个目录的函数问题!!急 关于vBulletin自动解禁的问题! 哪位高人能把这两个PHP函数转成asp代码 帮我这个网站估过价格吧.... 高手指点SESSION怎么用? 请问如何将.sql导入到mysql中,在线等待! mysql中用来进行密码转换的函数password在php中写sql语言的时候能用吗?怎么用?
在昨天早上还正常,昨天中午就出现问题了,中间数据库结构没做任何改动,而且程序也没有变动!!!
因此,我才觉得……
出错仅仅是说返回的$result不是合法的。下面看一下源码吧。在config.inc.php中:
<?php
$db_server_name="localhost";
$db_server_user="root";
$db_server_password="*********";
$db_database_name="DatabaseName";
?>
在mysql.inc.php中:
<?php
require("config.inc.php");
global $db_server_name,$db_server_user,$db_server_password,$db_database_name,$db_connect_result;
$db_connect_result=mysql_connect($db_server_name,$db_server_user,$db_server_password);
mysql_select_db($db_database_name);function query($query) {
$result=mysql_query($query);
return $result;
}function get_row($result) {
if($row=mysql_fetch_array($result)) {
return $row;
}
else {
return FALSE;
}
}
function get_column($row,$column_name) {
return $row["$column_name"];
}
function close_db() {
global $db_connect_result;
mysql_close($db_connect_result);
}
?>
在程序中:
<?php
require("mysql_db.inc.php");
$cookiepath="/";// ###################### Start Cookies #######################
if (strlen($username)!=0 and strlen($password)!=0) {
$query="select Teacher_name,Teacher_type from Teacher where Teacher_name='".$username."' and Teacher_password='".$password."'";
$result=query($query);
if ($row=get_row($result)){
setcookie("teachernumber",get_column($row,"Teacher_number"),mktime(0,0,0,0,0,2020),$cookiepath); setcookie("teacherid",get_column($row,"Teacher_name"),mktime(0,0,0,0,0,2020),$cookiepath); setcookie("teachertype",get_column($row,"Teacher_type"),mktime(0,0,0,0,0,2020),$cookiepath);
}
}
?>