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. Link to comment https://forums.phpfreaks.com/topic/244676-dynamic-page-problem/ Share on other sites More sharing options...
Muddy_Funster Posted August 15, 2011 Share Posted August 15, 2011 Where is your <form> decleration? Link to comment https://forums.phpfreaks.com/topic/244676-dynamic-page-problem/#findComment-1257709 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. Link to comment https://forums.phpfreaks.com/topic/244676-dynamic-page-problem/#findComment-1298091 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.