PHP/ASP

[PeiWen]

Anyone has useful links regarding the topic above? Or anyone has any tips or advice in learning ASP and PHP?

Thanks a lot.

[luke]

I learnt PHP solely from www.php.net and I think that site rox!

[PeiWen]

Thanks so much Luke :wink:

[chenchow]

I think a good way to learn will be trial and error. I had 6 lectures (75 minutes per lecture) of PhP and mySQL and at the end of it, we could design a basic forum and guestbook. So, I think it is not too difficult to handle.

[masterof_none]

just an addition to Luke's post on php.net.

a fast way to find some doc, is to type : php.net/something.

example, php.net/array (http://www.php.net/array) then , it would go to array doc right away.

[littlebigone]

set up your comp as a server. It's much easier than to find some hosting company that serves php.

As recommended by Luke, I also recommend using the YellowTip server.

Easy for newbies and good enough for people who know what they're doing.

oh and if you're doing php, you probably want to dabble in mySql too.

[bachok83]

if you guys wanna setup a server on your computer yourself,
i've created a "pretty" complete tutorial on how to install apache+php+mysql from A to Z.

hit this link if you are interested. (i'm sorry it's in Malay - since people there requested it to be in Malay)
http://phpnuke.com.my/2004/modules.php?name=Tutorial2

anyway, in addition to luke and masterof_none, i found that php.net is the best website you could refer to. However, the website doesnt provide forums that sometimes you need to refer to some people. I found this forum is very helpful.

http://www.phpbuilder.com/board

and now, i'm stuck... i wanna learn how to use mysql (i mean how to write script to connect+retrieve+write+create initial database)

i guess chenchow could help me, if you are free. Since my "sensei" (luke) is not available at the moment. Or could you tell me where i can find such tuto to make my life complete... lol

thanks in advance

[luke]

whaddaya mean I'm not available? I'm still single maa ... hehehe :wink:

if you want to learn mysql syntax, I suggest finding a book .. the online documentation is not so beginner-friendly ... if you want to learn how to use mysql from php, again, I suggest www.php.net :)

anyway, mysql thru php is not so hard ... first, you connect to the database using mysql_connect() ... then construct the query you want and pass it to mysql_query() ... to extract the returned rows, use mysql_fetch_row() on the return value of the previous mysql_query() ... to write to mysql is pretty simple ... just contruct the query with all the data included and pass it to mysql_query() ... you are basically done ...

mysql basic query formats:

read data:
SELECT *FROM table_name WHERE column_name='value'
-or-
SELECT column_name1,column_name2 FROM table_name WHERE column_name='value'

write data:
INSERT INTO table_name (column_name1, column_name2) VALUES ('data1', 'data2')

[bachok83]

hmm.. that sounds easy.. let see how easy it is when i'm coding it.. lol

[chenchow]

I think an easy way for anyone to practice on those SELECT, INSERT etc functions of mysql would be to play with it in MS Access. Just set up any database and then use those functions to play with it... It will help.

[bachok83]

thx chenchow and luke.. i got it to work now... woohooo... it's pretty simple actually, after reading the your posts and some posts by some users in the php.net

[sarahkj]

those who interested to join IT course tuition, just let me know


sara
012-6636739