PHPBuilder.com - Newbies http://board.phpbuilder.com/ Help for those who are just getting started en Wed, 19 Jun 2013 04:00:34 GMT vBulletin 60 http://board.phpbuilder.com/images/misc/rss.png PHPBuilder.com - Newbies http://board.phpbuilder.com/ results into an array http://board.phpbuilder.com/showthread.php?10390031-results-into-an-array&goto=newpost Tue, 18 Jun 2013 14:23:55 GMT Hi
I have a sql query that results in the likes of
123/456/789

i need to be able to break the above result up into variables without the / ie var1=123 var2=456 var3=789 i gather this would be in to an array but im not sure how to get the details before & after the / in the result

can anyone help please

many thanks ]]> Newbies neroag http://board.phpbuilder.com/showthread.php?10390031-results-into-an-array form submit redirect inside WP Plugin http://board.phpbuilder.com/showthread.php?10390023-form-submit-redirect-inside-WP-Plugin&goto=newpost Mon, 17 Jun 2013 22:51:17 GMT Hi all, Please don't bash me. I have spent hours and hours, days and days. I can't get this stupid thing to work right.

The plugin is inside of wp which makes it own headers so making it almost impossible for me to understand.

I have tried Action"", Target"" and many things in between. I got it to open a new window but was same page not the page I was trying to get to load. I want it to open in same window with a new page.

My form has multi .php pages that collect data. But the first php page need to redirect to a new page and continue to submit data.

I did see this post that was something like my issue.

http://board.phpbuilder.com/showthre...t-without-curl

here is the page I have.
http://simplecarrentals.co.nz/home/

here is where I want to goto on submit.
http://simplecarrentals.co.nz/book-a-car-now/

I am not asking any one to build my site. I just really need direction in how to fix or find the issue.
I know it is a really simple issue to fix. Just I have no clue how it is done. ]]> Newbies carbincopy http://board.phpbuilder.com/showthread.php?10390023-form-submit-redirect-inside-WP-Plugin <![CDATA[PHP mail with gmail > edit "from email address"?]]> http://board.phpbuilder.com/showthread.php?10390007-PHP-mail-with-gmail-gt-edit-quot-from-email-address-quot&goto=newpost Sun, 16 Jun 2013 08:58:27 GMT Hi,

I managed to set up a simple smtp with sendmail and gmail in the PHP mail function. The thing is, is it possible to change the "from" email address to a different one, than the gmail account I'm using?

No matter which $from I assign, the from address is always my gmail account, which I am using to send mails.

Thanks ]]> Newbies skyhrg http://board.phpbuilder.com/showthread.php?10390007-PHP-mail-with-gmail-gt-edit-quot-from-email-address-quot wtf unexpected $end, and I did nothin wrong! http://board.phpbuilder.com/showthread.php?10389983-wtf-unexpected-end-and-I-did-nothin-wrong!&goto=newpost Thu, 13 Jun 2013 20:18:46 GMT הרשמה
'; ob_start(); echo ''; echo '

'; if(empty($_POST['sub'])) { ?>
שם פרטי
סיסמא
אימות סיסמא
אי מייל
"; if(empty($cu) AND empty($cu) AND $password == $repassword) { if (strlen($fname) < 3 OR strlen($fname) > 12) { echo ""; echo "שגיאה - השם הפרטי שבחרת ארוך/קצר מדי"; echo ""; echo "

"; ?> 12) { echo ""; echo "שגיאה - הסיסמא ארוכה/קצרה מדי"; echo ""; echo "

"; ?> "; echo "שגיאה - האי מייל תפוס"; echo ""; echo "

"; ?> "; echo "שגיאה - האי מייל לא תקין"; echo ""; echo "

"; ?> "; echo "שגיאה - אימות סיסמא שגוי"; echo ""; echo "

"; ?> "; echo "שגיאה - שם פרטי תפוס"; echo ""; echo "

"; ?>


'; include(LOVE_ROOT . '/system/love_foot.php'); } else { header('Location: modules/' . MODULE); } ?> --------- it dirrects me to line number 164, (the last line of the code), and "unexpected $end"... ????? what is going on here? it's a simple Sign Up code + few php's I added for the overall design and form around... please guys, thanks alot!]]> omg it's drivin me crazy 3 days or 4 already I stopped counting...

please guy take a look and try n help me:

PHP Code:
<?php
include('config.php');


