How to connect to database php

Question

<?php
    mysql_connect("mysql13.000webhost.com", "a7796367_Bubelz", "password"); or die("Couldn't connect to SQL server.");
    mysql_select_db("a7796367_Bubelz"); or die("Couldn't select DB.");
?>

I can't connect to my database. I'm using 000webhost.com

When I open it, it shows me this error :

Parse error: syntax error, unexpected T_LOGICAL_OR in    
/home/a7796367/public_html/bubelz/connect.inc.php on line 2

Please, [stop using `mysql_*` functions](http://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php). They are no longer maintained and are [officially deprecated](https://wiki.php.net/rfc/mysql_deprecation). Learn about [prepared statements](http://en.wikipedia.org/wiki/Prepared_statement) instead, and use [PDO](http://jayblanchard.net/demystifying_php_pdo.html). — Jay Blanchard, Apr 21 '15 at 14:11

Osama Jetawe · Answer 1 · 2015-04-21T14:15:07.100

1

try this you have syntax error and you have to use mysqli insted becuse mysql Officially deprecated

mysql_connect("mysql13.000webhost.com", "a7796367_Bubelz", "password") or die("Couldn't connect to SQL server.");
mysql_select_db("a7796367_Bubelz") or die("Couldn't select DB.");


mysqli

$connection = new mysqli('localhost', 'my_user', 'my_password', 'my_db') ;

edited Apr 21 '15 at 14:15

answered Apr 21 '15 at 14:08

Osama Jetawe

2,697
6
24
40

Sometimes I also forget this syntactical typo error.. Thanks @Osama Jetawe. – Akilsree1 Apr 21 '15 at 14:12
I dont have enough permissions to mark your answer., Are you asking me or @Nicholas Bastarache – Akilsree1 Apr 21 '15 at 14:39

score 0 · Accepted Answer · answered Apr 21 '15 at 14:11

0

remove ; in first line of code:

mysql_connect("mysql13.000webhost.com", "a7796367_Bubelz", "password"); <---

answered Apr 21 '15 at 14:11

Alexis Peters

1,583
1
10
17

score 0 · Answer 3 · answered Apr 21 '15 at 14:13

You Cannot write OR like this.

mysql_connect("mysql13.000webhost.com", "a7796367_Bubelz", "password"); 
or die("Couldn't connect to SQL server.");

You can use as follows

if(!mysql_connect("mysql13.000webhost.com", "a7796367_Bubelz", "password")){ 
    die("Couldn't connect to SQL server.");
}

How to connect to database php

3 Answers3