PHP/MySQL programming?

sonjeriff · 10-22-2010, 11:14 AM

hi , ive made a member profile page and i want to grab the member data from the mysql table and display it on the page.

i want to grab the data from the row associated with the member logged in.

thanks.

**Eric** · 10-23-2010, 05:15 PM

Well, it would depend on the structure of your database and how you're getting the member's id and/or username (however you check if they're logged in).

Obulus · 11-03-2010, 02:49 PM

Maybe looking into arraying the row that is assigned to the user logged in?

BuLLDoG · 11-03-2010, 04:59 PM

you need a function to grab a id of the profile such as:

$id=$_GET['id'];

then a WHERE clause in your SQL statement, something like:

SELECT * FROM members WHERE id = '$id'

Something along those lines

hhelen · 11-26-2010, 09:06 AM

Looks like the OP has found a solution to their database problem.

rickmci · 11-26-2010, 06:23 PM

Originally Posted by BuLLDoG

you need a function to grab a id of the profile such as:
????: NamePros.com http://www.namepros.com/programming/683498-php-mysql-programming.html

$id=$_GET['id'];

then a WHERE clause in your SQL statement, something like:

SELECT * FROM members WHERE id = '$id'

Something along those lines

This is exaaclty right. However, you will need to know what user is logged in in the first place and there are several ways to do that. id will = the user id assigned in you web page to the currently loged on user.

stevemack · 11-29-2010, 10:59 PM

also it depends on the structure of the db. i think BollDog has come up with the solution.

trukin · 12-01-2010, 09:58 AM

Originally Posted by BuLLDoG

you need a function to grab a id of the profile such as:

$id=$_GET['id'];

then a WHERE clause in your SQL statement, something like:

SELECT * FROM members WHERE id = '$id'

Something along those lines

????: NamePros.com http://www.namepros.com/showthread.php?t=683498
Make sure you use something like PDO or mysql_escape_string when using raw user input. You don't want to be dealing with SQL Injections.

10-22-2010, 11:14 AM	THREAD STARTER #1 (permalink)
sonjeriff First Time Poster! Join Date: Oct 2010 Posts: 1	PHP/MySQL programming? hi , ive made a member profile page and i want to grab the member data from the mysql table and display it on the page. i want to grab the data from the row associated with the member logged in. thanks. __________________ 7zip download

11-03-2010, 02:49 PM	#3 (permalink)
Obulus NamePros Regular Join Date: Aug 2009 Posts: 313	Maybe looking into arraying the row that is assigned to the user logged in? __________________ Available for hire.

11-03-2010, 04:59 PM	#4 (permalink)
BuLLDoG NamePros Regular Join Date: Aug 2003 Location: England Posts: 934	you need a function to grab a id of the profile such as: $id=$_GET['id']; then a WHERE clause in your SQL statement, something like: SELECT * FROM members WHERE id = '$id' Something along those lines __________________ Free iPhone \| Free Facebook Likes

11-29-2010, 10:59 PM	#7 (permalink)
stevemack New Member Join Date: Aug 2010 Location: US Posts: 21	also it depends on the structure of the db. i think BollDog has come up with the solution. __________________ Drivers Ed \| Virginia Driving School \| Traffic School Florida

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Looking for PHP/MySQL Programming Work	Cyphix	Developers For Hire	4	04-22-2007 12:33 PM
Basic Introduction to Programming - Vocab	Rudy	Webmaster Tutorials	1	08-23-2005 06:08 PM
PHP/MySQL Programming Project - Earn MID $xx	PolurNET	Web Development Wanted	0	06-28-2005 08:43 AM
Help needed with personal project. PHP/MySql programming and layouts!	QBert	Website Development	3	11-09-2004 10:52 AM

10-23-2010, 05:15 PM	#2 (permalink)
Eric Tech Support Join Date: Mar 2005 Posts: 4,944	Well, it would depend on the structure of your database and how you're getting the member's id and/or username (however you check if they're logged in).

11-26-2010, 09:06 AM	#5 (permalink)
hhelen New Member Join Date: Nov 2010 Posts: 2	Looks like the OP has found a solution to their database problem.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)