Viewing Information on another PHP File

[Arsenal_Rule]

Ive done the design for my view.php file, and its all working well, but, its got a few teething errors, my echo statements wont work.

what i'm trying to get at is, getting a layout for each different user, so when they click on their name in the testview.php table, it links to view.php and on the view.php file they see:

• [az_firstname][az_surname] at the top in Bold as a header,
• [user_id] a few spaces below in normal font and
• [password] 2 spaces below user_id in normal font

here is my code for testview.php which works and links nicely to the view.php

<?php 


	$conn = mysql_connect("localhost","root","") or die("Could Not Connect To The Database"); 
	mysql_select_db("aziz",$conn) or die("Could Not Select The Database"); 



$result=mysql_query("SELECT user_id,az_firstname,az_surname,username FROM azizpassword ORDER BY user_id;");

$i=0;
while( $row=mysql_fetch_array($result) )
{
	if($i>0)
	{
		echo "<tr valign=top>";
		echo "<td bgcolor=#ffffff background='img/strichel.gif' colspan=6><img src=img/blank.gif wuser_idth=1 height=1></td>";
		echo "</tr>";
	}
	echo "<tr valign=center>";
	echo "<td width=100 class=table><b>".$row['user_id']."</b></td>";
	echo "<td width=100 class=table><a href=\"view.php?id=".$row['user_id']."\">".$row['az_surname']."</a></td>";
	echo "<td width=100 class=table>".$row['az_firstname']." </td>";
	echo "<td width=100 class=table><i>".$row['username']."</i> </td>";

	echo "<td class=table></td>";
	echo "</tr>";
	$i++;

}

echo "<tr valign=bottom>";
    echo "<td bgcolor=#fb7922 colspan=6><img src=img/blank.gif wuser_idth=1 height=8></td>";
    echo "</tr>";





?>

here is my code for view.php:

<?php
			if(isset($_REQUEST['user_id']))
			{
			$user_id = $_REQUEST['user_id'];

		$conn = mysql_connect("localhost","root","") or die("Could Not Connect To The Database"); 
	mysql_select_db("aziz",$conn) or die("Could Not Select The Database"); 

		//sql query somethinglike
		$sql = "SELECT * FROM users_table WHERE user_id = '$id'"; 

		//the display stuff here.  }


		}
		?>

I've taken all the display stuff out for now, because ive tried everything and i get nothing but errors.

So what I need to know is what is the best way to achieve what is wanted above which is the layout of

-[az_firstname][az_surname] at the top in Bold as a header,
- [user_id] a few spaces below in normal font and
- [password] 2 spaces below user_id in normal font

If anyone could show me some examples on how to get this information to appear, it'd be much appreciated!!

Any help would be much appreciated because been stuck on this for a very long time now so it would be greatly appreciated if someone could help me with this problem THANK YOU ALL FOR YOUR TIME 🙂

[kburger]

$sql = "SELECT * FROM users_table WHERE user_id = '$id'";  

should be

$sql = "SELECT * FROM users_table WHERE user_id = '$user_id'";  

Other than that, you should be able to use the stuff that's in your 'testview.php' to be able to correctly set up your 'view.php'

[Arsenal_Rule]

Thanx mate for your help I tried it but it doesn't come up with anything on screen I tried to put the same table features as I did in testview.php to show the the output but it stil does work.

Here the code for view.php

<?php
			if(isset($_REQUEST['user_id']))
			{
			$user_id = $_REQUEST['user_id'];

		$conn = mysql_connect("localhost","root","") or die("Could Not Connect To The Database"); 
	mysql_select_db("aziz",$conn) or die("Could Not Select The Database"); 

		//sql query somethinglike
		$sql = "SELECT * FROM users_table WHERE user_id = '$user_id'"; 

		//your display stuff here.  }
		echo "<tr valign=center>";
	echo "<td width=100 class=table><b>".$row['user_id']."</b></td>";
	echo "<td width=100 class=table><b>".$row['az_surname']."</b></a></td>";
	echo "<td width=100 class=table>".$row['az_firstname']." </td>";
	echo "<td width=100 class=table><i>".$row['username']."</i> </td>";

	echo "<td class=table></td>";
	echo "</tr>";
	$i++;
		}
		?>

So I am still having problems with viewing anything on this page because everytime I click on the name linked to view.php it does not proceed to show anything at all so I am left with a black screen I hope some one can help me get out of this hole I'm I would be very much appreciate it Thank You Again for you time
🙂

