News: TinyPortal Release Schedule. Please read this update for More Info.

Login  |  Register
HTML5 Icon HTML5 Icon
TP on Social Media
Welcome, Guest. Please login or register.
Did you miss your activation email?

October 18, 2019, 08:29:22 PM

Login with username, password and session length

Recent

Members
  • Total Members: 3756
  • Latest: Ocean
Stats
  • Total Posts: 189090
  • Total Topics: 20764
  • Online Today: 73
  • Online Ever: 629
  • (November 08, 2018, 01:36:54 PM)
Users Online
Users: 0
Guests: 34
Total: 34

Author Topic: Learning PHP & MYSQL  (Read 1886 times)

0 Members and 1 Guest are viewing this topic.

akulion

  • Guest
Learning PHP & MYSQL
« on: August 19, 2006, 06:25:33 AM »
Hi everyone

Well I have started learning some PHP and MYSQL from http://www.w3schools.com

And up to now I've managed to create a simple database with 2 feilds.
New entries can be made via a small admin console (which isnt password protected lol)
And entries can also be deleted from there as long as you know the value

Now I have basically come to an end of the tutorial available on that site so I wanted to ask you guys for help if you know of tutorials which will allow me to learn the following things:

- Searching and displaying specific feilds from the DB

- Creating a password protected admin panel

- Inserting images in to the DB and displaying them by calling them from the DB randomly or sequentially

- Joining data from 2 tables to create one feild output

- Creating random results using arrays...basically what i would like to achieve is that lets say I enter as my primary key the word "Akulion" - now the query should check each alphabet in he word and generate an output from another table of words like so:

A - Amazing
K - Kookoo
U - Ultimate
L - Lazy
I - Interesting
O - Obnixious
N - Naughty

So if anyone knows some good learning resources out there can you please share them here?

Something like the w3schools website - easy to understand and follow

Thanks

=========================

Just in case someone is curious what I am trying to create, have a look at this thread on my forum: Secrets of your name

alan s

  • Guest
Re: Learning PHP & MYSQL
« Reply #1 on: August 19, 2006, 06:58:50 AM »
Well this might help akulion , i found this ebook a few months ago on a freeware/ebook site.

http://rapidshare.de/files/29977451/TYPHPMySQLApache24.rar


Teachs php and mysql

Offline hygron

  • Full Member
  • ***
  • Posts: 242
Re: Learning PHP & MYSQL
« Reply #2 on: August 19, 2006, 07:14:29 AM »
Alan.  Are you saying the free version teaches php and mysql?  I hate to download something that I can't preview.  Looks interesting

yj98

  • Guest
Re: Learning PHP & MYSQL
« Reply #3 on: August 19, 2006, 07:16:22 AM »
No. Its Free version CHM file and I download it recently..

akulion

  • Guest
Re: Learning PHP & MYSQL
« Reply #4 on: August 19, 2006, 07:17:28 AM »
thanks alan ill have a look :D

alan s

  • Guest
Re: Learning PHP & MYSQL
« Reply #5 on: August 19, 2006, 07:39:11 AM »
Screenshot of what the ebook looks like/some of its content is attached to this post

akulion

  • Guest
Re: Learning PHP & MYSQL
« Reply #6 on: August 19, 2006, 07:40:43 AM »
this is a nice book

it has everything i will need - thanks again :D

Offline hygron

  • Full Member
  • ***
  • Posts: 242
Re: Learning PHP & MYSQL
« Reply #7 on: August 21, 2006, 02:50:14 AM »
thanks...Y'all, I will try it out myself