SimpleXML is a PHP extension that allows us to easily manipulate and get XML data. The SimpleXML Parser SimpleXML is a tree-based parser. SimpleXML provides an easy way of getting an element’s name, attributes and textual content if you know…
What is XML? The XML language is a way to structure data for sharing across websites. Several web technologies like RSS Feeds and Podcasts are written in XML. XML is easy to create. It looks a lot like HTML, except…
Limit Data Selections From a MySQL Database MySQL provides a LIMIT clause that is used to specify the number of records to return. The LIMIT clause makes it easy to code multi page results or pagination with SQL, and is…
Update Data In a MySQL Table Using MySQLi and PDO The UPDATE statement is used to update existing records in a table: UPDATE table_name SET column1=value, column2=value2,… WHERE some_column=some_value Notice the WHERE clause in the UPDATE syntax: The WHERE clause…
Delete Data From a MySQL Table Using MySQLi and PDO The DELETE statement is used to delete records from a table: DELETE FROM table_name WHERE some_column = some_value Notice the WHERE clause in the DELETE syntax: The WHERE clause specifies…
Select and Order Data From a MySQL Database The ORDER BY clause is used to sort the result-set in ascending or descending order. The ORDER BY clause sorts the records in ascending order by default. To sort the records in…
Select and Filter Data From a MySQL Database The WHERE clause is used to filter records. The WHERE clause is used to extract only those records that fulfill a specified condition. SELECT column_name(s) FROM table_name WHERE column_name operator value
Select Data From a MySQL Database The SELECT statement is used to select data from one or more tables: SELECT column_name(s) FROM table_name or we can use the * character to select ALL columns from a table: SELECT * FROM…
Prepared statements are very useful against SQL injections. Prepared Statements and Bound Parameters A prepared statement is a feature used to execute the same (or similar) SQL statements repeatedly with high efficiency.