if(MODULE == 'none')
{  
    include(LOVE_ROOT . '/system/love_head.php');    
    $content = '<h2> הרשמה </h2><br />';




    ob_start();


    echo '<html dir="rtl"><head><title></title>';
    echo '<meta http-equiv="Content-Type" content="text/html charset=windows-1255" /></head><body><br /><br />';
    
if(empty($_POST['sub']))
{
?>
<form method="post">
<table>
<tr><td>שם פרטי</td><td><input type="text" name="fname"></td></tr>
<tr><td>סיסמא</td><td><input type="password" name="pass"></td></tr>
<tr><td>אימות סיסמא</td><td><input type="password" name="repass"></td></tr>
<tr><td>אי מייל</td><td><input type="text" name="email"></td></tr>
<tr><td colspan="2" align="center"><input type="submit" name="sub" value="הרשמה"></td></tr>
</table>
</form>
<?php
}
else
{
$fname = $_POST['fname'];
$password = $_POST['pass'];
$repassword = $_POST['repass'];
$email = $_POST['email'];
$date = date('Y-m-d');

$pass1 = md5($password);
$pass = sha1($pass1);

$select = mysql_query("SELECT * FROM `users` WHERE fname='$fname'");

$cu = mysql_fetch_array($select);

$select3 = mysql_query("SELECT * FROM `admins` WHERE fname='$fname'");

$cu3 = mysql_fetch_array($select3);

$select2 = mysql_query("SELECT * FROM `users` WHERE email='$email'");

$cu2 = mysql_fetch_array($select2);

echo "<center>";

if(empty($cu) AND empty($cu) AND $password == $repassword)
{
if (strlen($fname) < 3 OR strlen($fname) > 12)
{
echo "<font color='darkred'><b>";
echo "שגיאה - השם הפרטי שבחרת ארוך/קצר מדי";
echo "</b></font>";
echo "<br><br>";
?>
<input type="button" value="חזור אחורה" onclick="window.location.href='javascript:window.history.back(-1)';">
<?php
}

else if (strlen($password) < 3 OR strlen($password) > 12)
{
echo "<font color='darkred'><b>";
echo "שגיאה - הסיסמא ארוכה/קצרה מדי";
echo "</b></font>";
echo "<br><br>";
?>
<input type="button" value="חזור אחורה" onclick="window.location.href='javascript:window.history.back(-1)';">
<?php
}

else if (!empty($cu2))
{
echo "<font color='darkred'><b>";
echo "שגיאה - האי מייל תפוס";
echo "</b></font>";
echo "<br><br>";
?>
<input type="button" value="חזור אחורה" onclick="window.location.href='javascript:window.history.back(-1)';">
<?php
}

else if (stristr($email, "@") == false OR stristr($email, ".")== false)
{
echo "<font color='darkred'><b>";
echo "שגיאה - האי מייל לא תקין";
echo "</b></font>";
echo "<br><br>";
?>
<input type="button" value="חזור אחורה" onclick="window.location.href='javascript:window.history.back(-1)';">
<?php
}

else
{
$insert = mysql_query("INSERT INTO `users` VALUES ('','$fname','$pass','$email','0','','$date','0')");

setcookie('adv_U',$fname);
setcookie('adv_P',$pass);
Header('Location: index.php');
}
}
else if ($password != $repassword)
{
echo "<font color='darkred'><b>";
echo "שגיאה - אימות סיסמא שגוי";
echo "</b></font>";
echo "<br><br>";
?>
<input type="button" value="חזור אחורה" onclick="window.location.href='javascript:window.history.back(-1)';">
<?php
}
else
{
echo "<font color='darkred'><b>";
echo "שגיאה - שם פרטי תפוס";
echo "</b></font>";
echo "<br><br>";
?>
<input type="button" value="חזור אחורה" onclick="window.location.href='javascript:window.history.back(-1)';">
<?php
}
}
?>
</body>
</html>
<?php
ob_end_flush();
?>
<?php
?>
<br /> <br /> <br />     
        
        ';
    
    include(LOVE_ROOT . '/system/love_foot.php');
}
else
{
    header('Location: modules/' . MODULE);
}
?>


it dirrects me to line number 164, (the last line of the code), and "unexpected $end"...

????? what is going on here? it's a simple Sign Up code + few php's I added for the overall design and form around...

please guys, thanks alot! ]]> Newbies Zyzz http://board.phpbuilder.com/showthread.php?10389983-wtf-unexpected-end-and-I-did-nothin-wrong! <![CDATA[OMG im stuck with "unexpected T_STRING" 3 days already!!!]]> http://board.phpbuilder.com/showthread.php?10389967-OMG-im-stuck-with-quot-unexpected-T_STRING-quot-3-days-already!!!&goto=newpost Wed, 12 Jun 2013 18:51:01 GMT Sign Up


XXXXXXXXXXXXXXXXXXXXXX



