PHP - Can You Help Me Find My Mistake?

Hi Guys
           I hope its ok to post here with some problems im having. This is my 1st time with trying to use php, and my 1st time attempting to create a website. Im using some extensions from Webassist, and although they can cut down the time it takes to code php. There also not as stated on there website, and you need too pretty much understand Php too get them working. And i have been banging my head against walls for 6mth in there forum, which only ever seem too send you too w3schools website. In my mind thats not support more being Fobbed Off!
  I came across this forum and seen there are people out there too help, and everyone here seems to enjoy helping unlike webassist. I have a few problems, my 1st is on the index page. When i run it i get this 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 ') WHERE id = -1 AND ((type = 'Dog')) AND ((country = 'England')) LIMIT 0, 10' at line 1

i will add the index page for anyone too look at, thanks in advance of any help with this.

I was just about to post a problem which I have been working on for 2 days... and the spell check in the text box pointed out that my variable missing a freaking T...... I dont know about you guys but I will defo run my code through a spell checker now....

I hope you are all having a nice day =)

My DB is holding time as "11:00 AM" "10:00 AM" ect...

Is there a way to convert these to time() after I have queried the DB for results?


<?php

connect();
$query = "SELECT * FROM party WHERE year(DOP) = '2011' order by PTIMES asc";
$qt=mysql_query($query);
echo mysql_error();
while($nt=mysql_fetch_array($qt)){

echo "
<tr height='30'> 
<td id='label'>".$nt['NOC']."</td>
<td id='labeloff'>".$nt['CFN']." ".$nt['CLN']."</td>
<td id='labeloff'>".$nt['type']."</td>
<td id='label'>".birthday($nt['DOB'])."</td>
<td id='label'>$DOP</td>
<td id='labeloff'>".$nt['PTIME']."</td>
<td id='labeloff'>".$nt['act1']."</td>
<td id='labeloff'>".$nt['act2']."</td>
<td id='label'>".$nt['pizza']."</td>
<td id='label'>".$nt['fc']."</td>
</tr>
";
}free($qt);

?>


Thank you.

ignore

I wish to use the code from the following page that can be used to check if an uploaded image is an animated GIF:
http://stackoverflow.com/questions/280658/can-i-detect-animated-gifs-using-php-and-gd

Here is the function:
function is_ani($filename) {
    if(!($fh = @fopen($filename, 'rb')))
        return false;
    $count = 0;
    //an animated gif contains multiple "frames", with each frame having a
    //header made up of:
    // * a static 4-byte sequence (\x00\x21\xF9\x04)
    // * 4 variable bytes
    // * a static 2-byte sequence (\x00\x2C)

    // We read through the file til we reach the end of the file, or we've found
    // at least 2 frame headers
    while(!feof($fh) && $count < 2)
        $chunk = fread($fh, 1024 * 100); //read 100kb at a time
        $count += preg_match_all('#\x00\x21\xF9\x04.{4}\x00\x2C#s', $chunk, $matches);

    fclose($fh);
    return $count > 1;
}


Am I right in saying that there are curly brackets missing after the while line? The indenting indicates that both of the 2 following lines should be included in the while loop, but the lack of curly brackets mean that only the line beginning with $chunk is included in the loop.

The code actually seems to work with and without the curly brackets. Does anyone understand this code well enough to know whether or not the curly brackets should be included?

Thanks in advance.

I am doing something stupid, and just can't see it and hoping someone has better eyes than mine.  I have two Doctrine entities which extend another class using single class inheritance, but when retrieving the collection of either of the two child classes, I get the collection of the parent (i.e. combination of both child classes).  I've experimented with making the parent abstract and not including it in the discriminator map but no change.  In hopes to identifying my mistake, I created a new Symfony project with just the relevant classes and show all steps below.

Initial install by running the following:

symfony new test
composer update
composer require doctrine/orm
composer require migrations
composer require maker --dev
composer require security

Using "php bin/console make:user", I created three users: AbstractUser, OwnerUser, VendorUser.  I then edited all three entities and the owner and vendor repositories as follows:

<?php

namespace App\Entity;

use App\Repository\AbstractUserRepository;
use Doctrine\ORM\Mapping as ORM;
use Symfony\Component\Security\Core\User\UserInterface;

