CodingForums.com - test to live with mysql_connect

CodingForums.com (http://www.codingforums.com/index.php)

- PHP (http://www.codingforums.com/forumdisplay.php?f=6)

- - test to live with mysql_connect_db (http://www.codingforums.com/showthread.php?t=283309)

dambuster

11-30-2012 08:10 PM

test to live with mysql_connect_db

Some advice please.

I have a testing server at localhost, after making amendments fixing bugs etc. I upload to a hosted web server. Problem is I have to change all the mysql_connect_db statements before uploading due to parameter 1 of the mysql_connect_db statement on the testing server being set to "localhost" and on the live server it's info provided by the web hosting company.

Is there any way I can set something in my localhost testing environment (or a completely different method) that simulates the same as the live environment

LearningCoder

11-30-2012 08:17 PM

I see what you mean and I found this hassle. How many times are you calling that function? Do you have multiple databases or just one?

Just upload your local version. When it is live, go into your host directories and manually edit all the connection stuff. Then you've only done it once and you also keep a copy of your original localhost versions of the files. Once you got a live version, you can work locally, then just copy paste the code into your live version by going into the bit where you upload and editing the file which is online directly.

Hope it helps.

Maybe someone can give you better information and good tips to keep in mind. This is what I do but I'm no expert.

Regards,

LC.

Junsee

12-01-2012 12:11 AM

Poeple do this is several ways, personally I use a include file, while other use a function call.

it goes something like this, you just edit file to which host its on.
file 'db.php'

PHP Code:


		
			
$conn = mysql_connect("localhost", "root", "") or die("Could not Connect");

$rs = mysql_select_db("Database", $conn) or die("Couldn't Find Database");



#$conn = mysql_connect("livehost", "liveroot", "") or die("Could not Connect");

#$rs = mysql_select_db("Database", $conn) or die("Couldn't Find Database");

File with the selects and whatever

PHP Code:


		
			
include 'db.php';

$sql = "SELECT * FROM `table` ; ";

$rs = mysql_query($sql, $conn) or die ("error with sql query ".$sql);

while ($row = mysql_fetch_array ($rs)){

    #CODE

}

master3w

12-01-2012 12:47 AM

Keep one configuration file name config_db.php or any name when you want to connect database to outer pages just include it
config_db.php

$con=mysql_connect('localhost','root','pass')or die("Could not Connect");
$select=mysql_select_db('database name',$con);

after you test your site using localhost before upload it to server just change config_db.php values localhost, root,pass and database name

:o:o:o:o:o

AndrewGSW

12-01-2012 11:33 PM

Just a suggestion, but I use a constant named LOCAL and just set it to true or false to switch between localhost and live - saves having to edit, or comment out, all the other details:

PHP Code:


		
			
<?php
if (!defined('LOCAL')) {
    define('LOCAL', true);      // set this to true or false
}
if (!defined('DB_USER')) {
    if (LOCAL) {
        DEFINE ('DB_USER', 'Andrew');
        DEFINE ('DB_PASSWORD', 'Password1');
        DEFINE ('DB_HOST', 'localhost');
        DEFINE ('DB_NAME', 'Andy2');
    } else {
        DEFINE ('DB_USER', 'user2');
        DEFINE ('DB_PASSWORD', 'Password2');
        DEFINE ('DB_HOST', 'www.some.com');
        DEFINE ('DB_NAME', 'db2');
    }
}
?>

LearningCoder

12-02-2012 12:58 AM

What a great idea, would save A LOT of messing about.

Regards,

Lc.

All times are GMT +1. The time now is 07:10 AM.