include(parts . '/parts/footer.php'); } else { header('Location: pages/' . PAGE); } ?> --------- it's supposed to insert to the page the footer & header php's, for the "design", and to add the form in the middle of the page. this is my goal.. so it's didn't work cuz: PHP: --------- Parse error: syntax error, unexpected T_STRING --------- leads me to: PHP: --------- if(empty($_POST['sub'])){ --------- SO what is the problem around here? I did NOT miss anything, closed everyline as I should to.. I really dont know what to do.. Thanks to the helpers, REALLY BIG THANK YOU! I don't know why it's so complicated.. it's just a ****in sign up form with few php's around it for the design .. that's all..]]> Hey guys, im so glad to join this community cuz im so lost!
I tried for the last 3 days to solve this ****in annoying "unexpected T_STRING", and didnt mange to do it!

so I addressed my question to some guy and he tried to help me, but his code didnt work as well.

please try and look at this, im so desperate :(

So this is the original code:
[signup form that connects the users to the database sql]:

PHP Code:
<?php/////////////////////////////////////////////////////////////////////////////////
//                                                                             //
//  DO NOT COPY ANYTHING FROM HERE
SITE BY XXXXXXXX                     //
//                                                     //
//                                                                             //
/////////////////////////////////////////////////////////////////////////////////


include('config.php');


if(PAGE == 'none')
{
    include(parts . '/parts/header.php');
    $content = '<h2> Sign Up </h2>
<br />






<?php
ob_start();
?>
<html dir="rtl">
<head>
<title></title>


<meta http-equiv="Content-Type" content="text/html; charset=windows-1255" />
</head>
<body>
<br><br>
<?php


$selcom = mysql_query("SELECT * FROM `com` ORDER BY ID DESC");
$selcom = mysql_fetch_array($selcom);
?>
<center>
<?php
?>
<?php
if(empty($_POST['sub']))
{
?>
<form method="post">
<table>
XXXXXXXXXXXXXXXXXXXXXX
</table>
</form>
<?php
}
else
{
XXXXXXXXXXXXXXXXXXXXXXXXXXXX
}
}
?>
</body>
</html>
<?php
ob_end_flush();
?>
<?php
?>
<br /> <br /> <br />     




    include(parts . '/parts/footer.php');
}
else
{
    header('Location: pages/' . PAGE);
}
?>

it's supposed to insert to the page the footer & header php's, for the "design", and to add the form in the middle of the page. this is my goal..

so it's didn't work cuz:
PHP Code:
Parse error: syntax error, unexpected T_STRING 
leads me to:
PHP Code:
if(empty($_POST['sub'])){ 
SO what is the problem around here?
I did NOT miss anything, closed everyline as I should to..
I really dont know what to do..

Thanks to the helpers, REALLY BIG THANK YOU!

I don't know why it's so complicated.. it's just a ****in sign up form with few php's around it for the design .. that's all.. ]]> Newbies Zyzz http://board.phpbuilder.com/showthread.php?10389967-OMG-im-stuck-with-quot-unexpected-T_STRING-quot-3-days-already!!! Coding a Poll http://board.phpbuilder.com/showthread.php?10389949-Coding-a-Poll&goto=newpost Mon, 10 Jun 2013 18:44:35 GMT Hi I am new to this forum and am also new to PHP. I have coded the structure of my website using HTML & CSS. I have started reading books to try and give myself a boost and
they are extremely useful. I would now like to take a leap forward and code a poll to see peoples views on my website.

If anyone could give me a detailed tutorial on how to code a poll or link me to another
website that will teach me I would be greatly thankful. ]]> Newbies HQmaroon http://board.phpbuilder.com/showthread.php?10389949-Coding-a-Poll Auto-calculate form http://board.phpbuilder.com/showthread.php?10389931-Auto-calculate-form&goto=newpost Sat, 08 Jun 2013 20:34:24 GMT
Item Amount Total sum:
Gloves (25 dollars pair) $tot_gloves dollars

"; ?>
Kimono (100 dollars each) $tot_kimono dollars

"; ?>
Protectors (15 dollars set) $tot_protectors dollars

"; ?>
 
--------- ]]> Hello everybody, im new in php programming and have came to a dead end. I have a homework that I must make till Monday but I dont know how to make it and really need some help.

Im making a simple, like order, form that will take numbers imputed and save it to a simple txt file that acts like database. Now I need to auto calculate price when someone enters amount.

Here is the code for the form, if anybody can help ill really appreciate it. Tyvm and cheers.

HTML Code:
<form name="form1" method="post" action="order.php">
        <table width="400" border="0" cellspacing="0" cellpadding="4">
                <tr>
                        <td>Item</td>
                        <td>Amount</td>
                        <td>Total sum:</td>
                </tr>
                <tr>
                        <td>Gloves (<font color="red">25</font> dollars pair)</td>
                        <td><input name="gloves" type="text" id="gloves" size="4"></td>
                        <td>
                       
                                <?PHP
                                $price_gloves=125;
                                $tot_gloves=$price_gloves*gloves;
                                echo "<p>$tot_gloves dollars</p>";
                                ?>
                               
                        </td>
                </tr>
                <tr>
                        <td>Kimono (<font color="red">100</font> dollars each)</td>
                        <td><input name="kimono" type="text" id="kimono" size="4"></td>
                        <td>
                       
                                <?PHP
                                $price_kimono=125;
                                $tot_kimono=$price_kimono*kimono;
                                echo "<p>$tot_kimono dollars</p>";
                                ?>
                               
                        </td>
                </tr>
                <tr>
                        <td>Protectors (<font color="red">15</font> dollars set)</td>
                        <td><input name="protectors" type="text" id="protectors" size="4"></td>
                        <td>
                       
                                <?PHP
                                $price_protectors=125;
                                $tot_protectors=$price_protectors*protectors;
                                echo "<p>$tot_protectors dollars</p>";
                                ?>
                               
                        </td>
                </tr>
                <tr>
                        <td>&nbsp;</td>
                        <td><input type="submit" name="Submit" value="Submit"></td>
                </tr>
        </table>
</form>
]]> Newbies marioweb http://board.phpbuilder.com/showthread.php?10389931-Auto-calculate-form PHP Mail Loop While http://board.phpbuilder.com/showthread.php?10389909-PHP-Mail-Loop-While&goto=newpost Thu, 06 Jun 2013 14:12:23 GMT 'Complete' AND email_sent = 0 LIMIT 1"); if (!result) { die("No data"); } while ($row = mysql_fetch_assoc($result)) { $from = "Some Name "; $completerecord = "http://xyz.com/some.php?record_id="; $header = "From: ".$from."\r\n"; $header .= "Reply-To: ".$from; $to = $row['email_to']; $subject .= "Some text ".$row['xyz_id']." ".$row['record_type']." Due ".$row['date_target']; $record_id = $row['record_id']; $emailBody .= "You have some email text here in the body."." "." XYZ: ".$row['xyz_id']." Record Type: ".$row['record_type']." Start Date: ".$row['date_start']." Target Date: ".$row['date_target']." Complete: ".$completerecord.$row['record_id']." \n"; } { $result = mysql_query("UPDATE tbl_test SET email_sent='1' , email_log_date=date('Y-m-d') WHERE record_id='$record_id'"); } if (mail($to, $subject, $emailBody, $header)) { echo("

Message successfully sent! Record '$record_id'.

"); } else { echo("

Message delivery failed...

"); } ?> --------- ]]> I am trying to loop through each record in my database and send an email to the email address associated with that records Once the email is sent I change a value from email_sent=0 to email_sent=1 so it doesnt get sent more than once.

I am expecting to get record 1 emailed to email 1, record 2 emailed to email 2, and so on until all records are marked complete.

I tried placing the loop in a few different places in the code and ended up getting the correct number of emails. The first email had the correct record 1, the second email started with record 1 and appended record 2, the third email had record 1, appended record 2 and record 3. Each record was marked as email_sent=1.

I also tried just running the query three times within the same page with some changes to try to close the loop but it didnt work either.

The code below is working to send record 1 to email 1, marks the record complete. When run again it sends record 2 to email 2 and marks it complete. I then have to run it once for each record in the database.

I am using LIMIT 1 because if it isn't there I got all records sent in one email.

Here is the code. Any help or thoughts would be greatly appreciated:
Code:
<?php
require_once("dbconnxyz.php");

if (!mysql_connect($DB_HOST, $DB_USER, $DB_PASSWORD))
die("Can't connect to database");
if (!mysql_select_db($DB_DATABASE))
die("Can't select database");
?>
<?php
$result = mysql_query("SELECT * FROM tbl_test WHERE date_target BETWEEN CURDATE() AND ADDDATE(CURDATE(), INTERVAL 30 DAY) AND rev_status <> 'Complete' AND email_sent = 0 LIMIT 1");
if (!result) {
die("No data");
}
while ($row = mysql_fetch_assoc($result))
{
$from = "Some Name <email@something.com>";
$completerecord = "http://xyz.com/some.php?record_id=";
$header = "From: ".$from."\r\n";
$header .= "Reply-To: ".$from;
$to = $row['email_to'];
$subject .= "Some text ".$row['xyz_id']." ".$row['record_type']." Due ".$row['date_target'];
$record_id = $row['record_id'];

$emailBody .= "You have some email text here in the body."."
"."
XYZ: ".$row['xyz_id']."
Record Type: ".$row['record_type']."
Start Date: ".$row['date_start']."
Target Date: ".$row['date_target']."
Complete: ".$completerecord.$row['record_id']." \n";
}
{
$result = mysql_query("UPDATE tbl_test SET email_sent='1' , email_log_date=date('Y-m-d') WHERE record_id='$record_id'");
}

if (mail($to, $subject, $emailBody, $header)) {
echo("<p>Message successfully sent! Record '$record_id'.</p>");
} else {
echo("<p>Message delivery failed...</p>");
}
 ?>
]]> Newbies ThatsBadAss.com http://board.phpbuilder.com/showthread.php?10389909-PHP-Mail-Loop-While Question on PHP programm? http://board.phpbuilder.com/showthread.php?10389895-Question-on-PHP-programm&goto=newpost Wed, 05 Jun 2013 08:09:27 GMT Hi all,

I'm trying to create a PHP programm that does the following:

Acts as a tracker in a call-center environment, where each agent has to log in to his account and can enter basic data about each case he has (e.g. serial number, calling party etc.). Afterwards, the programm has to check if the serial is in a database (Excel file as of now) and give it's category listing. Then, we have to count them by category/agent/calling party?

How do you suggest this should be done best?

Kind regards, ]]> Newbies Blago86 http://board.phpbuilder.com/showthread.php?10389895-Question-on-PHP-programm CRUD class http://board.phpbuilder.com/showthread.php?10389871-CRUD-class&goto=newpost Mon, 03 Jun 2013 15:33:45 GMT Hello everyone.
This is my first post here. :)
I'm implementing a very simple PHP class (learning purposes only) for doing CRUD tasks and I would love to receive some tips/advices about good practices.
As every CRUD class, this one has a delete() method which is used only to delete an entry from the database (MySQL in my case).
My question is:

