Really Basic PHP / MySQL Help

Dev Articles Community Forums Sponsor:

Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here

May 22nd, 2004, 07:20 AM

glen279

Registered User

Join Date: May 2004

Posts: 1

Time spent in forums: < 1 sec
Reputation Power: 0

Really Basic PHP / MySQL Help

Hello People.
I am really hoping you can help me, I'm 15 and just starting to learn php. I know how to set up a MySQL database and I know some basic PHP. I was wondering if anybody could tell me how to query a database? What I really want to do is a New and Updates thing for my personal site. I want two things, a date, and the new for that date. I have the basic idea how it works I just need a little help.

Thanks.
Glen

May 22nd, 2004, 09:52 AM

Pheifel

Contributing User

Join Date: Mar 2004

Location: Denmark

Posts: 174

Time spent in forums: 43 m 46 sec
Reputation Power: 5

hmmm.... you should look at php.net. They have a great section that will explain all the different codes fore you, and then mysql.com. They will tell you how to query the db.

BUT. Here is the genneral idear:

PHP Code:


		
			
 $SQL = mysql_query(select * from db where '-=what ever the limits of the search might be=-');

this querys the db according to the where claus. instead of the "select" you can use the update or delete. these does not need the " * ".

PHP Code:


		
			
 $sql = mysql_fetch_array(init result of query);

this putes all the results from teh query into an array. This can be fetched like this:

PHP Code:


		
			
 $sql['field name']

- Pheifel

May 22nd, 2004, 10:47 PM

gallifray

Registered User

Join Date: Dec 2003

Location: Pennsylvania

Posts: 16

Time spent in forums: 35 m 3 sec
Reputation Power: 0

if you want a really great book ( at least in my opinion ) on learning php, get PHP Fast and Easy Web Development by Julie C. Meloni. I got it and it helped me out a great deal and I still use it for reference though it is mainly good for learning the basics. After you learn the basics, all you need is the PHP and MySQL online documentation.

May 23rd, 2004, 10:10 AM

q3utom

Registered User

Join Date: Nov 2003

Posts: 16

Time spent in forums: < 1 sec
Reputation Power: 0

Hey I started learning php when I was 16 and been doing it for a year. What helped me was looking at hotscripts.com and the example scripts there for updates and inserts then learning that way.

PHP and MySql for dummies helped me a lot. php.net is also very useful.

May 25th, 2004, 01:52 PM

ClearWater

Registered User

Join Date: May 2004

Posts: 3

Time spent in forums: < 1 sec
Reputation Power: 0

Hi Glen,

One way to establish a connection with a mySQL server is with the following function:

PHP Code:


		
			
function ConnectToDB()
{
    if ($objDBConn = mysql_connect ("myServerName", "myUserName", "myPassword"))
    {
        mysql_select_db ("myDBName", $objDBConn);
        return true;
    }
    else
    {
        return false;
    }
}

This function will return a true if the connection was successfully made, and a false if the connection was not made. After the ConnectToDB function has been called by your script, you can do something as follows:

PHP Code:


		
			
 $objRecordSet = mysql_query ("SELECT * FROM tbMyTable"); // create a recordset from the data retrieved by the SQL statement in mysql_query function
 
 for ($iCounter = 0; $iCounter < mysql_num_rows ($objRecordSet); $iCounter ++)
 {
    $objCurrentRow = mysql_fetch_array ($objRecordSet); // go through the recordset, 1 row at a time and store the row data in $objCurrentRow
    print ($objCurrentRow["myRowName1"] . " " . $objCurrentRow["myRowName2"]);
 }

Additionally, http://us3.php.net/manual/en/ref.mysql.php has a list of available PHP functions that you can use with mySQL. Hope that helps.

Thanks, ClearWater

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: