PHP - Php W/xml N00b. Fatal Error Loading Xml

Hello all,   Appreciate if you folks could pls. help me understand (and more importantly resolve) this very weird error:     Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 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 'ASC, purchase_later_flag ASC, shopper1_buy_flag AS' at line 3' in /var/www/index.php:67 Stack trace: #0 /var/www/index.php(67): PDO->query('SELECT shoplist...') #1 {main} thrown in /var/www/index.php on line 67   Everything seems to work fine when/if I use the following SQL query (which can also be seen commented out in my code towards the end of this post) :  

$sql = "SELECT shoplist.*, store_master.store_name, item_master.item_name
           FROM shoplist, store_master, item_master
           WHERE     shoplist.store_id = store_master.store_id
                   AND shoplist.item_id = item_master.item_id";

  However, the moment I change my query to the following, which essentially just includes/adds the ORDER BY clause, I receive the error quoted above:

$sql = "SELECT shoplist.*, store_master.store_name, item_master.item_name 
		FROM shoplist, store_master, item_master 
		ORDER BY purchased_flag ASC, 
				purchase_later_flag ASC, 
				shopper1_buy_flag ASC, 
				shopper2_buy_flag ASC, 
				store_name ASC) 
		WHERE 	shoplist.store_id = store_master.store_id 
				AND shoplist.item_id = item_master.item_id";