/**
 * @ORM\Entity(repositoryClass=AbstractUserRepository::class)
 * @ORM\InheritanceType("SINGLE_TABLE")
 * @ORM\DiscriminatorColumn(name="discr", type="string")
 * @ORM\DiscriminatorMap({"owner" = "OwnerUser", "vendor" = "VendorUser", "abstract" = "AbstractUser"})
 */
class AbstractUser implements UserInterface
{
    // No changes made
}

 

<?php

namespace App\Entity;

use App\Repository\OwnerUserRepository;
use Doctrine\ORM\Mapping as ORM;

/**
 * @ORM\Entity(repositoryClass=OwnerUserRepository::class)
 */
class OwnerUser extends AbstractUser
{
}

 

<?php

namespace App\Entity;

use App\Repository\VendorUserRepository;
use Doctrine\ORM\Mapping as ORM;

/**
 * @ORM\Entity(repositoryClass=VendorUserRepository::class)
 */
class VendorUser extends AbstractUser
{
}

No change to AbstractUserRepository.

<?php

namespace App\Repository;

class OwnerUserRepository extends AbstractUserRepository
{
}

 

<?php

namespace App\Repository;

class VendorUserRepository extends AbstractUserRepository
{
}

Then I migrated the DB.

php bin/console doctrine:schema:drop --full-database --force
rm migrations/*
php bin/console make:migration
php bin/console doctrine:migrations:migrate

Next I created two OwnerUsers and one VendorUser using a command script I wrote shown at the end of this post.

# php bin/console app:tester create OwnerUser roles=[]
# php bin/console app:tester create OwnerUser roles=[]
# php bin/console app:tester create VendorUser roles=[]

Checked the PostSQL database.

facdocs=> \d
                     List of relations
 Schema |            Name             |   Type   |  Owner
--------+-----------------------------+----------+---------
 public | abstract_user               | table    | facdocs
 public | abstract_user_id_seq        | sequence | facdocs
 public | doctrine_migration_versions | table    | facdocs
(3 rows)

facdocs=> select * from abstract_user;
 id |    email    | roles |    password    | discr
----+-------------+-------+----------------+--------
  1 | setEmail158 | []    | setPassword146 | owner
  2 | setEmail87  | []    | setPassword101 | owner
  3 | setEmail62  | []    | setPassword20  | vendor
(3 rows)

facdocs=>

Next, I retrieved the entities using Doctrine along with the beforementioned test script.
 

[michael@devserver test]$ php bin/console app:tester read VendorUser
Test Entity Manager
============

command: read
entity: VendorUser
class: \App\Entity\VendorUser
properties: []
array(3) {
  [0]=>
  object(stdClass)#293 (5) {
    ["__CLASS__"]=>
    string(20) "App\Entity\OwnerUser"
    ["id:App\Entity\AbstractUser:private"]=>
    int(1)
    ["email:App\Entity\AbstractUser:private"]=>
    string(11) "setEmail158"
    ["roles:App\Entity\AbstractUser:private"]=>
    string(8) "Array(0)"
    ["password:App\Entity\AbstractUser:private"]=>
    string(14) "setPassword146"
  }
  [1]=>
  object(stdClass)#294 (5) {
    ["__CLASS__"]=>
    string(20) "App\Entity\OwnerUser"
    ["id:App\Entity\AbstractUser:private"]=>
    int(2)
    ["email:App\Entity\AbstractUser:private"]=>
    string(10) "setEmail87"
    ["roles:App\Entity\AbstractUser:private"]=>
    string(8) "Array(0)"
    ["password:App\Entity\AbstractUser:private"]=>
    string(14) "setPassword101"
  }
  [2]=>
  object(stdClass)#358 (5) {
    ["__CLASS__"]=>
    string(21) "App\Entity\VendorUser"
    ["id:App\Entity\AbstractUser:private"]=>
    int(3)
    ["email:App\Entity\AbstractUser:private"]=>
    string(10) "setEmail62"
    ["roles:App\Entity\AbstractUser:private"]=>
    string(8) "Array(0)"
    ["password:App\Entity\AbstractUser:private"]=>
    string(13) "setPassword20"
  }
}
[michael@devserver test]$
[michael@devserver test]$ php bin/console app:tester read OwnerUser
Test Entity Manager
============

command: read
entity: OwnerUser
class: \App\Entity\OwnerUser
properties: []
array(3) {
  [0]=>
  object(stdClass)#293 (5) {
    ["__CLASS__"]=>
    string(20) "App\Entity\OwnerUser"
    ["id:App\Entity\AbstractUser:private"]=>
    int(1)
    ["email:App\Entity\AbstractUser:private"]=>
    string(11) "setEmail158"
    ["roles:App\Entity\AbstractUser:private"]=>
    string(8) "Array(0)"
    ["password:App\Entity\AbstractUser:private"]=>
    string(14) "setPassword146"
  }
  [1]=>
  object(stdClass)#294 (5) {
    ["__CLASS__"]=>
    string(20) "App\Entity\OwnerUser"
    ["id:App\Entity\AbstractUser:private"]=>
    int(2)
    ["email:App\Entity\AbstractUser:private"]=>
    string(10) "setEmail87"
    ["roles:App\Entity\AbstractUser:private"]=>
    string(8) "Array(0)"
    ["password:App\Entity\AbstractUser:private"]=>
    string(14) "setPassword101"
  }
  [2]=>
  object(stdClass)#358 (5) {
    ["__CLASS__"]=>
    string(21) "App\Entity\VendorUser"
    ["id:App\Entity\AbstractUser:private"]=>
    int(3)
    ["email:App\Entity\AbstractUser:private"]=>
    string(10) "setEmail62"
    ["roles:App\Entity\AbstractUser:private"]=>
    string(8) "Array(0)"
    ["password:App\Entity\AbstractUser:private"]=>
    string(13) "setPassword20"
  }
}
[michael@devserver test]$

 

As seen, when requesting a collection of either OwnerUsers or VendorUsers, I am retrieving the combination of both collections.  I am sure it is totally user (i.e. me) error, but just don't see it.  Are you able to see my stupid mistake?  Thanks

My test script is below:
 

<?php

namespace App\Command;

use Symfony\Component\Console\Command\Command;
use Symfony\Component\Console\Input\InputInterface;
use Symfony\Component\Console\Output\OutputInterface;
use Symfony\Component\Console\Input\InputArgument;
use Doctrine\ORM\EntityManagerInterface;
use Doctrine\Common\Util\Debug;

class Tester extends Command
{
    // the name of the command (the part after "bin/console")
    protected static $defaultName = 'app:tester';
    private $entityManager;
    public function __construct(EntityManagerInterface $entityManager)
    {
        $this->entityManager = $entityManager;
        parent::__construct();
    }

    protected function configure()
    {
        $this
        ->setDescription('Doctrine Object Tester.  --help')
        ->setHelp('This command allows you to query a single entity...')
        ->addArgument('cmd', InputArgument::REQUIRED, 'The command name [create, read].')
        ->addArgument('entity', InputArgument::REQUIRED, 'The name of the entity.')
        ->addArgument('properties', InputArgument::IS_ARRAY | InputArgument::OPTIONAL, 'properies (foo=foo bla=[]')
        ;
    }

    private function getProperties($input)
    {
        $properties=[];
        foreach($input as $property) {
            $property=explode('=', $property);
            $name = trim($property[0]);
            $value = trim($property[1]);
            if($value === '[]') {
                $value = [];
            }
            elseif($value === 'null') {
                $value = null;
            }
            elseif(substr($value, 0, 1) === '/') {
                $value = explode('/', substr($value, 1));
                $class = ucfirst(substr($value[0], 0, -1));
                $class = '\App\Entity\\'.$class;
                if(count($value)===1) {
                    $value = $this->entityManager->getRepository($class)->findAll();
                }
                else {
                    $value = $this->entityManager->getRepository($class)->find($value[1]);
                }
            }
            $properties[$name] = $value;
        }
        return $properties;
    }

    protected function execute(InputInterface $input, OutputInterface $output)
    {
        $output->writeln([
            'Test Entity Manager',
            '============',
            '',
        ]);

        // retrieve the argument value using getArgument()

        $cmd = $input->getArgument('cmd');
        $output->writeln('command: '.$cmd);
        $entity = $input->getArgument('entity');
        $output->writeln('entity: '.$entity);
        $class = '\App\Entity\\'.$entity;
        $output->writeln('class: '.$class);
        $properties = $this->getProperties($input->getArgument('properties'));

        $output->writeln('properties: '.json_encode($properties));

        switch($cmd) {
            case 'create':
                $entity = new $class;
                foreach(get_class_methods($entity) as $method) {
                    if(substr($method, 0, 3)==='set') {
                        $m = lcfirst(substr($method, 3));
                        $entity->$method(array_key_exists($m, $properties)?$properties[$m]:$method.rand(0,200));
                    }
                }
                $this->entityManager->persist($entity);
                $this->entityManager->flush();
                $output->writeln('entity created');
                break;
            case 'read':
                Debug::dump($this->entityManager->getRepository($class)->findAll());
                break;
            default:
                $output->writeln('INVALID COMMAND: '.$cmd.'.  Only create and read are supported.'); 
        }
        return Command::SUCCESS;
    }
}

 

 

Still forgetting it.

Code: [Select]
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

$data = array();

class Main extends CI_Controller {

public function __construct() {
parent::__construct();

$this->load->helper('form');
$this->load->helper('html');
$this->load->helper('url');    
$this->load->library('ion_auth');
$this->load->library('session');
$this->load->library('form_validation');
$this->load->database();

//$this->load->model('prod_m');
}


function login()
{
$this->$data['header'] = $this->load->view('header', null, TRUE); 

$this->load->view('front_page', $this->data);
}

}
/* End of file main.php */
/* Location: ./application/controllers/main.php */


All I just is to make the $data array variable as public and works across all function inside the class.
Where did I made wrong?

Thanks in advance.

Hi Guys

I'm trying to get clients to:
1. upload an image
2. fill out details
3. submit image and details to me via email

1. Uploading the image is fine, they choose it and it displays on the next page
2. They fill in form details
3. then click submit to send to me - I get all details except the image

How do I keep the image variable around to insert it into the details form and email it?

The image appears to be displayed on the second page, then the variable disappears (is deleted) and isn't available in step 3 to submit as part of the email.

I'm sure it's a simple fix - I'm pretty new with php and I've started kicking things so I thought it was time to ask for help.

Upload-image-code

<?php if($_FILES)
{ 
$img = $_FILES['filename']['img'];

switch($_FILES['filename']['type'])
{
case 'image/jpeg' : $ext = 'jpg'; break;
case 'image/png' : $ext = 'png'; break;
default: $ext = ''; break;
}
if ($ext)
{
$n = "image.$ext";
move_uploaded_file($_FILES['filename']['tmp_name'], $n);
echo "<span class='uploaded-photo'>uploaded image '$img'  as '$n':</span> <br />";
echo "<img src='$n' />";
}
else echo "'$img' is not a supported image file";
}
//else echo "<span class='uploaded-photo'>No image has been uploaded</span>";

 ?>

$n is available to be displayed on page 2 and it works
Page 2 contains the rest of the form, but when I submit the form $n isn't available to be sent with the other data
(i have tried REQUEST $img as well.
Submit form code

<?php
$name = $_REQUEST['name'] ;
$email = $_REQUEST['email'] ;
$phone = $_REQUEST['phone'] ;
$address = $_REQUEST['address'] ;
$pname = $_REQUEST['pname'] ;
$pdescription = $_REQUEST['pdescription'];
$plow = $_REQUEST['plow'] ;
$phigh = $_REQUEST['phigh'] ;
$purl = $_REQUEST['purl'] ;
$ponline = $_REQUEST['ponline'] ;
$n = $_REQUEST['n'];
$img = $_REQUEST['img'];


if (!isset($_REQUEST['email'])) {
    echo "we need your name and email address please" ;
  }

elseif (empty($name)){
echo "please enter your name";
}
elseif (empty($email)){
echo "please enter your email address";
}
elseif (!eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,6})", "$email")) {
echo"please check your email address - it doesn't appear to be a valid format";
}
else {
    mail( "eamail@address.com", "Subject",
     "$name\n $email\n $phone\n $address\n $pname\n $pdescription\n $plow\n $phigh\n $purl\n $ponline\n $n\n $img", "$email");
   
    header( "Location: ../index.php" );
  }


