PHP - Check Fields In Db And Overwrite One

hi, is there a way to do a check for blank fields before posting to database?  dumb users keep adding blank fields.

i need to check fields $_POST[company], $_POST[jobNO] and $_POST[staff].


Code: [Select]
if(isset($_POST['add']))
{


$cname=$_POST[company];

$compid = mysql_query("SELECT * FROM company WHERE company = '$cname'");
while($row4 = mysql_fetch_array($compid))
{


$cid=$row4["ID"];

}




$query = "INSERT INTO jobno VALUES (
NULL,
'$_POST[jobNO]',
'$cid'
)";

mysql_query($query) or die('Error, insert failed');


$query1 = "INSERT INTO staff VALUES (
NULL,
'$_POST[staff]',
'$_POST[Y]-$_POST[M]-$_POST[D]',
'$_POST[jobNO]'
)";

mysql_query($query1) or die('Error, insert failed1');


echo "1 record added";

I'm trying to show on my order printed receipt some checkout fields and extras from the products.

The website is www.prontoitaliano.co.uk/shop

What needs to appear on the receipt are all the extras options from all the products(See checkboxes in all pasta dishes and checkboxes toppings in "create your own pizza") and 2 fields from the checkout page (Pick up Date, Pick up Time).

To send the order to the printer I'm using the "Star cloud PRNT woocommerce" plugin and for the pickup date and time fields "ultimate woocommerce delivery and pickup date time", I've attached below the code that needs to be edited to add more fields to the receipt. I know that probably it's not difficult to solve my issue but I don't have any knowledge of php and I hope you guys can assist me. Also, I've attached a picture showing what is missing on the printed receipt and what result I'm trying to get. Thanks for your time!

 

<?php
function star_cloudprnt_get_column_separated_data($columns)
{
    $max_chars = STAR_CLOUDPRNT_MAX_CHARACTERS_THREE_INCH;
    $total_columns = count($columns);

    if ($total_columns == 0) return "";
    if ($total_columns == 1) return $columns[0];
    if ($total_columns == 2)
    {
        $total_characters = strlen($columns[0])+strlen($columns[1]);
        $total_whitespace = $max_chars - $total_characters;
        if ($total_whitespace < 0) return "";
        return $columns[0].str_repeat(" ", $total_whitespace).$columns[1];
    }

    $total_characters = 0;
    foreach ($columns as $column)
    {
        $total_characters += strlen($column);
    }
    $total_whitespace = $max_chars - $total_characters;
    if ($total_whitespace < 0) return "";
    $total_spaces = $total_columns-1;
    $space_width = floor($total_whitespace / $total_spaces);
    $result = $columns[0].str_repeat(" ", $space_width);
    for ($i = 1; $i < ($total_columns-1); $i++)
    {
        $result .= $columns[$i].str_repeat(" ", $space_width);
    }
    $result .= $columns[$total_columns-1];

    return $result;
}

function star_cloudprnt_get_seperator()
{
    $max_chars = STAR_CLOUDPRNT_MAX_CHARACTERS_THREE_INCH;
    return str_repeat('_', $max_chars);
}

function star_cloudprnt_parse_order_status($status)
{
    if ($status === 'wc-pending') return 'Pending Payment';
    else if ($status === 'wc-processing') return 'Processing';
    else if ($status === 'wc-on-hold') return 'On Hold';
    else if ($status === 'wc-completed') return 'Completed';
    else if ($status === 'wc-cancelled') return 'Cancelled';
    else if ($status === 'wc-refunded') return 'Refunded';
    else if ($status === 'wc-failed') return 'Failed';
    else return "Unknown";
}

function star_cloudprnt_get_codepage_1252_currency_symbol()
{
    $symbol = get_woocommerce_currency_symbol();
    if ($symbol === "&pound;") return "\xA3"; // £ pound
    else if ($symbol === "&#36;") return "\x24"; // $ dollar
    else if ($symbol === "&euro;") return "\x80"; // € euro
    return ""; // return blank by default
}