In googling for this error I came across posts that suggested using "ORDER BY FIND_IN_SET()" and "ORDER BY FIELD()"...both of which I tried with no success.   Here's the portion of my code which seems to have a problem, and line # 67 is the 3rd from bottom (third last) statement in the code below:  

                    <?php
                        /*
                        $sql = "SELECT shoplist.*, store_master.store_name, item_master.item_name
                                FROM shoplist, store_master, item_master
                                WHERE     shoplist.store_id = store_master.store_id
                                        AND shoplist.item_id = item_master.item_id";
                        */
                    
                        $sql = "SELECT shoplist.*, store_master.store_name, item_master.item_name
                                FROM shoplist, store_master, item_master
                                ORDER BY FIND_IN_SET(purchased_flag ASC,
                                                 purchase_later_flag ASC,
                                                 shopper1_buy_flag ASC,
                                                 shopper2_buy_flag ASC,
                                                 store_name ASC)
                                WHERE     shoplist.store_id = store_master.store_id
                                        AND shoplist.item_id = item_master.item_id";
                        $result = $pdo->query($sql);                        
                        
                        // foreach ($pdo->query($sql) as $row) {
                        foreach ($result as $row) {
                            echo '<tr>';
                                print '<td><span class="filler-checkbox"><input type="checkbox" name="IDnumber[]" value="' . $row["idnumber"] . '" /></span></td>';

    Thanks  

Hi Guys,

Real PHP newbie here, and slowly getting to grips with it (I did say slowly, right!). Basically, I've created this register page. It's supposed to ask the user for their username, password, password verificiation, email address and then finally to ask the user to select from a tick list of interests (populated via the DB).

Here's my code:
<?
include('includes/config.php');
$is_error = 0;

if ($_POST['task'] == 'singup_do') {

      $signup_username = $_POST['user_username'];
      $signup_password = $_POST['user_password'];
      $signup_pwd_again = $_POST['user_password_again'];
      $signup_email = $_POST['user_email_address'];
      $signup_interest = $_POST['signup_interest'];
    
    if ($signup_username == ''){
        $is_error = 1;
        $signup_username_msg = 'The username cannot be left blank';
    }

    if ($signup_password == ''){
       $is_error = 1;
        $signup_password_msg = 'Password field cannot be left blank';
    }

    if ($signup_pwd_again == ''){
        $is_error = 1;
        $signup_pwd_again_msg = 'Password again field cannot be left blank';
    }

    if ($signup_email == ''){
        $is_error = 1;
        $signup_email_msg = 'Email cannot be left blank';
    }
    if ($signup_email != '' && !validateEmailAddress($signup_email)) {
        $is_error = 1;
        $signup_email_msg = 'Incorrect E-mail address';
    }
    if (!is_array($signup_interest) || count($signup_interest)==0){
        $is_error = 1;
        $signup_interest_msg = 'Please select atleast one interest';
    }

    //EMAIL ADDRESS VALIDATION
    if ($signup_password!='' && $signup_pwd_again!='' && $signup_password != $signup_pwd_again) {
        $is_error = 1;
        $error_msg = 'Passwords don\'t match';
    }

    //USERNAME DUPLICATION VALIDATION
    if (!$is_error && $signup_username!='' && !checkUsername($signup_username)) {
        $is_error = 1;
        $signup_username_msg = 'Username already taken, please enter another';
    }

    if (!$is_error) {

       $signup_interest_ids = ( is_array($signup_interest) ? implode(',', $signup_interest) : '' );
       $users_insert = "INSERT INTO users SET user_id='', user_username = '{$signup_username}' , user_password='{$signup_password}', user_email_address = '{$signup_email}', users_interests='{$signup_interest_ids}', user_active='Y', user_date_added=NOW()";
       mysql_query($users_insert);
       header('Location:login.php?signup=success');
    }

}
?>
<html>
<head>
<title>Register</title>
<link href="css/style.css" rel="stylesheet" type="text/css" />
</head>
<body >
<div align="center"><BR><BR><BR>
<div style="width:50%; ">
<form name="frmSignup" action="sign_up.php" method="post">
<input type="hidden" name="task" value="singup_do">
<table width="100%" border="0" cellspacing="4" cellpadding="4" align="center">
<? if ($error_msg!='') {?>
<tr><td>&nbsp;</td><td class="tahoma10rednormal"><?=$error_msg?></td></tr>
<? }?>
<tr><td width="20%" valign="top">Username : </td><td><input name="user_username" type="text" class="textfield" size="35" value="<?=$signup_username?>"/><? if ($signup_username_msg!='') { echo '<BR><span class="tahoma10rednormal">' . $signup_username_msg. '</span>' ; } ?></td></tr>
<tr><td valign="top">Password : </td><td><input name="user_password" type="password" class="textfield"  size="35"  value="<?=$signup_password?>"/><? if ($signup_password_msg!='') { echo '<BR><span class="tahoma10rednormal">' . $signup_password_msg. '</span>' ; } ?></td></tr>
<tr><td valign="top">Password (again): </td><td><input name="user_password_again" type="password" class="textfield" size="35" value="<?=$signup_pwd_again?>"/><? if ($signup_pwd_again_msg!='') { echo '<BR><span class="tahoma10rednormal">' . $signup_pwd_again_msg. '</span>' ; } ?></td></tr>
<tr><td valign="top">Email address: </td><td><input name="user_email_address" type="text" class="textfield" size="35" value="<?=$signup_email?>"/><? if ($signup_email_msg!='') { echo '<BR><span class="tahoma10rednormal">' . $signup_email_msg. '</span>' ; } ?></td></tr>
<tr><td colspan="2" ><b>Interests:</b><? if ($signup_interest_msg!='') { echo '&nbsp;&nbsp;<span class="tahoma10rednormal">' . $signup_interest_msg. '</span>' ; } ?></td></tr>
<tr><td colspan="2">
                        <? 
                         $categories = getCategories(); 
                         $categories_count = count($categories);
                         if (is_array($categories)) { $cat_counter=0; ?>
                            <table width="80%" border="0" cellspacing="4" cellpadding="4">
                            <? foreach($categories as $cats) {
                                if ($cat_counter==0 || ($cat_counter%4) == 0) echo '<tr>';

                                $chk_selected = '';
                                if (is_array($signup_interest) && in_array($cats['id'], $signup_interest)) $chk_selected = "CHECKED"; 
                            ?>
                                <td><input type="checkbox" name="signup_interest[]" value="<?=$cats['id']?>" <?=$chk_selected?>><?=$cats['text']?></td>
                             <? if ($cat_counter==$categories_count || ($cat_counter%4) == 3) echo '</tr>';
                                $cat_counter++;
                                }
                            ?>
                            </table>
                         <? 
                          } else {
                            echo 'No interest added yet.';
                         }
                        ?>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="submit" name="submit_btn" value="Sign Up">&nbsp;<input type="button" name="cancel_btn" value="Cancel" onClick="window.location.href='index.php'"></td>
</tr>
</table>
</div>
</div>
</body>
</html>

I'm getting undefined varible errors for:

Notice: Undefined variable: error_msg
Undefined variable: signup_username_msg
Notice: Undefined variable: signup_password_msg
Notice: Undefined variable: signup_pwd_again_msg
Notice: Undefined variable: signup_email_msg
Notice: Undefined variable: signup_interest_msg
Notice: Undefined variable: signup_interest
Notice: Undefined variable: signup_interest

Which as the canny of you will have noticed, is all of them! Hurrah at least I'm consistent!

If anyone could help out a n00b I'd be so so grateful.

Thanks!
Rob

Hello ,

I have a made a PHP website where users signup and send their Date of Birth and gets an OTP on their email after signup.

The OTP is recieved but when we enter the OTP this problem occurs 

Quote

Error! Something went wrong 

and I am facing this error in the error log

Quote

PHP Fatal error: Uncaught Error: Object of class DateTime could not be converted to string 

This is my config.php code

<?php
    session_start();
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Confirmation Page - Kanha Stories</title>

    <style>
        body
        {
            background-color: #330000;
            background-image: url("data:image/svg+xml,%3Csvg xmlns='http://www.w3.org/2000/svg' width='100%25' height='100%25' viewBox='0 0 800 400'%3E%3Cdefs%3E%3CradialGradient id='a' cx='396' cy='281' r='514' gradientUnits='userSpaceOnUse'%3E%3Cstop offset='0' stop-color='%23D18'/%3E%3Cstop offset='1' stop-color='%23330000'/%3E%3C/radialGradient%3E%3ClinearGradient id='b' gradientUnits='userSpaceOnUse' x1='400' y1='148' x2='400' y2='333'%3E%3Cstop offset='0' stop-color='%23FA3' stop-opacity='0'/%3E%3Cstop offset='1' stop-color='%23FA3' stop-opacity='0.5'/%3E%3C/linearGradient%3E%3C/defs%3E%3Crect fill='url(%23a)' width='800' height='400'/%3E%3Cg fill-opacity='0.4'%3E%3Ccircle fill='url(%23b)' cx='267.5' cy='61' r='300'/%3E%3Ccircle fill='url(%23b)' cx='532.5' cy='61' r='300'/%3E%3Ccircle fill='url(%23b)' cx='400' cy='30' r='300'/%3E%3C/g%3E%3C/svg%3E");
            background-attachment: fixed;
            background-size: cover;
            padding: 20px;
            width: 100vw;
            height: 100vh;
            display: flex;
            align-items: center;
            justify-content: center;
            color:#ffffff;
            overflow-x: hidden;
        }
        .cont
        {
            padding: 20px 40px;
            position: relative;
            border-right: 4px solid rgb(184, 182, 182);
            border-bottom: 4px solid rgb(184, 182, 182);
            border-radius: 15px;
            display: flex;
            flex-direction: column;
            align-items: center;
        }
        #left{
            float: left;
        }
        #right{
            float: right;
        }
        input{
            margin: 10px 0px;
        }
        s{
            padding: 5px;
        }
        .error{
            padding: 5px;
            color: #ffffff;
        }
        .resend{
            color: rgb(14, 14, 196);
            padding: 5px;
        }
        .s:hover{
            cursor: pointer;
            background-color:gray;
            color: rgb(243, 237, 237);
            border-radius: 5px;
        }
    </style>

</head>
<body>

    <?php
        $code="";
        $err="";
        $error="";
        if(($_SERVER["REQUEST_METHOD"]=="GET" && $_SESSION['xyz'] === 'xyz') || isset($_POST['verify']) || isset($_POST['resend']))
        {
            unset($_SESSION["xyz"]);
            if($_SERVER["REQUEST_METHOD"] ==="POST")
            {
                if(isset($_POST['verify']))
                {
                    if(empty($_POST['code']))
                    {
                        $err="Enter the code!";
                    }
                    else
                    {
                        $code=$_POST['code'];
                        if(password_verify($code,$_SESSION['code']))
                        {
                            $name=$_SESSION['name'];
                            $email=$_SESSION['email'];
                            $tel=$_SESSION['tel'];
                            $dob=$_SESSION['dob'];
                            $password=$_SESSION['password'];
                            $age_category=$_SESSION['age_category'];
                            
                            require_once('./all_utils/connection.php');
                            $sql="INSERT INTO identity_table(name,email,password,tel,dob,age_category) VALUES ('$name','$email','".$password."','$tel','$dob','$age_category')";
                            if(mysqli_query($conn,$sql) === TRUE) 
                            {
                                unset($_SESSION["name"]);
                                unset($_SESSION["password"]);
                                unset($_SESSION["dob"]);
                                unset($_SESSION["tel"]);
                                unset($_SESSION["age_category"]);
                                
                                header("location:welcome/welcome.php");
                            }
                            else
                            {
                                $err="Error! Something went wrong";
                            }
                        }
                        else
                        {
                            $err="Incorrect code!";
                        }

                    }
                }
                elseif(isset($_POST['resend']))
                {
                    require_once('./all_utils/mail.php');
                    $error="OTP has been sent again!";
                }
            }
        }
        else{
            header("location:signup.php");
        }
    ?>

    <div class="cont">
        <h2> Email Verification</h2>
        <form action="<?php echo htmlspecialchars($_SERVER['PHP_SELF']) ?>" method="POST">
            <label for="verification">Enter the 5 digit code</label>
            <br/>
            <p> Didn't got the mail?  Please check your spam folder </p>
            <input type="text" name="code" placeholder="Eg. 12345" value="<?php echo $code; ?>">
            <br/>
            <div class="error"><?php echo $err; ?></div>
            <div class="resend"><?php echo $error;?></div>
            <input type="submit" name="resend" class="s" id="left" value="Resend OTP">
            <input type="submit" name="verify" class="s" id="right" value="Verify">
        </form>
    </div>
