mysql_select_db()期望参数2为资源，给定对象 [英] mysql_select_db() expects parameter 2 to be resource, object given

问题描述

我是使用PHP的新手.我简化了连接MySQL并选择数据库的过程:

I'm new in using PHP. I made something simple to connect to MySQL and select a database:

$conn = mysqli_connect($db_host, $db_admin, $db_pass) or die(mysql_error());
// these variables are previously declared and initialized 

$selected_db = mysql_select_db($db_name, $conn) or die(mysql_error());

测试时，我建立了成功的连接，并发出以下警告:

When I tested it, I got a successfully-established connection and the following warning:

mysql_select_db() expects parameter 2 to be resource, object given 

为什么会这样?我该如何解决?

Why did this happen? How can I fix it?

推荐答案

您同时使用mysqli和mysql进行更改

mysql_select_db()

使用

mysqli_select_db

参考 http://php.net/手册/en/mysqli.select-db.php

updated

使用mysql_select_db时应该使用mysql api，因此必须使用mysql sintax来增强与数据库的连接mysql_connect

When you use mysql_select_db you are supposed to use mysql api and so you have to exatibilish connection to database with mysql sintax mysql_connect Reference

现在不建议使用Mysql，因此使用mysqli或PDO

Mysql is now deprecated so it's correct either to use mysqli or PDO

这篇关于mysql_select_db()期望参数2为资源，给定对象的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！