getting parse error

116 New Member

i m trying to display a message based on code status against the code in the database for on the code entered.
however it gives me a parse error

Expand|Select|Wrap|Line Numbers

 
<?php require_once("includes/functions.php"); ?>

<?php
 
// Database Constants

define("DB_SERVER", "localhost");

define("DB_USER", "tara");

define("DB_PASS", "tara");

define("DB_NAME", "book");
 
?>
 
<?php
 
// 1. Create a database connection

$connection = mysql_connect(DB_SERVER,DB_USER,DB_PASS);

if (!$connection) {

    die("Database connection failed: " . mysql_error());

}
 
// 2. Select a database to use 

$db_select = mysql_select_db(DB_NAME,$connection);

if (!$db_select) {

    die("Database selection failed: " . mysql_error());

}

?>
 
<?php
 
    include_once("includes/form_functions.php");
 
    // START FORM PROCESSING

    if (isset($_POST['submit'])) { // Form has been submitted.

        $code = trim(mysql_prep($_POST['code']));

        $count_code = 0;
 
         // checks database for the code for errors

             $result_code = mysql_query("SELECT code FROM orders WHERE code = '{$code}' " );

            confirm_query($result_code);

            if (mysql_num_rows($result_code) == 1) 

            {

            $count_code = $count_code + 1;

            }
 
        // checks database for the status for errors

             $result_codestatus = mysql_query("SELECT codestatus FROM orders WHERE code = '{$code}'");    

            confirm_query($result_codestatus);

            if (mysql_num_rows($result_codestatus) == 1)

            {    

                if ($result_codestatus=="P"){

                $message = " Your status is pending";   

                }

                if ($result_codestatus=="W"){

                $message = " Your status is waiting";                      }

                if ($result_codestatus=="A"){

                $message = " Your status is approved";

                }        
 
            }
 
            else 

            {// Code does not existing

            $code = "";

            $message = " Your code doesn't exist";

            }    
 
?>

<html>

    <head>

        <title>sitename</title>

        <link href="stylesheets/public.css" media="all" rel="stylesheet" type="text/css" />

    </head>

    <body>

        <div id="header">

            <h1>sitename</h1>

        </div>

        <div id="main">

<table id="structure">

    <tr>

        <td id="navigation">

            <a href="welcome.php">Return to Menu</a><br />

            <br />

        </td>

        <td id="page">

            <h2>Login</h2>

            <?php if (!empty($message)) {echo "<p class=\"message\">" . $message . "</p>";} ?>
 
            <?php $code = ""; ?>
 
            <form action="status.php" method="post">

            <table>

                <tr>

                    <td>Enter Code:</td>

                    <td><input type="text" name="code" maxlength="40" value="<?php echo htmlentities($code); ?>" /></td>

                </tr>
 
                <tr>

                    <td colspan="2"><input type="submit" name="submit" value="Check" /></td>

                </tr>

            </table>

            </form>

        </td>

    </tr>

</table>

        </div>

        <div id="footer">Copyright 2010</div>

    </body>

</html>

<?php

    // Close connection

    mysql_close($connection);

?>

Jun 10 '10 #1

Subscribe Reply

1463

Dormilich

8,658

Recognized Expert Moderator Expert

the opening brace of line #32 has not been closed.

Jun 10 '10 #2

angelicdevil

116

New Member

but why doesnt it display the message in 50 53 and 55 when the condition is correct

Jun 10 '10 #3

Dormilich

8,658

Recognized Expert Moderator Expert

those lines are syntactically correct.

Jun 10 '10 #4

JKing

1,206

Recognized Expert Top Contributor

The function mysql_query returns a resource. You will need to use another function such as mysql_fetch_row or mysql_fetch_array to access the data. I altered your code so you should be able to copy and paste. Give it a try and let me know how it works out for you.

Expand|Select|Wrap|Line Numbers

 
<?php require_once("includes/functions.php"); ?>

<?php
 
// Database Constants

define("DB_SERVER", "localhost");

define("DB_USER", "tara");

define("DB_PASS", "tara");

define("DB_NAME", "book");
 
?>
 
<?php
 
// 1. Create a database connection

$connection = mysql_connect(DB_SERVER,DB_USER,DB_PASS);

if (!$connection) {

    die("Database connection failed: " . mysql_error());

}
 
// 2. Select a database to use 

$db_select = mysql_select_db(DB_NAME,$connection);

if (!$db_select) {

    die("Database selection failed: " . mysql_error());

}

?>
 
<?php
 
    include_once("includes/form_functions.php");
 
    // START FORM PROCESSING

    if (isset($_POST['submit'])) { // Form has been submitted.

        $code = trim(mysql_prep($_POST['code']));

        $count_code = 0;
 
         // checks database for the code for errors

             $result_code = mysql_query("SELECT code FROM orders WHERE code = '{$code}' " );

            confirm_query($result_code);

            if (mysql_num_rows($result_code) == 1) 

            {

            $count_code = $count_code + 1;

            }
 
        // checks database for the status for errors

             $result_codestatus = mysql_query("SELECT codestatus FROM orders WHERE code = '{$code}'");    

            confirm_query($result_codestatus);

            if (mysql_num_rows($result_codestatus) == 1)

            {    

                $row_codestatus = mysql_fetch_row($result_codestatus);

                if ($row_codestatus[0]=="P"){

                $message = " Your status is pending";   

                }

                if ($row_codestatus[0]=="W"){

                $message = " Your status is waiting";                      }

                if ($row_codestatus[0]=="A"){

                $message = " Your status is approved";

                }        
 
            }
 
            else 

            {// Code does not existing

            $code = "";

            $message = " Your code doesn't exist";

            }    
 
?>

<html>

    <head>

        <title>sitename</title>

        <link href="stylesheets/public.css" media="all" rel="stylesheet" type="text/css" />

    </head>

    <body>

        <div id="header">

            <h1>sitename</h1>

        </div>

        <div id="main">

<table id="structure">

    <tr>

        <td id="navigation">

            <a href="welcome.php">Return to Menu</a><br />

            <br />

        </td>

        <td id="page">

            <h2>Login</h2>

            <?php if (!empty($message)) {echo "<p class=\"message\">" . $message . "</p>";} ?>
 
            <?php $code = ""; ?>
 
            <form action="status.php" method="post">

            <table>

                <tr>

                    <td>Enter Code:</td>

                    <td><input type="text" name="code" maxlength="40" value="<?php echo htmlentities($code); ?>" /></td>

                </tr>
 
                <tr>

                    <td colspan="2"><input type="submit" name="submit" value="Check" /></td>

                </tr>

            </table>

            </form>

        </td>

    </tr>

</table>

        </div>

        <div id="footer">Copyright 2010</div>

    </body>

</html>

<?php

    // Close connection

    mysql_close($connection);

?>

Jun 10 '10 #5

angelicdevil

116

New Member

perfect it works thanx jking and dormilich

Jun 10 '10 #6

angelicdevil

116

New Member

another thing ...if say at the time of displaying the message i dont want the text box to enter code to be displayed how can i hide it and disable it?

Jun 10 '10 #7

Similar topics

16280

Parse error: parse error, expecting `','' or `';''

by: entoone | last post by:

I'm getting the following error Parse error: parse error, expecting `','' or `';'' in /home/notarywe/public_html/php/update2.php on line 108 Here is line 108 <input type="text" name="ud_first"...

PHP

590

Parse error

by: Stuart Rogers | last post by:

I have just setup my website with a new linux hosting service. I have copied over my scripts and the jpgraph (the stable version) files from my working local lan linux server. The hosting service...

PHP

2664

'Parse error' problem in "isset" and "empty"

by: Marcin Dobrucki | last post by:

I've been having some problems with a parse error that I can't figure out (PHP 4.3.11 on Solaris9). Sample code: <?php // getting strange parse errors on this class A { var $value; function...

PHP

1476

parse error

by: Jim Anderson | last post by:

I'm just starting to use XML and I'm thinking of using DocBook for some documentation. I tried my first simple example from the book and I'm getting a parse error. I iniitally typed in the...

.NET Framework

3665

Getting Parse Error at or near and at character......

by: urmyfriend | last post by:

Hi, I am getting the parse error while i try to execute a simple sql query in postgres. java.sql.SQLException: ERROR: parser: parse error at or near "and" at character 58 The Query has...

PostgreSQL Database

1352

Need Help!! Trouble getting into a webpage...Parse error

by: Sianaba | last post by:

I am getting help from a website to fix my malware etc problem.... i was instructed to run a Kaspersky scan and now when i try to get to my specific forum i get this come up instead: Parse error:...

General

1247

Getting parse errors with these small bit of codes

by: DavidPr | last post by:

I'm getting - parse error, unexpected T_LNUMBER - error messages referring to the last "if" lines of this code. What I'm trying to do is check the database and if this user's article row isn't...

PHP

3207

parse error or infinite loop? a blank screen, yet the php error logis empty

by: Lawrence Krubner | last post by:

Imagine a template system that works by getting a file, as a string, and then putting it through eval(), something like this: $formAsString = $controller->command("readFileAndReturnString",...

PHP

2074

A Parse error that shouldnt be

by: micky125 | last post by:

Lo all, Ive been getting the error message Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/moneill/public_html/input.html...

PHP

6799

need help with auto load of listbox contents without page refresh or button

by: angelicdevil | last post by:

i have 2 tables 1 is status_type with field name status and other is users with field username and status now i want that the first listbox lists all status from status type ( this i have achieved...

Javascript

7205

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7093

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7349

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

7467

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

5594

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

5022

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

3177

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

3168

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

746

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP