PHP Coding to Connect MYSQL Issues

Question

I am creating a database to make my 'PHP' website but I couldn't do this. My website is cruzapp that is related to rideshare companies and changing it in to php to get details about our users. But I can't connect MYSQL by using the following PHP code:

?php
$username = "name";
$password = "password";
$hostname = "host"; 

//connection to the database
$dbhandle = mysql_connect($hostname, $username, $password) 
 or die("Not connected to MySQL");
echo "Connected to MySQL<br>";

//select a database to work with
$selected = mysql_select_db("examples",$dbhandle) 
  or die("Could not select examples");

//execute the SQL query and return records
$result = mysql_query("SELECT id, model,year FROM cars");

//fetch tha data from the database 
while ($row = mysql_fetch_array($result)) {
   echo "ID:"$row{'id'}." Name:".$row{'model'}."Year: ". //display the results
   $row{'year'}.<br>";
}
//close the connection
mysql_close($dbhandle)
?>

Can anyone help me to debug this code? I will be very thankful to you.

1. Don't use MySQL, instead switch to MySQLi or PDO. 2. Use mysqli_error() and mysqli_connect_error() to debug. — Areeb
– Areeb, Commented Feb 17, 2017 at 11:11

Areeb · Accepted Answer · 2017-02-17 11:17:02Z

1

Try this one out. It uses MySQLi with error echoing.

<?php

$username = "name";
$password = "password";
$hostname = "host";
$database = "examples";

$con = mysqli_connect($hostname, $username, $password, $database);

if (!$con) {
    exit("Connection failed: " . mysqli_connect_error());
}

$result = mysqli_query($con, "SELECT id, model,year FROM cars");

if (mysqli_error($con)) {
    exit("Error: " . mysqli_error($con));
}

while ($row = mysqli_fetch_array($result)) {
    echo "ID:" . $row['id'] . " Name:" . $row['model'] . "Year: " . $row['year'] . "<br>";
}

mysqli_close($con);

answered Feb 17, 2017 at 11:17

Areeb

5544 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Rotimi Over a year ago

do not forget to bind your statements. PDO is much better with prepared statements

Saquib Lari · Accepted Answer · 2017-02-17 11:16:48Z

0

First of all you should not use mysql because with PHP 7 mysql extension does not work anymore. so you must consider to change it to mysqli or PDO. PDO is recommended. Any how for a quick fix $selected = mysql_select_db($dbhandle,"examples") do this and also check all your values like hostname database name table name and make sure there are no mistakes.

answered Feb 17, 2017 at 11:16

Saquib Lari

1908 bronze badges

Collectives™ on Stack Overflow

PHP Coding to Connect MYSQL Issues

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related