Good project to better my php skills?

killaklown · 07-04-2006, 06: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, 07: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, 07: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, 08:00 PM

i would use mysql_fetch_array().

Dan · 07-04-2006, 08: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, 09:50 AM

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

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

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

Flubber · 07-05-2006, 11:57 AM

PHP Code:

  <?

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

$result = mysql_query($query);

$myrecord = mysql_fetch_row($result);

 
echo $myrecord['0'];

?>

Should work.

Flubb.

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

thanks flubber, works.

07-04-2006, 06:13 PM	#1 (permalink)
killaklown Senior Member Join Date: Oct 2003 Location: Winnipeg, Canada Posts: 3,472 5.31 NP$ (Donate)	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.

07-04-2006, 07:46 PM	#3 (permalink)
killaklown Senior Member Join Date: Oct 2003 Location: Winnipeg, Canada Posts: 3,472 5.31 NP$ (Donate)	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'. Last edited by killaklown; 07-04-2006 at 07:52 PM.

07-04-2006, 08:00 PM	#4 (permalink)
wackyjoe NamePros Regular Join Date: Dec 2005 Posts: 206 270.00 NP$ (Donate)	i would use mysql_fetch_array(). __________________ Free WebProxy // ProxBot!ImagePros.us - FREE Image Hosting! Try us out www.team-shock.com \|F.L.U.M.P Mutuo 100%\|Partito Di Dio X-Box Advice \| LazyArcade.com \| Itachi.info

07-05-2006, 11:57 AM	#8 (permalink)
Flubber NamePros Regular Join Date: Jun 2005 Location: UK Posts: 691 25.95 NP$ (Donate)	PHP Code: `<? $query = "SELECT downloads FROM counter WHERE id='1'"; $result = mysql_query($query); $myrecord = mysql_fetch_row($result); echo $myrecord['0']; ?>` Should work. Flubb.

07-04-2006, 07:40 PM	#2 (permalink)
Dan Buy my domains. Join Date: Feb 2006 Posts: 2,801 56.00 NP$ (Donate)	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, 08:31 PM	#5 (permalink)
Dan Buy my domains. Join Date: Feb 2006 Posts: 2,801 56.00 NP$ (Donate)	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, 09:50 AM	#6 (permalink)
killaklown Senior Member Join Date: Oct 2003 Location: Winnipeg, Canada Posts: 3,472 5.31 NP$ (Donate)	i tried using mysql_fetch_array() but it still showed array.

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

07-05-2006, 04:59 PM	#9 (permalink)
killaklown Senior Member Join Date: Oct 2003 Location: Winnipeg, Canada Posts: 3,472 5.31 NP$ (Donate)	thanks flubber, works.

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