PHP - Can Someone Offer Guidance With A Simple Form

I have created a script that will upload and reminder images.
Currently, the script gives each image a common name (myPhotoSample) and a timestamp.

Now, I want to replace the timestamp with a number so that each image is listed sequentially with more easily recognized values (1,2,3,etc).

My concern is the effect this could have if several uploads were coincidentally started simultaneously.

I doubt the script (or directory) would allow duplicate names to be rendered, so would I lose files because of overwriting?

If 3 uploads of 10 images each were all started at exactly midnight what could go wrong? How can I best resolve the risk and ensure that I get 30 complete files sequentially numbered?
 

Hello:

I am very new to PHP. I have done a few basic feedback forms, but that's it.

I have done Classic ASP for years, and am trying to switch over to PHP.

I wanted to see what it would take to make a basic CMS that would allow users to update page content from an admin panel.

Very much like the attached .JPG demo.

Is there existing code available like what I'm trying to do?

I can post the ASP version code if it will help.

I assume it would need a database, but I have only used DNS-less connections with Access - not anything PHP related.

I know the site is hosted on justhost.com, and justhost.com uses unix servers.

Any assistance would be appreciated!

I am trying to set up a class for my database connection. I have it working one way, this is a completely new method I am trying to learn. I have a file called MyClasses.php and in that file I did this. (I am following a not very well done tutorial)

Code: [Select]

class MySQLDatabase
{
private $connection;

function __construct(){
$this->open_connection();
}
public function open_connection(){
$this->connection = new MySQLi('localhost','MyDatabase','password','billpay') or die($mysql->error);
}
}
$database = new MySQLDatabase();

then in my index page where I want to begin by doing a query on the database, I did this

Code: [Select]
<?php include MyClasses.php ?>

$result = $database->query("SELECT * FROM names") or die($mysql->error);


but that gives me this error

Fatal error: Call to undefined method MySQLDatabase::query() in C:\wamp\www\BillPay\index.php

I can't figure out how to get past it.

Hi guys,

I need some help from you pro's please with converting code from a TPL template file to PHP.

My client has payment gateway scripts in an ecommerce site that he wants to offer to other merchants.  The code currently is in numerous TPL files (currently being used in Opencart).

What is involved in converting to plain ol' PHP?  Do I need the TPL files at all?  Can I rename the TPL extension to PHP as it looks like they contain PHP code??


Example of one of the TPL's is below:

 
<form action="<?php echo $action; ?>" method="post" id="checkout">
  <input type="hidden" name="instId" value="<?php echo $merchant; ?>" />
  <input type="hidden" name="cartId" value="<?php echo $order_id; ?>" />
  <input type="hidden" name="amount" value="<?php echo $amount; ?>" />
  <input type="hidden" name="currency" value="<?php echo $currency; ?>" />
  <input type="hidden" name="desc" value="<?php echo $description; ?>" />
  <input type="hidden" name="name" value="<?php echo $name; ?>" />
  <input type="hidden" name="address" value="<?php echo $address; ?>" />
  <input type="hidden" name="postcode" value="<?php echo $postcode; ?>" />
  <input type="hidden" name="country" value="<?php echo $country; ?>" />
  <input type="hidden" name="tel" value="<?php echo $telephone; ?>" />
  <input type="hidden" name="email" value="<?php echo $email; ?>" />
  <input type="hidden" name="testMode" value="<?php echo $test; ?>" />
</form>
<div class="buttons">
  <table>
    <tr>
      <td align="left"><a onclick="location = '<?php echo $back; ?>'" class="button"><span><?php echo $button_back; ?></span></a></td>
      <td align="right"><a onclick="$('#checkout').submit();" class="button"><span><?php echo $button_confirm; ?></span></a></td>
    </tr>
  </table>
</div>


I also have 3 PHP files as well, which look like (example):

<?php
class ControllerPaymentOnlineVoucher extends Controller {
protected function index() {

$this->data['button_confirm'] = $this->language->get('button_confirm');
$this->data['button_back'] = $this->language->get('button_back');

$this->load->model('checkout/order');

$order_info = $this->model_checkout_order->getOrder($this->session->data['order_id']);

$this->load->library('encryption');

$this->data['action'] = 'https://www.domain-removed.com/purchaseAndRedeem.php';

$this->data['merchant'] = $this->config->get('onlineVoucher_merchant');
$this->data['order_id'] = $order_info['order_id'];
$this->data['amount'] = $order_info['total'];
$this->data['currency'] = $order_info['currency'];
$this->data['description'] = $this->config->get('config_store') . ' - #' . $order_info['order_id'];
$this->data['name'] = $order_info['payment_firstname'] . ' ' . $order_info['payment_lastname'];

if (!$order_info['payment_address_2']) {
$this->data['address'] = $order_info['payment_address_1'] . ', ' . $order_info['payment_city'] . ', ' . $order_info['payment_zone'];
} else {
$this->data['address'] = $order_info['payment_address_1'] . ', ' . $order_info['payment_address_2'] . ', ' . $order_info['payment_city'] . ', ' . $order_info['payment_zone'];
}

$this->data['postcode'] = $order_info['payment_postcode'];

$payment_address = $this->customer->getAddress($this->session->data['payment_address_id']);

$this->data['country'] = $payment_address['iso_code_2'];
$this->data['telephone'] = $order_info['telephone'];
$this->data['email'] = $order_info['email'];
$this->data['test'] = $this->config->get('onlineVoucher_test');

$this->data['back'] = $this->url->https('checkout/payment');

$this->id       = 'payment';
$this->template = $this->config->get('config_template') . 'payment/onlineVoucher.tpl';

$this->render();

}

public function callback() {

if (isset($this->request->post['callbackPW']) && ($this->request->post['callbackPW'] == $this->config->get('onlineVoucher_password'))) {
$this->language->load('payment/onlineVoucher');

$this->data['title'] = sprintf($this->language->get('heading_title'), $this->config->get('config_store'));

if (!isset($this->request->server['HTTPS']) || ($this->request->server['HTTPS'] != 'on')) {
$this->data['base'] = HTTP_SERVER;
} else {
$this->data['base'] = HTTPS_SERVER;
}

$this->data['charset'] = $this->language->get('charset');
$this->data['language'] = $this->language->get('code');
$this->data['direction'] = $this->language->get('direction');

$this->data['heading_title'] = sprintf($this->language->get('heading_title'), $this->config->get('config_store'));

$this->data['text_response'] = $this->language->get('text_response');
$this->data['text_success'] = $this->language->get('text_success');
$this->data['text_success_wait'] = sprintf($this->language->get('text_success_wait'), $this->url->https('checkout/success'));
$this->data['text_failure'] = $this->language->get('text_failure');
$this->data['text_failure_wait'] = sprintf($this->language->get('text_failure_wait'), $this->url->https('checkout/payment'));

$this->data['button_continue'] = $this->language->get('button_continue');

if (isset($this->request->post['transStatus']) && $this->request->post['transStatus'] == 'Y') { 
$this->load->model('checkout/order');

$this->model_checkout_order->confirm($this->request->post['cartId'], $this->config->get('onlineVoucher_order_status_id'));

$message = '';

if (isset($this->request->post['transId'])) {
$message .= 'transId: ' . $this->request->post['transId'] . "\n";
}

if (isset($this->request->post['transStatus'])) {
$message .= 'transStatus: ' . $this->request->post['transStatus'] . "\n";
}

if (isset($this->request->post['countryMatch'])) {
$message .= 'countryMatch: ' . $this->request->post['countryMatch'] . "\n";
}

if (isset($this->request->post['AVS'])) {
$message .= 'AVS: ' . $this->request->post['AVS'] . "\n";
}

if (isset($this->request->post['rawAuthCode'])) {
$message .= 'rawAuthCode: ' . $this->request->post['rawAuthCode'] . "\n";
}

if (isset($this->request->post['authMode'])) {
$message .= 'authMode: ' . $this->request->post['authMode'] . "\n";
}

if (isset($this->request->post['rawAuthMessage'])) {
$message .= 'rawAuthMessage: ' . $this->request->post['rawAuthMessage'] . "\n";
}

if (isset($this->request->post['wafMerchMessage'])) {
$message .= 'wafMerchMessage: ' . $this->request->post['wafMerchMessage'] . "\n";
}

$this->model_checkout_order->update($this->request->post['cartId'], $this->config->get('onlineVoucher_order_status_id'), $message, FALSE);

$this->data['continue'] = $this->url->https('checkout/success');

$this->template = $this->config->get('config_template') . 'payment/onlineVoucher_success.tpl';
  
   $this->render();
} else {
     $this->data['continue'] = $this->url->https('checkout/payment');

$this->template = $this->config->get('config_template') . 'payment/onlineVoucher_failure.tpl';
  
   $this->render();
}
}
}
}
?>



Any guidance would be highly appreciated...

Phil

I'm looking for some direction as I approach a new challenge.

I have a table named friends_and_family and it contains name, email, and age fields.

I'm planning a party and want to invite 10 of the people that are between 20 and 35 years old.

The format I am considering would query the table and provide a list of those members that fit the age requirement.

I would like to generate that result (which I should be capable of handling) so that each person listed has a checkbox next to their name.

I imagine I will be creating a resultant form, so that I can then evaluate the result and select the checkboxes for those specific people that I want to invite.

Upon submission, an email will be sent to the people with selected checkboxes.

How should I approach this best?

A for each loop? Implode an array? 

I'm not very good with AJAX, so I'm thinking along these lines.

 

 

This topic has been moved to Other.

http://www.phpfreaks.com/forums/index.php?topic=314445.0

I have made a classified website. it works and I am proud of it. But as far as securing it goes, I have done almost nothing and I am sure, if in case the site becomes popular, it would be compromised with ease.

So I have started reading a book ' essential php security' and am reading several articles on php security online , but am still unable to wrap my head around the whole security issue.

Can someone help me ? there are a lot of unfamiliar topics, filtering, escaping , validating, session hijacking etc etc and it all goes over my head.

Its a classified website , considering this on what should I concentrate on as far as security goes ? 
btw what I have managed to do is use mysql_real_escape_string on every var going into a mysql $query.

Thanks