For the delete() method, is it good to check if the entries that match the WHERE clause really exist before effectively deleting them?
In other words: before executing the deletion itself, should I include as part of the code for the delete() method the instructions for checking if the entries really exist or this checking should be done *outside* elsewhere (maybe in an isolated method)? Or yet, do you guys think that shouldn't be a concern, since the DBMS doesn't complain (i.e. doesn't emit any errors) when deleting entries that don't exist in the given table?

What is the best option? Which approach the PHP frameworks use for handling this situation?
Thanks a lot for any help! :) ]]> Newbies chapeupreto http://board.phpbuilder.com/showthread.php?10389871-CRUD-class <![CDATA[[RESOLVED] How to fix "Headers Already Sent"?]]> http://board.phpbuilder.com/showthread.php?10389861-RESOLVED-How-to-fix-quot-Headers-Already-Sent-quot&goto=newpost Fri, 31 May 2013 18:26:25 GMT --------- I understand the part about headers already sent: The question is, HOW can I combine the two things? And yes I know they're out of order if they did work, but as shown throws only the Headers Already Sent message instead of a bunch of Notices and Warnings. And besides I know the session is working or the first section of code wouldn't work. 1. How do I get both parts, including the commented out part, to work? 2. Why would a session fail to start? That would be a server issue, would it not? Nothing to do with the coder or visitor? LOL, assuming the coder did his job right! 3. But since I can envision other circumstances where I may want to use two or more, how would I do it? Sorry for the dumb Q! :o]]> Hi guys n gals;
I'm playing with sessions at the moment and it's a PIA to get my head around.:confused:

I have the following snippet in form.php:

PHP Code:
<?php
session_start();
// prevent page caching in PHP:
header('Cache-Control: no-cache, no-store, must-revalidate'); //HTTP/1.1
header('Expires: Sun, 01 Jul 2005 00:00:00 GMT');
header('Pragma: no-cache'); //HTTP/1.0

/* if (!session_start()) {
  die("Session failed to start!"); }
*/
?>
I understand the part about headers already sent: The question is, HOW can I combine the two things? And yes I know they're out of order if they did work, but as shown throws only the Headers Already Sent message instead of a bunch of Notices and Warnings. And besides I know the session is working or the first section of code wouldn't work.

1. How do I get both parts, including the commented out part, to work?

2. Why would a session fail to start? That would be a server issue, would it not? Nothing to do with the coder or visitor? LOL, assuming the coder did his job right!

3. But since I can envision other circumstances where I may want to use two or more, how would I do it?

Sorry for the dumb Q! :o ]]> Newbies Rivet http://board.phpbuilder.com/showthread.php?10389861-RESOLVED-How-to-fix-quot-Headers-Already-Sent-quot Extracting Entries From Arrays From My Database http://board.phpbuilder.com/showthread.php?10389853-Extracting-Entries-From-Arrays-From-My-Database&goto=newpost Fri, 31 May 2013 01:15:29 GMT I query a field within my database and when I echo the value from the table entry I get the following:

a:2:{i:0;s:8:"Joe";i:1;s:15:"Jenny";}
a:1:{i:0;s:11:"Jimmy";}
a:1:{i:0;s:8:"Joe";}

