PHP Forum

**ufo973** · 05-03-2008, 12:19 PM

Hello
for 5 hours i am trying to figure out this strange problem but can't so i came here if any one of you can solve it.

What i want to do is get the text value of a SELECT by javascript then asseign it to a php variable and insert it in the mysql database
everything works fine but when i go to mysql and chekck the entry it is strange. even if i echo the variable in page it is showing the value and ok but when i check it in the database it is something like this.
<script language=javascript>document.write

Here is my page...

<html>
<body>

<form name="form1" method="post" action="">
<select name="select">
<option value="1">a</option>
<option value="2">b</option>
</select>
</form>

<?php
//asseigning the javascript variable to php
$MyVar1 = "?><script language=javascript>document.write(document.form1. select.options[form1.select.selectedIndex].text);</script><?php";
$MyVar1 = str_replace("?>", "", $MyVar1);
echo $MyVar1."<br><br>";//works fine

$host="localhost";
$user="root";
$pass="";
$db="hr_mysql";

$con=mysql_connect($host,$user,$pass);
if($con){
echo "Mysql Connected <br>";
}
else{
echo "Mysql connect error<br>";
}

$sel=mysql_select_db($db,$con);
if($sel){
echo "DB Selected<br>";
}
else{
echo "DB Select error<br>".mysql_error();
}

$sql="insert into hs_mustafa_modify values ('$MyVar1')";
$res=mysql_query($sql);
if($res){
echo "successful"; //successfuly enteres in database
}
else{
echo "Sorry ".mysql_error();
}

mysql_close();

// now go check it in the database for miracle.
?>

</body>
</html>

**ufo973** · 05-03-2008, 12:55 PM

no body wants to help

**chrishirst** · 05-03-2008, 02:09 PM

It's Saturday and 30 minutes later.

Apart from that it can't be done. PHP code is run and finished with, before the javascript even gets started.

**technica** · 05-03-2008, 02:27 PM

the variable actually taking the javascript code , so the database get s the javascript code.

the reason might be the value is not assigned to variable.

**Plugin-Developer** · 05-03-2008, 02:30 PM

I think your problem is that you're expecting to intermingle JavaScript and PHP. You just can't do that, as chrishirst pointed out. PHP is a server side language that is interpreted before the page is ever sent to the browser.

JavaScript, on the other hand, is a client-side language that processes things within the confines of the current environment, usually a browser. If you need some PHP processing to happen, you can dynamically post values to a PHP page from a JavaScript function. That may be what you want to look into. Just do a google search for AJAX.

**halo** · 05-03-2008, 04:36 PM

You dont need javascript to process a form...