Small problem - Dev Articles

Dev Articles Community Forums Sponsor:

September 21st, 2002, 10:18 AM

Teckniel

Junior Member

Join Date: Sep 2002

Posts: 1

Time spent in forums: < 1 sec
Reputation Power: 0

Small problem

if i enter a url like
URL

how can i see the artikel with id 6
on the page??
and just that artikel with id 6??

September 21st, 2002, 11:21 AM

Ben Rowe

Guest

Posts: n/a
Time spent in forums:
Reputation Power:

this means that your sending a get variable to the server.

a simple example would be

echo $_GET['artikelid'];

so in your case it would print out 6, you can then use this variable to query a database or do anything you like with it

September 21st, 2002, 11:23 AM

Joe4JC

The name's Joe. Yours?

Join Date: Aug 2002

Location: Lurking in the shadows...

Posts: 147

Time spent in forums: < 1 sec
Reputation Power: 7

Cheers, m8, try this:

PHP Code:


		
			
<?php

$id = $_GET['artikelid'];



$query = "SELECT * FROM your_table WHERE id='$id'";



$connect = mysql_connect('localhost', 'user', 'password');

$select = mysql_select_db('yourdb', $connect);

$result = mysql_query($query) or die('MySQL error: '.mysql_error().'. Error #'.mysql_errno());

if (mysql_num_rows($result) >= 1) {

while(list($data) = mysql_fetch_row($result)) {

echo $data;

}

mysql_free_result($result);

mysql_close($connect);

?>

Also, reading the manual helps too!

Good luck,
Joe of 4Life

[edit]I assume that the article is in a MySQL database. Is it?[/edit]

__________________
Check out 4Life today!

Last edited by Joe4JC : September 21st, 2002 at 11:28 AM.

September 21st, 2002, 11:25 AM

Joe4JC

The name's Joe. Yours?

Join Date: Aug 2002

Location: Lurking in the shadows...

Posts: 147

Time spent in forums: < 1 sec
Reputation Power: 7

Wow Ben, you posted before I could! Well, actually it took me 20 mins to type that because I was trying to do a million other things at once!

lol

Cheers,
Joe of 4Life

September 21st, 2002, 12:42 PM

wAr-AnGeL

Forum Security

Join Date: Apr 2002

Location: Behind You

Posts: 479

Time spent in forums: 6 m
Reputation Power: 7

Joe4JC's code is basically what you are going to need to do. You will need to make changes in order for it to fit your website's style, database structure, etc..

For more indepth explanation on retrieving data from a specifc row in a table can be found in Ben's PHP & MySQL basics tutorial.

__________________

"Only Linux users see the end of crashes."
- Pl4t0

Viewing: Dev Articles Community Forums > Programming > General Programming Help > Small problem

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump