MySql database

@RuchithFeb 14.2016

Hi all,

I have created a db in mysql local host with username and password.

For now I found a free server for 60 days to run my website

The problem I have is how to give the connection string from local host to the current free server domain.

The website is in php.

Pls help

to post a comment

PHP

@NogDogFeb 15.2016 — #It is not clear to me what you are trying to do with regard to the free server, and what that has to do with connecting to it from local host (does that mean from your own personal computer?).

@RuchithauthorFeb 15.2016 — #i was sleepy, sorry. what i am saying is i got this free web server and i uploaded my db and the php files. when trying to run it its giving a lot of errors. specially with the connection string.

i have defined as localhost. now i need to change and i dont know what to change it to

@NogDogFeb 15.2016 — #You may have to find that out from the hosting company. Somewhere on their control panel for your site there, they should have info about the host name (and possibly port number) you should use to connect to the DB server.

@RuchithauthorFeb 16.2016 — #thank you.

@ginerjmFeb 20.2016 — #Has your problem been solved yet? I ask only because I'm thinking that you might be trying to get an answer from a recalcitrant hosting company.

Here is how my code does it ( I use pdo)

[code=php]
  $pdo = new PDO($host,$uid,$pswd,$db_options);
 [/code]

where $host is the string:

[code=php]
  $host="mysql:host=localhost;dbname=$sc_dbname;charset=utf8";
 [/code]

$uid and $pswd are what you have setup when you created the database that you are trying to connect to. $db_options are defaulted to the common settings:

[code=php]
  $db_options = array(PDO::ATTR_EMULATE_PREPARES => false,
 PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
 PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC);
 [/code]

This code is part of a std. db connect function that I use all the time where I pass in the desired dbname as an argument of the function header.

Hope this helps if you haven't already solved it.

MySql database

5 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

MySql database

5 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

5 Comments(s) _↴

Also in #PHP _↴