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

Simple program to copy files between two computers over the web
I use logmein free and often need to move files between my two computers. Generally, I move the file

Packet Design
Hi All,
Im new about network programming and I want to design a protocol but I have some question

limit string by words??
hello all,

I was wonder if there is a function to limit a string by the number of words inste

Converting numbers to months
The porgram works -just need the last function(month_convert_ to convert numbers to months -thanks.

How to read CSS message data
Hi,
I have a requirement here. When working as a Dev angel for multiple customers its really di

Help With editting and deleting form
So look at this image :

http://img194.imageshack.us/img194/8272/snapshot5f.png
This table

Apart from cron
I need to run a php file every one hour. Is there any other solution apart from cron job?

Handling text changed in text box control using Ajax
I need to create a web form with a text box control. When someone types text into the textbox I nee

How to submit a form to the same page?
I have a table containing information about books in my library and this table has the following col

retrieving images from mysql database using php
So I've been trying to figure out how to store images in a mysql database, and as far as i can tell