PHP and mySQL

[Ju-Pao]

How can I retrieve a data from my mySQL database using PHP and save the data in a variable in in my PHP code

 

for example i have this table in the database

 

First name          Last Name

  Juan                  Punkista

 

I would like to store 'Juan' in variable $first and 'Punkista' in variable $last

 

thank you for your notice

[mmarif4u]

How can I retrieve a data from my mySQL database using PHP and save the data in a variable in in my PHP code

 

for example i have this table in the database

 

First name           Last Name

   Juan                  Punkista

 

I would like to store 'Juan' in variable $first and 'Punkista' in variable $last

 

thank you for your notice

 

Do like this:

After ur query write this,

$first= $row-> First Name

$last= $row-> Last Name

[Wildhalf]

Hi,

 

You will have to change the follow with reference to your Database

1. ocalhost

2. DB_User

3. password

4. DB

 

You will have to change the follow with reference to your Table

1. table_name

2. first_name

3. last_name

 

Try this....

 

# Create DB connection

$dbhost = 'localhost';
$dbusername = 'DB_User';
$dbpasswd = 'password';
$database_name = 'DB';

#under here, don't touch!
$connection = mysql_pconnect("$dbhost","$dbusername","$dbpasswd")
    or die ("Couldn't connect to server.");
$db = mysql_select_db("$database_name", $connection)
    or die("Couldn't select database.");

/* Let's get the user info */
$sql = mysql_query("SELECT * FROM table_name");
$data = mysql_fetch_array($sql);

$first = $data[first_name];
$last = $data[last_name];

 

 

[Gruzin]

First of all u have to connect to your mysql database using MYSQL_CONNECT, then you can retrive info from db. For example:

 

$sql = mysql_query("SELECT * FROM tablename");
while($row = mysql_fetch_array($sql)){
$first = $row['name'];
$last = $row['lastname'];
}

[Ju-Pao]

thanks for the reply guys 

[Ju-Pao]

follow up question, is there a way where I can select the latest row that was added in mySQL?

[Wildhalf]

Best way to do that would have a unique key in your database that auto increaments then qeury the database for the max number