?>

Would really appreciate any help - if you need full code please let me know.

Thanks


@webecho

The issue I'm having is that this query won't find a max value record if it has less than 5 votes. It'll only show the results of an entry has 5 or greater votes. Why is that?

$contest_id = 5;
$category_id = 8;

$find_entries = $db->prepare("SELECT entry_id, user_id, votes FROM contest_entries 
WHERE contest_id = :contest_id AND category_id = :category_id AND e_status = :e_status AND votes = (SELECT MAX(votes) FROM contest_entries) LIMIT 1");
$find_entries->bindParam(':contest_id', $contest_id);
$find_entries->bindParam(':category_id', $category_id);
$find_entries->bindValue(':e_status', 0);
$find_entries->execute();
$result_entries = $find_entries->fetchAll(PDO::FETCH_ASSOC);
if(count($result_entries) > 0) {
  foreach($result_entries as $row) {
    $entry_id  =	$row['entry_id'];
    $user_id   =	$row['user_id'];
    $votes     =	$row['votes'];
  }
  echo $entry_id;
  
} else {
	echo 'nothing';
}

 

Edited June 26, 2019 by imgrooot

Hi

I downloaded a PHP script, copied at localhost and when I run it, it will not display all results
instruction says that Globals should be off in PHP.ini and scripts should work while Globals are off.

but I can't find php.ini in XAMPP. I tried

xampp/apache/bin   but I didn't find php.ini

what should I do?

Hey, What function / how would I find if a string has something? Say I have a string like:

$string = 'Hello their! This is my post :) btw, my name is Justin.';

Say I wanted to find out if my name "Justin" is inside that string..
so:

whateverfunction('Justin', $string)


So I think you should get my idea now though

Thanks a lot!

Hello I am new thought I would ask help here as I was not getting much help on another forum.

I have this code

Code: [Select]
<?php 
header("content-type: text/xml"); 
    $rssfeed = '<?xml version="1.0" encoding="UTF-8"?>';
    $rssfeed .= '<rss version="2.0">';
    $rssfeed .= '<channel>';
    $rssfeed .= '<title>My Price Savings Coupons.com Feed</title>';
    $rssfeed .= '<link>http://www.mypricesavings.com</link>';
    $rssfeed .= '<description>This is coupons.com feed</description>';
    $rssfeed .= '<language>en-us</language>';
    $rssfeed .= '<copyright>Copyright (C) 2011 mypricesavings.com</copyright>';
function compareFeeds($a, $b){ //this function will compare the "val" array element of each $itemRSS 
        if ($a["val"] == $b["val"]) {
        return 0;
    }
    return ($a["val"] < $b["val"]) ? -1 : 1;     
}

        $doc = new DOMDocument();
        $doc->load('http://rss.coupons.com/xmlserve.asp?go=14520kk5210');
        $arrFeeds = array();
        foreach ($doc->getElementsByTagName('item') as $node) {
                $itemRSS = array (
                        'val' => $node->getElementsByTagName('value')->item(0)->nodeValue,
                        'image' => $node->getElementsByTagName('image')->item(0)->nodeValue,
                        'link' => $node->getElementsByTagName('link')->item(0)->nodeValue,
                        'desc' => $node->getElementsByTagName('description')->item(0)->nodeValue,
                        'exp' => $node->getElementsByTagName('activedate')->item(0)->nodeValue
                        );
                array_push($arrFeeds, $itemRSS);
                }
                usort($arrFeeds, 'compareFeeds');
                 
foreach($arrFeeds as $itemRSS){
       
       $descrip = '<![CDATA[ <p><a href="'.$itemRSS["link"].'"><img src="'. $itemRSS["image"].'" align="left" border="0" height="80" width="80" alt="'.$itemRSS["desc"].'"/></a></p>]]>';
       $descrip .= '' .$itemRSS["desc"];

        $rssfeed .= '<item>';
        $rssfeed .= '<title>' . $itemRSS["desc"] . '</title>';
        $rssfeed .= '<link>' . $itemRSS["link"] . '</link>';
        $rssfeed .= '<pubDate>' . $itemRSS["exp"] . '</pubDate>';
        $rssfeed .= '<description>'. $descrip . '</description>';
        $rssfeed .= '</item>';
    }
 
    $rssfeed .= '</channel>';
    $rssfeed .= '</rss>';

echo $rssfeed;
?>


The purpose of this code is to take http://rss.coupons.com/xmlserve.asp?go=14520kk5210 and turn it into a true RSS Feed.

I currently have the php above at mypricesavings.com/coupons/couponsfeed.php I receive the error in google chrome on mac, however, in safari it does work, If I were to use RSS Graffiti on facebook it also errors

Thank you for any help,

Also, If there is a better more efficient way to accomplish what I am trying to do, please share with me so I may learn better

Derrick

Hi There,

I have ported my website over to another hosting provider and I cannot get this one thing working!  We have images on our site, which this PHP Script should resize, but it can't find the Imagick.php script.

I am convinced that it resides in a different path. Here is the error i get when trying to access one of the images :

Warning: require_once(include/classes/Imagick.php) [function.require-once]: failed to open stream: No such file or directory in /hermes/bosweb/web128/b1282/ipg.accommodateruralcom/include/global.php on line 29

Fatal error: require_once() [function.require]: Failed opening required 'include/classes/Imagick.php' (include_path='.:/usr/local/lib/php-5.2.17/lib/php:/home/users/web/b1282/ipg.accommodateruralcom') in /hermes/bosweb/web128/b1282/ipg.accommodateruralcom/include/global.php on line 29

I contacted my hosting support about that and they said that the Imagick.php resides in the following directory :

/usr/local/lib/ImageMagick

I can appreciate that there may be references to this everywhere and anywhere.  I have PHP files called imageResize, Global etc...just let me know which ones to post and ill do that.

I really appreciate the help.


[attachment deleted by admin]

Hi,

This piece of code below stops site loading, can't find the problem 
Please help. If i remove the whole of this the site loads but does not function correct.

Code: [Select]
if ( $_GET[sssess] )
{
    session_id( $_GET[sssess] );
}
session_start( );
header( "cache-control: private" );
if ( isset( $_GET[redeempoints] ) && $_GET[redeempoints] == "Y" )
{
    $_SESSION[redeemer] = "Y";
}
if ( $_POST[purchaseorder] )
{
    $_SESSION[po] = "{$_POST['purchaseorder']}";
}
if ( !$_SESSION[loginemail] )
{
    $_SESSION[loginemail] = "noemail@site";
}
if ( !$_SESSION[adminemail] )
{
    $_SESSION[adminemail] = "noadmin@site";
}
if ( $_POST[discode] )
{
    $_SESSION[discode] = trim( "{$_POST['discode']}" );
}
$auth_ok_check = md5( "{$_SESSION['loginemail']}.{$hash}" );
$admin_ok_check = md5( "{$_SESSION['adminemail']}.{$hash}" );
if ( isset( $_GET['oidref'] ) )
{
    $GLOBALS['_GET']['oidref'] = mysql_real_escape_string( $_GET['oidref'] );
    $sql = "SELECT o_id FROM order_list WHERE ref='".$_GET['oidref']."' AND unh='{$_GET['oidref']}'";
    if ( !( $result = @mysql_query( $sql, $connection ) ) )
    {
        exit( "**COULD NOT GET COPYRIGHT KEYS**" );
    }
    if ( $row = mysql_fetch_array( $result ) )
    {
        $_SESSION['unh'] = $_GET['oidref'];
        header( "location: ".$sshopurl."orderdetails_os.php?o_id={$row['o_id']}" );
        exit( );
    }
    if ( $_SESSION['auth_ok'] == $auth_ok_check )
    {
        header( "location: ".$sshopurl."secure/orders.php" );
        exit( );
    }
    header( "location: ".$sshopurl."secure/login.php?next=orders.php" );
    exit( );
}
if ( preg_match( "/secure/", "{$_SERVER['PHP_SELF']}" ) && !preg_match( "/doqreg.php/", "{$_SERVER['PHP_SELF']}" ) || !preg_match( "/qreg.php/", "{$_SERVER['PHP_SELF']}" ) || !preg_match( "/voicepaycallback.php/", "{$_SERVER['PHP_SELF']}" ) || !preg_match( "/secpaysecpagecallback.php/", "{$_SERVER['PHP_SELF']}" ) || !preg_match( "/vps_handle_protx_response.php/", "{$_SERVER['PHP_SELF']}" ) || !preg_match( "/protx/", "{$_SERVER['PHP_SELF']}" ) || !preg_match( "/protxformcallback.php/", "{$_SERVER['PHP_SELF']}" ) || !preg_match( "/protxcallback.php/", "{$_SERVER['PHP_SELF']}" ) || !preg_match( "/worldpaycallback.php/", "{$_SERVER['PHP_SELF']}" ) || !preg_match( "/securetradingcallback.php/", "{$_SERVER['PHP_SELF']}" ) || !preg_match( "/barclayscpicallback.php/", "{$_SERVER['PHP_SELF']}" ) || !preg_match( "/paypalcallback.php/", "{$_SERVER['PHP_SELF']}" ) || !preg_match( "/moneybookerscallback.php/", "{$_SERVER['PHP_SELF']}" ) || !preg_match( "/nochexcallback.php/", "{$_SERVER['PHP_SELF']}" ) || !preg_match( "/offlinecallback.php/", "{$_SERVER['PHP_SELF']}" ) || !preg_match( "/doregister.php/", "{$_SERVER['PHP_SELF']}" ) || !preg_match( "/register.php/", "{$_SERVER['PHP_SELF']}" ) || !preg_match( "/doprereg.php/", "{$_SERVER['PHP_SELF']}" ) || !preg_match( "/login.php/", "{$_SERVER['PHP_SELF']}" ) || !preg_match( "/dologin.php/", "{$_SERVER['PHP_SELF']}" ) )
{
    if ( $auth_ok_check != $_SESSION[auth_ok] )
    {
        header( "Location: ".$sshopurl."secure/login.php?next={$_GET['next']}&shk&p={$_SERVER['PHP_SELF']}" );
        exit( );
    }
    if ( preg_match( "/secure/", "{$_SERVER['PHP_SELF']}" ) )
    {
        $isaccount = "1";
    }
}
if ( preg_match( "/".$adminDir."/", "{$_SERVER['PHP_SELF']}" ) && !preg_match( "/adlogin.php/", "{$_SERVER['PHP_SELF']}" ) || !preg_match( "/forgetful.php/", "{$_SERVER['PHP_SELF']}" ) )
{
    if ( $admin_ok_check != $_SESSION[admin_ok] )
    {
        header( "Location: ".$adminurl."adlogin.php" );
        exit( );
    }
    if ( preg_match( "/".$adminDir."/", "{$_SERVER['PHP_SELF']}" ) )
    {
        $isadmin = "1";
    }
}
$noadirs = count( $admin_dirs );
$i = 0;
for ( ; $i <= $noadirs; ++$i )
{
    if ( !preg_match( "/admin\\/".$admin_dirs[$i]."/", "{$_SERVER['PHP_SELF']}" ) && preg_match( "/".$admin_dirs[$i]."/", "{$_SESSION['admin_type']}" ) )
    {
        continue;
    }
    header( "Location: ".$adminurl."perms.php?noperm={$admin_dirs[$i]}" );
    exit( );
}
if ( !$_SESSION[shopper_type] )
{
    $_SESSION[shopper_type] = "1";
}
if ( $_GET[setcurrency] == 1 )
{
    if ( $_GET[new_currency_id] )
    {
        $GLOBALS['_POST'][new_currency_id] = $_GET[new_currency_id];
    }
    $_SESSION['currency_id'] = $_POST[new_currency_id];
}
if ( $_GET[clearptid] == Y )
{
    session_unregister( "ptid" );
}
if ( $_GET[selectpostage] == 1 )
{
    if ( $_POST[selptid] == Free || $_POST[selptid] == free )
    {
        session_unregister( "ptid" );
    }
    else if ( isset( $_POST[selptid] ) )
    {
        $_SESSION['ptid'] = $_POST[selptid];
    }
    else
    {
        session_unregister( "ptid" );
    }
    $GLOBALS['_POST'][selptid] = mysql_real_escape_string( $_POST[selptid] );
    $sql1 = "UPDATE basket SET ptid='".$_POST['selptid']."' WHERE session_id='".session_id( )."'";
    if ( !( $result1 = @mysql_query( $sql1, $connection ) ) )
    {
        exit( "Couldn't execute request 1" );
    }
}

this code works fine it I take out the checkboxes(repair & replace) in the html & PHP ?
Code: [Select]
<form name="form" action="<?php $_SERVER[PHP_SELF] ?>" method="post">
<input type="text" size="2" name="apt" id="apt"
onkeyup="getResults();if(this.value.length==this.size)document.form.datereceived.focus();" />Apt<br />
<input type="text" size="25" name="name" id="name" />Name<br />
<INPUT TYPE="text" size=10 name="datereceived"
onKeyUp="if(this.value.length==this.size)document.form.time.focus();">Date Received<br />
<INPUT TYPE="text" size=7 name="time">Time Received<br />

<br>Kitchen
<select name="item">
<option value="kitchen blinds" selected>kitchen blinds</option>
<option value="kitchen bifolds">kitchen bifolds</option>
<option value="kitchen lights">kitchen light fixtures</option>
<option value="kitchen bulbs">kitchen light bulbs</option>
<option value="kitchen tile">kitchen tile/linoleum</option>
<option value="kitchen countop">kitchen counter top</option>
<option value="kitchen cabinets">kitchen cabinets</option>
<option value="kitchen drawers">kitchen drawers</option>
<option value="fridge">refidgerator</option>
<option value="stove">stove</option>
<option value="range hood">stove hood</option>
<option value="kitchen sink">kitchen sink</option>
<option value="under kitchensink">under kitchen sink</option>
<option value="kitchen faucet">kitchen faucet</option>
<option value="kitchen drain">kitchen drain</option>
<option value="kitchen screens">kitchen windows & screens</option>
<option value="fire extinguisher">fire extinguisher</option>
<option value="kitchen wall plates">kitchen switch plates</option>
<option value="kitchen outlets">kitchen electrical outlets</option>
<option value="kitchen ceilings">kitchen ceiling paint</option>
<option value="kitchen wallpaint">kitchen wall paint</option>
</select>
<br> repaired <input type=checkbox name="repair" value="Y">
 replaced <input type=checkbox name="replace" value="Y"><br>
</p>
action<INPUT TYPE="text" size=100 name="action"><br />
<INPUT TYPE="text" size=2 name="compday" MAXLENGTH=2
onKeyUp="if(this.value.length==this.size)document.form.compmoyr.focus();">
<INPUT TYPE="text" size=7 name="compmoyr" MAXLENGTH=7
Date Completed - <font color=red>day then mm/yyyy</font <br /><br />
 cost<INPUT TYPE="text" size=4 name="cost">
 charge<INPUT TYPE="text" size=4 name="charge">
Order#<INPUT TYPE="text" size=4 name="ordno"> -  If Insp
<p>
<INPUT type="submit" value="submit data" />
</p>
</form><?php
if (isset( $_POST['apt']) ) {
$apt=$_POST['apt'];  
$name=$_POST['name'];  
$datereceived=$_POST['datereceived'];  
$time=$_POST['time'];  
$item=$_POST['item'];
$repair=$_POST['repair'];  
$replace=$_POST['replace'];
$action=$_POST['action'];  
$compday=$_POST['compday'];  
$compmoyr=$_POST['compmoyr'];  
$cost=$_POST['cost'];  
$charge=$_POST['charge'];  
$ordno=$_POST['ordno'];
$stat = mysql_connect("localhost","root","") or die('Unable to connect to database: ' . mysql_error());  
$stat = mysql_select_db("maintdb") or die('Unable to select database: ' . mysql_error());  
$query = "
INSERT INTO maintdata (apt,name,datereceived,time,item,repair,replace,action,compday,compmoyr,cost,charge,ordno)
VALUES('$apt','$name','$datereceived','$time','$item','$repair','$replace','$action','$compday','$compmoyr','$cost','$charge','$ordno')";
echo "apt $apt data inserted</font><br /><br />"; 
$stat = mysql_query($query) or die('Query failed: ' . mysql_error());  
mysql_close();
}
?>