douxing9567 2016-06-07 10:02
浏览 112
已采纳

mysql_query无法在最新的php版本中运行

I am trying to insert data in to MySQL Database, but have been stuck on Data insertion.

I am using Version 3.0.0 of WampServer and PHP 5.6.16, phpMyAdmin 4.5.2.

Everything else are ok, I can UPDATE, DELETE...Except INSERT INTO.

Code

<?php 
$con=@mysql_connect('localhost','root','');
mysql_query('SET NAMES utf8;');
mysql_select_db('mydb',$con);
////////////////////////////////// 
if(isset($_POST['post_files'])) {  
$files = $_POST['files']; 
$title = $_POST['title']; 
////////////////////////////////// 
$query = "INSERT INTO files (`file`, `title`) VALUES ('$files', '$title')";  
if(mysql_query($query))
{ 
echo'OK, Data Inserted.'; 
}
else
{ 
echo 'Sorry! Operation failed.';
}  
}
mysql_close(); 
?>
        

These Bunch of codes were working fine in previous PHP versions.

</div>
  • 写回答

1条回答 默认 最新

  • dongyan5706 2016-06-07 10:25
    关注

    instead of mysql use mysqli For instance:

    • mysql_connect will be replaced by mysqli_connect
    • mysql_query will be replaced by mysqli_query($con, $query)
    • and so on

    Note that, for some functions, you may need to check the parameters carefully: Maybe there are some differences here and there -- but not that many, I'd say: both mysql and mysqli are based on the same library (libmysql ; at least for PHP <= 5.2)

    For instance :

    with mysql, you have to use the mysql_select_db once connected, to indicate on which database you want to do your queries mysqli, on the other side, allows you to specify that database name as the fourth parameter to mysqli_connect. Still, there is also a mysqli_select_db function that you can use, if you prefer.

    For more information read this article : PHP MySQL to MySQLi

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥30 用arduino开发esp32控制ps2手柄一直报错
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 求chat4.0解答一道线性规划题,用lingo编程运行,第一问要求写出数学模型和lingo语言编程模型,第二问第三问解答就行,我的ddl要到了谁来求了
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题