Re: passing parameters
| From: | Alain Fontaine | Date: | Fri, 02 Feb 2001 10:44:03 +0000 |
| Subject: | Re: passing parameters | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-37808@lists.php.net to get a copy of this message | ||
Rule #1:
Do not post your database credentials into newsgroups.
Rule #2:
See Rule #1
"Stinie Steinbach" <s695645@kub.nl> a écrit dans le message news:
3A7A8A30.4000331B@kub.nl...
> does anyone know what's wrong with this files?
> i want to pass the parameter $module_id from one file tot the next so
> that i can extract all records from my tables in the mysql database that
> have this parameter... the queries that i used are tested and are
> working correctly... at this moment i cant see waht i do wrong.. does
> anyone know an answer tot my problem? if you need tot know more about
> the result look at my url.. please help me....
>
> http://stuwww.kub.nl/~s695645/TIAS/
>
> file test_blok_array.php3
>
> <? include("connect.php3") ?>
>
> <?
> $result = mysql_query ("select m.module_id,m.module_nummer
> from module m, leergang l where m.leergang_afkorting =
> l.leergang_afkorting
> and m.leergang_afkorting = 'EDP16' order by m.module_nummer");
> while (list ($module_id,$module_nummer) = mysql_fetch_row ($result)) {
>
> echo "<a href=\"test_list.php3?module_id=$module_id\"> BLOK
> 0$module_nummer | </a>";
> }
> ?>
>
> file test_list.php3
>
> <? include("test_blok_array.php3") ?>
>
> <table>
> <form action="_url_" method="post">
>
> <table border=1>
> <tr>
> <th>submodule</th>
> <th>onderdeel</th>
> <th>docent</td>
> <th>datum</th>
> <th>dagdeel</th>
> <th>edit</th>
> <th>delete</th>
> </tr>
>
> <?php
> mysql_connect ("kubstu.kub.nl","s695645","BikHuis");
> mysql_select_db ("s695645");
> $result = mysql_query ("SELECT
>
u.module_id,u.submodule_nummer,u.submodule_naam,d.docent_naam,s.dagdeel,s.da
tum,u.submodule_id,u.submodule_id
>
> FROM submodule u, sessie s, docent d, module m
> WHERE u.module_id = '$module_id'
> AND d.docent_nummer = s.docent_nummer
> AND u.submodule_id = s.submodule_id
> AND m.module_id = u.module_id
> AND m.leergang_afkorting = 'EDP16'
> ORDER BY s.datum, u.submodule_nummer");
> while (list ($module_id, $submodule_nummer, $submodule_naam,
> $docent_naam, $dagdeel, $datum, $submodule_id, $submodule_id) =
> mysql_fetch_row ($result)) {
> echo " <tr>
> <td><small>$submodule_nummer</small></td>
> <td><small>$submodule_naam</small></td>
> <td><small>$docent_naam</small></td>
> <td><small>$datum</small></td>
> <td><small>$dagdeel</small></td>
> <td><a href=\"edit.php3?submodule_id=$submodule_id\"><small>
> edit
> </small></a></td>
> <td><a
> href=\"delete.php3?submodule_id=$submodule_id\"><small> delete
> </small></a></td>
> </tr>\n";
> }
>