Can anyone point me in the right direction to find out what rows a Joe exists in? Sorry I'm a bit of a newb but learning quick. In this example for instance it would be in row 0 and row 2 but just trying to figure out how to output an array that tells me that. ]]> Newbies jkrystof http://board.phpbuilder.com/showthread.php?10389853-Extracting-Entries-From-Arrays-From-My-Database Connecting to MySQL http://board.phpbuilder.com/showthread.php?10389847-Connecting-to-MySQL&goto=newpost Thu, 30 May 2013 21:27:08 GMT '; exit; } if (!empty($vote)) //if they filled the form out, add their vote { $vote = addslashes($vote); $query = "update poll_results set num_votes = num_votes + 1 where SODA_NAME = '$vote'"; if(!($result = @$db_conn->query($query))) { echo 'Could not connect to database
'; exit; } } //get current results of poll, regardless of whether they voted $query = 'select * from poll_results'; if(!($result = @$db_conn->query($query))) { echo 'Could not connect to database
'; exit; } $num_SODA_NAME = $result->num_rows; //calculate total number of votes so far $total_votes=0; while ($row = $result->fetch_object()) { $total_votes += $row->num_votes; } $result->data_seek(0); //reset result pointer /****************************** Initial calculations for graph *******************************/ //set up constants putenv('GDFONTPATH=/Applications/Font Book.app'); $width=500; //width of image in pixel-this will fit in 640x480 $left_margin = 50; //space to leave on left of graph $right_margin = 50; //ditto right $bar_height = 40; $bar_spacing = $bar_height/2; $font = 'ariel'; $title_size= 16; //point $main_size= 12; //point $small_size= 12; //point $text_indent = 10; //postition for text labels from edge of image //set up initial point to draw from $x = $left_margin + 60; //place to draw baseline of the graph $y = 50; //ditto $bar_unit = (width-($x+$right_margin)) / 100; //one "point" on the graph //calculate height of graph - bars plus gaps plus some margin $height = $num_SODA_NAME * ($bar_height + $bar_spacing) + 50; /****************** Set up base image *******************/ //create a blank canvas $im = imagecreateruecolor($width, $height); //Allocate colors $white=imagecolorallocate($im, 255, 255, 255, 255); $blue=imagecolorallocate($im, 0, 64, 128); $black=imagecolorallocate($im, 0, 0, 0); $pink=imagecolorallocate($im, 255, 78, 243); $text_color = $black; $percent_color = $black; $bg_color = $white; $line_color = $black; $bar_color = $blue; $number_color = $pink; //Create "canvas" to draw on imagefilledrectangle($im, 0, 0, $width, $height, $bg_color); //Draw outline around canvas imagerectangle($im, 0, 0, $width-1, $height-1, $line_color); //Add title $title = 'The Beverage Company Poll Results'; $title_dimentions = imagettfbbox($title_size, 0, $font, $title); $title_length = $title_dimentions[2] - $title_dimentions[0]; $title_height = abs($title_dimentions[7] - $title_dimentions[1]); $title_above_line = abs($title_dimentions[7]); $title_x = ($width-$title_length)/2; //center it in x $title_y = ($y - $title_height)/2 + $title_above_line; //center in y gap imagettftext($im, $title_size, 0, $title_x, $title_y, $title_color, $font, $title); //Draw a base line from a little above first bar location //to a little below last imageline($im, $x, $y-5, $x, $height-15, $line_color); /******************** Draw data into graph *********************/ //Get each line of db data and draw corresponding bars while ($row = $result->fetch_object()) { if($total_votes > 0) $percent = intval(($row->num_votes/$total_votes)*100); else $percent = 0; //display percent for this value $percent_dimentions = imagettfbbox($main_size, 0, $font, $percent.'%'); $percent_length = $percent_dimentions[2] - $percent_dimentions[0]; imagettftext($im, $main_size, 0, $width-$percent_length-$text_indent, $y+($bar_height/2), $percent_color, $font, $percent.'%'); //length of bar for this value $bar_length = $x + ($percent * $bar_unit); //draw bar for this value imagefilledrectangle($im, $x, $y-2, $bar_length, $y+bar_height, $bar_color); //draw title for this value imagettftext($im, $main_size, 0, $text_indent, $y+($bar_height/2), $text_color, $font, "$row->SODA_NAME"); //draw outline showing 100% imagerectangle($im, $bar_length+1, $y-2, ($x+(100*$bar_unit)), $y+$bar_height, $line_color); //display numbers imagettftext($im, $small_size, 0, $x+(100*$bar_unit)-50, $y+($bar_height/2), $number_color, $font, $row->num_votes.'/' .$total_votes); //move down to next bar $y=$y+($bar_height+$bar_spacing); } /************* Display image **************/ Header('Content-type: image/png'); imagepng($im); /***************** Clean up ******************/ imagedestroy($im); ?> --------- I appreciate any help. I am wondering if I have to do something in MySQL or Dreamweaver to connect PHP with MySQL that I have missed??? Thanks, Beth]]> Hey everyone. I am working on an assignment and need some help. I have no syntax errors but it won't connect to MySQL. My assignment is to do a poll on a fake company that I have set up on the fake company's products....well...take a look at my code and see if there is anything wrong...please!!!
PHP Code:
 <?php
        //get vote from form
        $vote=$_REQUEST['vote'];
        
        //log in to database
        if (!$db_conn = new mysqli('localhost', 'poll', 'poll', 'POLL'))
        {
            echo 'Could not connect to database<br/>';
            exit;
        }
        
        if (!empty($vote)) //if they filled the form out, add their vote
        {
            $vote = addslashes($vote);
            $query = "update poll_results
            set num_votes = num_votes + 1
            where SODA_NAME = '$vote'";
        if(!($result = @$db_conn->query($query)))
        {
            echo 'Could not connect to database<br />';
            exit;
        }
        }
        
        //get current results of poll, regardless of whether they voted
        $query = 'select * from poll_results';
        if(!($result = @$db_conn->query($query)))
        {
            echo 'Could not connect to database<br />';
            exit;
        }
        $num_SODA_NAME = $result->num_rows;
        
        //calculate total number of votes so far
        $total_votes=0;
        while ($row = $result->fetch_object())
        {
            $total_votes += $row->num_votes;
        }
        $result->data_seek(0); //reset result pointer
        
        /******************************
        Initial calculations for graph
        *******************************/
        //set up constants
        putenv('GDFONTPATH=/Applications/Font Book.app');
        $width=500;  //width of image in pixel-this will fit in 640x480
        $left_margin = 50; //space to leave on left of graph
        $right_margin = 50; //ditto right
        $bar_height = 40; 
        $bar_spacing = $bar_height/2;
        $font = 'ariel';
        $title_size= 16; //point
        $main_size= 12; //point
        $small_size= 12; //point
        $text_indent = 10; //postition for text labels from edge of image
        
        //set up initial point to draw from
        $x = $left_margin + 60; //place to draw baseline of the graph
        $y = 50; //ditto
        $bar_unit = (width-($x+$right_margin)) / 100; //one "point" on the graph
        
        //calculate height of graph - bars plus gaps plus some margin
        $height = $num_SODA_NAME * ($bar_height + $bar_spacing) + 50;
    
    /******************
    Set up base image
    *******************/
    
    //create a blank canvas
    $im = imagecreateruecolor($width, $height);
    
    //Allocate colors
    $white=imagecolorallocate($im, 255, 255, 255, 255);
    $blue=imagecolorallocate($im, 0, 64, 128);
    $black=imagecolorallocate($im, 0, 0, 0);
    $pink=imagecolorallocate($im, 255, 78, 243);
    
    $text_color = $black;
    $percent_color = $black;
    $bg_color = $white;
    $line_color = $black;
    $bar_color = $blue;
    $number_color = $pink;
    
    //Create "canvas" to draw on
    imagefilledrectangle($im, 0, 0, $width, $height, $bg_color);
    
    //Draw outline around canvas
    imagerectangle($im, 0, 0, $width-1, $height-1, $line_color);
    
    //Add title
    $title = 'The Beverage Company Poll Results';
    $title_dimentions = imagettfbbox($title_size, 0, $font, $title);
    $title_length = $title_dimentions[2] - $title_dimentions[0];
    $title_height = abs($title_dimentions[7] - $title_dimentions[1]);
    $title_above_line = abs($title_dimentions[7]);
    $title_x = ($width-$title_length)/2; //center it in x
    $title_y = ($y - $title_height)/2 + $title_above_line; //center in y gap
    imagettftext($im, $title_size, 0, $title_x, $title_y, 
    $title_color, $font, $title);
    
    //Draw a base line from a little above first bar location
    //to a little below last
    imageline($im, $x, $y-5, $x, $height-15, $line_color);
    
    /********************
    Draw data into graph
    *********************/
    
    //Get each line of db data and draw corresponding bars
    while ($row = $result->fetch_object())
    {
        if($total_votes > 0)
            $percent = intval(($row->num_votes/$total_votes)*100);
        else
            $percent = 0;
            
            //display percent for this value
        $percent_dimentions = imagettfbbox($main_size, 0, $font, $percent.'%');
        $percent_length = $percent_dimentions[2] - $percent_dimentions[0];
        imagettftext($im, $main_size, 0, $width-$percent_length-$text_indent,
        $y+($bar_height/2), $percent_color, $font, $percent.'%');
        
        //length of bar for this value
        $bar_length = $x + ($percent * $bar_unit);
        
        //draw bar for this value
        imagefilledrectangle($im, $x, $y-2, $bar_length, $y+bar_height, $bar_color);
        
        //draw title for this value
        imagettftext($im, $main_size, 0, $text_indent, $y+($bar_height/2),
        $text_color, $font, "$row->SODA_NAME");
        
        //draw outline showing 100%
        imagerectangle($im, $bar_length+1, $y-2,
        ($x+(100*$bar_unit)), $y+$bar_height, $line_color);
        
        //display numbers
        imagettftext($im, $small_size, 0, $x+(100*$bar_unit)-50, $y+($bar_height/2),
        $number_color, $font, $row->num_votes.'/' .$total_votes);
        
        //move down to next bar
        $y=$y+($bar_height+$bar_spacing);
    }
    
    /*************
    Display image
    **************/
    Header('Content-type: image/png');
    imagepng($im);
    
    /*****************
    Clean up
    ******************/
    imagedestroy($im);
        
    ?>

