Jump to content

running in to a few problems

aebstract

By aebstract
in PHP Coding Help

Recommended Posts

aebstract Advanced Member

aebstract

Posted
Posted 

<?php
if ($user->data['username_clean'] != admin) {
header("Location: index.php");
exit;
}

$content .= "<div id=\"content\">";












switch ($_GET['a']) {



case registrations:


if (isset($_POST["submit"])){
$hidden = "$_POST[hidden]";

$query = mysql_query("SELECT * FROM registrations WHERE id = $_POST[hidden] LIMIT 1") or DIE(mysql_error());
if(mysql_num_rows($query)!=0){
	while($r=mysql_fetch_array($query))
	{
echo "$r[id]";
	if($r[firstname] == $_POST["firstname_$hidden"]) {
			$firstname = $r[firstname];
			} else {
			$firstname = $_POST["firstname_$hidden"];
	}
	if($r[lastname] == $_POST["lastname_$hidden"]) {
			$lastname = $r[lastname];
			} else {
			$lastname = $_POST["lastname_$hidden"];
	}
	if($r[address] == $_POST["address_$hidden"]) {
			$address = $r[address];
			} else {
			$address = $_POST["address_$hidden"];
	}
	if($r[city] == $_POST["city_$hidden"]) {
			$city = $r[city];
			} else {
			$city = $_POST["city_$hidden"];
	}
	if($r[state] == $_POST["state_$hidden"]) {
			$state = $r[state];
			} else {
			$state = $_POST["state_$hidden"];
	}
	if($r[zip] == $_POST["zip_$hidden"]) {
			$zip = $r[zip];
			} else {
			$zip = $_POST["zip_$hidden"];
	}
	if($r[car] == $_POST["car_$hidden"]) {
			$car = $r[car];
			} else {
			$car = $_POST["car_$hidden"];
	}

	if($r[number] == $_POST["number_$hidden"]) {
			$number = $r[number];
			} else {
			$number = $_POST["number_$hidden"];
	}
	if($r[phone] == $_POST["phone_$hidden"]) {
			$phone = $r[phone];
			} else {
			$phone = $_POST["phone_$hidden"];
	}
	if($r[email] == $_POST["email_$hidden"]) {
			$email = $r[email];
			} else {
			$email = $_POST["email_$hidden"];
	}


$query = ("UPDATE registrations
SET firstname = '$firstname', lastname = '$lastname', address = '$address', city = '$city', state = '$state', zip = '$zip', car = '$car', number = '$number', phone = '$phone', email = '$email'
WHERE id = $r[id]
") or DIE(mysql_error());


	}

}

}








if (isset($_GET['u'])){
$query = mysql_query("UPDATE registrations SET active = '$_GET[u]' WHERE id = $_GET[i]") or DIE(mysql_error());
header("Location: index.php?page=admin&a=registrations");
exit;
}

$content .= "<table style=\"margin-top: 30px;\"><tr>
<td></td>
<td class=\"ar\">
Personal Information
</td><td class=\"ar\">
Contact Information
</td><td class=\"ar\">
Class & Car Information
</td>
</tr>
";

$query = mysql_query("SELECT * FROM registrations") or DIE(mysql_error());
if(mysql_num_rows($query)!=0){
$count = 1;
	while($r=mysql_fetch_array($query))
	{

$content .= "<form action=\"index.php?page=admin&a=registrations\" method=\"post\" name=\"update_registration_$r[id]\">";


$content .= "
<tr>";
if($r[active] == '1'){
$content .= "<td class=\"arx_a\">";
} else {
$content .= "<td class=\"arx\">";
}
$content .= "
<a href=\"index.php?page=admin&a=registrations&i=$r[id]&u=1\">+</a>
<br />
<a href=\"index.php?page=admin&a=registrations&i=$r[id]&u=0\">-</a>
<br />
<input type=\"submit\" name=\"submit\" value=\"update\" />
</td>
<td class=\"ar1\">
	<input size=\"8\" class=\"a_reg\" type=\"text\" value=\"$r[firstname]\" name=\"firstname_$r[id]\" /> <input size=\"11\" class=\"a_reg\" type=\"text\" value=\"$r[lastname]\" name=\"lastname_$r[id]\" /><br />
	<input size=\"23\" class=\"a_reg\" type=\"text\" value=\"$r[address]\" name=\"address_$r[id]\" /><br />
	<input size=\"10\" class=\"a_reg\" type=\"text\" value=\"$r[city]\" name=\"city_$r[id]\" />, <input style=\"text-transform: uppercase; text-align:center;\" size=\"1\" class=\"a_reg\" type=\"text\" value=\"$r[state]\" name=\"state_$r[id]\" /> <input style=\"text-align:center;\" maxlength=\"5\" size=\"3\" class=\"a_reg\" type=\"text\" value=\"$r[zip]\" name=\"zip_$r[id]\" />
</td><td class=\"ar2\">
	<input class=\"a_reg\" type=\"text\" value=\"$r[phone]\" name=\"phone_$r[id]\" /><br />
	<input class=\"a_reg\" type=\"text\" value=\"$r[email]\" name=\"email_$r[id]\" />
</td><td class=\"ar3\">
	<input class=\"a_reg\" type=\"text\" value=\"$r[car]\" name=\"car_$r[id]\" /><br />
	<input class=\"a_reg\" type=\"text\" value=\"$r[class]\" name=\"class_$r[id]\" /><br />
	<input class=\"a_reg\" type=\"text\" value=\"$r[number]\" name=\"number_$r[id]\" />
</td>
</tr>
<tr height=\"20\"><td></td><td></td><td></td></tr>


	";

	$content .= "<input type=\"hidden\" name=\"hidden\" value=\"$r[id]\" /></form>";

	}
$content .= "</table>";
}

break;

default:
$content .= "CUSTOM ADMIN CONTROL PANEL
<a href=\"index.php?page=admin&a=registrations\">registrations</a>";
break;



}






$content .= "</div>";


?>

 

 

Specifically talking about case: registrations. When I click on update for the form, I'm getting an error message:

[phpBB Debug] PHP Notice: in file /var/www/vhosts/outlawracing.com/httpdocs/admin.php on line 32: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

 

Not too sure why.  :shrug:

I also had "class" in the query at top but it was giving me some error, so once I get this portion working I'll add it back in and go from there.

Link to comment
https://forums.phpfreaks.com/topic/194052-running-in-to-a-few-problems/
Share on other sites
aebstract Advanced Member

aebstract

Posted
  • Author
Posted 

<?php
if ($user->data['username_clean'] != admin) {
header("Location: index.php");
exit;
}

$content .= "<div id=\"content\">";












switch ($_GET['a']) {



case registrations:


if (isset($_POST["submit"])){
$hidden = "$_POST[hidden]";

$query2 = mysql_query("SELECT * FROM registrations WHERE id = $_POST[hidden]") or DIE(mysql_error());
if(mysql_num_rows($query2)!=0){
	while($rs=mysql_fetch_array($query2))
	{
	if($rs[firstname] == $_POST["firstname_$hidden"]) {
			$firstname = $rs[firstname];
			} else {
			$firstname = $_POST["firstname_$hidden"];
	}
	if($rs[lastname] == $_POST["lastname_$hidden"]) {
			$lastname = $rs[lastname];
			} else {
			$lastname = $_POST["lastname_$hidden"];
	}
	if($rs[address] == $_POST["address_$hidden"]) {
			$address = $rs[address];
			} else {
			$address = $_POST["address_$hidden"];
	}
	if($rs[city] == $_POST["city_$hidden"]) {
			$city = $rs[city];
			} else {
			$city = $_POST["city_$hidden"];
	}
	if($rs[state] == $_POST["state_$hidden"]) {
			$state = $rs[state];
			} else {
			$state = $_POST["state_$hidden"];
	}
	if($rs[zip] == $_POST["zip_$hidden"]) {
			$zip = $rs[zip];
			} else {
			$zip = $_POST["zip_$hidden"];
	}
	if($rs[car] == $_POST["car_$hidden"]) {
			$car = $rs[car];
			} else {
			$car = $_POST["car_$hidden"];
	}

	if($rs[number] == $_POST["number_$hidden"]) {
			$number = $rs[number];
			} else {
			$number = $_POST["number_$hidden"];
	}
	if($rs[phone] == $_POST["phone_$hidden"]) {
			$phone = $rs[phone];
			} else {
			$phone = $_POST["phone_$hidden"];
	}
	if($rs[email] == $_POST["email_$hidden"]) {
			$email = $rs[email];
			} else {
			$email = $_POST["email_$hidden"];
	}


$query = ("UPDATE registrations
SET firstname = '$firstname', lastname = '$lastname', address = '$address', city = '$city', state = '$state', zip = '$zip', car = '$car', number = '$number', phone = '$phone', email = '$email'
WHERE id = $r[id]
") or DIE(mysql_error());


	}

}

}








if (isset($_GET['u'])){
$query = mysql_query("UPDATE registrations SET active = '$_GET[u]' WHERE id = $_GET[i]") or DIE(mysql_error());
header("Location: index.php?page=admin&a=registrations");
exit;
}

$content .= "<table style=\"margin-top: 30px;\"><tr>
<td></td>
<td class=\"ar\">
Personal Information
</td><td class=\"ar\">
Contact Information
</td><td class=\"ar\">
Class & Car Information
</td>
</tr>
";

$query = mysql_query("SELECT * FROM registrations") or DIE(mysql_error());
if(mysql_num_rows($query)!=0){
$count = 1;
	while($r=mysql_fetch_array($query))
	{

$content .= "<form action=\"index.php?page=admin&a=registrations\" method=\"post\" name=\"update_registration_$r[id]\">";


$content .= "
<tr>";
if($r[active] == '1'){
$content .= "<td class=\"arx_a\">";
} else {
$content .= "<td class=\"arx\">";
}
$content .= "
<a href=\"index.php?page=admin&a=registrations&i=$r[id]&u=1\">+</a>
<br />
<a href=\"index.php?page=admin&a=registrations&i=$r[id]&u=0\">-</a>
<br />
<input type=\"submit\" name=\"submit\" value=\"update\" />
</td>
<td class=\"ar1\">
	<input size=\"8\" class=\"a_reg\" type=\"text\" value=\"$r[firstname]\" name=\"firstname_$r[id]\" /> <input size=\"11\" class=\"a_reg\" type=\"text\" value=\"$r[lastname]\" name=\"lastname_$r[id]\" /><br />
	<input size=\"23\" class=\"a_reg\" type=\"text\" value=\"$r[address]\" name=\"address_$r[id]\" /><br />
	<input size=\"10\" class=\"a_reg\" type=\"text\" value=\"$r[city]\" name=\"city_$r[id]\" />, <input style=\"text-transform: uppercase; text-align:center;\" size=\"1\" class=\"a_reg\" type=\"text\" value=\"$r[state]\" name=\"state_$r[id]\" /> <input style=\"text-align:center;\" maxlength=\"5\" size=\"3\" class=\"a_reg\" type=\"text\" value=\"$r[zip]\" name=\"zip_$r[id]\" />
</td><td class=\"ar2\">
	<input class=\"a_reg\" type=\"text\" value=\"$r[phone]\" name=\"phone_$r[id]\" /><br />
	<input class=\"a_reg\" type=\"text\" value=\"$r[email]\" name=\"email_$r[id]\" />
</td><td class=\"ar3\">
	<input class=\"a_reg\" type=\"text\" value=\"$r[car]\" name=\"car_$r[id]\" /><br />
	<input class=\"a_reg\" type=\"text\" value=\"$r[class]\" name=\"class_$r[id]\" /><br />
	<input class=\"a_reg\" type=\"text\" value=\"$r[number]\" name=\"number_$r[id]\" />
</td>
</tr>
<tr height=\"20\"><td></td><td></td><td></td></tr>


	";

	$content .= "<input type=\"hidden\" name=\"hidden\" value=\"$r[id]\" /></form>";

	}
$content .= "</table>";
}

break;

default:
$content .= "CUSTOM ADMIN CONTROL PANEL
<a href=\"index.php?page=admin&a=registrations\">registrations</a>";
break;



}






$content .= "</div>";


?>

 

This isn't giving me an error, but it isn't updating my database.

aebstract Advanced Member

aebstract

Posted
  • Author
Posted

Most recent:

<?php
if ($user->data['username_clean'] != admin) {
header("Location: index.php");
exit;
}

$content .= "<div id=\"content\">";












switch ($_GET['a']) {



case registrations:


if (isset($_POST["submit"])){
$hidden = "$_POST[hidden]";

$query2 = mysql_query("SELECT * FROM registrations WHERE id = $_POST[hidden]") or DIE(mysql_error());
if(mysql_num_rows($query2)!=0){
	while($rs=mysql_fetch_array($query2))
	{
	if($rs[firstname] == $_POST["firstname_$hidden"]) {
			$firstname = $rs[firstname];
			} else {
			$firstname = $_POST["firstname_$hidden"];
	}
	if($rs[lastname] == $_POST["lastname_$hidden"]) {
			$lastname = $rs[lastname];
			} else {
			$lastname = $_POST["lastname_$hidden"];
			echo "IT CHANGED $lastname";
	}
	if($rs[address] == $_POST["address_$hidden"]) {
			$address = $rs[address];
			} else {
			$address = $_POST["address_$hidden"];
	}
	if($rs[city] == $_POST["city_$hidden"]) {
			$city = $rs[city];
			} else {
			$city = $_POST["city_$hidden"];
	}
	if($rs[state] == $_POST["state_$hidden"]) {
			$state = $rs[state];
			} else {
			$state = $_POST["state_$hidden"];
	}
	if($rs[zip] == $_POST["zip_$hidden"]) {
			$zip = $rs[zip];
			} else {
			$zip = $_POST["zip_$hidden"];
	}
	if($rs[car] == $_POST["car_$hidden"]) {
			$car = $rs[car];
			} else {
			$car = $_POST["car_$hidden"];
	}
	if($rs['class'] == $_POST["class_$hidden"]) {
			$class = $rs['class'];
			} else {
			$class = $_POST["class_$hidden"];
	}
	if($rs[number] == $_POST["number_$hidden"]) {
			$number = $rs[number];
			} else {
			$number = $_POST["number_$hidden"];
	}
	if($rs[phone] == $_POST["phone_$hidden"]) {
			$phone = $rs[phone];
			} else {
			$phone = $_POST["phone_$hidden"];
	}
	if($rs[email] == $_POST["email_$hidden"]) {
			$email = $rs[email];
			} else {
			$email = $_POST["email_$hidden"];
	}


mysql_query("UPDATE registrations
SET firstname = '$firstname', lastname = '$lastname', address = '$address', city = '$city', state = '$state', zip = '$zip', car = '$car', class= '$class', number = '$number', phone = '$phone', email = '$email'
WHERE id = $r[id]") or DIE(mysql_error());

header("Location: index.php?page=admin&a=registrations");
exit;


	}

}

}








if (isset($_GET['u'])){
$query = mysql_query("UPDATE registrations SET active = '$_GET[u]' WHERE id = $_GET[i]") or DIE(mysql_error());
header("Location: index.php?page=admin&a=registrations");
exit;
}

$content .= "<table style=\"margin-top: 30px;\"><tr>
<td></td>
<td class=\"ar\">
Personal Information
</td><td class=\"ar\">
Contact Information
</td><td class=\"ar\">
Class & Car Information
</td>
</tr>
";

$query = mysql_query("SELECT * FROM registrations") or DIE(mysql_error());
if(mysql_num_rows($query)!=0){
$count = 1;
	while($r=mysql_fetch_array($query))
	{

$content .= "<form action=\"index.php?page=admin&a=registrations\" method=\"post\" name=\"update_registration_$r[id]\">";


$content .= "
<tr>";
if($r[active] == '1'){
$content .= "<td class=\"arx_a\">";
} else {
$content .= "<td class=\"arx\">";
}
$content .= "
<a href=\"index.php?page=admin&a=registrations&i=$r[id]&u=1\">+</a>
<br />
<a href=\"index.php?page=admin&a=registrations&i=$r[id]&u=0\">-</a>
<br />
<input type=\"submit\" name=\"submit\" value=\"update\" />
</td>
<td class=\"ar1\">
	<input size=\"8\" class=\"a_reg\" type=\"text\" value=\"$r[firstname]\" name=\"firstname_$r[id]\" /> <input size=\"11\" class=\"a_reg\" type=\"text\" value=\"$r[lastname]\" name=\"lastname_$r[id]\" /><br />
	<input size=\"23\" class=\"a_reg\" type=\"text\" value=\"$r[address]\" name=\"address_$r[id]\" /><br />
	<input size=\"10\" class=\"a_reg\" type=\"text\" value=\"$r[city]\" name=\"city_$r[id]\" />, <input style=\"text-transform: uppercase; text-align:center;\" size=\"1\" class=\"a_reg\" type=\"text\" value=\"$r[state]\" name=\"state_$r[id]\" /> <input style=\"text-align:center;\" maxlength=\"5\" size=\"3\" class=\"a_reg\" type=\"text\" value=\"$r[zip]\" name=\"zip_$r[id]\" />
</td><td class=\"ar2\">
	<input class=\"a_reg\" type=\"text\" value=\"$r[phone]\" name=\"phone_$r[id]\" /><br />
	<input class=\"a_reg\" type=\"text\" value=\"$r[email]\" name=\"email_$r[id]\" />
</td><td class=\"ar3\">
	<input class=\"a_reg\" type=\"text\" value=\"$r[car]\" name=\"car_$r[id]\" /><br />
	<input class=\"a_reg\" type=\"text\" value=\"$r[class]\" name=\"class_$r[id]\" /><br />
	<input class=\"a_reg\" type=\"text\" value=\"$r[number]\" name=\"number_$r[id]\" />
</td>
</tr>
<tr height=\"20\"><td></td><td></td><td></td></tr>


	";

	$content .= "<input type=\"hidden\" name=\"hidden\" value=\"$r[id]\" /></form>";

	}
$content .= "</table>";
}

break;

default:
$content .= "CUSTOM ADMIN CONTROL PANEL
<a href=\"index.php?page=admin&a=registrations\">registrations</a>";
break;



}






$content .= "</div>";


?>

 

No errors of any kind, database isn't being updated.

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.