esoteric Posted August 13, 2011 Share Posted August 13, 2011 I cannot understand the problem with this script, im trying to have a invoice page that is updated with the information from my sql table depending on what the user types into a little form. My http form is just; <table width="400" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td width="52%" align="center">Order Number</td> <td width="48%"><input name="order" type="text" id="order" size="20" /></td> </tr> <tr> <td><p> </p></td> <td><p> <input name="button" type="submit" id="button" value="Submit" /> </p></td> </tr> </table> My php page is; <?php include 'dbc.php'; page_protect();?> <?php $order = $_POST['order']; mysql_connect("xxx", "xxx", "xxx") or die( "Unable to connect to database"); mysql_select_db("membership") or die( "Unable to select database"); $result = mysql_query("SELECT * FROM orderTable WHERE orderNum = '$order'"); $username = "test"; $password = "test"; if ($_POST['txtUsername'] != $username || $_POST['txtPassword'] != $password) { ?> <h1>Login</h1> <form name="form" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> <p><label for="txtUsername">Username:</label> <br /><input type="text" title="Enter your Username" name="txtUsername" /></p> <p><label for="txtpassword">Password:</label> <br /><input type="password" title="Enter your password" name="txtPassword" /></p> <p><input type="submit" name="Submit" value="Login" /></p> </form> <?php } else { ?> <table width="50%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="29%">First Name</td> <td width="71%"><?php echo $result['firstName']; ?></td> </tr> <tr> <td>Lastname</td> <td><?php echo $result['lastName']; ?></td> </tr> <tr> <td>Order Number</td> <td><?php echo $result['orderNum']; ?></td> </tr> <tr> <td>Order Date</td> <td><?php echo $result['orderDate']; ?></td> </tr> <tr> <td>Order</td> <td><?php echo $result['strMessageBody']; ?></td> </tr> <tr> <td>Total</td> <td><?php echo $result['total']; ?></td> </tr> </table> <?php } ?> It just doesn't display anything! Any help is much appreciated. Thank you. Quote Link to comment Share on other sites More sharing options...
Muddy_Funster Posted August 15, 2011 Share Posted August 15, 2011 Where is your <form> decleration? Quote Link to comment Share on other sites More sharing options...
jonsborn Posted December 15, 2011 Share Posted December 15, 2011 Please, Follow These three step and solve your error: - You can make empty files named index.php, page1.php, page2.php, page3.php. Now add content. - index.php - this file contains alone the layout. The agreeable space is empty. Remember, this is an absolute html file, which use it compulsory to basic HTML structure(<html> <head> </head> <body> </body> </html>) and what comes in between. - page1.php, page2.php, page3.php - these 3 files contain only the content. No layout. Just throw on some headings, paragraphs of text and images here. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.