Need help with some php code :)

Posted on 16th Feb 2014 07:03 pm by admin

Hey! I'm quite new to this whole thing, so please don't fire me with shait on this one =D

I'm trying to learn PHP and MySQL, and atm I am trying to make a website which corresponds with a database - a database with customers.

I managed to make the page show all the customers in the database - with first- and surname.

I want each of these customers to be clickable - when you click a customer, it shows all the information about that customer which is stored in the database.

So far I have managed to make them clickable, but I don't know how to make it so that the click posts all the associated information about that customer on the page..

I can post some of the stuff I tried out with, but I'm not good with PHP (yet! =D), and therefore I got stuck quite early... but here's some of the stuff I've done so far..


Code: <?php
// Connect to the database server
$dbcnx = @mysql_connect('localhost', 'root', 'password');
if (!$dbcnx) {
exit('<p>Unable to connect to the database server at this time.</p>');
}

// Select the database
if (!@mysql_select_db('customerdb')) {
exit('<p>Unable to locate the database at this time');
}

?>

<p>Here are all the customers:</p><br />

// Request data from the database
$customers = @mysql_query('SELECT * FROM customers');
if (!$customers) {
exit('<p>Error performing query: ' . mysql_error() . '</p>');
}

while ($row = mysql_fetch_array($customers)) {
$customerID = $row['kundeID'];
$customer_forename = $row['forename'];
$customer_surname = $row['surname'];
echo '<p>' . $customer_forename .
$customer_surname .
' <a href="' . $_SERVER['PHP_SELF'] .
'?showcustomer=' . $customerID . '">' .
'customer details</a></p>';
}

?>

Thanks!

Your Answer:

Login to answer

Other forums

PHP4 to PHP5 Conversion
Hi Everyone,

I am working on a site that is built up on PHP4 and each page is being started f

PHP error. Need help urgently
Hi,

I am programming a php site and have a problem that i just cant find out how to fix. When

What are causes of a connection-timeout with fopen()?
Hello! Here is the situation: The server I host my website on just upgraded it's PHP build from 4.4.

Combining Two Queries
I have two scripts that each work fine by themselves. One is a search script with a variable that de

i want run some web server under the ip sharer
hello i want run some web server under the ip sharer
my ip is floating ip but it doesnt matter

Ajax Error since Upgrading to 3.5
Ever since upgrading my site to .NET 3.5 (I needed LINQ), I've been getting this annoying error on o

Parse error: syntax error, unexpected T_ELSEIF in /home/......html/item.php on l
I do not know what is wrong with this. Hope some one can help. I do nto want to post the entire site

Oracle Connectivity
Hi Every One,

Can we access SAP from oracle database.If it possible then please spec

MASS PM
Hello all, I'm trying to send mass private messages to users in my database but keep getting an erro

Tournament Brackets (Double Elimination)?
Is making a double elimination tournament style bracket system capable of being done in php?