Board index   FAQ   Search  
Register  Login
Board index php forum :: Database mySQL & php coding

MySQL online connection

Codes here !

Moderators: macek, egami, gesf

Postby elitecodex » Thu Jul 11, 2002 5:33 pm

I cant provide that much help because you really didnt explain the problem. Basically, once you get the connection, you select your database, run a query against it, and use mysql_fetch_array or similar function to obtain the results. Here is a good place to start with the basics:
http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html and of course, the PHP site: http://www.php.net/manual/en/ref.mysql.php. Best of luck with those. If you have any other problems, try showing some example code or being more specific, and I would be more than willing to attempt to help.

Will
elitecodex
New php-forum User
New php-forum User
 
Posts: 68
Joined: Tue Jul 09, 2002 8:45 am
Location: East Coast, USA

Re: MySQL online connection

Postby WiZARD » Thu Jul 11, 2002 10:57 pm

RTFM my dear friend RTFM :wink:
User avatar
WiZARD
Moderator
Moderator
 
Posts: 1257
Joined: Thu Jun 20, 2002 10:14 pm
Location: Ukraine, Crimea, Simferopol

Postby Oleg Butuzov » Fri Jul 12, 2002 7:43 am

Dear James,
How said my friend Wizard, RTFM!

It is very nice that you want to learn PHP and MySQL. I hope my links will help you...

http://www.php.net here you can find online documentaion, but you can download all documentation in one file (Soory but I forgot a link to the file)
http://www.mysql.org documentation...
http://www.apache.org - APache web server...

If you are allredy called on this sites and dowloaded documentation. please rad its.



For reaply on your question...
It is just simple code? for your learning...

Code: Select all
<?
$user="pejone";
$host=""flashsoft.com.ua;
$pass="asdgWERaf@#$AFSD";

#dbname="flashsoft";

$link=mysql_connect($host, $user, $pass);

mysql_select_db($dbname, $link);

$query=mysql_query("SELECT * FROM `table`", $link);
 
for ($i=0; $i<mysql_num_rows($query); $i++)
{
$data=mysql_fetch_array($query);
$echo($data['somes']);
}
?>


regards...
Oleg Butuzov
Last Samuray
Last Samuray
 
Posts: 831
Joined: Sun Jun 02, 2002 3:09 am

Postby Jay » Thu Aug 01, 2002 4:02 pm

Pejone: Not meaning to be picky, I thought perhaps this would be a more suitable alternative to your loop as it's neater and more efficient

Code: Select all
$query = mysql_query("SELECT * FROM `table`", $link);
while ($data = mysql_fetch_array($query)) print $data['somes'];


It's essentially the same code, just smaller and neater. :D
Jay
 


Return to mySQL & php coding

Who is online

Users browsing this forum: Bing [Bot], Yahoo [Bot] and 1 guest

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.

cron