PHP can't complete MYSQL query in XAMPP

Question

I have a question. This is a simple piece of php that should show the number of rows in a table.

<?php

$link = mysql_connect("localhost", "root", "1234") or die("Couldn't connect");
mysql_select_db("regulas", $link);

$result = mysql_query("SELECT * FROM index", $link) or die("Couldn't finish query");
$num_rows = mysql_num_rows($result);

echo $num_rows;

?>

However, the page displays:

Couldn't connect

I'm using a xampp server on my own computer: localhost

What am i doing wrong?

Thx Jules

mysql_* functions have been removed from PHP 7, and deprecated in previous versions. It's recommend that you switch to PDO or mysqli. Other than that, check for mysql_errors, that will tell you why. — aynber
– aynber, Commented Oct 6, 2016 at 16:58
What you are doing wrong? Firstly you apparently do not monitor your http servers error log file which is where you can simply read what the issue is instead of having to guess. — arkascha
– arkascha, Commented Oct 6, 2016 at 17:00
As index is a reserved word in MySQL, it has to be enclosed in backticks to not produce a syntax error in this place. — syck
– syck, Commented Oct 6, 2016 at 17:08
I have another script with mysqli but that doesn't work neither — Jules Hummelink
– Jules Hummelink, Commented Oct 6, 2016 at 17:11

Nadeem · Accepted Answer · 2016-10-06 17:03:16Z

1

You must provide the password in,there is no defauls password in WAMP or XAAXMP try this :

    <?php

$link = mysql_connect("localhost", "root","", "1234") or die("Couldn't   connect");
mysql_select_db("regulas", $link);

$result = mysql_query("SELECT * FROM index", $link) or die("Couldn't finish query");
$num_rows = mysql_num_rows($result);

echo $num_rows;

?>

Read the manual here : http://php.net/manual/en/function.mysqli-connect.php

answered Oct 6, 2016 at 17:03

Nadeem

2612 gold badges6 silver badges20 bronze badges

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

1 Comment

Jules Hummelink Over a year ago

but i have set a password

Jules Hummelink · Accepted Answer · 2016-10-06 17:21:17Z

0

I changed mysql to mysqli and changed index to siteIndex

<?php

$link = mysqli_connect("localhost", "root", "102030!!", "regulas") or die("Couldn't connect");

$result = mysqli_query($link, "SELECT * FROM siteIndex") or die("Couldn't finish query"); $num_rows = mysqli_num_rows($result);

echo $num_rows;

?>

answered Oct 6, 2016 at 17:21

Jules Hummelink

7341 gold badge7 silver badges14 bronze badges

Collectives™ on Stack Overflow

PHP can't complete MYSQL query in XAMPP

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