|
|
Posted by Robertu on 05/17/07 07:34
Hi at all
It is very difficult for me write in english my qiestions therefore please
sorry my bad english and try to understand best.
I have html code that display some datas coming from a dbf file throught
Baserunner.cgi (see baserunner.com)
Now I try to mifrate to php
Therefore first I transformed my databases to mysql and they work well.
Now I must transform an html page that must dispkay datas from mysql table.
To try if my code work I must insert with php the mysql fields values into
my php page that is like this:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
</HEAD>
<BODY>
<?php
/* Connessione e selezione del database */
$connessione = mysql_connect("00.00.00.00..00", "1111111", "2345678")
or die("Connessione non riuscita: " . mysql_error());
mysql_select_db("Sql144961_1") or die("Selezione del database non
riuscita");
/* Esecuzione di una query SQL */
$query = "SELECT sub_tipo, nome, pub, memo, img FROM fs where sub_tipo like
'%di feltro rosso%'";
$risultato = mysql_query($query) or die("Query fallita: " . mysql_error() );
/* Stampa dei risultati in HTML */
echo "<table border=3><caption>";
$riga = mysql_fetch_array($risultato, MYSQL_NUM);
printf ($riga[0]);
printf ("</caption");
while ($riga = mysql_fetch_array($risultato, MYSQL_NUM))
{
HERE THERE IS A TABLE TO DISPLAY FIELDS VALUES
BUT THERE IS ALSO A JAVASCRIPT FUNCTION WHERE I MUST PASS WITH PHP A
PARAMETER LIKE:
<script type="text/javascript">
document.writeln("<form onSubmit='return false;'><input type='hidden'
name='Codice' value='$riga[1]'><input type='hidden' name='Description'
value='$riga[2]'><input type='hidden' name='Price' value='$riga[3]}'><input
type='hidden' name='Size' value=''><input type='hidden' name='Color'
value=''><INPUT type='text' size=4 maxlength=4 name='Qty' onFocus=select()
onChange='Control(this.form)' value='"+fust($riga[1])+"'></form>");
</script>
}
echo "</table>";
/* Liberazione delle risorse del risultato */
mysql_free_result($risultato);
/* Chiusura della connessione */
mysql_close($connessione);
?>
</BODY>
</HTML>
How can I do to insert javascript code into the while PHP loop and to insert
into the javascript code the field value from mysql table PLEASE?
Thank you very much in advance
Navigation:
[Reply to this message]
|