DaniWeb Forum Index > Web Development > PHP

Newbie in need of help with some PHP code :)

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Nov 2009

Posts: 2

Reputation: hawkontvn is an unknown quantity at this point

Solved Threads: 0

hawkontvn

Offline

Newbie Poster

Newbie in need of help with some PHP code :)

Nov 5th, 2009

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.

1. I want the page to show all the customers in the database - with first- and surname.

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

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..

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?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>';
                } 
 
                ?>
<?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>';
                } 

                ?>

This piece of code also gives me no spaces between the $customer_forename and $customer_surname.. How can I make a space between them?

And one last question

In this example, I have just created a link at the end of the customers listed - which says customer details.. Is there a way to make the $customer_forename and $customer_surname a clickable link which executes what I am trying to achieve?

Thanks, and sorry for not being really good at this, at all! =D
Have a nice day!

Last edited by hawkontvn; Nov 5th, 2009 at 2:33 pm.

•

Join Date: Feb 2008

Posts: 49

Reputation: emhmk1 is an unknown quantity at this point

Solved Threads: 0

emhmk1

Offline

Light Poster

Nov 5th, 2009

Hi there,

To get a space you could the html

Help with Code Tags

PHP Syntax (Toggle Plain Text)

&nbsp

That should sort that, as for making the name clickable replace 'customer details' in the link to .$customer_forname. "&nbsp" .$customer_surname.

That should work in theory

Hope it helps

•

Join Date: Sep 2009

Posts: 26

Reputation: Cronless is an unknown quantity at this point

Solved Threads: 2

Cronless

Offline

Light Poster

Nov 5th, 2009

You can do that above, but simply adding a quoted space should suffice as well:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
echo '<p>' . $customer_forename . " " . $customer_surname .
echo '<p>' . $customer_forename . " " . $customer_surname .

Never use a hammer when a screwdriver will do.

~~ Free Cron Jobs - Online Cron Service ~~
Best place to run your PHP Cron Jobs

•

Join Date: Nov 2009

Posts: 2

Reputation: hawkontvn is an unknown quantity at this point

Solved Threads: 0

hawkontvn

Offline

Newbie Poster

Thanks so far :)

Nov 5th, 2009

Ok guys, thanks for the help so far!

I should have known the &nbsp or the empty " " would work for the spacing... I also managed to make the names clickable..

But I still lack the tricky stuff :p

I made the names from the database clickable, but how can I make them show the rest of the data associated with the names show when I click a name?

Hope somebody can help out!

•

Join Date: Jun 2007

Posts: 1,492

Reputation: evstevemd has a spectacular aura about

Solved Threads: 128

evstevemd

Offline

Nearly a Posting Virtuoso

Nov 5th, 2009

Also there is function called die() that will save you alot of coding.You have:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
#
$dbcnx = @mysql_connect('localhost', 'root', 'password');
#
if (!$dbcnx) {
#
exit('<p>Unable to connect to the database server at this time.</p>');
#
}
#
$dbcnx = @mysql_connect('localhost', 'root', 'password');
#
if (!$dbcnx) {
#
exit('<p>Unable to connect to the database server at this time.</p>');
#
}

but you can do this:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$dbcnx = @mysql_connect('localhost', 'root', 'password') or die('<p>Unable to connect to the database server at this time.</p>');
$dbcnx = @mysql_connect('localhost', 'root', 'password') or die('<p>Unable to connect to the database server at this time.</p>');

See how simple it is :lol:

Atheist: God is man made imagination, he doesn't exist!
Theist: It's okay, can you imagine anything else that doesn't exist?
---- Python, C++ PHP and Java ----

•

Join Date: Jun 2007

Posts: 1,492

Reputation: evstevemd has a spectacular aura about

Solved Threads: 128

evstevemd

Offline

Nearly a Posting Virtuoso

Nov 5th, 2009

•

Originally Posted by hawkontvn

I made the names from the database clickable, but how can I make them show the rest of the data associated with the names show when I click a name?

I don't get you here! What do you mean? display data from database or what?

Atheist: God is man made imagination, he doesn't exist!
Theist: It's okay, can you imagine anything else that doesn't exist?
---- Python, C++ PHP and Java ----

•

Join Date: Oct 2009

Posts: 185

Reputation: venkat0904 is an unknown quantity at this point

Solved Threads: 19

venkat0904 venkat0904 is offline

Offline

Junior Poster

Nov 6th, 2009

ur link points to php self ie the same file. I suggest u to handle customer details retrieval from another php file.
anyway if u want to do that from the same file itself, u can have an if statement like

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
if(isset($_REQUEST['showcustomer'])){
   $query = 'SELECT * FROM customers where customerId = '.$_REQUEST['showcustomer'];
    $customerDetails = @mysql_query($query); //here is the data u need. Use it the way u want
}
if(isset($_REQUEST['showcustomer'])){
   $query = 'SELECT * FROM customers where customerId = '.$_REQUEST['showcustomer'];
    $customerDetails = @mysql_query($query); //here is the data u need. Use it the way u want
}

Hope this helps

•

Originally Posted by hawkontvn

Ok guys, thanks for the help so far!
I should have known the &nbsp or the empty " " would work for the spacing... I also managed to make the names clickable..

But I still lack the tricky stuff :p

I made the names from the database clickable, but how can I make them show the rest of the data associated with the names show when I click a name?

Hope somebody can help out!

Last edited by venkat0904; Nov 6th, 2009 at 2:15 am.