Enjoy an ad free experience by logging in. Not a member yet?
Register .
PM User | 1
New Coder
Join Date: Jan 2005
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
Display sql results in html table
I know how to display my results in a plain html table, but how can I display the results in my existing webpage?
see what I mean:
http://www.sliquid.com/protected/admin.php
user - admin
pass - temppass2
Then click on Search / Edit Records under Customers.
search for "dallas" or "texas" to see my results.
How can I get these results to display within my html?
heres my code right now:
PHP Code:
<?php
include( "dbconnection.php" );
$_POST [ 'Submit' ])) {
$search = $_POST [ 'search' ];
$date = $_POST [ 'date' ];
$query = "SELECT firstname,lastname,city,state,email FROM customers WHERE firstname = '$search' OR lastname = '$search' OR city = '$search' OR state = '$search' OR email = '$search' AND date >= '$date' ORDER BY date asc" ;
$result = odbc_exec ( $cnx , $query );
$row = odbc_fetch_array ( $result )) {
/*
echo "
;
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
<?php require_once( "adminOnly.php" ); ?>
<div id="container">
PM User | 2
New Coder
Join Date: Jan 2006
Location: Oslo, Norway
Posts: 86
Thanks: 0
Thanked 0 Times in 0 Posts
Quote:
Originally Posted by croix
How can I get these results to display within my html?
Cold you try to explain what you want to do? You'll have to excuse my english, but I cant figure out what your problem is/what you want.
__________________
PM User | 3
Senior Coder
Join Date: Nov 2002
Location: North-East, UK
Posts: 1,265
Thanks: 0
Thanked 0 Times in 0 Posts
There are different ways. You could put your results into a variable or you could move the code to output within the table
PHP Code:
<?php require_once( "adminOnly.php" ); ?>
<?php
// Show If
include( "dbconnection.php" );
$_POST [ 'Submit' ])) {
$search = $_POST [ 'search' ];
$date = $_POST [ 'date' ];
$query = "SELECT firstname,lastname,city,state,email FROM customers WHERE firstname = '$search' OR lastname = '$search' OR city = '$search' OR state = '$search' OR email = '$search' AND date >= '$date' ORDER BY date asc" ;
$result = odbc_exec ( $cnx , $query );
$row = odbc_fetch_array ( $result )) {
/*
echo "
;
// Else Show
else {
?>
<div id="table1">
<?php
// End If
}
?>
PM User | 4
Senior Coder
Join Date: Apr 2005
Location: Colorado, United States
Posts: 1,208
Thanks: 0
Thanked 0 Times in 0 Posts
Personally I'd recommend executing all the code first and feeding that into a variable, then echoing out the variable in the right place...less messy and far easier to work with and make changes.
__________________"$question = ( to() ) ? be() : ~be();"
Jump To Top of Thread
Thread Tools
Rate This Thread
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
All times are GMT +1. The time now is 03:00 AM .
Advertisement
Log in to turn off these ads.
Before you post, read our: 
