mysql update

[LiLaaron]

Hi,

For some reason, i cant get this to work, i keep on getting a mysql error... no database selected...

index.php

<center><b><font size="5">Upgrade</font><BR><font color="#FF0000" size="-1">From 3.30 to 3.31</font>
<BR /><BR /><BR /><BR />
<font color="#FF0000" size="-5">MAKE SURE ALL OF THE DETAILS YOU ENTER HERE IS THE SAME WHEN FIRST INSTALLED!</font>
<form method="post" action="upgrade-330to331.php">
MySQL Host<BR /><BR />
<input type="text" name="dbhost"><BR /><BR />
MySQL Username<BR /><BR />
<input type="text" name="dbuser"><BR /><BR />
MySQL Password<BR /><BR />
<input type="password" name="dbpass"><BR /><BR />
MySQL Database Name<BR /><BR />
<input type="text" name="dbname"><BR /><BR />
Database Prefix<BR /><BR />
<input name="prefix" type="text" value="rl_" size="20" maxlength="30" />
<BR /><BR />
<input name="submit" type="submit" value="   Next   " />
</form>
</font></b>
</center>

upgrade*.php

<?php

if(!isset($_POST['dbhost']) || empty($_POST['dbhost'])) { 	}
if(!isset($_POST['dbuser']) || empty($_POST['dbuser'])) { 	}
if(!isset($_POST['dbpass']) || empty($_POST['dbpass'])) { 	}
if(!isset($_POST['dbname']) || empty($_POST['dbname'])) { 	}
if(!isset($_POST['prefix']) || empty($_POST['prefix'])) { 	}

$server = $_POST['dbhost'];
$dbusername = $_POST['dbuser'];
$dbpassword = $_POST['dbpass'];
$db_name = $_POST['$dbname'];
$pv = $_POST['prefix'];   

$connection = @mysql_connect($server, $dbusername, $dbpassword)
		or die(mysql_error());

$db = @mysql_select_db($db_name,$connection)
		or die(mysql_error());

$sql ="UPDATE ".$pv."config SET value = '3.31' WHERE name = 'recipman_version'";
$result = @mysql_query($sql,$connection) or die(mysql_error());

?>

Aaron

[pppppp]

<?php

if(!isset($_POST['dbhost']) || empty($_POST['dbhost'])) {     }
if(!isset($_POST['dbuser']) || empty($_POST['dbuser'])) {     }
if(!isset($_POST['dbpass']) || empty($_POST['dbpass'])) {     }
if(!isset($_POST['dbname']) || empty($_POST['dbname'])) {     }
if(!isset($_POST['prefix']) || empty($_POST['prefix'])) {     }

$server = $_POST['dbhost'];
$dbusername = $_POST['dbuser'];
$dbpassword = $_POST['dbpass'];
$db_name = $_POST['dbname'];
$pv = $_POST['prefix'];   

$connection = @mysql_connect($server, $dbusername, $dbpassword)
        or die(mysql_error());

$db = @mysql_select_db($db_name,$connection)
        or die(mysql_error());

$sql ="UPDATE ".$pv."config SET value = '3.31' WHERE name = 'recipman_version'";
$result = @mysql_query($sql,$connection) or die(mysql_error());

?>

copy this php code and chek... i think u should get the output if not PM me

[LiLaaron]

Ok thankss... thats that sorted... now i am getting another error:

<?php

if(!isset($_POST['dbhost']) || empty($_POST['dbhost'])) { 	}
if(!isset($_POST['dbuser']) || empty($_POST['dbuser'])) { 	}
if(!isset($_POST['dbpass']) || empty($_POST['dbpass'])) { 	}
if(!isset($_POST['dbname']) || empty($_POST['dbname'])) { 	}
if(!isset($_POST['prefix']) || empty($_POST['prefix'])) { 	}

$server = $_POST['dbhost'];
$dbusername = $_POST['dbuser'];
$dbpassword = $_POST['dbpass'];
$db_name = $_POST['$dbname'];
$pv = $_POST['prefix'];   

$connection=mysql_connect($server, $dbuser, $dbpass);
mysql_select_db($dbname, $connection);

