Unexpected 'mysql_select_db' (T_STRING)?

Question

okay guys, I've got a problem. I always get the following error line:

Parse error: syntax error, unexpected 'mysql_select_db' (T_STRING) in line 10

here's the whole code:

<html>
<head>
<title>test3</title>
</head>
<body>
<?php
$verbindung = mysql_connect("localhost, test3")
or die ("Fehler")

mysql_select_db("test3");
or die ("Verbindung nicht möglich..."); 

$datum = $_POST["datum"]; 
$autor = $_POST["autor"];
$newstext = $_POST["newstext"]; 

if($datum == "" or $autor == "" or $newstext == "") {
echo "FAIL"
} else {

$eintrag = "INSERT INTO test3
(datum, autor, newstext)

VALUES 
('$datum', '$autor', '$newstext')";

}

mysql_close($verbindung); 
?>
</body>                              
</html>

Always accept the useful answer which helps the poster to get more reputation. — Gunasegar, Oct 29 '15 at 09:16
http://stackoverflow.com/questions/33411437/mysql-connection-problems-getaddrinfo-failed-no-such-host-is-known for @Niranjan N Raju — DarkYagami, Oct 29 '15 at 10:17

score 1 · Answer 1 · edited May 23 '17 at 12:03

1

$verbindung = mysql_connect("localhost, test3")
or die ("Fehler"); << semicolon missing

You should add one here as well:

echo "FAIL"; << here

And you have one too much in another place:

mysql_select_db("test3"); << remove here
or die ("Verbindung nicht möglich...");

You will not get your programs to work without some accuracy.

Please also note that mysql extension is deprecated and will not be supported in PHP versions after PHP 5.5 (look at mysqli and PDO extensions), and that your code is prone to SQL Injection.

edited May 23 '17 at 12:03

Community

1
1

answered Oct 29 '15 at 08:43

syck

2,984
1
13
23

Bittesehr... =) If it was useful to you, please consider accepting it. – syck Oct 29 '15 at 08:55

score 1 · Accepted Answer · answered Oct 29 '15 at 08:45

1

Totally u have missed 2 semicolons and added 1 extra semicolon

<html>
<head>
<title>test3</title>
</head>
<body>
<?php
$verbindung = mysql_connect("localhost, test3")
or die ("Fehler");    //----- semicolon here

mysql_select_db("test3")   //  remove semicolon here
or die ("Verbindung nicht möglich..."); 

$datum = $_POST["datum"]; 
$autor = $_POST["autor"];
$newstext = $_POST["newstext"]; 

if($datum == "" or $autor == "" or $newstext == "") {
echo "FAIL" ; //----- semicolon here
} else {

$eintrag = "INSERT INTO test3
(datum, autor, newstext)

VALUES 
('$datum', '$autor', '$newstext')";

}

mysql_close($verbindung); 
?>
</body>                              
</html>

answered Oct 29 '15 at 08:45

Niranjan N Raju

12,047
4
22
41

Is it working fine?? – Niranjan N Raju Oct 29 '15 at 08:54
the only problem i have, is that this line keeps showing up: php_network_getaddresses: getaddrinfo failed: Der angegebene Host ist unbekannt. in – DarkYagami Oct 29 '15 at 09:17
That line is not there in your code?? – Niranjan N Raju Oct 29 '15 at 09:27
it's a error line, sorry I didn't said that. – DarkYagami Oct 29 '15 at 09:44
ya but is that line present in your question?? – Niranjan N Raju Oct 29 '15 at 09:45
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/93659/discussion-between-darkyagami-and-niranjan-n-raju). – DarkYagami Oct 29 '15 at 09:49

Unexpected 'mysql_select_db' (T_STRING)?

2 Answers2