PHP/Javascript help!

**EggDesign** · 16-07-2009, 10:59 AM

Hi lads

Firstly, my knowledge of php & javascript is very limited. I need to remake this calculator for the clients microsite but cannot get access to the files on the server Contract Cleaning Ireland Contract cleaners Ireland Duct Cleaning Forecourt Cleaning Construction Cleaning Halcyon Hygiene

Ive rebuilt the form by using the code & css copied from the broswer (view source).

Thing is, how do i get it to calculate? There is Javascript embedded also but should there be an external php file on the server also that works out the calculations?

They sent me this code by email, pretty sure theres something missing:

$total = 0;
$WaterUse = 0;
$Kwatts = 0;
$totalSaving = 0;
$Co2 = 0;
$WaterUse2 = 0;
$Kwatts2 = 0;
$Co22 = 0;

$rates['Carlow']=2.73;
$rates['Cavan']=2.51;
$rates['Clare']=2.98;
$rates['Cork']=2.3;
$rates['Cork City']=2.3;
$rates['Donegal']=2.31;
$rates['Dublin City']=1.64;
$rates['South Dublin']=1.56;
$rates['Dun Laoghaire Rathdown']=2.34;
$rates['Fingal']=1.94;
$rates['Galway']=2.12;
$rates['Galway City']=1.96;
$rates['Kerry']=1.79;
$rates['Kildare']=2.98;
$rates['Kilkenny']=2.53;
$rates['Laois']=2.45;
$rates['Leitrim']=2.28;
$rates['Limerick']=2.6;
$rates['Limerick City']=1.99;
$rates['Longford']=2.63;
$rates['Louth']=1.95;
$rates['Mayo']=2.36;
$rates['Meath']=2.36;
$rates['Monaghan']=2.11;
$rates['Offaly']=2.02;
$rates['Roscommon']=2.32;
$rates['Sligo']=2.3;
$rates['Tipperary North']=2.4;
$rates['Tipperary South']=2.1;
$rates['Waterford']=2.43;
$rates['Waterford City']=2.32;
$rates['Westmeath']=2.45;
$rates['Wexford']=2.63;
$rates['Wicklow']=3.04;

