include ('series_letter.php?letter=$series_l'); ??

ricod

Hi ! I'm still working on my form.

I'm trying to populate my mySQL database with PHP and pretty much got it. Except the following. I retrieve all records from the series table where the index_letter = a. So, I get a list with all series starting with 'a'. I want a quick add, so the index_letter should automatically be submitted.

After submission I want the list that is shown to be updated, so I include the original php file again, but it has to pass on this index_letter. I tried several among :

$series_l = $_POST['series_letter'];
include ('series_letter.php?letter=' .$series_l);

But I get :
Warning: main(series_letter.php?letter=a) [function.main]: failed to create stream: Invalid argument in E:\web\list_files\submit_series.php on line 20

Can somebody help me ?

alanzhao

I am pretty sure that you can't do it like this, with a query string.

include ('series_letter.php?letter=$series_l');

but I don't know the reason😃

ricod

Yeah, that doesn't work (for those who just step in, I had that first). And the other one (see edited post) gives the same error,e xcept now it changes my variable nicely into that 'a'.

dalecosp

Your posts thus far don't say much about your program logic, so I can only guess at possible solutions. Is there any possibility you can call the updated page with header() ? For example, the form has now been submitted, and the handler script says:

<?
$series_l=$_POST['series_l'];
header("Location:  http://someplace.com/series_letter.php?letter=$series_l");
?>

tsinka

Hi,

the include function of php just includes a script. You cannot add get paramters to the script name. But that isn't neccessary, though.

If you include the file with include('series_letter.php') you already can access the $series_l variable in that script ($series_l in the global script code an $GLOBALS['$series_l'] in functions in that script).

So just remove the ?... part.

ricod

Thanks for the suggestions people !

tsinka's suggestion seems to work best for my setup. There's only one minor problem (which couldn't be forseen ofcourse since I didn't include my setup, like dalecsp said).

------------------------------(setup)-----------------------------------
I have a navigation bar that loads the series_letter.php in a frame along with a variable like this : <a href="series_letter.php?letter=a" target="SeriesFrame">A</a>

The series_letter.php holds the code to retrieve and display the names of the series starting with the letter (in this case 'a').

There's a submit form at the bottom that sends the letter as well :
<form name="series_form" action="submit_series.php" method="post">
<input type="hidden" value="<?php echo ($s_letter); ?>" name="series_letter">

This submit_series.php inserts the data into my mySQL database's series table.

Failure or succes, it will always include the series_letter.php (the one with the displaying and submit form).

When submit_series is initialized from the naviagation.html, it can $_GET the letter variable. When initialized from the submit_series.php, it can acces the letter by using $GLOBALS.

$global_letter = $GLOBALS['letter'];

if (!$global_letter) {
	$get_letter = $_GET['letter'];
	$s_letter = $get_letter;
} else {
	$s_letter = $global_letter;
}

This code gives an error(undefined index letter) when series_letter.php is initialized from the navigation.html. But if I turn it around, it gives that same error when initialized from the submit_series.php. I could ofcourse call another script from the submit_series.php, but that would be plain silly.

Anyone knows of some nice setup / function to tackle this one ? It would be much appreciated !

dalecosp

What's the name of this variable? In the link, you refer to a "series_letter" variable...then, in the PHP code, you look for $GET['letter'] .... then you have a post form, but your PHP doesn't look in the $POST array ...

Hmm, I wonder why you get an 'undefined index' .... 😉 Of course, it's been a long week......

Also, sorry about leaving "automatically parse URLs" on during that last post....

ricod

You're on a roll dalecosp !

I do look in the $_POST array you called it ?

It's a bit confusing, I know. I'm giving it different names each time.

When submitted from navigation.html its : letter
so, I find it with $s_letter = $_GET['letter']; right ?

When submitting from the form in series_letter.php its :
<input type="hidden" value="<?php echo ($s_letter); ?>" name="series_letter">

The form action is submit_series.php and I access it there with :
$letter = $_POST['series_letter'];

And then I include the series_letter.php again and then I can access $letter like this :
$global_letter = $GLOBALS['letter'];

I know, I'm a sloppy coder 🙁 but it's primarily because of my N00b-ness.

I'm building this step-by-step. It works fine until the inlcusion of the series_letter.php ... because the variable in the $_GET array is no longer there...