$results1=mysql_query("INSERT INTO ".$pv."config (name, value, comment, kind, options, title, category, cat_order)  VALUES ('catcase','0','Change Category Case For Your New Categories','list','0|Exact^1|ALL UPPER CASE^2|all lower case','Category Text Case','02|Categories','2')", $connection) or die(mysql_error());
$results2=mysql_query("INSERT INTO ".$pv."config (name, value, comment, kind, options, title, category, cat_order)  VALUES ('showpagerankgoogle','1','Show Google Page Rank, below URL','flag','','Search Engine Information - Google Page Rank','03|Links','10')", $connection) or die(mysql_error());	
$results3=mysql_query("UPDATE ".$pv."config SET value = '3.31' WHERE name = 'recipman_version'", $connection) or die(mysql_error());	
$results4=mysql_query("UPDATE ".$pv."config SET cat_order = '3' WHERE name = 'catfilesep'", $connection) or die(mysql_error());
$results5=mysql_query("UPDATE ".$pv."config SET cat_order = '4' WHERE name = 'showcounters'", $connection) or die(mysql_error());
$results6=mysql_query("UPDATE ".$pv."config SET cat_order = '5' WHERE name = 'dispsubcat'", $connection) or die(mysql_error());
$results7=mysql_query("UPDATE ".$pv."config SET cat_order = '6' WHERE name = 'showcatdesc'", $connection) or die(mysql_error());
$results8=mysql_query("UPDATE ".$pv."config SET comment = 'Show Alexa Traffic Rank, below URL, below URL', title = 'Search Engine Information - Alexa Traffic Rank', cat_order = '9' WHERE name = 'showpagerank')", $connection) or die(mysql_error());
$results9=mysql_query("UPDATE ".$pv."config SET cat_order = '11' WHERE name = 'showrecip'", $connection) or die(mysql_error());
$results10=mysql_query("UPDATE ".$pv."config SET cat_order = '12' WHERE name = 'linkstatus'", $connection) or die(mysql_error());
$results11=mysql_query("UPDATE ".$pv."config SET cat_order = '13' WHERE name = 'showlinktotal'", $connection) or die(mysql_error());
$results12=mysql_query("UPDATE ".$pv."config SET cat_order = '14' WHERE name = 'displinktotal'", $connection) or die(mysql_error());

echo "<BR><BR>";
echo "$results1<BR>";
echo "$results2<BR>";
echo "$results3<BR>";
echo "$results4<BR>";
echo "$results5<BR>";
echo "$results6<BR>";
echo "$results7<BR>";
echo "$results8<BR>";
echo "$results9<BR>";
echo "$results10<BR>";
echo "$results11<BR>";
echo "$results12<BR>";

echo "<font size=\"4\">Upgrade Completed!</font><BR><BR><font color=\"#FF0000\" size=\"-1\">Now Delete The Upgrade-SQL Folder</font>";

mysql_close($connection);

?>

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

Cheers
Aaron

[LiLaaron]

I am still getting probelms for some reason... the inserts are working fine, but the updates are not working...

my code

<?php

if(!isset($_POST['dbhost']) || empty($_POST['dbhost'])) { 	}
if(!isset($_POST['dbuser']) || empty($_POST['dbuser'])) { 	}
if(!isset($_POST['dbpass']) || empty($_POST['dbpass'])) { 	}
if(!isset($_POST['dbname']) || empty($_POST['dbname'])) { 	}
if(!isset($_POST['prefix']) || empty($_POST['prefix'])) { 	}

$server = $_POST['dbhost'];
$dbusername = $_POST['dbuser'];
$dbpassword = $_POST['dbpass'];
$db_name = $_POST['$dbname'];
$pv = $_POST['prefix'];   

$connection=mysql_connect($server, $dbuser, $dbpass);
mysql_select_db($dbname, $connection);

$results1=mysql_query("INSERT INTO ".$pv."config (name, value, comment, kind, options, title, category, cat_order)  VALUES ('catcase','0','Change Category Case For Your New Categories','list','0|Exact^1|ALL UPPER CASE^2|all lower case','Category Text Case','02|Categories','2')", $connection) or die(mysql_error());
$results2=mysql_query("INSERT INTO ".$pv."config (name, value, comment, kind, options, title, category, cat_order)  VALUES ('showpagerankgoogle','1','Show Google Page Rank, below URL','flag','','Search Engine Information - Google Page Rank','03|Links','10')", $connection) or die(mysql_error());	

$sql ="UPDATE ".$pv."config SET value = '3.31' WHERE name = 'recipman_version'";
$sql ="UPDATE ".$pv."config SET cat_order = '3' WHERE name = 'catfilesep'";
$sql ="UPDATE ".$pv."config SET cat_order = '4' WHERE name = 'showcounters'";
$sql ="UPDATE ".$pv."config SET cat_order = '5' WHERE name = 'dispsubcat'";
$sql ="UPDATE ".$pv."config SET cat_order = '6' WHERE name = 'showcatdesc'";
$sql ="UPDATE ".$pv."config SET comment = 'Show Alexa Traffic Rank, below URL, below URL', title = 'Search Engine Information - Alexa Traffic Rank', cat_order = '9' WHERE name = 'showpagerank'";
$sql ="UPDATE ".$pv."config SET cat_order = '11' WHERE name = 'showrecip'";
$sql ="UPDATE ".$pv."config SET cat_order = '12' WHERE name = 'linkstatus'";
$sql ="UPDATE ".$pv."config SET cat_order = '13' WHERE name = 'showlinktotal'";
$sql ="UPDATE ".$pv."config SET cat_order = '14' WHERE name = 'displinktotal'";

