How to grab variable?

Radon3k

Below is my code. I believe the last if statement isn't working because it isn't grabbing the variable I need. Is there a way to grab the variable so the code will work? Thanks. 🙂

<html>
<head>
<title></title>
</head>
<body text="#000000">
To find a record, type a query into the search box:<br>
<form method="post" action="<?php echo("$PHP_SELF")?>">
Family Last Name:<input type="text" name="lname"><br>
<input type="submit" name="subsearch" value="Search"><br><br>
<?php
$db = mysql_connect("localhost", "root", "kaod");
if(!$db) {
	echo("Could not connect to the database server.");
}

mysql_select_db("test", $db);
if(!@mysql_select_db("test")) {
	echo("Could not connect to the database.");
}

if($_POST['subsearch'] == "Search") {
	$search = mysql_query("SELECT * FROM family WHERE PLAST_NM LIKE '%$lname%' GROUP BY PLAST_NM");

$num = mysql_num_rows($search);
if($num > 0) {
	while($row = mysql_fetch_array($search)) {
		$famid = $row['fam_id'];
		$firstname = $row['PFIRST_NM'];
		$lastname = $row['PLAST_NM'];
		$addy = $row['ADDRESS'];
		$city = $row['CITY'];
		$state = $row['STATE'];
		$zip = $row['ZIP'];
		$country = $row['COUNTRY'];

		echo("<table cellpadding='0' cellspacing='0' bgcolor='#CCCCCC' width='400'>");
		echo("<tr><td>");
		echo("<b>ID:</b> $famid<br>");
		echo("<b>Name:</b> $lastname, $firstname<br>");
		echo("<b>Address:</b> $addy<br>");
		echo("<b>City:</b> $city<br>");
		echo("<b>State:</b> $state<br>");
		echo("<b>Zip:</b> $zip<br>");
		echo("<b>Country:</b> $country<br>");
		echo("</td></tr>");
		echo("<tr><td align='center'>");
		echo("<a href='sql.php?action=modify&id=$famid'>Modify</a> &nbsp;");
		echo("<a href='sql.php?action=delete&id=$famid'>Delete</a><br>");
		echo("</td></tr>");
	}
}
}

if($_GET['action'] == "modify") {
	$getidf = "SELECT * FROM family WHERE `fam_id` = '$id'" or die(mysql_error());
	$queryf = mysql_query($getidf);
	while($rowf = mysql_fetch_array($queryf)) {
        $famidf = $rowf['fam_id'];
        $fnamef = $rowf['PFIRST_NM'];
        $lnamef = $rowf['PLAST_NM'];
		$addyf = $rowf['ADDRESS'];
		$cityf = $rowf['CITY'];
		$statef = $rowf['STATE'];
		$zipf = $rowf['ZIP'];
		$phonef = $rowf['P_PHONE'];
		echo("<table border=0 cellpadding=0 cellspacing=0 bgcolor='#CCCCCC' width='400'>");
		echo("<tr><td align='center' valign='middle'>");
		echo("<b>Family Table</b>");
		echo("</td></tr>");
		echo("<tr><td>");
		echo("<b>Family ID:</b> $famidf<br>");
		echo("<b>Name:</b> $fnamef $lnamef<br>");
		echo("<input type='hidden' name='id' value='$id'>");
		echo("<b>Address:</b> <input type='text' name='famaddy' value='$addyf'><br>");	
		echo("<b>City:</b> <input type='text' name='famcity' value='$cityf'><br>");
		echo("<b>State:</b> <input type='text' name='famstate' value='$statef'><br>");
		echo("<b>Zip:</b> <input type='text' name='famzip' value='$zipf'><br>");
		echo("<b>Phone:</b> <input type='text' name='famphone' value='$phonef'><br>");
		echo("</td></tr></table>");
		echo("<br><br>");
		echo("<input type='submit' name='subfam' value='Continue'>");
	}
}

if($_POST['subfam'] == "Continue") {
	$updatefam = mysql_query("UPDATE family SET
					ADDRESS = '$famaddy',
					CITY = '$famcity',
					STATE = '$famstate',
					ZIP = '$famzip',
					P_PHONE = '$famphone' WHERE `fam_id` = '$id'");

if($updatefam) {
	echo("Updated.<br>");
	echo("<a href='sql.php?action=accounts'>Click here to proceed</a>");
}
}

if($_GET['action'] == "accounts") {
	echo("<input type='hidden' name='id' value='$id'>");
	$getida = "SELECT * FROM accounts WHERE `fam_id` = '$id'" or die(mysql_error());
	$querya = mysql_query($getida);
	while($rowa = mysql_fetch_array($querya)) {
		$famida = $row['fam_id'];
		echo("$famida");
	}
}
?>

ESCForums_com

I presume the problem is here:

while($rowa = mysql_fetch_array($querya)) {
        $famida = $row['fam_id'];

"while($rowa =" -> so "$famida = $rowa['fam_id'];"
$row['fam_id'] is undefined...
$rowa['fam_id'] is workin...

Radon3k

oops, that was just a small typo. It still doesn't work.

stolzyboy

if you replace this

echo("<input type='hidden' name='id' value='$id'>");

with this

echo("<input type='text' name='id' value='$id'>");

do you see a value in the text box

Radon3k

All I see is an empty text field. No values in it.

stolzyboy

then do this

$id = $_GET['id'];
//then do your echo
echo "<input type=\"hidden\" name=\"id\" value=\"" . $id . "\">";

Radon3k

That doesn't work either.

stolzyboy

i edited my previous post, and please when you say it still
doesn't work, tell us how, if you give us more information we will
be able to help you easier, just saying it doesn't work could mean
a lot of things, give us errors, etc..........

The_Chancer

//edited

In this

if($_POST['subfam'] == "Continue") {
    $updatefam = mysql_query("UPDATE family SET
                    ADDRESS = '$famaddy',
                    CITY = '$famcity',
                    STATE = '$famstate',
                    ZIP = '$famzip',
                    P_PHONE = '$famphone' WHERE `fam_id` = '$id'");

if($updatefam) {
    echo("Updated.<br>");
    echo("<a href='sql.php?action=accounts'>Click here to proceed</a>");
}
}

You don't seem to be passing the $id over... try putting it in the link...

Also echo out the final SQL statement in the accounts section - see what you get... is it what you expected ? Is the $id variable filled ?

stolzyboy

maybe radon you should give this a read

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10240608

The_Chancer

Makes for a very good read too...

And helps in finding almost all errors - must say I do use his suggestions as a matter of course..

Radon3k

My apologies. The thing is, it's not throwing errors, it's just that nothing at all is showing up. Perhaps if I explained a little bit about what I was doing that may help.

In a way, I'm creating a mini "phpMyAdmin" for non-programmer (or computer for that matter) savvy folks. They can search the database and it will bring up a list of names that it found. Beneath each name they can click either "Modify" or "Delete". Delete will obviously delete the record from the database. Modify will allow them to edit any part of that record that they choose, without messing up anything that already exists. However, I'm having problems getting the information to display how I need it to.

There are 4 tables that I am working with: accounts, courses, family, and members. What I wanted was that when the "Modify" link was clicked, a page would display four tables each containing the information for that name (or ID) in that table. There would be one "Submit" button at the bottom that they would click after all of the information was edited to suit their needs. Once the "Submit" button was clicked the information in the database would be updated and they could then do another search, or whatever they need to do.

All my attempts at this thus far have been futile because I can only get one table to show at a time. This was supposed to be done a while ago but between other work and being out of town it's been kind of hard. Not to mention the problems I've ran into with this. Would it be possible for someone to guide me in the right direction now that you know what I'm trying to accomplish? I would be most appreciative of it as I always am for any help that I receive here. I'm not looking for someone to write code (I won't stop them, but that's not what I'm asking 😉), just merely some help in the right direction with how I might better write my code to make this work so that I don't have to go through 5 different pages just to get one record updated.

As a side note I am about to read that "Debugging 101" link that was provided. Thanks for that and thanks for all the help you've provided me with! 🙂

Radon3k

Anybody?