[kburger]

You're never actually executing that query you created. In your testview.php file look at your use of mysql_query() and mysql_fetch_array(). Those parts are missing in your view.php.

All you're doing right now is connecting to a database server, selecting a database, then assigning a string to a variable named $sql.

[Arsenal_Rule]

Thanx for replying mate appreciate it. I just wanna ask if you can show me what I have to do on view.php I know it maybe ignorant but its just I'm really struggling with this program I am just a beginner at PHP I have no real experience with it at all, so if it is ok that you can show me what I have to do to correct view.php to make it ork and show what is wanted to see on that page.

I hope you can help me with this

Take Care

[kburger]

I don't know what info you want to extract from users_table, but the basic idea is this.

$sql = "SELECT * FROM users_table WHERE user_id = '$user_id'"; 
$result=mysql_query($sql); // <-- you were missing this
echo "<table>";

while( $row=mysql_fetch_assoc($result) ) { // <-- and this
    echo "<tr valign=center>";
    echo "<td width=100 class=table><b>".$row['user_id']."</b></td>";
    echo "<td width=100 class=table><b>".$row['az_surname']."</b></td>";
    echo "<td width=100 class=table>".$row['az_firstname']." </td>";
    echo "<td width=100 class=table><i>".$row['username']."</i> </td>";
    echo "<td class=table></td>";
    echo "</tr>"; 
}
echo "</table>";

edit: oops. I originally posted using mysql_fetch_array(). I should have posted mysql_fetch_assoc().

[Arsenal_Rule]

Thankyou so much for your reply mate I'm sorta getting the jist of it I will try it out but basically this the is what I wanted to extract from the user_table.

This how I would like it best to look on screen from view.php.

[az_firstname][az_surname] at the top in Bold as a header,
- [user_id] a few spaces below in normal font and
- [password] 2 spaces below user_id in normal font

Thankyou so much for your help again appreciate it mate

[kburger]

No problem. Hope it's beginning to make sense.

Assuming those are the actual field names from your table...

$sql = "SELECT * FROM users_table WHERE user_id = '$user_id'"; 
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);

echo "<h1>" . $row['az_firstname'] . " " . $row['az_surname'] . "</h1>";
echo "<br><br>" . $row['user_id'] . "<br><br>" . $row['password'];

That's pretty much all there is to it. I'll leave the HTML formatting up to you. But the basic idea is to connect to a database server, select a database to use, use mysql_query() to execute your query, and use mysql_fetch_assoc() to get the results of that query. In this particular case, there should only be one row returned. If there were going to be multiple rows returned we'd put it in a 'while' loop like in previous posts.

Let me know if anything's unclear. Read the manual on those functions I have linked above.

[Arsenal_Rule]

Thanx alot mate you have been a great help I will try this out it is beginning to make sense to me there is still hope lol. I will try this out to see if it works.

If it is ok if I can ask you for another favour if it ok to show me how I go about allowing the user to edit the information given in view.php when the Edit User button is clicked. If its possible you can please point me in the right direction.

You been a great help to me thanx mate really appreciate it mate

Take Care Mate

[kburger]

Well, the basic idea would be to build a form and put those values into the form. When the user clicks the submit button have it go to a page where the values of that form are updated to the database using an UPDATE query. Most of the code you'll need will simply be a modification of code you've used before. Play around with it. You should be able to figure it out.

[Arsenal_Rule]

Thanx again for the reply mate Ok I will research and try to figure what you said out but hopefully I will get to show you my attempt and If there is any problems with it is there any possiblity to show you and so you can see where i'm going wrong if thats ok

hope it is ok with you

Take Care Mate

[Arsenal_Rule]

Oh mate I've tried what you showed me to do but still nothing is happening on view.php when the username is clicked I honestly do not know what is wrong with this it is so frustrating it un believeable

Here is my testview.php code again

<?php 


	$conn = mysql_connect("localhost","root","") or die("Could Not Connect To The Database"); 
	mysql_select_db("aziz",$conn) or die("Could Not Select The Database"); 



$result=mysql_query("SELECT user_id,az_firstname,az_surname,username FROM azizpassword ORDER BY user_id;");

