$_GET & Includes questions and issues

TheMightySpud

Hi all,

Hopefully, this will make sense to people 🙂

I'm building a site for a friend, and I'm fairly new to PHP, so here goes.....

What I'm trying to do is display several images in a spiral pattern, this in itself is not a problem if I was using HTML, but future functionality demands that I use PHP and a database (Will need to upload new images, add comments etc. at a later date for each of the images.)

The problem I'm having is getting the information from the database to display.

Here's the php

<?php

$id= $_GET['id'];

//=====================================//
// Database Section
//=====================================//
// creates a new Common-Object-Model (COM) connection object
	$adoCon = new COM("ADODB.Connection");

// the path to the folder holding this PHP script
	$sHere = dirname(__FILE__);

// opens the connection using a standard Access2007 connection string
	$adoCon-> Open("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=$sHere/dbase/test1.accdb");

$sSQL=	"SELECT * FROM tblTest WHERE ID LIKE $id";

// searches the DB
	$rsMain = $adoCon->Execute( $sSQL );

//=====================================//
// Outputs all the selected fields in the table "tblTest",
// processes each record until we reach the end of the recordset


	$simgURL = $rsMain->Fields("URL")->value;
//	
//
//		// prints each of the fields
		print "<img src='images/grid/$simgURL'>";

//=====================================//
// closes the recordset, frees up resources, kills all traces
//	$rsMain->Close();
//	$rsMain = null;

// closes the connection, frees up resources, kills all traces
//	$adoCon->Close();
//	$adoCon = null;

?>

This works fine when ran by itself. The problem comes when I try to use 'includes' now I'm pretty sure the problem is the includes itself, the error kinda tells me so.

So, here's how I'm trying it atm, but it seems as though passing ReadDB.php?id=2 is something that the includes command doesn't like.

<td><?php include("ReadDB.php?id=2"); ?></td>

I've also tried using the img src html tag (changing the PHP to fit), but with no luck.

Could someone point me in the right direction?

Also, because of the way the images will be layed out, the 'id=' part needs to be a static number.

Thanks
TheMightySpud

laserlight

Ah, but you see, include normally works with a file path, not a URL (the exception being when you use the url fopen wrappers, e.g., include 'http://www.example.com'; in which case the included file would have already been parsed by the remote server).

This means that the "?id=2" does not make $GET['id'] exist in ReadDB.php. Rather, ReadDB.php can already access $GET['id'] and can also access $id from the current script, as long as it is defined before the inclusion.

TheMightySpud

Hi,

Thanks for the swift reply.

I understand what you mean about the file/url thing, that's pretty straight forward, thanks.

I've had a look at the fopen() command, but I'm not quite sure how to use it (the php manual doesn't seem overly clear to me.

Any chance of an example?

Thanks
TheMightySpud

laserlight

Unless you need to use fopen(), use [man]file_get_contents/man.

However, are you sure that including the file is not the correct thing to do? What is ReadDB.php for?

TheMightySpud

ReadDB.php basically takes the id from the URL and performs an SQL query to get the url of an image stored in the DB, then displays the image.

It needs to be database based, because once this part is complete, I'll be adding upload/comment functionality.

Thanks again 🙂

TheMightySpud

Okay, so I've been trying to figure this out for the best part of 7 hours, and it's really beginning to bug me.

I've put this together as an example of what I am trying to do.

http://www.woolywarrior.co.uk/magpie/grid.php

Each square needs to be an image, and each image needs to appear in the sequence shown on that example.

The idea being that vistors to the site can upload the 'next' image in the sequence.

Could someone point me in the right direction on how to acheive this please?

Thanks
TheMightySpud