How to create XML with PHP Mysql

How To Create XML With PHP MySQL

Nobody can deny the power and benefits of XML which is mostly used in Java and .Net environment extensively. Using XML in PHP is also very popular and you will notice many PHP based web applcations using XML to it’s extent. A popular PHP/Zend software Magento ecommerce is also using XML a lot which tells […]

Continue Reading →

database-tables

Dangers of Adding fields to Database Tables

There are certain dangers if you don’t plan carefully before adding fields to your database. Though, it seems obvious but its not as simple as you might think. If you don’t plan properly you may miss something or ruin the current table which will consume lot of your time fixing. You must have come to […]

Continue Reading →

MySQL: foreign keys and referential integrity

Recent versions of MySQL have implemented support for foreign keys through the InnoDB table engine. Following is an explaination of how it works. Referential integrity is an important concept in database design. The term refers to a state when all the references in a database are valid and no invalid links exist between the various […]

Continue Reading →

Secure sensitive data in MySQL with few easy steps

Many hackers constantly try to breach your secure data and steal your secure information away. People generally think that they can’t secure their data actively but this isn’t true. If you’re using MySQL, there are some easy things you can do to secure your systems and significantly reduce the risk of unauthorised access to your […]

Continue Reading →

Setting-Up a Relational Database in MySQL

Relational Database Design is one of the most powerful ways to ensure data integrity and a great way to kick-off any project. Very often the first thing developers do when starting a new project, or stub-project, is to design the database. This way the structure of the application is already in place and we just […]

Continue Reading →

PHP: Securing Your Input Forms From MySQL Injection Attacks

Every website has ‘em. Forms. Places for users to enter data into your website. Whether it be a search box, a “Contact Us” form, or variables in the website address, at some point in the flow of your script these suckers are going to touch your database. Oh, that’s no problem — We’ll just take […]

Continue Reading →

Database Normalization and Table structures

Normalisation is the term used to describe how you break a file down into tables to create a database. There are 3 or 4 major steps involved known as 1NF (First Normal Form), 2NF (Second Normal Form), 3NF (Third Normal Form) and BCNF (Boyce-Codd Normal Form). There are others but they are rarely if ever […]

Continue Reading →

Free PHP Scripts, Source Code and Tutorial Website List

Following are the websites list who provide free php scripts. You can find lots of information about PHP as well as free code samples, code galleries, and free scripts for download at these and other sites. There may be some premium php scripts which may come for a price but overall the list is good […]

Continue Reading →

Parsing XML using PHP : Good example

The following example illustrates how to use an external entity reference handler to include and parse other documents, as well as how PIs can be processed, and a way of determining “trust” for PIs containing code. Consider the following XML’s < ?xml version=’1.0′?> < !DOCTYPE chapter SYSTEM “/just/a/test.dtd” [ <!ENTITY plainEntity “FOO entity”> < !ENTITY […]

Continue Reading →

Parsing XML using PHP

Load an XML file as data using PHP By handling mime-types and using browser detection, CodeHelp has already shown how to export XML using a PHP script. PHP can also receive XML as input – using the XML parser: if (!([email protected]("./contactsbare.xml", "r")))         die ("Couldn’t open XML."); $usercount=0; $userdata=array(); $state=”; if (!($xml_parser = xml_parser_create()))         […]

Continue Reading →