function star_cloudprnt_get_formatted_variation($variation, $order, $item_id) 
{
    $return = '';
    if (is_array($variation))
    {
        $variation_list = array();
        foreach ($variation as $name => $value)
        {
            // If the value is missing, get the value from the item
            if (!$value)
            {
                $meta_name = esc_attr(str_replace('attribute_', '', $name));
                $value = $order->get_item_meta($item_id, $meta_name, true);
            }

            // If this is a term slug, get the term's nice name
            if (taxonomy_exists(esc_attr(str_replace('attribute_', '', $name))))
            {
                $term = get_term_by('slug', $value, esc_attr(str_replace('attribute_', '', $name)));
                if (!is_wp_error($term) && ! empty($term->name))
                {
                    $value = $term->name;
                }
            }
            else
            {
                $value = ucwords(str_replace( '-', ' ', $value ));
            }
            $variation_list[] = wc_attribute_label(str_replace('attribute_', '', $name)) . ': ' . rawurldecode($value);
        }
        $return .= implode('||', $variation_list);
    }
    return $return;
}

function star_cloudprnt_create_receipt_items($order, &$printer)
{
    $order_items = $order->get_items();
    foreach ($order_items as $item_id => $item_data)
    {
        $product_name = $item_data['name'];
        $product_id = $item_data['product_id'];
        $variation_id = $item_data['variation_id'];

        $item_qty = $order->get_item_meta($item_id, "_qty", true);
        $item_total_price = floatval($order->get_item_meta($item_id, "_line_total", true))
                        +floatval($order->get_item_meta($item_id, "_line_tax", true));
        $item_price = floatval($item_total_price) / intval($item_qty);
        $currencyHex = star_cloudprnt_get_codepage_1252_currency_symbol();
        $formatted_item_price = number_format($item_price, 2, '.', '');
        $formatted_total_price = number_format($item_total_price, 2, '.', '');

        $printer->set_text_emphasized();
        $printer->add_text_line(str_replace('&ndash;', '-', $product_name)." - ID: ".$product_id."");
        $printer->cancel_text_emphasized();

        if ($variation_id != 0)
        {
            $product_variation = new WC_Product_Variation( $variation_id );
            $variation_data = $product_variation->get_variation_attributes();
            $variation_detail = star_cloudprnt_get_formatted_variation($variation_data, $order, $item_id); 
            $exploded = explode("||", $variation_detail);
            foreach($exploded as $exploded_variation)
            {
                $printer->add_text_line(" ".ucwords($exploded_variation));
            }
        }
        $printer->add_text_line(star_cloudprnt_get_column_separated_data(array(" Qty: ".
                    $item_qty." x Cost: ".$currencyHex.$formatted_item_price,
                    $currencyHex.$formatted_total_price)));
    }
}

function star_cloudprnt_create_address($order, $order_meta, &$printer)
{
    $fname = $order_meta[_shipping_first_name][0];
    $lname = $order_meta[_shipping_last_name][0];
    $a1 = $order_meta[_shipping_address_1][0];
    $a2 = $order_meta[_shipping_address_2][0];
    $city = $order_meta[_shipping_city][0];
    $state = $order_meta[_shipping_state][0];
    $postcode = $order_meta[_shipping_postcode][0];
    $tel = $order_meta[_billing_phone][0];

    $printer->set_text_emphasized();
    if ($a1 == '')
    {
        $printer->add_text_line("Billing Address:");
        $printer->cancel_text_emphasized();
        $fname = $order_meta[_billing_first_name][0];
        $lname = $order_meta[_billing_last_name][0];
        $a1 = $order_meta[_billing_address_1][0];
        $a2 = $order_meta[_billing_address_2][0];
        $city = $order_meta[_billing_city][0];
        $state = $order_meta[_billing_state][0];
        $postcode = $order_meta[_billing_postcode][0];
    }
    else
    {
        $printer->add_text_line("Shipping Address:");
        $printer->cancel_text_emphasized();
    }

    $printer->add_text_line($fname." ".$lname);
    $printer->add_text_line($a1);
    if ($a2 != '') $printer->add_text_line($a2);
    if ($city != '') $printer->add_text_line($city);
    if ($state != '') $printer->add_text_line($state);
    if ($postcode != '') $printer->add_text_line($postcode);
    $printer->add_text_line("Tel: ".$tel);
}