if (isset($_POST['submit'])) {
if ($ccprices == "") {
$feedback="Please select your local county council.";
}else if($_POST['email']==""){
$feedback="Please enter an email address.";
}else if($_POST['urinals']==""){
$feedback="Please enter an value in the urinals text box.";
}else{
$ccprices = $rates[$_POST['ccprices']];

$urinals = $_POST['urinals'];
$wateruseperurinal = 175000;
$TotalWaterUsed = ($wateruseperurinal*$urinals);
$TotalWaterCostperCC = (($TotalWaterUsed/1000)*$ccprices);
$TotalKwattsUsed = (($TotalWaterUsed/1000)*9.04);
$TotalCo2 = (($TotalWaterUsed/1000)*0.04);

$totalCost = (($wateruseperurinal/1000)*$urinals*$ccprices);

$wateruseperurinalSaved = 145800;
$wateruseperurinalNew = 29200;
$TotalWaterSaved = ($wateruseperurinalSaved*$urinals);

$TotalKwattsSaved = $TotalKwattsUsed * ($wateruseperurinalSaved / $wateruseperurinal);
$TotalCo2Saved = $TotalCo2 * ($wateruseperurinalSaved / $wateruseperurinal);

$newCost = ((($wateruseperurinalNew/1000)*$urinals*$ccprices)+($urinals*140));
$totalsaved=$totalCost-$newCost;

$q="INSERT INTO calculator (email, location, rate, urinals) VALUES ('".addslashes($_POST['email'])."', '".addslashes($_POST['ccprices'])."', ".addslashes($ccprices).", ".addslashes($_POST['urinals']).")";

Any help with this would be great
cheers

**php.allstar** · 16-07-2009, 12:42 PM

Hi,

I'm not sure if I understand you correctly, but I've looked at the code and I don't see any problems off hand, it should calculate no problem.

Javascript is not needed.

Here's how it works:

A user submits the form
The form submits to itself (<form action=""></form>)
The page reloads
PHP checks to see if the form has been submitted (if (isset($_POST['submit'])) {...)
If the form has been submitted, some pretty standard vvalidation is done on the user input to check for errors
If there were no errors, the calculation is performed based on the values the user entered in the form along with some hardcoded factors
The results are saved to a database.

I don't see anything here for displaying the results. To display the results, you would have to echo the variables from the calculation (<?php echo $TotalWaterUsed; ?>) in the appropriate location in the source code.

Sorry for being so vague about the display but If I saw the full php source code I could pinpoint the problem for you.

By the way, there is a security concern in your source code. On your mysql query you are using addslashes on $_POST variables. This is a big no-no. You should be using mysql_real_escape_string(), its slightly more secure.

addslashes can be tricked by injecting the hexadecimal character 0xbf27, addslashes coverts this to 0xbf5c27 which is a legal muti byte character followed by a single quote... now I understand that this may be over your head, don't be worried, just replace "addslashes" with "mysql_real_escape_string" provided your database connection is open or persistent.

**EggDesign** · 16-07-2009, 12:52 PM

Thanks for your reply allstar. Like I said my knowledge of php is very limited so alot of what you said is over my head

You said all the code looks fine but where do I place this code? I am in the process of remaking the form from scratch which is the easy part. Then I need to work out how to calculate using the details above.

You said you would like to see the full php source code, where would I find this? Should it not be in the above code I was sent by client?

Thanks again for your help

**php.allstar** · 16-07-2009, 01:10 PM

Yeah, sorry for getting technical, but there will be others reading this post too so its nice to share the knowledge anyway!

Ok, I'll try to break it down.

Go to the url that contains the form in your browser
Copy the source code
Save it as whatever.php
Above your opening <html> tag insert the code you received via email within <?php and ?> tags.
there will be some variables available once the form is posted (like $TotalWaterSaved, $TotalKwattsSaved, $TotalCo2Saved etc... )
You will have to edit the source code of the file to echo your php variables (see the attached screenshot) the variable names are pretty self explanatory so you should be able to figure out where to echo them!
I presume you don't have a testing server so comment out the mysql_query line and upload the file to some obscure location on your web server (like http:// www. cleaning .ie /calculator-test.php)
Go to the url in your browser and test
Works now?!

Let us know how you get on.

Here's a nice little place to pickup the basics of php PHP Tutorial - Introduction

**EggDesign** · 16-07-2009, 01:46 PM

Cheers dude, your a legend. Ill give that a shot.

Just couple of things:

So I save whatever page Im putting the calculator on as a php file & the rest as .html?
Is the whole thing self contained then in that php file? ie I dont need an external php file to run the script?
I understand what you mean by echoing variables but how come when I look at the source code of the site (through the browser as I have no access to files) there is no php code or variables in it?

Sorry if im being thick!

thanks for the help

**php.allstar** · 16-07-2009, 01:54 PM

LOL!

I almost fell off my chair when I read that!

The whole thing has to be saved as a php file.
It's just one file, no external php scripts needed.
PHP is a server side scripting language. Your web server will read the php code and then parse it (covert and display) as html, but it will still have a .php extension

Sorry but that was funny! Why are you taking on php work if you don't know it!

**EggDesign** · 16-07-2009, 01:58 PM

I knew that, just double checking!

Hey, its all learning. I like a challenge.

Thanks for the help.

**php.allstar** · 16-07-2009, 02:06 PM

Well fair play, keep it up, thats how I started off too, just said what the hell and took a dive in the deep end.

Keep it up, you'll get there eventually.

Here's a nice series of articles to help you learn php

Also make sure to set up your own development server on your local machine using something like Xampp

Then you can test your php files on your local computer (open a browser and type http://localhost) without having to upload to a server everytime.

**EggDesign** · 16-07-2009, 02:12 PM

Cheers man, yeah im using MAMP (on a mac)

Just one more dumb question:

You said to comment out 'mysql_query'. Where do I find this? its not in the code they emailed.

Edit: sorry for being annoying but I did those steps & its showing up blank in the browser?

Thanks again man

**php.allstar** · 16-07-2009, 02:51 PM

Hi,

It was

$q="INSERT INTO calculator (email, location, rate, urinals) VALUES ('".addslashes($_POST['email'])."', '".addslashes($_POST['ccprices'])."', ".addslashes($ccprices).", ".addslashes($_POST['urinals']).")";

But now that I look at it, thats just building the query string. No need to comment it out.

Just pm or email me with the full source code, I'll tell you why its coming up blank

Thread: PHP/Javascript help!

LinkBack

Thread Tools

Display

PHP/Javascript help!

Similar Threads

JavaScript and CSS

Need Javascript Help

Javascript Help

javascript

javascript help

Visitors found this page by searching for:

Tags for this Thread

Posting Permissions