I appreciate any help. I am wondering if I have to do something in MySQL or Dreamweaver to connect PHP with MySQL that I have missed???
Thanks,
Beth ]]> Newbies Wefferiscoding http://board.phpbuilder.com/showthread.php?10389847-Connecting-to-MySQL <![CDATA[[RESOLVED] SESSION Varuables, saving & retrieving]]> http://board.phpbuilder.com/showthread.php?10389831-RESOLVED-SESSION-Varuables-saving-amp-retrieving&goto=newpost Wed, 29 May 2013 16:13:53 GMT Contact Form Contact Form "; $a= mt_rand(nnn,nnn); $b= mt_rand(nnn,nnn); $c= mt_rand(nnnnn); $d=($a.$b.$c); echo "Your Temporary Code is : " . $d."
" ; ?>

Enter your temporary code here : ,including dashes.

Enter Your Name :

Your E-mail Address :

--------- and PHP: --------- formecheck.php: "."My E-mail: ".$myemail."
"; echo "======================="."
"; $code=($_POST['code']); echo "Your temporary code was: ".$code."
"; echo "======================="."
"; // Verify the code is correct: // use session? Can't get sessions to work $name=($_POST['name']); echo "Your Name is: ".$name."
"; if (count(explode(' ', $name)) >2) { echo "You used too many names-use 1 or 2 names only."."
"."Go back and try again"."
"; } echo (strlen($name)-1)." letters
"; echo "======================="."
"; echo "Server IP is: " . $_SERVER['REMOTE_ADDR']; echo "
"."======================="."
"; ?> --------- An earlier question just occurred to me: 3. Is there a way to get the random number $d into a $_POST to use? TIA, Rivet`]]> PHP 5.3, Win 7, XAMP 1.7.3 local server, + a website with PHP 5.4 served.
3 forms: form.php, formcheck.php and thanks.html. Code is below.

