Hello,
I would like to create a window through JavaScript with PHP code that would insert data into a database, but I don't know if it's possible, because I tried everything I could so far and had no results at all.
The code I am using is
<script language="JavaScript">
<!--
top.consoleRef = new Object();
top.consoleRef.closed = true;
function writeConsole(content) {
top.consoleRef=window.open('em_branco.php','myconsole','width=350,height=250')
top.consoleRef.document.writeln(
'<html><head><title>página nova</title></head><body><?php $db = pg_connect("host=localhost dbname=dpf_db user=postgres password=asdasd"); $query = "INSERT INTO tbl_dummy(nome) VALUES('
+ '´treco´'
+ ')"; $result = pg_query($query); if (!$result) { $errormessage = pg_last_error(); echo "Error with query: " . $errormessage; exit(); } printf ("These values were inserted into the database"); pg_close(); ?></body></html>'
)
//top.consoleRef.document.close()
}
//-->
</script>
Note that line 13 has a sort of aberration, because I'd need three kinds of quotes, and not only two (the +'´treco´' stuff). And I don't know how to circumvent this, because escaping didn't work either.
Any help is most welcome, and thank you in advance for your attention.
Nicole