0

I'm new to learning PHP and I checked my work online but I get this error message: Warning: mysql_query() expects parameter 2 to be resource, object given in C:\wamp64\www\Lessons\createdatabase.php on line 12. I checked through all of the answers on stack and nothing looks like the code i'm working with. I'm not asking if mysql & mysqli can work together I just need a solution to this code so that it can finally work....I don't know what to do and the article referenced at the top does not help me.....Here is the code I currently have:

<html>
<head>
</head>
<body>
<?php
$con = mysqli_connect("localhost","Matt","password");
if (!$con){
die("Can not connect: " . mysql_error());
}


if (mysql_query("CREATE DATABASE snippets",$con)){
echo "Your Database was created sucessfully";
} else echo "Error: " . mysql_error();

mysqli_close($con);
 
?>

</body>
</html>

Any advice would really help me out. Thanks

Ariel A.
  • 1
  • 1
  • The link up top doesn't help me......I just need to know what wrong with my code so that this can finally work.....The issue is in line 12...... – Ariel A. Apr 25 '17 at 14:21
  • Dude, you can't *mix* **`mysqli_`** and **`mysql_`** interface functions. That doesn't work. The problem is that the code is creating a "mysql**i**" connection, and then calling a "mysql" function. Don't do that. Do NOT mix mysql functions with mysqli functions. Call a "mysql**i**_" function. – spencer7593 Apr 25 '17 at 14:31

0 Answers0