http://www.roughguidetophp.com An introductory tutorial to the world of PHP. Some more advanced subjects too Mon, 23 Mar 2009 17:43:59 +0000 http://backend.userland.com/rss092 en Now it’s time to get down to the real task at hand - actually creating a working web-page using PHP. In this tutorial, I’ll show you how to create a simple web-page to demonstrate how to add a little bit of dynamic jazz to an otherwise static site. Mixing PHP with ... http://www.roughguidetophp.com/adding-php-to-html-files/ What is MySQL? If you’re reading this tutorial, there’s a good chance you’ve already gained a reasonable familiarity with PHP programming, and can piece together a simple application with a few lines of code. If not, why not head on over to the PHP Tutorial section for a quick refresher course? If ... http://www.roughguidetophp.com/an-introduction-to-mysql-with-php/ Website design with PHP It’s quite likely you’ve reached this page because you’re interested in learning how to build your first website with PHP, or modify your existing website to make use of PHP. It’s also quite likely, if you’re just starting out with PHP, or programming in general, that you ... http://www.roughguidetophp.com/an-introduction-to-php/ Arrays There are times in programming where you need to keep track of many variables at once. Maybe the current time of day, the number of items in a package or the name of a certain product. These variables may all be very similar too though, you might, for example, need ... http://www.roughguidetophp.com/arrays-in-php/ So far throughout this tutorial, we’ve been looking at a method of programming called “procedural programming” in which program execution proceeds in a linear fashion, from start to finish and makes use of procedure calls. Procedures, which we’ve come to know as functions, allow us to execute arbitrary code segments ... http://www.roughguidetophp.com/classes-and-object-oriented-programming-in-php/ Conditional statements are used in PHP (and in any other programming language) when the programmer wishes to place a branch in the code, where a specific result will occur if, and only if, a set of conditions is matched. A real world example might be I will go to the cinema ... http://www.roughguidetophp.com/conditional-statements-in-php/ Functions are arguably one of the most useful features of PHP. They allow a programmer to encapsulate sections of code within a structure which can then be executed from anywhere else in the program flow. Functions are instantiated by use of the function keyword, followed by the user-defined function name ... http://www.roughguidetophp.com/functions-in-php/ Introduction to Loops Loops in PHP are very useful when you need to perform repetitions of the same code over and over again, or when you need to ensure that you iterate through all possible values of an array, for example. They come in a few different flavours, the most common ... http://www.roughguidetophp.com/loops-in-php-while-and-for/   (The files used in this tutorial are available to download here) Pagination Sometimes when working with a MySQL powered website in PHP, we’ll come across situations where we have multiple records that we wish to display to the visitor. If there are many tens, hundreds or more of these results, we might ... http://www.roughguidetophp.com/pagination-splitting-data-across-multiple-pages-with-mysql-and-php/ One of the more surprising things you can learn about PHP is that it’s actually very useful when it comes to manipulating images of varying filetypes and formats. And a good thing too, since a lot of the internet is made up of pictures! The functionality of PHP in terms of ... http://www.roughguidetophp.com/php-image-manipulation-with-gd2/ Saving a PHP file A PHP file is basically a text file containing all the required PHP code to run a specific program. PHP code can be written with the use of a simple text editor, like Windows Notepad, or the more useful Crimson Editor. All you need to do ... http://www.roughguidetophp.com/php-syntax/ When developing a PHP project, whether it’s a simple website or a much larger web application, it’s always a good idea to take into account the potential appearance of errors in your PHP code. An error occurs whenever PHP tries to execute an instruction which either results in an ... http://www.roughguidetophp.com/reporting-and-handling-errors-in-php/ Variables are probably one of the most commonly used code constructs you’ll come across while programming. If you have any experience of mathematics, especially algebra, you’ll be aware of the concept of using symbols to represent unknown quantities in equations, like in the following example x + 5 = 7; from this ... http://www.roughguidetophp.com/variables-in-php/ When developing more complex PHP sites, especially forums, discussion boards and blogs where date and time functions are important, you’ll regularly encounter situations where you need to display and manipulate values based around the current date and time. PHP includes a range of functions which can help you to easily ... http://www.roughguidetophp.com/working-with-dates-and-times-in-php/ Verifying a Valid UsernameVerifying Valid DatesValidating IP AddressesMatching Phone Numbers, Postcodes, Social Security numbers etcValidating Email AddressesVerifying Credit Card NumbersReplacing Static Links with Hyperlinks in HTMLRemoving Swearing and Profanity from blogs and forumsStripping out Bad Attributes and Javascript from HTML codeBBCode - Custom Formatting DefinitionsConclusion Regular expression are one of the ... http://www.roughguidetophp.com/10-regular-expressions-you-just-cant-live-%20without-in-php/ http://www.roughguidetophp.com/2008/ (Download all the files used in this tutorial here) Visitor Tracking and Analysis When running a website, whether it’s a small personal homepage, or a large site for a company, it’s useful to be able to know who is visiting your site, and what they’re up to while they’re there. If you ... http://www.roughguidetophp.com/a-simple-ip-address-and-visitor-tracking-tool-with-php-mysql/ Cleaning up User Input for MySQLDealing With Invalid User DataCase 1 - Invalid HTML TagsSolution 1 : Stripping out HTML tags before inserting via MySQLCase 2 : Using apostrophes and quotation marks in commentsSolution 2 : Escaping quotation characters with mysql_real_escape_string()Case 3 : Preventing SQL injection attacksSolution 3 : Prepare ... http://www.roughguidetophp.com/cleaning-up-user-data-in-mysql/ MySQL and Data Storage MySQL stores data in a tabular format, which makes it easy to visualise the information and print it out in a way that you or I can easily understand. Like all tables, it uses horizontal rows to store individual records, and vertical columns to assign labels to ... http://www.roughguidetophp.com/column-and-data-types-in-mysql/ Now that we’ve got a simple understanding of how to perform SELECT, INSERT and UPDATE MySQL queries (and if not, have a quick review from the last couple of tutorials) we can now work on building ourselves a very simple PHP application to accept user data and save it into ... http://www.roughguidetophp.com/creating-a-simple-comments-and-login-system-using-mysql-and-php/