$i=0;
while( $row=mysql_fetch_array($result) )
{
	if($i>0)
	{
		echo "<tr valign=top>";
		echo "<td bgcolor=#ffffff background='img/strichel.gif' colspan=6><img src=img/blank.gif wuser_idth=1 height=1></td>";
		echo "</tr>";
	}
	echo "<tr valign=center>";
	echo "<td width=100 class=table><b>".$row['user_id']."</b></td>";
	echo "<td width=100 class=table><a href=\"view.php?id=".$row['user_id']."\">".$row['az_surname']."</a></td>";
	echo "<td width=100 class=table>".$row['az_firstname']." </td>";
	echo "<td width=100 class=table><i>".$row['username']."</i> </td>";

	echo "<td class=table></td>";
	echo "</tr>";
	$i++;

}

echo "<tr valign=bottom>";
    echo "<td bgcolor=#fb7922 colspan=6><img src=img/blank.gif wuser_idth=1 height=8></td>";
    echo "</tr>";





?>

And here is my view.php which is ment to link to the testview.php

<?php
			if(isset($_REQUEST['user_id']))
			{
			$user_id = $_REQUEST['user_id'];

		$conn = mysql_connect("localhost","root","") or die("Could Not Connect To The Database"); 
	mysql_select_db("aziz",$conn) or die("Could Not Select The Database"); 

		//sql query somethinglike

		$sql = "SELECT * FROM users_table WHERE user_id = '$user_id'";    
		$result = mysql_query($sql); 
		$row = mysql_fetch_assoc($result); 

	echo "<h1>" . $row['az_firstname'] . " " . $row['az_surname'] . "</h1>"; 
	echo "<br><br>" . $row['user_id'] . "<br><br>" . $row['password'];



		}
		?>

so annoying I have tried everything I just dunno what to do anymore I just dunno what to do to make it work. Basically all I want it to do is testview.php to have the user as a hyperlink to view.php and on view.php I want it to show that chosen usernme information. But what ever I seem to be trying I just can not make it work I just hope you or someone can see any mistakes I have made at that I may have missed. I really appreciate all the help I have gained so far because without I would not even be at this stage yet but now its the final bit I'm at of solving this problem but yet it still not working so I hope I could get help to sort this problem out once and for all that would be so great

Take Care

[kburger]

Look at this line from your test_vew.php.

echo "<td width=100 class=table><a href=\"view.php?id=".$row['user_id']."\">".$row['az_surname']."</a></td>"; 

Now look at these lines from view.php.

if(isset($_REQUEST['user_id']))
{
$user_id = $_REQUEST['user_id']; 

See the problem? Since you called it 'id' in test_vew.php, but you're looking for $REQUEST['user_id'] in view.php that entire block won't get executed (because $REQUEST['user_id'] DOESN'T have a value, but $_REQUEST['id'] does) -- hint hint.

[Arsenal_Rule]

here is my view.php

<?php
			if(isset($_REQUEST['id']))
			{
			$user_id = $_REQUEST['id'];

		$conn = mysql_connect("localhost","root","") or die("Could Not Connect To The Database"); 
	mysql_select_db("aziz",$conn) or die("Could Not Select The Database"); 

		//sql query somethinglike

		$sql = "SELECT * FROM users_table WHERE user_id = '".$user_id."'"; 
		$result = mysql_query($sql); 
		$row = mysql_fetch_assoc($result); 

	echo "<h1>" . $row['az_firstname'] . " " . $row['az_surname'] . "</h1>"; 
	echo "<br><br>" . $row['user_id'] . "<br><br>" . $row['password'];



		}
		?>

I think it works thankyou which is a big step because instead of getting nothing I'm getting this error now on view.php

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\apachefriends\xampp\htdocs\view.php on line 67

which is this part on on my code

$row = mysql_fetch_assoc($result);

what is my luck like with this thing as soon as another problem is solved another one comes up its so unfair its unbelieveable I hope you or anyone figure this out I'm trying at the moment but it is so frustrating but I will still soldier on and try my best but any help again would be greatly appreciated Thank You

Take Care

[Arsenal_Rule]

Hey don't worry about the last reply post because I have finally mnage to figure out what wa the problem and the main problem was that I name the I put the wrong table name so it was searching the a table that doesn't exist but thank god I manage to finally figure this problem out. Hey thank you for all your help kburger I really appreciate it. Now I'm gonna work on Edit these values I hope I can keep you updated and if there are any problems that I can show you If that is ok with you mate that would be really great. THANK YOU SO MUCH AGAIN

TAKE CARE