I am having trouble finding information about sql, i have created a database with information in it, but have absolutely no idea at all how to get this to display on my webpage, do you have to write something within your html,or link to it somehow like an external style sheet, I have absolutely no idea of what to do next,:nuts:
sql database
- Thread starter wendyait
- Start date
- Status
- Messages
- 4,565
- Reaction score
- 245
- Points
- 63
Start with http://www.w3schools.com/PHP/php_mysql_intro.asp
If you don't know the php then start to learn it first.
If you don't know the php then start to learn it first.
PHP isn't the only option, but it's probably the best choice on X10. Second is Perl. There's also ASP.Net, Python and Perl. ASP.Net and Python each has it's own difficulties here when it comes to MySQL, otherwise I'd recommend Python over Perl.
The W3Schools PHP+MySQL tutorial is terrible. Its use of the old MySQL driver is out of date. Its use of "die" for errors is just wrong. It doesn't teach about SQL injection. It uses "SELECT *", which makes it difficult to restructure tables without having to first find then fix all the code that interacts with the table; in short, it's a maintenance nightmare. Better to google for a PDO tutorial.
You'll also need to learn some database design. You could try Maurer and Scherbakov's "Introduction to Databases and Relational Data Model", or check out the suggestions in the StackOverflow questions "Good Resources for Relational Database Design", "Relational database theory and SQL book recommendations?", "How should a programmer learn great database design?" and "Database Design Best Practices". Note: SO is a Q&A site, not a forum. If you wish to ask questions there, read the FAQ and lurk for a bit to learn how it works.
The W3Schools PHP+MySQL tutorial is terrible. Its use of the old MySQL driver is out of date. Its use of "die" for errors is just wrong. It doesn't teach about SQL injection. It uses "SELECT *", which makes it difficult to restructure tables without having to first find then fix all the code that interacts with the table; in short, it's a maintenance nightmare. Better to google for a PDO tutorial.
You'll also need to learn some database design. You could try Maurer and Scherbakov's "Introduction to Databases and Relational Data Model", or check out the suggestions in the StackOverflow questions "Good Resources for Relational Database Design", "Relational database theory and SQL book recommendations?", "How should a programmer learn great database design?" and "Database Design Best Practices". Note: SO is a Q&A site, not a forum. If you wish to ask questions there, read the FAQ and lurk for a bit to learn how it works.
Last edited:
- Status