Jump to content
Posted 01 March 2013 - 05:36
Posted 01 March 2013 - 05:42
Posted 01 March 2013 - 05:55
Posted 01 March 2013 - 06:35
SELECT Link FROM Links WHERE UserID in (SELECT UserID FROM Login WHERE Username = "articuno1au")Would return:
Posted 01 March 2013 - 18:15
Posted 01 March 2013 - 18:23
Posted 02 March 2013 - 03:51
FYI stackoverflow is a good resource
When you start getting more comfortable you will start finding ways to make the tables optimal for each application use
Practice always helps!
actually looking at others applications/programs/scripts or however you wish to pass it on as helps tons!
Those seem like decent articles
Posted 02 March 2013 - 06:10
Posted 02 March 2013 - 18:09
That's great advice, thanks!
The bit that requires special attention is securing the scripts that are running.
Having logins and submitting new links equals web forms and the use of GET and POST so you'll be wanting to do a bit of work to make sure your DB queries and inserts are secured from iffy SQL injection or other dodgy user inputs. Don't just think mysqli_real_escape_string will do the job...it'll likely not even work unless you've covered the configuration of the host in advance.
Working for a web design/development company I've seen a few rather farcical examples of "content management systems" that so called developers (created by others outside our company) have written in PHP that miss or just ignore these risks.
I'm in the middle of writing my own (super simple) blog and even though it's literally bare-bones (has no comments system yet and probably wont) and a few pages to list the articles/archive it's something I have to pay attention to as well.
Posted 02 March 2013 - 23:09
Teknikal you plan on open sourcing it?