Need help with very simple code...

[Alidad]

Hi, I'm using dreamweaver 8 and and i have created code that allowed me to insert data information in to the mysql server database.

And once insert into database, is redirect to other page at "thank you.php".

I also wrote a small javascripts that allowe me to slide background color where it said "thank you", the function called "thankyou()"

I like to change something that does not want to redirect to other page "thank youphp"after insert database, but I want to stay same page and instead of redirect to other page, i want to point to thank you() in javascripts in same page.

My question is that how can i change write code into javascript from inside of php code, please see code in BOLD, it said it will send to "thankyou.php" but on othr line (last line) under BOLD with underline is something that i want to change to javascripts to point to the function called "Thankyou()" how can write that code to point to the functio called "thankyou()" in javascrips!

please help me thanks.

AM

<?php require_once('../Connections/RegData.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;

case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}

$editFormAction = $SERVER['PHP_SELF'];
if (isset($SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($POST["MM_insert"])) && ($POST["MM_insert"] == "myform")) {
$insertSQL = sprintf("INSERT INTO pol_emaillist (Name, Email) VALUES (%s, %s)",
GetSQLValueString($POST['name'], "text"),
GetSQLValueString($POST['email'], "text"));

mysql_select_db($database_RegData, $RegData);
$Result1 = mysql_query($insertSQL, $RegData) or die(mysql_error());

$insertGoTo = "../thankyou.PHP";
if (isset($SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}

[bradgrafelman]

Just escape out of PHP..

if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
?><script type="text/javascript">Thankyou();</script><?php
}

Also, when posting PHP code, please use the board's [PHP][/PHP] bbcode tags - they make the code much, much easier to read (as well as aiding the diagnosis of syntax errors). You should edit your post now and add these bbcode tags to help others in reading/analyzing your code.

[Alidad]

thanks for your help, but after I made changed and run it, at firs data has been inserted into the database but then there is errors hiding errors showing in browser..

it said:

line:1
char: 1
error: object expect

i'm no sure did i missed, becuase i do not see any errors on line one.

please see code...

<?php require_once('../Connections/RegData.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    

    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "myform")) {
  $insertSQL = sprintf("INSERT INTO pol_emaillist (Name, Email) VALUES (%s, %s)",
                       GetSQLValueString($_POST['name'], "text"),
                       GetSQLValueString($_POST['email'], "text"));

  mysql_select_db($database_RegData, $RegData);
  $Result1 = mysql_query($insertSQL, $RegData) or die(mysql_error());

if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
  }
?><script type="text/javascript">Thankyou();</script><?php 

}

[bradgrafelman]

That would depend...

1. What is line 1 of the HTML?
2. Did you define the JS function "Thankyou" ?

[Alidad]

line one of html showing in BOLD....

and js fucntion works fine. but errors showing after call funtion.

AM

// $insertGoTo = "../WORKS.PHP";
if (isset($SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $SERVER['QUERY_STRING'];
}
?><script type="text/javascript">Thankyou();</script><?php

}
?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3c.org/TR/1999/REC-html401-19991224/loose.dtd">
<HTML xmlns="http://www.w3.org/1999/xhtml"><HEAD><TITLE>Interface FX demo - Interface plugin for jQuery</TITLE>
<META http-equiv=Content-Language content=en>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<META http-equiv=Content-Type content="text/html; charset[/code]=utf-8">

[bradgrafelman]

Alidad wrote:

line one of html showing in BOLD....

No, that'd be the second line. The HTML you output above would be on line 1.

Looks like you need to re-work the flow of the script so that the JS that defines the function is outputted before you try to use it.

[Alidad]

I did eveyrthing i could and i could not find anything, to call javascripts function is works great, but to javascripts fuction from inside of php is getting errors insert data into mysql.

the errors are same

line 1
char 1

any idea!

please help. thanks.

AM