$results3=mysql_query($sql,$connection) or die(mysql_error());

mysql_close($connection);

echo "<BR><BR>";

if ($results1 != "1") {
	echo "Could Not Instert New Row - Google Page Rank<BR><BR>";
} else {
	echo "Updated: Insterted New - Google Page Rank<BR><BR>";
}

	if ($results2 != "1") {
	echo "Could Not Instert New Row - Category Case Change<BR><BR>";
} else {
	echo "Updated: Insterted New Row - Category Case Change<BR><BR>";
}

if ($results3 != "1") {
	echo "Could Not Update Existing Rows<BR><BR>";
} else {
	echo "Updated Existing Rows<BR><BR>";
}

echo "<BR><BR>";

echo "<font size=\"4\">Upgrade Completed!</font><BR><BR><font color=\"#FF0000\" size=\"-1\">Now Delete The Upgrade-SQL Folder</font>";



?>

Aaron

[pppppp]

<?php

if(!isset($_POST['dbhost']) || empty($_POST['dbhost'])) {     }
if(!isset($_POST['dbuser']) || empty($_POST['dbuser'])) {     }
if(!isset($_POST['dbpass']) || empty($_POST['dbpass'])) {     }
if(!isset($_POST['dbname']) || empty($_POST['dbname'])) {     }
if(!isset($_POST['prefix']) || empty($_POST['prefix'])) {     }

$server = $_POST['dbhost'];
$dbusername = $_POST['dbuser'];
$dbpassword = $_POST['dbpass'];
$db_name = $_POST['dbname'];
$pv = $_POST['prefix'];   

$connection=mysql_connect($server, $dbuser, $dbpass);
mysql_select_db($dbname, $connection);

$results1=mysql_query("INSERT INTO ".$pv."config (name, value, comment, kind, options, title, category, cat_order)  VALUES ('catcase','0','Change Category Case For Your New Categories','list','0|Exact^1|ALL UPPER CASE^2|all lower case','Category Text Case','02|Categories','2')", $connection) or die(mysql_error());
$results2=mysql_query("INSERT INTO ".$pv."config (name, value, comment, kind, options, title, category, cat_order)  VALUES ('showpagerankgoogle','1','Show Google Page Rank, below URL','flag','','Search Engine Information - Google Page Rank','03|Links','10')", $connection) or die(mysql_error());    
$results3=mysql_query("UPDATE ".$pv."config SET value = '3.31' WHERE name = 'recipman_version'", $connection) or die(mysql_error());    
$results4=mysql_query("UPDATE ".$pv."config SET cat_order = '3' WHERE name = 'catfilesep'", $connection) or die(mysql_error());
$results5=mysql_query("UPDATE ".$pv."config SET cat_order = '4' WHERE name = 'showcounters'", $connection) or die(mysql_error());
$results6=mysql_query("UPDATE ".$pv."config SET cat_order = '5' WHERE name = 'dispsubcat'", $connection) or die(mysql_error());
$results7=mysql_query("UPDATE ".$pv."config SET cat_order = '6' WHERE name = 'showcatdesc'", $connection) or die(mysql_error());
$results8=mysql_query("UPDATE ".$pv."config SET comment = 'Show Alexa Traffic Rank, below URL, below URL', title = 'Search Engine Information - Alexa Traffic Rank', cat_order = '9' WHERE name = 'showpagerank'", $connection) or die(mysql_error());
$results9=mysql_query("UPDATE ".$pv."config SET cat_order = '11' WHERE name = 'showrecip'", $connection) or die(mysql_error());
$results10=mysql_query("UPDATE ".$pv."config SET cat_order = '12' WHERE name = 'linkstatus'", $connection) or die(mysql_error());
$results11=mysql_query("UPDATE ".$pv."config SET cat_order = '13' WHERE name = 'showlinktotal'", $connection) or die(mysql_error());
$results12=mysql_query("UPDATE ".$pv."config SET cat_order = '14' WHERE name = 'displinktotal'", $connection) or die(mysql_error());

echo "<BR><BR>";
echo "$results1<BR>";
echo "$results2<BR>";
echo "$results3<BR>";
echo "$results4<BR>";
echo "$results5<BR>";
echo "$results6<BR>";
echo "$results7<BR>";
echo "$results8<BR>";
echo "$results9<BR>";
echo "$results10<BR>";
echo "$results11<BR>";
echo "$results12<BR>";

echo "<font size=\"4\">Upgrade Completed!</font><BR><BR><font color=\"#FF0000\" size=\"-1\">Now Delete The Upgrade-SQL Folder</font>";

mysql_close($connection);

?>

this php script will remove ur "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1" this error

[pppppp]

mark it resolvd