Ad:

PHP Discussion Thread
Unsolved
Views: 434

Nov 5th, 2009

Newbie in need of help with some PHP code :)

Expand Post »

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

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.

Similar Threads

My embedded php code won't execute in PHP
help executing a .wav file with php code in PHP
Help newbie : need simple code in Python
I Need Help Please. Adding PHP Code To My Site. in PHP

hawkontvn

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Nov 2009

Permalink

Nov 5th, 2009

Re: Newbie in need of help with some PHP code :)

Hi there,

To get a space you could the html

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

emhmk1

Reputation Points: 11

Solved Threads: 7

Junior Poster

Offline

107 posts
since Feb 2008

Permalink

Nov 5th, 2009

Re: Newbie in need of help with some PHP code :)

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

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.

Cronless

Reputation Points: 14

Solved Threads: 2

Light Poster

Offline

29 posts
since Sep 2009

Permalink

Nov 5th, 2009

Thanks so far :)

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!

hawkontvn

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Nov 2009

Permalink

Nov 5th, 2009

Re: Newbie in need of help with some PHP code :)

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

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:

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:

evstevemd

Reputation Points: 462

Solved Threads: 392

Senior Poster

Offline

3,681 posts
since Jun 2007

Permalink

Nov 5th, 2009

Re: Newbie in need of help with some PHP code :)

Click to Expand / Collapse Quote 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?

evstevemd

Reputation Points: 462

Solved Threads: 392

Senior Poster

Offline

3,681 posts
since Jun 2007

Permalink

Nov 6th, 2009

Re: Newbie in need of help with some PHP code :)

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

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

Click to Expand / Collapse Quote 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.

venkat0904

Reputation Points: 13

Solved Threads: 21

Junior Poster

Offline

186 posts
since Oct 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: mail() problem

Next Thread in PHP Forum Timeline: SMS gateway in php

DaniWeb Message

Cancel Changes

User Name
Password