PHP gives T_STRING error when connecting to MySQL

Question

Code looks fine, but it throws up an error:

"Parse error: syntax error, unexpected T_STRING in /home/u924861036/public_html/press.php on line 7"

<?php
$ip = $_SERVER['REMOTE_ADDR'];
$type = $_POST['type'];
$data = $_POST['data'];

mysql_connect(“localhost”, “user_name”, “pass”) or
die(“Could not connect: ” . mysql_error());
mysql_select_db(“db_name”);

The second last line is line 7, but even if i delete it, the error is same, so there is some error in line 8 also.

@YogeshSuthar - I `“`second `”` that. Sorry, I did that on purpose (grin) — Funk Forty Niner, Jul 25 '13 at 11:46
Now the **"RACE IS ON"**, as to which **answer** will the OP **accept**. — Funk Forty Niner, Jul 25 '13 at 11:49
Downvoting this one, if you can't solve simple parse error caused by quotes, then I'm afraid you're in the wrong field of business. — N.B., Jul 25 '13 at 12:07
This question appears to be off-topic because it is caused by a typo. — madth3, Jul 25 '13 at 19:15

Matthijs · Answer 1 · 2013-07-25T11:43:33.750

2

I think you are using the wrong “ instead of " (notice they are 'italic')

please try this:

<?php
$ip = $_SERVER['REMOTE_ADDR'];
$type = $_POST['type'];
$data = $_POST['data'];

mysql_connect("localhost", "user_name", "pass") or
die("Could not connect: " . mysql_error());
mysql_select_db("db_name");
?>

edit:

Confirmed, this throws a invalid user/pass on my system :)

edited Jul 25 '13 at 11:43

answered Jul 25 '13 at 11:38

Matthijs

1,112
2
12
28

score 1 · Answer 2 · answered Jul 25 '13 at 11:37

Use double or single quotes ( " / ' ) instead of a weird ” symbol

<?php
$ip = $_SERVER['REMOTE_ADDR'];
$type = $_POST['type'];
$data = $_POST['data'];

mysql_connect("localhost", "user_name", "pass") or die("Could not connect: " . mysql_error());
mysql_select_db("db_name");

score 1 · Accepted Answer · edited May 23 '17 at 11:43

1

Your double quotes look weird.

Try this:

<?php
$ip = $_SERVER['REMOTE_ADDR'];
$type = $_POST['type'];
$data = $_POST['data'];

mysql_connect("localhost", "user_name", "pass") or
die("Could not connect: " . mysql_error());
mysql_select_db("db_name");

And please use mysqli or PDO instead of mysql_* functions.

Why shouldn't I use mysql_* functions in PHP?

edited May 23 '17 at 11:43

Community

1
1

answered Jul 25 '13 at 11:37

Simone

20,302
14
79
103

de_nuit · Answer 4 · 2013-07-25T11:51:28.867

1

<?php
$ip = $_SERVER['REMOTE_ADDR'];
$type = $_POST['type'];
$data = $_POST['data'];

mysqli_connect("localhost", "user_name", "pass") or die("Could not connect: " . mysqli_error());
mysqli_select_db("db_name");
?>

Just to make sure: You know that you are connecting with username 'user_name' and password 'pass' to the database 'db_name'? Fixed strange quotes.

edited Jul 25 '13 at 11:51

answered Jul 25 '13 at 11:39

de_nuit

650
7
13

score -1 · Answer 5 · answered Jul 25 '13 at 11:38

-1

Replace :-

mysql_connect(“localhost”, “user_name”, “pass”) or
die(“Could not connect: ” . mysql_error());
mysql_select_db(“db_name”);

with

mysql_connect("localhost", "user_name", "pass") or
die("Could not connect: " . mysql_error());
mysql_select_db("db_name");

answered Jul 25 '13 at 11:38

Vivek Sadh

4,230
3
32
49

That's only part of the answer since he has those strange quotes everywhere. – Zim84 Jul 25 '13 at 11:40
@Zim84 Ahh.. I didn't see it. Was in a hurry. I have updated the answer. Thanks :) – Vivek Sadh Jul 25 '13 at 11:43
thanks, it was with those quotes, from copy paste, works now – user2618458 Jul 25 '13 at 11:52

PHP gives T_STRING error when connecting to MySQL

5 Answers5