Hello, I am trying to make a page with a text box in where the user enters their post code and hits 'Submit' then it loads a new page with an embeded google maps map of that area.

with the following code:

<iframe width="425" height="350" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="http://www.google.com/maps?f=q&amp;source=s_q&amp;hl=en&amp;geocode=&amp;q=gym+**POSTCODE**&amp;sll=37.0625,-95.677068&amp;sspn=30.461748,86.572266&amp;ie=UTF8&amp;hq=gym&amp;hnear=**POSTCODE**,+United+Kingdom&amp;output=embed"></iframe><br /><small><a href="http://www.google.com/maps?f=q&amp;source=embed&amp;hl=en&amp;geocode=&amp;q=gym+**POSTCODE**&amp;sll=37.0625,-95.677068&amp;sspn=30.461748,86.572266&amp;ie=UTF8&amp;hq=gym&amp;hnear=**POSTCODE**,+United+Kingdom" style="color:#0000FF;text-align:left">View Larger Map</a>

I have typed **POSTCODE** where the user input needs to go.. Any ideas how this could be done? Thanks

On my website i have a form for customers to get in touch with me. This forum points to a php script to email me and tell them it has been submitted(via html). Here is the forum and the php script.

Form from html file
Code: [Select]
<form id="supportform" name="Support Form" method="post" action="php/formemail.php">
      <table width="100%" border="0">
        <tr>
          <td width="22%">Name:</td>
          <td width="78%"><input type="text" name="name" id="name" /></td>
        </tr>
        <tr>
          <td>Email:</td>
          <td><input type="text" name="email" id="email" /></td>
        </tr>
        <tr>
          <td>Company:</td>
          <td><input type="text" name="company" id="company" /></td>
        </tr>
        <tr>
          <td>Phone:</td>
          <td><input type="text" name="phone" id="phone" /></td>
        </tr>
        <tr>
          <td>Operating System:</td>
          <td><input type="text" name="os" id="os" /></td>
        </tr>
        <tr>
          <td>What Do You Need Help With?</td>
          <td><input type="text" name="problem" id="problem" /></td>
        </tr>
        <tr>
          <td>Additional Clarification:</td>
          <td><textarea name="additional" id="additional" cols="45" rows="3"></textarea></td>
        </tr>
        <tr>
          <td>Contact Preference:</td>
          <td><select name="preference" id="preference">
            <option value="null">Please Select</option>
            <option value="phone">Phone</option>
            <option value="email">Email</option>
          </select></td>
        </tr>
        <tr>
          <td>How Did You Hear Of Us?</td>
          <td><select name="advert" id="advert">
            <option value="null">Please Select</option>
            <option value="radio">Radio</option>
            <option value="newspaper">Newspaper</option>
            <option value="other">Other</option>
          </select></td>
        </tr>
        <tr>
          <td><input type="submit" name="Submit" id="submit" value="Submit" style="width:100px;height:30px" />
          <input type="reset" name="reset" id="reset" value="Reset" style="width:62px;height:30px;" /></td>
          <td>&nbsp;</td>
        </tr>
      </table>
    </form>

Here is php script
Code: [Select]
<?PHP

/*Subject an email variables */

$emailSubject = 'PHP Email Script';
$webMaster = 'me@mysite;otherperson@gmail.com';

/* Gathering Data Variables */

$nameField = $_POST['name'];
$emailField = $_POST['email'];
$companyField = $_POST['company'];
$phoneField = $_POST['phone'];
$osField = $_POST['os'];
$problemField = $_POST['problem'];
$additionalField = $_POST['additional'];
$preferenceField = $_POST['preference'];
$advertField = $_POST['advert'];

$body = <<<EOD
<br><hr><br>
Name: $nameField <br>
Email: $emailField <br>
Company: $companyField <br>
Phone: $phoneField <br>
OS: $osField <br>
Problem: $problemField <br>
Additional Info: $additionalField <br>
Preference: $preferenceField <br>
Advertising: $advertField <br>
<br>
Have a nice day!
EOD;

$headers = "From: $emailField\r\n";
$headers .= "Content-type: text/html\r\n";
$success = mail($webMaster, $emailSubject, $body, $headers);

/* Results rendered as HTML */

$theResults = <<<EOD
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Title</title>
<link rel="shortcut icon" href="images/favicon.ico" type="image/x-icon" />
<link href="css.css" rel="stylesheet" type="text/css">
<style type="text/css">
body {
background-color: #FFF;
}
</style>
</head>
<body>
  <div class="header"><a href="#"><img src="" alt="" name="greenhead" width="100%" height="17" id="greenhead" style="background: #B1FB17; display:block;" /></a>
    <!-- end .header --></div>
  <div class="content">
    <h1>&nbsp;</h1>
    <h1><img src="/images/logo2.jpg" width="194" height="152" align="middle"> Tech Suppport MT</h1>
    <h1 align="center">Success!</h1>
    <h2 align="center">Your information has been submitted to us.</h2>
    <p align="center">&nbsp;</p>
    <p align="center"><a href="/index.html">index - Home</a></p>
    <p>&nbsp;</p>
    <p>&nbsp;</p>
    <p>&nbsp;</p>
  </div>
  <div class="footer">
    <h4 align="center">footer</h4>
    <!-- end .footer --></div>
  <!-- end .container -->
