Good project to better my php skills?

killaklown · 07-04-2006, 07:13 PM

What would be a good project to better my php skills? Im new at php and finish coding a simple script at: http://www.netsnatch.com/script (which checks to see if the entered domain contains a valid license)

I dont think im ready with mysql, as most of the mysql information in the above script was copied from other scripts i bought.

Dan · 07-04-2006, 08:40 PM

http://www.netsnatch.com/script/

Doesn't work.

MySQL basically has 3 commands (insert, select, update; the others aren't used as much) that you need to know. It isn't hard at all.

killaklown · 07-04-2006, 08:46 PM

im working on making the script do more right now so it may give errors at times.

The things im not understanding right now about mysql is
mysql_query
mysql_fletch_array
etc.

Edit:

How can i get the number in a row in the database?

Code:

<?
$query = "SELECT downloads FROM counter WHERE id='1'";
$result = mysql_query($query);
$myrecord = mysql_fetch_row($result);

echo''.$myrecord.'';
?>

I have that, i want it to show the number in the 'downloads' column that has an id of 1, but all it does it show 'Array'.

wackyjoe · 07-04-2006, 09:00 PM

i would use mysql_fetch_array().

Dan · 07-04-2006, 09:31 PM

Use mysql_fetch_array instead of mysql_fetch_row.

I don't know why you are doing echo '', since the '' doesn't do anything.

$myrecord is an array with the row you got from the database. If you do mysql_fetch_array instead of mysql_fetch_row, you can do $myrecord['something'], where something is the name of the column in the database.

killaklown · 07-05-2006, 10:50 AM

i tried using mysql_fetch_array() but it still showed array.

Tree · 07-05-2006, 11:31 AM

You can't echo an array. Try print_r($myrecord) with mysql_fetch_array

Flubber · 07-05-2006, 12:57 PM

PHP Code:

  <?

$query = "SELECT downloads FROM counter WHERE id='1'";

????: NamePros.com http://www.namepros.com/programming/213541-good-project-better-my-php-skills.html
$result = mysql_query($query);

$myrecord = mysql_fetch_row($result);

 
echo $myrecord['0'];

?>

Should work.

Flubb.

killaklown · 07-05-2006, 05:59 PM

thanks flubber, works.

07-04-2006, 07:13 PM	THREAD STARTER #1 (permalink)
killaklown Senior Member Join Date: Oct 2003 Posts: 3,472	Good project to better my php skills? What would be a good project to better my php skills? Im new at php and finish coding a simple script at: http://www.netsnatch.com/script (which checks to see if the entered domain contains a valid license) I dont think im ready with mysql, as most of the mysql information in the above script was copied from other scripts i bought. __________________ hostvouchers - Coupons and Reviews for the top web hosts! (shared, reseller, vps, servers, adult, offshore, proxy)

07-04-2006, 08:46 PM	THREAD STARTER #3 (permalink)
killaklown Senior Member Join Date: Oct 2003 Posts: 3,472	im working on making the script do more right now so it may give errors at times. The things im not understanding right now about mysql is mysql_query mysql_fletch_array etc. Edit: How can i get the number in a row in the database? Code: <? $query = "SELECT downloads FROM counter WHERE id='1'"; $result = mysql_query($query); $myrecord = mysql_fetch_row($result); echo''.$myrecord.''; ?> I have that, i want it to show the number in the 'downloads' column that has an id of 1, but all it does it show 'Array'. __________________ hostvouchers - Coupons and Reviews for the top web hosts! (shared, reseller, vps, servers, adult, offshore, proxy) Last edited by killaklown; 07-04-2006 at 08:52 PM.

07-05-2006, 10:50 AM	THREAD STARTER #6 (permalink)
killaklown Senior Member Join Date: Oct 2003 Posts: 3,472	i tried using mysql_fetch_array() but it still showed array. __________________ hostvouchers - Coupons and Reviews for the top web hosts! (shared, reseller, vps, servers, adult, offshore, proxy)

07-05-2006, 12:57 PM	#8 (permalink)
Flubber NamePros Regular Join Date: Jun 2005 Location: UK Posts: 688	PHP Code: `<? $query = "SELECT downloads FROM counter WHERE id='1'"; ????: NamePros.com http://www.namepros.com/programming/213541-good-project-better-my-php-skills.html $result = mysql_query($query); $myrecord = mysql_fetch_row($result); echo $myrecord['0']; ?>` Should work. Flubb.

07-05-2006, 05:59 PM	THREAD STARTER #9 (permalink)
killaklown Senior Member Join Date: Oct 2003 Posts: 3,472	thanks flubber, works. __________________ hostvouchers - Coupons and Reviews for the top web hosts! (shared, reseller, vps, servers, adult, offshore, proxy)

07-04-2006, 08:40 PM	#2 (permalink)
Dan Buy my domains. Join Date: Feb 2006 Posts: 2,796	http://www.netsnatch.com/script/ Doesn't work. MySQL basically has 3 commands (insert, select, update; the others aren't used as much) that you need to know. It isn't hard at all.

07-04-2006, 09:00 PM	#4 (permalink)
wackyjoe NamePros Regular Join Date: Dec 2005 Posts: 210	i would use mysql_fetch_array().

07-04-2006, 09:31 PM	#5 (permalink)
Dan Buy my domains. Join Date: Feb 2006 Posts: 2,796	Use mysql_fetch_array instead of mysql_fetch_row. I don't know why you are doing echo '', since the '' doesn't do anything. $myrecord is an array with the row you got from the database. If you do mysql_fetch_array instead of mysql_fetch_row, you can do $myrecord['something'], where something is the name of the column in the database.

07-05-2006, 11:31 AM	#7 (permalink)
Tree NamePros Regular Join Date: Feb 2006 Location: Atlanta, GA, USA Posts: 335	You can't echo an array. Try print_r($myrecord) with mysql_fetch_array

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)