</body>
</html>

 

This is my signup.php code

<?php
    session_start();
    if(!empty($_SESSION['email']))
    {
        require_once('./all_utils/connection.php');
        $query="SELECT * FROM identity_table WHERE email='".$_SESSION['email']."'";
        $result=mysqli_query($conn,$query);
        if(mysqli_fetch_assoc($result))
        {
            header("location:welcome/welcome.php");
        }
    }

?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>SignUp - Kanha Stories</title>
    <style>
        * {
            margin: 0;
            padding: 0;
        }

        body {
            width: 100vw;
            height: 100vh;
            display: flex;
            align-items: center;
            background-color: #ff9d00;
            background-image: url("data:image/svg+xml,%3Csvg xmlns='http://www.w3.org/2000/svg' width='100%25' height='100%25' viewBox='0 0 1600 800'%3E%3Cg stroke='%23000' stroke-width='66.7' stroke-opacity='0' %3E%3Ccircle fill='%23ff9d00' cx='0' cy='0' r='1800'/%3E%3Ccircle fill='%23f27d00' cx='0' cy='0' r='1700'/%3E%3Ccircle fill='%23e55f00' cx='0' cy='0' r='1600'/%3E%3Ccircle fill='%23d84400' cx='0' cy='0' r='1500'/%3E%3Ccircle fill='%23cb2c00' cx='0' cy='0' r='1400'/%3E%3Ccircle fill='%23bf1600' cx='0' cy='0' r='1300'/%3E%3Ccircle fill='%23b20300' cx='0' cy='0' r='1200'/%3E%3Ccircle fill='%23a5000e' cx='0' cy='0' r='1100'/%3E%3Ccircle fill='%2398001c' cx='0' cy='0' r='1000'/%3E%3Ccircle fill='%238b0027' cx='0' cy='0' r='900'/%3E%3Ccircle fill='%237e0030' cx='0' cy='0' r='800'/%3E%3Ccircle fill='%23710037' cx='0' cy='0' r='700'/%3E%3Ccircle fill='%2364003b' cx='0' cy='0' r='600'/%3E%3Ccircle fill='%2358003c' cx='0' cy='0' r='500'/%3E%3Ccircle fill='%234b003a' cx='0' cy='0' r='400'/%3E%3Ccircle fill='%233e0037' cx='0' cy='0' r='300'/%3E%3Ccircle fill='%23310030' cx='0' cy='0' r='200'/%3E%3Ccircle fill='%23210024' cx='0' cy='0' r='100'/%3E%3C/g%3E%3C/svg%3E");
            background-attachment: fixed;
            background-size: cover;
            overflow-x: hidden;
        }

        .cont {
            color: #ffffff;
            width: 500px;
            margin: auto;
        }

        h2 {
            color: #ffffff;
            text-align: center;
            padding: 1.5px;
        }

        .error {
            text-align: center;
            padding: 20px;
            font-size: 1rem;
            color: rgb(233, 76, 76);
        }

        form {
            font-size: 1.2rem;
            /* width: 40%; */
            /* margin: auto; */
        }
        .in{
            margin: 5px 0;
        }

        input {
            border: 2px solid white;
            padding: 10px;
            margin: 5px 0;
            font-size: 1rem;
            width: 100%;
        }

        input:hover {
            border: 2px solid rgb(228, 81, 81);
            cursor: text;
        }

        p,a{
            text-align: center;
            font-size: 1rem;
        }
        a{
            color: deepskyblue;
            font-size:20px;
        }

        #s{
            text-decoration:none;
            border-radius: 12px;
        }
        #s:hover {
            cursor: pointer;
        }

        a {
            text-decoration: none;
        }
        
        @media only screen and (max-width: 600px){
            .cont{
                width: 300px;
            }
            .error,input{
                font-size: 0.8rem;
            }

        }
        @media only screen and (max-width: 400px){
            .cont{
                width: 70%;
            }
            h2{
                font-size: 1.3rem;
            }
            a,p{
                font-size: 0.7rem;
            }
            label{
                font-size: 1.0rem;
            }
            input{
                padding: 4px;
            }

        }
    </style>