function star_cloudprnt_print_order_summary($selectedPrinter, $file, $order_id)
{
    $order = wc_get_order($order_id);
    $shipping_items = @array_shift($order->get_items('shipping'));
    $order_meta = get_post_meta($order_id);

    $printer = new Star_CloudPRNT_Star_Line_Mode_Job($selectedPrinter, $file);
    $printer->set_codepage("20"); // 20 hex == 32 decimal == 1252 Windows Latin-1
    if (get_option('star-cloudprnt-print-logo-top-input')) $printer->add_nv_logo(esc_attr(get_option('star-cloudprnt-print-logo-top-input')));
    $printer->set_text_emphasized();
    $printer->set_text_center_align();
    $printer->add_text_line("ORDER NOTIFICATION");
    $printer->set_text_left_align();
    $printer->cancel_text_emphasized();
    $printer->add_new_line(1);
    $printer->add_text_line(star_cloudprnt_get_column_separated_data(array("Order #".$order_id, date("d-m-y H:i:s", time()))));
    $printer->add_new_line(1);
    $printer->add_text_line("Order Status: ".star_cloudprnt_parse_order_status($order->post->post_status));
    $printer->add_text_line("Order Date: ".$order->order_date);                     
    if (isset($shipping_items['name']))
    {
        $printer->add_new_line(1);
        $printer->add_text_line("Shipping Method: ".$shipping_items['name']);
    }
    $printer->add_text_line("Payment Method: ".$order_meta[_payment_method_title][0]);
    $printer->add_new_line(1);
    $printer->add_text_line(star_cloudprnt_get_column_separated_data(array('ITEM', 'TOTAL')));
    $printer->add_text_line(star_cloudprnt_get_seperator());

    star_cloudprnt_create_receipt_items($order, $printer);

    $printer->add_new_line(1);
    $printer->set_text_right_align();
    $formatted_overall_total_price = number_format($order_meta[_order_total][0], 2, '.', '');
    $printer->add_text_line("TOTAL     ".star_cloudprnt_get_codepage_1252_currency_symbol().$formatted_overall_total_price);
    $printer->set_text_left_align();
    $printer->add_new_line(1);
    $printer->add_text_line("All prices are inclusive of tax (if applicable).");
    $printer->add_new_line(1);

    star_cloudprnt_create_address($order, $order_meta, $printer);

    $printer->add_new_line(1);
    $printer->set_text_emphasized();
    $printer->add_text_line("Customer Provided Notes:");
    $printer->cancel_text_emphasized();
    $printer->add_text(empty($order->post->post_excerpt) ? "None" : $order->post->post_excerpt);
    if (get_option('star-cloudprnt-print-logo-bottom-input')) $printer->add_nv_logo(esc_attr(get_option('star-cloudprnt-print-logo-bottom-input')));

    $printer->printjob();
}

function star_cloudprnt_woo_on_thankyou($order_id)
{
    $file = STAR_CLOUDPRNT_PRINTER_PENDING_SAVE_PATH.star_cloudprnt_get_os_path("/order_".$order_id."_".time().".bin");

    $selectedPrinter = "";
    $printerList = star_cloudprnt_get_printer_list();
    if (!empty($printerList))
    {
        foreach ($printerList as $printer)
        {
            if (get_option('star-cloudprnt-printer-select') == $printer['name'])
            {
                $selectedPrinter = $printer['printerMAC'];
                break;
            }
        }

        if ($selectedPrinter === "" && count($printerList) === 1) $selectedPrinter = $printer['printerMAC'];

        if ($selectedPrinter !== "") star_cloudprnt_print_order_summary($selectedPrinter, $file, $order_id);
    }
}

function star_cloudprnt_setup_order_handler()
{
    if (selected(get_option('star-cloudprnt-select'), "enable", false) !== "" && star_cloudprnt_is_woo_activated())
    {
        add_action('woocommerce_thankyou', 'star_cloudprnt_woo_on_thankyou', 1, 1);
    }
}

 