I guess my methodology might be best to start witn in case it's all wrong. :confused:

It's always seemed logical to get the security issues with access taken care of first, rather than on a 2nd or 3rd page. To that end, I'd like to put the initial security issues right up front onf the form.php just above the actual form input data.

On form.php:
First I create a random number using mt_rand and have the user type it into an input box, type=text, etc. which I assign to $d and follow it with the remaining inputs needed. No problem, all $_POST info echoes fine in formcheck.php.

Problem: Validating the random code.
In formcheck.php I have what the user entered as the code. BUT I cannot get at the 'code', OR the $d I assigned it to.
In other words, I have what the user eneterd, but I cannot get at the original random number to compare it to for validation. So I can't check if the 'code' the user entered and th eoriginal random number are the same!

Since I canot get at the original code from a POST, I decided to try using SESSION()s.

Here are the two pages' codes; minimized for my own clarity and TSing.

So I end up with 2 questions:
1. Is SESSION a reasonable way to get the info to other pages? Or is there an easier way?
All the sample code I've been able to find brings this question up:
2. In formcheck.php, WHERE can the $_SESSION[... be located in a script?
All the examples show it coming immediately after the session_start() but that feels like asking for something that hasn't existed yet. But a session, which any page could access, sounds like the answer but of course it won't work for me!:( I get an undefined index error in formcheck.php.

Here are the codes:

PHP Code:
 form.php

<?php
session_start();
$_session['key']='code';
?>
<!DOCTYPE html>
<head>
<title> Contact Form</title>
</head>
<body>
<html>
<?php
echo "<H1> Contact Form </H1>";
   $a= mt_rand(nnn,nnn);
   $b= mt_rand(nnn,nnn);
   $c= mt_rand(nnnnn);
   $d=($a.$b.$c);
   echo "Your Temporary Code is : " . $d."<br />" ;
?>
<form action="formcheck.php" method="post">
<p> Enter your temporary code here : </b> <input type="text" name="code" size="14 "  maxlength="12">  ,including dashes. <br />
<p> Enter Your Name :  <input type="text" name="name" length="20" maxlength="25" value="Tom Rivet" <br /> </p>
<p> Your E-mail Address : <input type="text" name="email" size="30" maxlength="40" value="nobody@spamcop.net" <br />
<p> <input type="submit" value="Send "> </p>
</form>
</body>
</html>
and
PHP Code:
 formecheck.php:

<?php
session_start();
/* Set e-mail recipient */
$myemail  = "nobody@kspamcop.net";
echo "<br />"."My E-mail: ".$myemail."<br />";
echo "======================="."<br />";

$code=($_POST['code']);
echo "Your temporary code was: ".$code."<br />";
echo "======================="."<br />";

// Verify the code is correct:
  // use session?  Can't get sessions to work

$name=($_POST['name']);
echo "Your Name is: ".$name."<br />";
if (count(explode(' ', $name)) >2) {
  echo "You used too many names-use 1 or 2 names only."."<br />"."Go back and try again"."<br />";
}
echo (strlen($name)-1)." letters<br />";

echo "======================="."<br />";

 echo "Server IP is: " . $_SERVER['REMOTE_ADDR'];
echo "<br />"."======================="."<br />";
?>
An earlier question just occurred to me:
3. Is there a way to get the random number $d into a $_POST to use?



TIA,

Rivet` ]]> Newbies Rivet http://board.phpbuilder.com/showthread.php?10389831-RESOLVED-SESSION-Varuables-saving-amp-retrieving <![CDATA[[RESOLVED] HTML in PHP & !Doctype]]> http://board.phpbuilder.com/showthread.php?10389819-RESOLVED-HTML-in-PHP-amp-!Doctype&goto=newpost Mon, 27 May 2013 17:41:21 GMT ... but no !doctype. ========== 1. Without a !doctype how does a server know what type of HTML to serve? Or does it not matter somehow? 2. Or perhaps is the doctype only needed once the first time it's used? I've looked at the Manual and at W3schools plus Google without finding it mentioned. TIA, Rivet]]> I am no guru, but I can generally hold my own in HTML. A !doctype is pretty important to use in HTML and it seems the same situation should apply to HTML within a PHP script.
Howerver, I often see in PHP code snippets simply:
==========
<html>
<body>
...
</body>
</html>
but no !doctype.
==========

1. Without a !doctype how does a server know what type of HTML to serve? Or does it not matter somehow?

2. Or perhaps is the doctype only needed once the first time it's used?

I've looked at the Manual and at W3schools plus Google without finding it mentioned.

TIA,

Rivet ]]> Newbies Rivet http://board.phpbuilder.com/showthread.php?10389819-RESOLVED-HTML-in-PHP-amp-!Doctype