</head>
<body>

    <?php

        $name="";        
        $email="";
        $tel="";
        $dob="";
        $err="";
        
        $name_err="";
        $email_err="";
        $tel_err="";
        $dob_err="";
        $password_err="";
    if($_SERVER["REQUEST_METHOD"]=="POST")
       {
            if(isset($_POST['signup']))
            {
                if(empty($_POST['name']) || empty($_POST['dob']) || empty($_POST['tel']) || empty($_POST['email']) || empty($_POST['password']))
                {
                    if(empty($_POST['name']))
                    {
                        $name_err="Name is required!";
                    }
                    else{
                        $name=$_POST['name'];
                    }
                    if(empty($_POST['email']))
                    {
                        $email_err="Email is required!";
                    }
                    else{
                        $email=$_POST['email'];
                    }
                    if(empty($_POST['tel']))
                    {
                        $tel_err="Contact Number is required!";
                    }
                    else{
                        $tel=$_POST['tel'];
                    }
                    if(empty($_POST['dob']))
                    {
                        $dob_err="D.O.B is required!";
                    }
                    else{
                        $dob=$_POST['dob'];
                    }
                    if(empty($_POST['password']))
                    {
                        $password_err="Password is required!";
                    }
                }
                else
                {
                    $today = new DateTime(date('m.d.y'));
                    $dob = new DateTime($_POST['dob']);
                    $diff1 = $today->diff($dob);
                    $age = $diff1->y;
                    if($age > 15 || $age <3)
                    {
                        $dob = $_POST['dob'];
                        $dob_err = "Age criteria not satisfied , child's age must be between 3-15 years";
                    }
                    else
                    {
                        require_once("./all_utils/connection.php");
                        $email=$_POST['email'];
                        $query="SELECT * FROM identity_table WHERE email='".$email."'";
                        $result=mysqli_query($conn,$query);

                        if(mysqli_fetch_assoc($result))
                        {
                            $err="Email alredy registered!";
                            $name=$_POST['name'];
                            $email=$_POST['email'];
                        }
                        else
                        {
                            if($age < 7)
                            {
                                $_SESSION['age_category'] = '1';
                            }
                            else
                            {
                                $_SESSION['age_category'] = '2';
                            }
                            $_SESSION['name']=$_POST['name'];
                            $_SESSION['email']=$_POST['email'];
                            $_SESSION['password'] = password_hash($_POST['password'],PASSWORD_DEFAULT);
                            $_SESSION['tel']=$_POST['tel'];
                            $_SESSION['dob']=$_POST['dob'];
                            $_SESSION['xyz']='xyz';
                            require_once("all_utils/mail.php");
                            header("location:conf.php");
                        }
                    }
                }
            
            }
        }

    ?>

    <div class="cont">
        <h2>SignUp - Kanha Stories</h2>

            <form action="<?php echo htmlspecialchars($_SERVER['PHP_SELF'])?>" method="POST">

            <span class="error"><?php echo $err; ?></span>
            <br/>

            <label for="name">Name</label><br />
            <input type="text" name="name" placeholder="Enter your name" value="<?php echo $name; ?>">

            <span class="error"><?php echo $name_err; ?></span>
            <br/>

            <label for="email">Email</label><br />
            <input type="email" name="email" placeholder="Enter your Email ID" value="<?php echo $email; ?>">


            <span class="error"><?php echo $email_err;?></span>
            <br/>

            <label for="tel">Mobile Number</label><br />
            <input type="tel" name="tel" placeholder="Enter Mobile Number" value="<?php echo $tel; ?>">


            <span class="error"><?php echo $tel_err;?></span>
            <br/>

            <label for="date">D.O.B. of Child &nbsp; (Click on Calander icon)</label><br />
            
            <input  type="date" name="dob" placeholder="Enter date of birth " value="<?php echo $dob;?>">

            <span class="error"><?php echo $dob_err;?></span>
            <br/>

            <label for="password">Password</label><br />
            <input type="password" name="password" placeholder="Enter your Password">


            <span class="error"><?php echo $password_err; ?></span>
            <br/>
            

            <div class="sub">
            <input type="submit" name="signup" id="s"  placeholder="Submit"><br />
            </div>
        </form>
        <p>Already registered? <a href="./login.php">log in here</a></p>
    </div>