Hello All:

Trying to work with PHP on a contact form with a jQuery Validation to make certain that the visitors fill out the required information. I'll try to show everything that I have, and then the error I am getting when the visitor hits "submit."

I don't know PHP all that well, and trying to learn my way through it. I used a couple of tutorials to add the features I needed and did my own styling on the live site.  Here is the PHP that is currently in the header of my markup:


<?php
//If the form is submitted
if(isset($_POST['submit'])) {

//Check to make sure that the First name field is not empty
if(trim($_POST['firstname']) == '') {
$hasError = true;
} else {
$firstname = trim($_POST['firstname']);
}
    
    //Check to make sure that the Last name field is not empty
if(trim($_POST['lastname']) == '') {
$hasError = true;
} else {
$lastname = trim($_POST['lastname']);
}
    
    //Check to make sure that the Street Address 01 field is not empty
if(trim($_POST['street01']) == '') {
$hasError = true;
} else {
$street01 = trim($_POST['street01']);
}
    
    //If Street02 is filled out, give it a value
    
    $street02  = $_POST['street02'];
    
    //Check to make sure that the City field is not empty
if(trim($_POST['city']) == '') {
$hasError = true;
} else {
$city = trim($_POST['city']);
}
    
    //Check to make sure that the State field is not empty
if(trim($_POST['state']) == '') {
$hasError = true;
} else {
$state = trim($_POST['state']);
}
    
    //Check to make sure that the Zip field is not empty
if(trim($_POST['zip']) == '') {
$hasError = true;
} else {
$zip = trim($_POST['zip']);
}
    
    //If Email is filled out, give it a value 
    
    $email  = $_POST['email'];
    
    //If Telephone is filled out, give it a value 
    
    $telephone  = $_POST['telephone'];
    
    //Default Subject Value 
    
    $subject  = "VMC Inquiry";
    
    //Check checkboxes 
    foreach($_POST['check']  as  $value)  {

$check_msg = "Checked: $value\n";

} 

    //If Message is filled out, give it a value 
    
    $comment  = $_POST['comment'];


//If there is no error, send the email
if(!isset($hasError)) {
$emailTo = 'xxxx.xxxx@gmail.com'; //Put your own email address here
$body = "Name: $firstname $lastname \n\nStreet Address: $street01 \n\nStreet Address*: $street02 \n\nCity: $city \n\nState: $state \n\nZip: $zip \n\nEmail*: $email \n\nTelephone*: $telephone \n\nCheck Box: $check_msg \n\nMessage:\n $comment";
$headers = 'From: XXXXX <'.$emailTo.'>' . "\r\n" . 'Reply-To: ' . $email;

mail($emailTo, $subject, $body, $headers);
$emailSent = true;
}
}
?>

So basically I am using classes to say whether or not something is required, which ties into the jQuery validation. If it isn't required, whatever the visitor types into the box is put into something like "$telephone" which is then printed in the e-mail.

The markup for the forms in the body is the following:

Code: [Select]
<p class="contact-text-right">For more information, or to have a list of our properties mailed to you, please fill out the form below.</p>
    <div id="contact-wrapper">
            <?php if(isset($hasError)) { //If errors are found ?>
        <p class="error">Please check if you've filled all the fields with valid information. Thank you.</p>
            <?php } ?>
            <?php if(isset($emailSent) && $emailSent == true) { //If email is sent ?>
            <p class="accept"><strong><?php echo $firstname;?>,Your Email Successfully Sent!</strong></p> <?php } ?>
    <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>" id="contactform">
        <div id="names">
            <label for="firstname"><strong>First Name:</strong></label>
            <input type="text" name="firstname" id="firstname" value="" class="required" />
            <label for="lastname"><strong>Last Name:</strong></label>
            <input type="text" name="lastname" id="lastname" value="" class="required" />
        </div>
        <div id="address01">
            <label for="street01"><strong>Street Address:</strong></label>
            <input type="text" name="street01" id="street01" value="" class="required" />
        </div>
        <div id="address02">
            <label for="street02"><strong>Street Address*:</strong></label>
            <input type="text" name="street02" id="street02" value="" />
        </div>
        <div id="city">
            <label for="city"><strong>City:</strong></label>
            <input type="text" name="city" id="city" value="" class="required city" />
            <label for="state"><strong>State:</strong></label>
            <input type="text" name="state" id="state" value="" class="required state" />
            <label for="zip"><strong>Zip Code:</strong></label>
            <input type="text" name="zip" id="zip" value="" class="required zip" />
        </div>
        <div id="email">
            <label for="email"><strong>E-mail*:</strong></label>
            <input type="text" name="email" id="email" value="" class="email"/>
            <label for="telephone"><strong>Telephone*:</strong></label>
            <input type="text" name="telephone" id="telephone" value="" class="telephone" />
            <p class="bottom">*Optional fields.</p>
        </div>
        <div class="checkbox">
            <p><input  type="checkbox"  name="check[]"  value="properties">XXX</p> 
            <p><input  type="checkbox"  name="check[]"  value="contact-regarding">XXXX</p>
            <p class="indent">(Please list properties or ask specific questions in the space below.)</p>       
        </div>
        <div id="comment">
            <label for="comment"></label>
            <textarea name="comment" id="comment" ></textarea>
        </div>
        <div id="button">
        <input type="submit" value="Send Message" name="submit" />
        </div>
    </form>

All seems well until I hit submit on the live site. I think get this error returned to me:

Warning: Invalid argument supplied for foreach() in ......./html/development/contact.php on line 64

The e-mail goes through, with all the information, no problems! I just can't get this error message to go away.
Line 64 of contact.php is where the checkbox coding is:


    //Check checkboxes 
    foreach($_POST['check']  as  $value)  {

$check_msg = "Checked: $value\n";

} 


I know I've submitted a lot of code here, and tried to narrow you down to the exact spot I think the problem is, but hopefully some of you PHP gurus can pick out the flaw in a heartbeat.

I really appreciate all the help.

B

Hello there,

I have some code here which sends a number of variables from flash to SQL...

I would simply like to add the functionality to overwrite records which have the same 'name' or 'pseudo'... can anyone help me please ? Thanks in advance Martin


<?php

$pseudo=$_POST['var1'];
$score=$_POST['var2'];
$table = $_POST['tab'];

$dategame = $_POST['tempjoueur'];
//$micro = microtime();
//$dategame = time()."".substr($micro, 2, 6);

$_COOKIE['User'] = $_SERVER['REMOTE_ADDR'];
$envoie = InsertDatas($table, "name, score, dategame", "'".$pseudo."','".$score."','".$dategame."'");
if ($envoie) {
print_r("OK, $pseudo, $score, $dategame,$ipclient");
}
else { echo "BAD, $pseudo, $score, $dategame,$ipclient"; }
?>

hi all, i have written a seating plan page for my website which allows users to click on a seat and that seat is then allocated to there username, however theres nothing stopping a user changing the URL to a seat thats been taken and "taking" that seat from someone else.

heres my code for my reserve_seat.php

<?PHP
session_start();
/* get user id */
$user_id = $_SESSION['username'];

/* get the seat number */
$seat_id = $_GET['seat'];

/* connect to data base */
require ('./secure/connect.php');


/* create query */
$query = "UPDATE seats_table set taken = FALSE, user_id = '0' WHERE user_id = '$user_id'";
$query2 = "UPDATE seats_table set taken = TRUE, user_id = '$user_id'  WHERE id = '$seat_id'";
/* $query3 = "UPDATE users set signed_up = '3' WHERE username = '$user_id'"; */


/* execute the query */
$result = mysql_query($query);
$result2 = mysql_query($query2);
/* $result3 = mysql_query($query3); */


/* advise user their seat has been reserved */
include 'seating.php';

?>

so if a user reserves seat 28 the url is http://localhost/reserve_seat.php?seat=26, but theres nothing stopping another user typing this url and "stealing" this seat

i need some kind of IF statement before the sql queries that checks to see if the seats "taken" column is 1 or 0 bearing in mind there is 49 seats but im lost at how to write it. any help would be great

Lee