phpcode in javascript!?!

[mctwist]

Hey everyone!

I wonder if you can have php-codes within javascript.
I'm guessin it could look something like this:

---

<script language="JavaScript">
function onClick(){
if(form.name.value == ""){
return false;
}
else{
<?
$conn_id=odbc_connect("test","","");
$namn=form.name.value;
$sql="insert into forum namn values $namn";
odbc_exec($conn_id,$sql);
odbc_close($conn_id);
?>
return true;
}
}
</script>
<form name="form">
<input type="text" name="name">
</form>
<a href="sida1.php" onClick="return onClick();">Skicka</a>

---

this code doesn't work at all, so I figured I ask you guys.

[mystrymaster]

what are you trying to do

It looks like if they don't click you are trying to connect to a db via php.

PHP is server side

Javascript is client side

they can not talk however php can drop information from a db for javascript to use.

[mctwist]

ok, I'll try to explain...
I want the value written in the form to be added to the db when you click the link (unless there isn't a value).
The thing is that I don't want to post any information. I want it to be stored in the db before you leave the form-page...

[axnoran]

Well,

As mentioned before, javascript is client side while PHP is server side.

It is possible to write javascript so that the onchange/onclick/etc event triggers a server-side script, but they will require information to be posted to the server.

I have tested several scripts where I used the onchange/onclick function to trigger a refresh--either in a frame or an iframe (could possibly even be hidden from the user). This refreshed frame can be used to trigger a post--and subsequently a MySQL query.

axnoran

[Shawn_Jetton]

What you are trying to do can not be done the way you think..

You can do an onClick that submits the page and that page writes the information you need.

<SCRIPT LANGUAGE=javascript>
<!--
function verify(obj){
if(obj.name.value == ""){return false;}
}
//-->
</SCRIPT>
<FORM action="sida1.php" method=POST id=form1 name=form1 onSubmit="return verify(this)">
<INPUT type="text" id=text1 name=name>
<INPUT type="submit" value="Submit" id=submit1 name=submit1>

<?PHP
if(isset($_POST["name"])){
	$conn_id=odbc_connect("test","",""); 
	$namn=$_POST["name"]; 
	$sql="insert into forum namn values $namn"; 
	odbc_exec($conn_id,$sql); 
	odbc_close($conn_id); 
}
?>

Not to be rude or anything but if you don't know how to simply submit data to a php page you have a lot to learn and connection to a database isn't the best place to start.. But above is the code you need.. Good luck..

[sarahk]

I have a couple of little things on my website that might be of interest to you

http://www.hostultra.com/~data/phpjavascript.php

http://www.hostultra.com/~data/muck/example.php