Question on javascript and PHP

Anon

I have implemented my shopping cart with PHP. The cart is javascript based and the question I have is this:

Can you incorporate PHP "IN" javascript?

IE:

============= snippet =============
$server = "localhost"; // Server Name
$userid = ""; // Username
$pass = ""; // Password
$database = ""; // Database Name
$dbtable = "Products"; // Table Name

$con = mysql_connect("$server","$userid","$pass") or die ("Connection Error to Server");
$db = mysql_select_db("$database",$con) or die("Connection Error to Database");

$sql="SELECT * FROM $dbtable where CategoryID=$CategoryID"; //<--passed variable

$ProductCode=$result['ProductCode'];
$ProductCode=$result['ProductName'];
$ProductCode=$result['DiscountPrice'];
....START JAVASCRIPT.... for entire script.. email me
document.write("<FORM method=\"POST\" action=\"https://www.paypal.com/cgi-bin/webscr\">");
document.write("<INPUT TYPE=\"hidden\" NAME=\"item_name\" VALUE=\"<? echo "$ProductName" ?>\">");
document.write("<INPUT TYPE=\"hidden\" NAME=\"item_number\" VALUE=\"<? echo "$ProductCode" ?>\">");
document.write("<INPUT TYPE=\"hidden\" NAME=\"amount\" VALUE=\"<? echo "$DiscountPrice" ?>" + subtotal + "\">");
document.write("<INPUT TYPE=\"IMAGE\" src=\"http://www.paypal.com/images/x-click-but3.gif\">");
document.write("</FORM>");

============= snippet =============

Shouldn't the information <? echo "$whatever" ?> be OK?

Input?

Thanks folks... Matt

Anon

I was looking aver your code and it is a little <i>dirty</i> but still everything looked ok to me, except that I didn't see where you DID do the echo("whatever you want to put in here"); it looked to me like you just jumped into JavaScript, what is the problem you are running into, maybe we could then be of more help.

Anon

Hopefully this will post OK..
+++++++++++++++++++++++++++++++++++
//<BODY BACKGROUND="#FFFFFF" TEXT="#000000" onload="show_button();">

<APPLET CODE="uShopJSI.class" CODEBASE="../classes3/" NAME="uShopJSI" WIDTH="2" HEIGHT="2">
</APPLET>

-------------- BEGIN PHP --------------

//============================================
// CONNECTION TO SERVER & VARIABLE SETUP
//============================================

$server = "localhost"; // Server Name
$userid = "USERID"; // Username
$pass = "PASSWORD"; // Password
$database = "DATABASE"; // Database Name
$dbtable = "Products"; // Table Name

$con = mysql_connect("$server","$userid","$pass") or die ("Connection Error to Server");
$db = mysql_select_db("$database",$con) or die("Connection Error to Database");

$sql="SELECT * FROM $dbtable where CategoryID=$CategoryID";

$query = mysql_query($sql, $con);
$result=mysql_fetch_array($query))

$ProductCode=$result['ProductCode'];
$ProductName=$result['ProductName'];
$UnitPrice=$result['UnitPrice'];

-------------- END PHP --------------

-------------- BEGIN JAVASCRIPT --------------

script language="JavaScript"
function show_button()
{
while (document.uShopJSI == null);
var temp_subtotal = document.uShopJSI.getSubtotal();
var subtotal = Math.round(temp_subtotal * 100)/100;

// START OUTPUTTING THE ENTIRE PLACE ORDER HTML PAGE.
document.write("");
document.write("<HEAD>");
document.write("<TITLE>Place Order</TITLE>");
document.write("</HEAD>");
document.write("<BODY BACKGROUND=\"#FFFFFF\" TEXT=\"#000000\">");
document.write("<CENTER>");
document.write("<BR><BR>");
document.write("<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 WIDTH=595>");
document.write("<TR BGCOLOR=#000000>");
document.write("<TD>");
document.write("<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=10 WIDTH=100%>");
document.write("<TR BGCOLOR=#FFFFFF>");
document.write("<TD ALIGN=CENTER>");
document.write("<FONT COLOR=#000000 FACE=\"Verdana,Arial,Helvetica\" SIZE=2>");
document.write("To begin the order process, click on the PayPal button shown below.");
document.write("</FONT>");
document.write("</TD>");
document.write("</TR>");
document.write("</TABLE>");
document.write("</TD>");
document.write("</TR>");
document.write("</TABLE>");
document.write("<BR>");
document.write("<BR>");

// THIS HTML IS FOR THE PAYPAL BUTTON.
document.write("<BR><BR>");
document.write("<FORM method=\"POST\" action=\"https://www.paypal.com/cgi-bin/webscr\">");
document.write("<INPUT TYPE=\"hidden\" NAME=\"business\" VALUE=\"orders@websystemz.com\">");
document.write("<INPUT TYPE=\"hidden\" NAME=\"cmd\" VALUE=\"_xclick\">");
document.write("<INPUT TYPE=\"hidden\" NAME=\"item_name\" VALUE=\"<? echo "$ProductName" ?>\">");
document.write("<INPUT TYPE=\"hidden\" NAME=\"item_number\" VALUE=\"<? echo "$ProductCode" ?>\">");
document.write("<INPUT TYPE=\"hidden\" NAME=\"amount\" VALUE=\"<? echo "$UnitPrice" ?>" + subtotal + "\">");
document.write("<INPUT TYPE=\"IMAGE\" src=\"http://www.paypal.com/images/x-click-but3.gif\">");
document.write("</FORM>");

// FINISH THE HTML PAGE.
document.write("<BR>");
document.write("<BR>");
document.write("</CENTER>");
document.write("</BODY>");
document.write("");

// AND DON'T FORGET TO CLOSE THE DOCUMENT.
document.close();
}
-------------- END JAVASCRIPT --------------

The error I'm getting first is for the ONLOAD SHOWBUTTON at the beginning of the code... the next is: the first line also... BODY BACKGROUND.

If there's more info you need, just lemme know.. thanks!

Anon

Still need help with this please!

Thought I'd send it back to the top

Again, Thanks to those that answer

Matt

Anon

hi Matt!

small idea
you write
"<? echo "$UnitPrice" ?>"

shouldn´t it be
"<? echo "$UnitPrice"; ?>"

Anon

Irregardless, I still get the same error... this time using the ; - I get a javascript error. on 2 seperate lines, referencing first the line in the code at the beginning... on load show button command. Secondly, it references the beginning of that code.... the BODY tag.

Check for yourself..

http://www.websystemz.com/uburstsample.htm

add something to your cart and then try to check out... View the source. You'll see that nothing is entered dynamically for the variables of unit price, unit name and unit description. Therefore, PayPal gives an error.

I also tried another way to add the variable... like this...

<? echo ['$UnitPrice'] ;?>
<? echo ['UnitPrice'];?>
<? echo "$UnitPrice" ;?>
<? echo "Unitprice" ?>

and a few others.... as I am new to this.

This is the first page that I am having real issues with though.

The way it works is like this --> Add an item to the Javascript cart which uses CGI. Clicking on the begin order process should pass the variables to the next page... even through the script. But I end up with those 2 errors.

I don't know what else it could be other than the problem with javascript and php mixing?

Other ideas?

Thanks rakkaus