mySQL help please?

[rawritsluke]

Hey I need this file for one of my index pages to run but when I enter my database info it doesn't work :S

if ($sql_mode==2) {
$crishn = pg_connect("$localhost","5432","$sql_data");
} else if ($sql_mode==3) {
$crishn = mssql_connect($host, $sql_user, $changeme);
$crashn = mssql_select_db($sql_data);
} else if ($sql_mode==4) {
$crishn = odbc_connect($sql_data, $host, $changeme);
} else {
$crishn = mysql_connect($localhost, $host, $changeme);
$crashn = mysql_select_db($host);
} 

I've put the database user and password as host and changeme due to me not wanting the database info being leaked And yes when I put in the correct database info it is the correct info.

+REP to whoever helps

[Agnostic Bear]

Hey I need this file for one of my index pages to run but when I enter my database info it doesn't work :S

if ($sql_mode==2) {
$crishn = pg_connect("$localhost","5432","$sql_data");
} else if ($sql_mode==3) {
$crishn = mssql_connect($host, $sql_user, $changeme);
$crashn = mssql_select_db($sql_data);
} else if ($sql_mode==4) {
$crishn = odbc_connect($sql_data, $host, $changeme);
} else {
$crishn = mysql_connect($localhost, $host, $changeme);
$crashn = mysql_select_db($host);
} 

I've put the database user and password as host and changeme due to me not wanting the database info being leaked And yes when I put in the correct database info it is the correct info.

+REP to whoever helps

can you post the full script (obviously take out the details)

[rawritsluke]

Hey, that is the full script, what it does is enable users to register and submit content, I forgot the includes tho

<?php


require "mysqlinfo.php";
require "actions.php";


if ($sql_mode==2) {
$crishn = pg_connect("$localhost","5432","$sql_data");
} else if ($sql_mode==3) {
$crishn = mssql_connect($sql_host, $sql_user, $sql_pass);
$crashn = mssql_select_db($sql_data);
} else if ($sql_mode==4) {
$crishn = odbc_connect($sql_data, $sql_user, $sql_pass);
} else {
$crishn = mysql_connect($db_host, $db_user, $db_pass);
$crashn = mysql_select_db($db_name);
}

?>

I then include this code in the other pages example:
require "varfunctions.php";

[Hypertext]

I don't understand what you're trying to do ;S It looks pointless..

[rawritsluke]

Okay that script is for an install file. So when users download the cms they can install it. But I'm trying to get it to work. For them to install they need to input their database info but I've tried and it doesn't work.

The includes are for submitting content etc.

[Hypertext]

LOL! I'm doing the EXACT thing now, and having troubles, I have so far:

//blablabla
elseif($_GET['step'] == "2") {  
$sitename = $_POST['sitename'];
if(isset($_POST['submit'])) {
$host = $_POST['host'];
$username = $_POST['username'];
$password = $_POST['password'];
$database = $_POST['database'];
$contest = mysql_connect($host,$username,$password);
$dbtest = mysql_select_db($database);
$test = 0;
if(!$contest) {
$test = 0;
} 
if(!$dbtest) {
$test = 0;
} else {
$test = 1;
}
if($test == "1") {
echo "Success! Click <a href=\"step=3\">here</a>";
} else {
echo "Some of your information is incorrect, please try again.";

?>
<form name="step1" method="post" action="?step=2">
<input type="hidden" name="sitename" value="<?php echo $sitename; ?>" />
<fieldset><legend>Host (Usually 'localhost')</legend>
<input type="text" maxlength="100" name="dbhost" id="dbhost" value="localhost" />
</fieldset>
<fieldset><legend>Username</legend>
<input type="text" maxlength="100" name="dbusername" id="dbusername" />
</fieldset>
<fieldset><legend>Password</legend>
<input type="text" maxlength="100" name="dbpass" id="dbpass" />
</fieldset>
<fieldset><legend>Database</legend>
<input type="text" maxlength="100" name="dbdatabase" id="dbdatabase" />
</fieldset>
<fieldset><legend>Next Step</legend>
<input type="submit" name="submit" id="submit" value="Next Step" />
</fieldset>
</form>


<?php
}
}
}
elseif($_GET['step'] == "3") { //blbalbalbalab

[rawritsluke]

Lmao! it's so annoying isn't it See I built it so if they have the wrong information it says: You need to edit varfunctions.php with the correct database information!
And just re-directs them back to the install page

[Hypertext]

When I put in right or wrong info mine echos it's error..

[rawritsluke]

What this?
echo "Some of your information is incorrect, please try again.";

[Hypertext]

if info is incorrect.