</body>
</html>

 

I don't know what I can do now , Please try to give me the solutions as soon as possible. Thanks

I closed everything down last night and it was all fine, website was working as normal etc, but I've turned on the Xxamp server today and I am getting this error. Seems very random as nothing has changed since it was last on? 

Does anyone know how to sort this out and why I'm now getting this error? Thanks!

Can anyone help me with this error?

Fatal error: Call to a member function require_login() on a non-object in /home/wallls/public_html/index.php on line 27

Lines 26-33 below:

<?php 
$smilek = $_GET['id'];
$ppalout = $_GET['payout'];
$healthy = array("%", "!", "=", "'", ",", "OR", "?", "<", "&", ";");
$yummy   = array("", "", "", "", "" ,"", "", "", "", "");
$peee = str_replace($healthy, $yummy, $smilek);
$chnpay = str_replace($healthy, $yummy, $ppalout);


require_once 'appinclude.php';
require_once 'mystyle.php';

echo '<div align="center"><img src="'.$appcallbackurl.'main.png" width="300" height="150"></div>';

require_once 'ads/topads.php';
?>
<fb:tabs>
  <fb:tab-item href='<? echo $appCanvasUrl; ?>' title='Lottery' selected='true' />
  <fb:tab-item href='<? echo $appCanvasUrl; ?>earn.php' title='Get Tickets' />
  <fb:tab-item href='<? echo $appCanvasUrl; ?>payment.php' title='Payment Info' />
  <fb:tab-item href='<? echo $appCanvasUrl; ?>history.php' title='Lottery History' />
  <fb:tab-item href='<? echo $appCanvasUrl; ?>forum.php' title='Forum' />
  <fb:tab-item href='<? echo $appCanvasUrl; ?>invite.php' title='Invite Friends' />
</fb:tabs>
<div align="center">
<?
$fbid = $facebook->require_login();
$theirip = $_SERVER['REMOTE_ADDR'];


if ($fbid == "")
{
?>