</body>
</html>
EOD;

echo "$theResults";

?>

Everything works as it should except both people are getting two emails. One email with everything correct and the correct results. And another with all null values from an unknown sender. I should not be receiving one from an unknown sender with empty values.

Thanks for any help.

hi iam trying to make a simple search form to search the members tables based on there input. iam new php so most of my code is guess work

Code: [Select]
<form method="GET" action="<?php echo $_SERVER['PHP_SELF'];?>" name="searchForm">
<label for="country">Country:</label>
      <input type="text" name="country" />
      <label for="state">State:</label>
      <input type="text" name="state" />
      <label for="city">City:</label>
      <input type="text" name="city" />
      <input type="submit" value="submit" />
      </form>

<?

if ($_GET == array ()) {
//Define a variable that will be used to query the members; in this case, it would select all members
$query = "SELECT * FROM users";
} else {
//If the user typed at least one thing (in the form OR the url)
if (count ($_GET) == 1) {
//If what they typed is only for one criteria, define a variable that creates a query for only ONE criteria to search for
$query = "SELECT * FROM users WHERE 1";
foreach ($_GET as $field => $value) {
$query .= " AND $field = '$value'";
}
//If the user has typed in more than one field and hits search
} else {
//Define a variable for a query that selects members based off each criteria
$query = "SELECT * FROM users WHERE 1";
foreach ($_GET as $field => $value) {
$query .= " AND $field LIKE '%$value%'";
}
}

while($info = mysql_fetch_array( $data )) {

 Echo "<img src='http://datenight.netne.net/images/".$info['img'] ."' width='150' height='250''> <br>";

 Echo "<b>Name:</b> ".$info['username'] . "<br> <hr>";
 Echo "<b>Sex:</b> ".$info['sex'] . " <br><hr>";
 Echo "<b>Intrested in</b>" . "<br><hr>";
 Echo "".$info['rel'] . " ";
 Echo "".$info['frwb'] . " ";
 Echo "".$info['ons'] . " ";
 Echo "".$info['fr'] . "<br><hr>";
 Echo "<b>About me:</b> ".$info['aboutme'] . "<br><hr> ";
 Echo "<b>Looking for:</b> ".$info['looking'] . " <br><hr>";
 Echo "<a href='login_success.php'>'Back'</a>";

}
?>
    </body>
</html>

while($info = mysql_fetch_array( $data )) {  is not vaild error

I am trying to add some simple validation to my form. I only wanter users to be able to enter 11 numbers into the number field or else it will say 11 digit numbers only. A validation to only allow users to input numbers anything else and it brings up an error. and finally i want to check the email string to make sure it has an @ and a (.) .

How would i go about adding these validation techniques to this code?


<?php
                    if ($_SERVER['REQUEST_METHOD']=="POST"){
                                                
                    // Recipent Email
                    $to="andrew@peppermintdigital.com";
                                                        
                    $subject="Reply to Peppermint Invitation";
                    
                    $title = $_POST['title'];
                    $name = stripslashes($_POST['name']);
                    $add1 = stripslashes($_POST['add1']);
                    $add2 = stripslashes($_POST['add2']);
                    $add3 = stripslashes($_POST['add3']);
                    $add4 = stripslashes($_POST['add4']);
                    $postcode = stripslashes($_POST['postcode']);
                    $number = stripslashes($_POST['number']);
                    $email = stripslashes($_POST['email']);
                    $time = $_POST['time'];
                    
                                                        
                    $from = ($_POST['name']) . "<".stripslashes($_POST['email']).">";

$subject = ($_POST['name']) . "<".stripslashes($_POST['email']).">";
                                                        
                    // Email Message
                    $message = "Name : $title $name. Address : $add1, $add2, $add3, $add4, $postcode. Phone Number : $number. Email : $email. Appointment Time : $time";


                                                        
                                                        
                    // Validation Begins 

                    // Add Erros To Array
                    $errors = array();
                     
                    // Check Form
                    if (!$_POST['title'])
                    $errors[] = "Title Required";
        
                    if (!$_POST['name'])
                    $errors[] = "Name Required";
                    
                    if (!$_POST['add1'])
                    $errors[] = "Address Required";

if (!$_POST['add4'])
                    $errors[] = "City Required";
                    
                    if (!$_POST['postcode'])
                    $errors[] = "Postcode Required";
                    
                    if (!$_POST['number'])
                    $errors[] = "Number Required";

if(!$_POST['number'] == 11)
$errors[] = "Full Number Required";
                   
                    if (!$_POST['email'])
                    $errors[] = "Email Required";
                    
                    if (!$_POST['time'])
                    $errors[] = "Time Required";
                    
                    
                    // Display Errors
                    
                    if (count($errors)>0)
                    
                    {
                    echo"<h1 class='fail'>";
                    foreach($errors as $err)
                    echo "$err.\n";
                    echo"</h1>";


echo "


        <form method='post' action='#'>
         <table cellpadding='0' cellspacing='0' border='0'>
             <tr>
                    <td class='form_results' colspan='2'>               
                    </td>
                </tr>
             <tr>
                   <td class='form_left' valign='top'>
                     <table width='200' border='0' cellspacing='0' cellpadding='0'>
                          <tr>
                            <td class='title_left' valign='top'>Title</td>
                          </tr>
                          <tr>
                            <td class='sname_left' valign='top'>Name</td>
                          </tr>
                          <tr>
                            <td class='add_left' valign='top'>Address</td>
                          </tr>
                          <tr>
                            <td class='post_left' valign='top'>Postcode</td>
                          </tr>
                          <tr>
                            <td class='number_left' valign='top'>Phone Number</td>
                          </tr>
                          <tr>
                            <td class='email_left' valign='top'>Email Address</td>
                          </tr>
                          <tr>
                            <td class='time_left' valign='top'>Appointment Time</td>
                          </tr>
                        </table>
                  </td>
                  <td class='form_right' valign='top'>
                        <table width='300' border='0' cellspacing='0' cellpadding='0'>
                          <tr>
                            <td class='right_spacer'>
                             <select name='title' class='select'>
                                  <option>Mr</option>
                                  <option>Mrs</option>
                                  <option>Ms</option>
                                  <option>Miss</option>
                                </select>
                            </td>
                          </tr>
                          <tr>
                            <td class='right_spacer'><input type='text' name='name' class='field' value='$name' /></td>
                          </tr>
                          <tr>
                            <td class='right_spacer'><input type='text' name='add1' class='field' value='$add1' /></td>
                          </tr>
                          <tr>
                            <td class='right_spacer'><input type='text' name='add2' class='field' value='$add2' /></td>
                          </tr>
                          <tr>
                            <td class='right_spacer'><input type='text' name='add3' class='field' value='$add3' /></td>
                          </tr>
                          <tr>
                            <td class='right_spacer'><input type='text' name='add4' class='field' value='$add4' /></td>
                          </tr>
                          <tr>
                            <td class='right_spacer'><input type='text' name='postcode' class='field' value='$postcode' /></td>
                          </tr>
                          <tr>
                            <td class='right_spacer'><input type='text' name='number' class='field' value='$number' /></td>
                          </tr>
                          <tr>
                            <td class='right_spacer'><input type='text' name='email' class='field' value='$email' /></td>
                          </tr>
                          <tr>
                            <td class='right_spacer'>
                             <select name='time' class='select'>
                                  <option>5.30 pm</option>
                                  <option>6.30 pm</option>
                                  <option>7.30 pm</option>
                                </select>
                            </td>
                          </tr>
                        </table>
                  </td>
                </tr>
                <tr>
                  <td class='form_buttom' colspan='2'>
                   <input name='submit' type='submit' value='Submit' class='submit_button' />
                  </td>
                </tr>
             </table>
             </form>



 ";
                    }
                    
                    else {  



                  
                                                        
                                                        
                    // Build message headers
                    $headers = "From: $from\r\n" .
                    "MIME-Version: 1.0\r\n" .
                    "Content-Type: multipart/mixed;\r\n" .
                    " boundary=\"{$mime_boundary}\"";
                                                        
                    
                                                        
                    // Send message
                        if (@mail($to, $subject, $message, $headers))
                        echo "<h1 class='success'>Your message has been sent.</h1>";
                        
                        else
                        echo "<h1 class='fail'>Your message was not sent at this time.</h1>";
                        }
                     }
                    else {
echo "


        <form method='post' action='#'>
         <table cellpadding='0' cellspacing='0' border='0'>
             <tr>
                    <td class='form_results' colspan='2'>               
                    </td>
                </tr>
             <tr>
                   <td class='form_left' valign='top'>
                     <table width='200' border='0' cellspacing='0' cellpadding='0'>
                          <tr>
                            <td class='title_left' valign='top'>Title</td>
                          </tr>
                          <tr>
                            <td class='sname_left' valign='top'>Name</td>
                          </tr>
                          <tr>
                            <td class='add_left' valign='top'>Address</td>
                          </tr>
                          <tr>
                            <td class='post_left' valign='top'>Postcode</td>
                          </tr>
                          <tr>
                            <td class='number_left' valign='top'>Phone Number</td>
                          </tr>
                          <tr>
                            <td class='email_left' valign='top'>Email Address</td>
                          </tr>
                          <tr>
                            <td class='time_left' valign='top'>Appointment Time</td>
                          </tr>
                        </table>
                  </td>
                  <td class='form_right' valign='top'>
                        <table width='300' border='0' cellspacing='0' cellpadding='0'>
                          <tr>
                            <td class='right_spacer'>
                             <select name='title' class='select'>
                                  <option>Mr</option>
                                  <option>Mrs</option>
                                  <option>Ms</option>
                                  <option>Miss</option>
                                </select>
                            </td>
                          </tr>
                          <tr>
                            <td class='right_spacer'><input type='text' name='name' class='field' /></td>
                          </tr>
                          <tr>
                            <td class='right_spacer'><input type='text' name='add1' class='field' /></td>
                          </tr>
                          <tr>
                            <td class='right_spacer'><input type='text' name='add2' class='field' /></td>
                          </tr>
                          <tr>
                            <td class='right_spacer'><input type='text' name='add3' class='field' /></td>
                          </tr>
                          <tr>
                            <td class='right_spacer'><input type='text' name='add4' class='field' /></td>
                          </tr>
                          <tr>
                            <td class='right_spacer'><input type='text' name='postcode' class='field' /></td>
                          </tr>
                          <tr>
                            <td class='right_spacer'><input type='text' name='number' class='field' /></td>
                          </tr>
                          <tr>
                            <td class='right_spacer'><input type='text' name='email' class='field' /></td>
                          </tr>
                          <tr>
                            <td class='right_spacer'>
                             <select name='time' class='select'>
                                  <option>5.30 pm</option>
                                  <option>6.30 pm</option>
                                  <option>7.30 pm</option>
                                </select>
                            </td>
                          </tr>
                        </table>
                  </td>
                </tr>
                <tr>
                  <td class='form_buttom' colspan='2'>
                   <input name='submit' type='submit' value='Submit' class='submit_button' />
                  </td>
                </tr>
             </table>
             </form>



 ";
 } 
                    ?>

I'm having trouble with this form. I can't seem to figure out the rest of what is required I have already done most of it...I'm just stuck on these parts:

Province Select : (AutoGeneration, Multiple Select, Memory)

    AutoGeneration using Provinces Array: The Province Select box is generated by PHP using this array: provinces.txt Cut and paste this array into your own code.
    Multiple Selections: Note that the province select box permits multiple values to be selected. View the HTML source to see the configuration details. Also note how $_POST delivers these multiple values as an array.
    Select Box Memory: The Province select box retains the user choices after a POST. For each province selected by the user, your code will generate the "selected" attribute in the <options> tag for that province. View the HTML source of the working solution to see how this works.

Status CheckBoxes (Multiple Select, Memory)

    Multiple Selections: Note that these checkboxes have been configured in the HTML to permit multiple selections. Also note that $_POST delivers these multiple selection values in an array.
    Status Box Memory:The Status Box retains the user choices after a POST. Your code will need to generate the "checked" attribute in the <input> tag for each item selected.
    Do not generate the checkboxes with an array.

Location Radio button:

    Do not generate the radio buttons with an array.
    The Location radio button retains the user choice after a POST.

Validation Success Message:

    Where does it go - The final success message is placed within the <div class="success"></div> tags at the top of the HTML.
    Use a Loop: Generate the success message with a single array loop that reads the $_POST array and prints out the success message as an ordered list.
    Form Variables List
        Un-Ordered List - The form variables are displayed in an unordered list . CSS removes the bullet.
        Names Capitolised - The names of the form variables are capitolised ( use strtoupper() function ) .
        Handle Empty Values - Print "---None supplied---" if the variable is empty.
        Province Long Names - Print the long names of the provinces selected as comma separated string
        Status Choices - Print the status choices as a comma separated string.

Functions I need to use:

    empty() - is the string empty. Unfortunately, a "0" value counts as an empty string.
    strlen() - returns the number of characters in a string.
    is_numeric() - is the string a number
    count() - how many rows in an array
    is_array() - is the variable an array
    isset() - does the variable or member of array exist
    in_array() -does this string exist in this array
    strtoupper() - convert string to upper case.
    join() - you'll want this one too. Converts an array of strings into a string with a delimiter.
    error_reporting(E_ALL ^ (E_NOTICE | E_WARNING)); - suppresses warning messages in your code. Place at top.
    foreach ($_POST as $KEY => $VAL) {} - walk through the $_POST array (or any array)

My code:

Code: [Select]
<!--"StAuth10065: I Adam Graham, 000136921 certify that this material is my original work. No other person's work has been used without due acknowledgement. I have not made my work available to anyone else."-->

  <?
  $PROVINCES = array( "--" => "--- Please Select Provinces ---",
"nf"=>"Newfoundland",
"pe"=>"Prince Edward Island",
"nb"=>"New Brunswick",
"ns"=>"Nova Scotia",
"qc"=>"Quebec",
"on"=>"Ontario",
"mb"=>"Manitoba",
"sk"=>"Saskatchewan",
"ab"=>"Alberta",
"bc"=>"British Columbia",
"nt"=>"Northwest Territories");
 
  if ($_SERVER['REQUEST_METHOD'] == 'GET')
  {
  $dimwelcomeMsg = TRUE;
  }
 
  if ($_SERVER['REQUEST_METHOD'] == 'POST')
  {
  if ($_POST['uname'] == ''){
$errMsgs['uname'] = "Username must not be blank!!!"; 
$unameInError = true;
  }
  if (empty($_POST['year']) == TRUE){
  $errMsgs['year'] = "Year must not be blank!!";
  }
  if (count($errMsg) > 0 ):
  $dispErrorMsg = TRUE;
else:

foreach ($_POST as $key => $val):
$key = strtoupper($key);
$successMsg[$key] = $val;
endforeach;

$dispSuccessMsg = TRUE;


endif;
  }
  ?>
<html  >

<head>
<title>Comp10065 - Simple Form Validatioon</title>

 
<style type="text/css">


body { margin: 0; padding: 0; font: 80%/1.5 Arial,Helvetica,sans-serif; color: #111; background-color: green; }
h2 { margin: 0px; padding: 10px; font-family: Georgia, "Times New Roman", Times, serif; font-size: 200%; font-weight: normal; color: #FFF; background-color: #CCC; border-bottom: #BBB 2px solid; }
h1 {color:#006600}
p#copyright { margin: 20px 10px; font-size: 90%; color: #999; }
div.form-container { margin: 10px; padding: 5px; background-color: #FFF; border: #EEE 1px solid; }
p.legend { margin-bottom: 1em; }
p.legend em { color: #C00; font-style: normal; }
div.errors { margin: 0 0 10px 0; padding: 5px 10px; border: #FC6 1px solid; background-color: #FFC; }
div.errors p { margin: 0; }
div.errors p em   { color: #C00; font-style: normal; font-weight: bold; }
div.success { margin: 0 0 10px 0; padding: 5px 10px; border: #FC6 1px solid; background-color: #FFC; }
div.success p { margin: 0; color:#006633}
div.success li {list-style-type: none; }
div.form-container form p { margin: 0; }
div.form-container form p.note { margin-left: 170px; font-size: 90%; color: #333; }
div.form-container form fieldset { margin: 10px 0; padding: 10px; border: #DDD 1px solid; }
div.form-container form legend { font-weight: bold; color: #666; }
div.form-container form fieldset div { padding: 0.25em 0; }
div.form-container label,
div.form-container span.label { margin-right: 10px; padding-right: 10px; width: 150px; display: block; float: left; text-align: right; position: relative; }
div.form-container label.error,
div.form-container span.error { color: #000; }
div.form-container select.error, div.form-container div.error {background-color: #FEF;}
div.form-container label em,
div.form-container span.label em { position: absolute; right: 0; font-size: 120%; font-style: normal; color: #C00; }
div.form-container input.error { border-color: #C00; background-color: #FEF; }
div.form-container input:focus,
div.form-container input.error:focus,
div.form-container textarea:focus { background-color: #FFC; border-color: #FC6; }
div.form-container div.controlset {margin: 3px}
div.form-container div.controlset label,
div.form-container div.controlset input { display: inline; float: none; }
div.form-container div.controlset div { margin-left: 170px; }
div.form-container div.buttonrow { padding-left: 430px; border: 1px solid #CCCCCC }
div#wrapper {width: 700px ; margin-left: auto; margin-right: auto}
pre {color:black; font-size: 10pt; font-weight: bold; margin-left: 30px}
</style>

</head>

<body>

<div id="wrapper">

<h1> Form Validation Lab</h1>

<div class="form-container">
 <? if ($_SERVER['REQUEST_METHOD'] == 'GET') : ?>
 <? if (displayWelcomeMsg) : ?>
 <p>Please fill in the form........</p>
 <? endif; ?>
 
<? endif; ?>

<? if ($displaySuccessMsg): ?>
<div class="success">
<p>Thank you for your submission.</p>
<ol>
<? foreach($successMsgs as $key => $successMsg): ?>
<li><?= $key ?> = <?= $successMsg ?> </li>
<? endforeach; ?>
</ol>
</div>
<? endif; ?>

<? if ($dispErrorMsg) : ?>
<div class="errors">
<p><em>Oops...the following errors were encountered</em></p>
<ul>
<? foreach ($errMsgs as $key => $errMsg): ?>
<li><?= $errMsgs ?> </li>
<? endforeach; ?>
</ul>
<p>Please correct the errors and re-submit this form.</p>
</div>
<? endif; ?>




<form action="<?= $_SERVER['PHP_SELF'] ?>" method="post">
<input type="hidden" name="act" value="post">
<div class="buttonrow">
<input type="submit" value="Submit This Form " class="button" />
<a href="<?= $_SERVER['PHP_SELF'] ?>" >Start Again</a>
</div>

<p class="legend"><strong>Note:</strong> Required fields are marked with an asterisk (<em>*</em>)</p>
<fieldset>
<legend>User Details</legend>
<div>
<label for="uname" >User Name <em>*</em></label>
<? if (isset($errMsgs['uname'])) echo 'class = "errors"' ?>
           
<input id="uname" type="text" name="uname"  value="<?=$_POST['uname'] ?>"  />
(must be greater than 5 chars)</div>
<div>
<label for="email">Email Address </label>
<input id="email" type="text" name="email" value="" />
</div>
</fieldset>

<fieldset>

<legend>Submission</legend>
<div>
<label for="year">Year (YYYY) <em>*</em></label>
<input id="year" type="text" name="year"
            <? if (isset($errMsgs['year'])) echo 'class = "errors"' ?>
value="" size="4" maxlength="4"  />
(4 digit number)</div>
<div>
<label for="date">Month (MM)</label>
<input id="date" type="text" name="month" value="" size="4" maxlength="2" />

(number ranging from 1-12)</div>
</fieldset>

<fieldset>
<legend>Preferences</legend>
<div>
<label for="type" >Province (Multiple Select) <em>*</em></label>
<select name = "province[]" multiple size = "12" id="type"  >
                <? foreach ($PROVINCES as $abbreviation => $longname); ?>
                <option value = "<?=$abbreviation ?> "></option>
                <? enfgoreach; ?>
</select>

</div>
<div class= 'controlset'   >
<span class="label">Status (Mult Select)<em>*</em></span>
<input name="status[]" id="approved" value="approved" type="checkbox"  /> <label for="approved">Approved</label>
<input name="status[]" id="pending" value="pending" type="checkbox"  /> <label for="pending">Pending Application</label> <input name="status[]" id="actives" value="actives" type="checkbox"  /> <label for="actives">Active Service</label>

</div>

<div class= 'controlset'>
<span class="label">  Location  <em>*</em></span>
<input name="location" id="radio1" value="Garage" type="radio" /> <label for="radio1">Garage</label>
<input name="location" id="radio2" value="Attic" type="radio" /> <label for="radio2">Attic</label>
<input name="location" id="radio3" value="House" type="radio" /> <label for="radio3">House</label>

</div>
</fieldset>

</form>
<p>This debug info is here to help you. You are only required to display the POST array</p>
<pre><?= print_r($_POST,true) ?> </pre>
</div>

</div>

</body>
</html>

Hi,

Today I have taken my first step towards familiarisation with php.

I have created a simple form form a tutorial I read.

The mail.php file is this:

Code: [Select]
<?php
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$email = $_POST['email'];
$dropdown = $_POST['dropdown'];
$formcontent=" From: $firstname \n Surname: $lastname \n Email: $email \n Dropdown: $dropdown";
$recipient = "fathernugen@googlemail.com";
$subject = "Newsletter Sign Up";
$mailheader = "From: $email \r\n";
mail($recipient, $subject, $formcontent, $mailheader) or die("Error!");
echo "You have been added to our newsletter subscription list!" . " -" . "<a href='newsletter.php' style='margin:0 auto; top: 100px; text-decoration:none;color:#ff0099;'> Return to Sitting Spiritually</a>";
?>

My problem is that users are redirected to a blank page with 'thank you return to sitting spiritually'.

I would like to use a custom thank you page with a url like;

www.sittingspiritually.co.uk/thankyou.php

so the look of the site is not completely ruined by my php inadequacies.


Is there a small piece of code i can add to the mail.php file so i can use a custom page for the success???

I hope some one can help, thanks in advance.

Hi, I have a php form that I use to try to get matching data from the database that I put into the form. So if I enter date of birth 9-4-80 and first name Dave and lastname Smith. When I submit it the code should pull all of the matching terms out of the database and display. Now I get the following error when I submit the form.


Query: Resource id #2
Failed with error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Resource id #2' at line 1

any help Greatly appreciated. thank you!


here is the code

Code: [Select]
<?php 
ini_set ("display_errors", "1");
error_reporting(E_ALL);

$host = " ";
$database  = " ";
$username  = " ";
$password  = " ";
$tbl_name   = "users";


$conn = mysql_connect($host, $username, $password) or die("Could not connect: " . mysql_error());

if($conn)
{
mysql_select_db($database);
echo "connected to database!!";
 } else {
  echo "failed to select database";
}




//include('bouncer.php');


 
 
//$currentUser = $_SESSION['myusername'];
 
if(isset($_POST['submit'])) 

{  


$first = mysql_real_escape_string( $_POST['first']);
$last = mysql_real_escape_string( $_POST['last']);
$dob = mysql_real_escape_string( $_POST['dob']);

 
   
  //THE SEARCH FUNCTION
$sql = mysql_query ( "SELECT * FROM users WHERE firstname  LIKE '%$first%' 
OR lastname LIKE '%$last%' OR dob  LIKE '%$dob%' ") or die(mysql_error());  
 
  

$result = mysql_query($sql) or die( "<br>Query: $sql<br>Failed with error: " . mysql_error() );

if (!$result) {
    echo "Could not successfully run query ($sql) from DB: " . mysql_error();
    exit;
}

if (mysql_num_rows($result) == 0) {
    echo "No rows found, nothing to print so am exiting";
    exit;
}


while ($row = mysql_fetch_assoc($result)) {
    echo $row["firstname"];
    echo $row["lastname"];
    echo $row["dob"];
}



 

 }//if(isset($_POST['submit']))
?>
<html>
<body>


<form action="login_success8.php" method="post">
  <p>
    <input type="text" name="first" size="20" />
  First name<br />
    <input type="text" name="last" size="20" />
    Last name<br />
    <input name="dob" type="text" size="20" id="dob" />
    Date of Birth<br />
    <input type="submit" name="submit" value="Search" />
    <input type="reset" value="Reset fields" />
  </p>
</form> 



</body>
</html>

Ok so I already have a "post" action URL, here it is below.

<form method="post" action="http://survey.leisuretrends.com/RemoteSurvey.asp?survey=321&survey_version=1330">

The idea is to put a simple e-mail form on my personal website:



And have the post action to go to the URL above (its a marketing company for email submissions / newsletters)

Here is what I have so far, but I know something is not right:

Quote

<form>
<input type="text" />
<input type="submit" />
<form method="post" />
<form action="http://survey.leisuretrends.com/RemoteSurvey.asp?survey=321&survey_version=1330"/>
</form>


Any help would be greatly appreciated.  Thank you for your patience with me