Web programming Tutorial

Mysql Date and Time Data Types

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; vertical-align: baseline;">
MySQL provides types for date and time and combination of date and time. In addition, MySQL also provide timestamp data type for tracking last change on a record. If you just want to store the year without date and month, you can use YEAR data type. Here is the table which showing MySQL date and type data types:</div>
<table border="0" cellpadding="0" style="background-color: white; border-bottom-color: rgb(221, 221, 221); border-bottom-style: solid; border-spacing: 0px; border-width: 0px 0px 1px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin: 0px 0px 1.625em; outline: 0px; padding: 0px; vertical-align: baseline; width: 690px;"><thead style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
<tr style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; vertical-align: baseline;" width="186"><div align="center" style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.625em; outline: 0px; padding: 0px; vertical-align: baseline;">
<strong style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Date and Time Types</strong><strong style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></strong></div>
</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; vertical-align: baseline;" width="369"><div align="center" style="border: 0px; font-family: inherit; font-style: inherit; margin-bottom: 1.625em; outline: 0px; padding: 0px; vertical-align: baseline;">
<strong style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Description</strong><strong style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></strong></div>
</td></tr>
</thead><tbody style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
<tr style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; vertical-align: baseline;" width="186">DATE</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; vertical-align: baseline;" width="369">A date value in ‘YYYY-MM-DD’ format</td></tr>
<tr style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; vertical-align: baseline;" width="186">TIME</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; vertical-align: baseline;" width="369">A time value in ‘hh:mm:ss’ format</td></tr>
<tr style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; vertical-align: baseline;" width="186">DATETIME</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; vertical-align: baseline;" width="369">A date and time value in ‘YYYY-MM-DD hh:mm:ss’ format</td></tr>
<tr style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; vertical-align: baseline;" width="186">TIMESTAMP</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; vertical-align: baseline;" width="369">A timestamp value in ‘YYYY-MM-DD hh:mm:ss’ format</td></tr>
<tr style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; vertical-align: baseline;" width="186">YEAR</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; vertical-align: baseline;" width="369">A year value in YYYY or YY format</td></tr>
</tbody></table>
<h2 style="background-color: white; border: 0px; clear: both; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin: 0px 0px 0.8125em; outline: 0px; padding: 0px; vertical-align: baseline;">
</h2>
<h2 style="background-color: white; border: 0px; clear: both; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin: 0px 0px 0.8125em; outline: 0px; padding: 0px; vertical-align: baseline;">
Spatial Data Types</h2>
<div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; vertical-align: baseline;">
MySQL support many spatial data types as below table which contains various kind of geometrical and geographical values.</div>
<br />
<h3 style="background-color: white; border: 0px; clear: both; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 10px; font-weight: inherit; letter-spacing: 0.1em; line-height: 2.6em; margin: 0px; outline: 0px; padding: 0px; text-transform: uppercase; vertical-align: baseline;">
</h3>
<br />
<table border="0" cellpadding="0" style="-webkit-text-stroke-width: 0px; background-color: white; border-bottom-color: rgb(221, 221, 221); border-bottom-style: solid; border-collapse: separate; border-spacing: 0px; border-width: 0px 0px 1px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; font-style: normal; font-variant: normal; font-weight: 300; letter-spacing: normal; line-height: 24px; margin: 0px 0px 1.625em; orphans: auto; outline: 0px; padding: 0px; text-align: start; text-indent: 0px; text-transform: none; vertical-align: baseline; white-space: normal; widows: auto; width: 690px; word-spacing: 0px;"><thead style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
<tr style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="204"><div align="center" style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px 0px 1.625em; outline: 0px; padding: 0px; vertical-align: baseline;">
<strong style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: bold; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Spatial Data Types</strong><strong style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: bold; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></strong></div>
</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="255"><div align="center" style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px 0px 1.625em; outline: 0px; padding: 0px; vertical-align: baseline;">
<strong style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: bold; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Description</strong><strong style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: bold; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></strong></div>
</td></tr>
</thead><tbody style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
<tr style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="204">GEOMETRY</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="255">A spatial value of any type</td></tr>
<tr style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="204">POINT</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="255">A point (a pair of X Y coordinates)</td></tr>
<tr style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="204">LINESTRING</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="255">A curve (one or more POINT values)</td></tr>
<tr style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="204">POLYGON</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="255">A polygon</td></tr>
<tr style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="204">GEOMETRYCOLLECTION</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="255">A collection of GEOMETRY values</td></tr>
<tr style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="204">MULTILINESTRING</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="255">A collection of LINESTRING values</td></tr>
<tr style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="204">MULTIPOINT</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="255">A collection of POINT values</td></tr>
<tr style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="204">MULTIPOLYGON</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="255">A collection of POLYGON values</td></tr>
</tbody></table>
</div>

Mysql Date and Time Data Types

MySQL provides types for date and time and combination of date and time. In addition, MySQL also provide timestamp data type for tracking ...

10:04 PM

Mysql String Data Types

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; vertical-align: baseline;">
In MySQL, string can hold anything from plain text to binary data such as images and files. String can be compared and searched based on pattern matching by using LIKE clause or regular expression. The table below shows you the string data types in MySQL:</div>
<br />
<h2 style="background-color: white; border: 0px; clear: both; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin: 0px 0px 0.8125em; outline: 0px; padding: 0px; vertical-align: baseline;">
</h2>
<br />
<table border="0" cellpadding="0" style="-webkit-text-stroke-width: 0px; background-color: white; border-bottom-color: rgb(221, 221, 221); border-bottom-style: solid; border-collapse: separate; border-spacing: 0px; border-width: 0px 0px 1px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; font-style: normal; font-variant: normal; font-weight: 300; letter-spacing: normal; line-height: 24px; margin: 0px 0px 1.625em; orphans: auto; outline: 0px; padding: 0px; text-align: start; text-indent: 0px; text-transform: none; vertical-align: baseline; white-space: normal; widows: auto; width: 690px; word-spacing: 0px;"><thead style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
<tr style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="156"><div align="center" style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px 0px 1.625em; outline: 0px; padding: 0px; vertical-align: baseline;">
<strong style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: bold; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">String Types</strong><strong style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: bold; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></strong></div>
</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="413"><div align="center" style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px 0px 1.625em; outline: 0px; padding: 0px; vertical-align: baseline;">
<strong style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: bold; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Description</strong><strong style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: bold; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"></strong></div>
</td></tr>
</thead><tbody style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
<tr style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="156">CHAR</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="413">A fixed-length non-binary (character) string</td></tr>
<tr style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="156">VARCHAR</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="413">A variable-length non-binary string</td></tr>
<tr style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="156">BINARY</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="413">A fixed-length binary string</td></tr>
<tr style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="156">VARBINARY</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="413">A variable-length binary string</td></tr>
<tr style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="156">TINYBLOB</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="413">A very small BLOB (binary large object)</td></tr>
<tr style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="156">BLOB</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="413">A small BLOB</td></tr>
<tr style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="156">MEDIUMBLOB</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="413">A medium-sized BLOB</td></tr>
<tr style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="156">LONGBLOB</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="413">A large BLOB</td></tr>
<tr style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="156">TINYTEXT</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="413">A very small non-binary string</td></tr>
<tr style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="156">TEXT</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="413">A small non-binary string</td></tr>
<tr style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="156">MEDIUMTEXT</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="413">A medium-sized non-binary string</td></tr>
<tr style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="156">LONGTEXT</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="413">A large non-binary string</td></tr>
<tr style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="156">ENUM</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="413">An enumeration; each column value may be assigned one enumeration member</td></tr>
<tr style="border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="156">SET</td><td style="border-top-color: rgb(221, 221, 221); border-top-style: solid; border-width: 1px 0px 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: normal; margin: 0px; outline: 0px; padding: 6px 10px 6px 0px; text-align: left; vertical-align: baseline;" width="413">A set; each column value may be assigned zero or more set members</td></tr>
</tbody></table>
</div>

Mysql String Data Types

In MySQL, string can hold anything from plain text to binary data such as images and files. String can be compared and searched based on p...

10:02 PM

MySQL Numeric Data Types

MySQL Numeric Data Types

You can find all SQL standard numeric types in MySQL including exact number data type and approximate numeric data types including integer...

10:01 PM

Understanding MySQL Table Types

Understanding MySQL Table Types

MySQL supports various of table types or storage engines to allow you to optimize your database. The table types are available in MySQL ar...

10:00 PM

Delete the unused database in mysql

<div dir="ltr" style="text-align: left;" trbidi="on">
<code class="keyword" style="background-color: white; background-image: none !important; border: 0px !important; bottom: auto !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 15px; font-weight: bold !important; height: auto !important; left: auto !important; line-height: 16.5px; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">DROP</code><span style="background-color: white; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace; font-size: 15px; line-height: 16.5px;"> </span><code class="keyword" style="background-color: white; background-image: none !important; border: 0px !important; bottom: auto !important; color: rgb(0, 102, 153) !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 15px; font-weight: bold !important; height: auto !important; left: auto !important; line-height: 16.5px; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">DATABASE</code><span style="background-color: white; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace; font-size: 15px; line-height: 16.5px;"> </span><code class="plain" style="background-color: white; background-image: none !important; border: 0px !important; bottom: auto !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 15px; height: auto !important; left: auto !important; line-height: 16.5px; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">IF EXISTS mydb;</code><br />
<code class="plain" style="background-color: white; background-image: none !important; border: 0px !important; bottom: auto !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 15px; height: auto !important; left: auto !important; line-height: 16.5px; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"><br /></code>
<div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; vertical-align: baseline;">
After executing the statement, MySQL will returns you a message to notify the new database dropped successfully or not.</div>
<code class="plain" style="background-color: white; background-image: none !important; border: 0px !important; bottom: auto !important; direction: ltr !important; display: inline !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 15px; height: auto !important; left: auto !important; line-height: 16.5px; margin: 0px !important; outline: 0px !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"></code><br />
<h3 style="background-color: white; border: 0px; clear: both; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 10px; font-weight: inherit; letter-spacing: 0.1em; line-height: 2.6em; margin: 0px; outline: 0px; padding: 0px; text-transform: uppercase; vertical-align: baseline;">
DISPLAY</h3>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIXddFDigDOSTYvJQAITzcsZtfWmsz-bj3LBVmu3HnJnWwPwQlIxkOZpy4R4Nmv_bEaEHXhPEBwlFlThUXYrm6sBoR74luIPWgMJc0K3rpO3SJcq5oAlmC4Mb7kmXfX7IPySyRnwWgaLnC/s1600/mysql4.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="143" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIXddFDigDOSTYvJQAITzcsZtfWmsz-bj3LBVmu3HnJnWwPwQlIxkOZpy4R4Nmv_bEaEHXhPEBwlFlThUXYrm6sBoR74luIPWgMJc0K3rpO3SJcq5oAlmC4Mb7kmXfX7IPySyRnwWgaLnC/s320/mysql4.jpg" width="320" /></a></div>
<div>
<br /></div>
</div>

Delete the unused database in mysql

DROP DATABASE IF EXISTS mydb; After executing the statement, MySQL will returns you a message to notify the new database dropped suc...

9:59 PM

how to Select the database in mysql

how to Select the database in mysql

If you want to CREATE, INSERT, UPDATE, ALTER or DELETE a table, you need to select a database. Thus, you need to call the common use in or...

9:58 PM

ho to Create A Database in mysql

ho to Create A Database in mysql

We need a database, and in order to create a database you need to use the following syntax. CREATE A NEW DATABASE NAME CALLED MYDB C...

9:57 PM

Start mysql

Start mysql

This section helps you to get familiar with basic MySQL including managing MySQL database and manipulating data using various SQL statemen...

9:55 PM

A Simple Contact Us Forms Using PHP

<label>Email</label><input name="email" type="text" size="45" /><br />

<label>Website</label><input name="website" type="text" size="45" /><br />

</fieldset>

<legend>Your Message</legend>

<label>Subject</label><input name="subject" type="text" size="45" /><br />

<label>Message</label><textarea name="message" cols="35" rows="7"></textarea>

</fieldset>

</form>
</pre>
<div>
<br /></div>
<div>
<span style="background-color: white; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; text-align: justify;">Ok, Now let’s style the forms using css, create a new css document and name it</span><em style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">”</em><span style="background-color: white; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; text-align: justify;">, and then copy & paste the below code in</span><em style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">”</em><span style="background-color: white; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; text-align: justify;">:</span></div>
<div>
<span style="background-color: white; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; text-align: justify;"><br /></span></div>
<div>
<pre>.form {
margin:0;
padding:0;
font-family:"Palatino Linotype", "Book Antiqua", Palatino, serif;
font-size:16px;
}
.form fieldset{
border: #cce0b8 solid 1px;
width:30%;
margin-bottom:20px;
background-color: #f1ffe3;
}
.form legend{
text-transform:uppercase;
font-size:14px;
padding:4px;
background-color: #cce0b8;
color: #3b6d0a;
}
.form label{
display: inline-block;
width:14%;
text-align:right;
padding:4px;
vertical-align:top;
}
.form input{
border:1px solid #cce0b8;
padding:4px;
color: #48820e;
}
.form textarea{
border:1px solid #cce0b8;
padding:6px;
color: #3a6c08;
}
.errors{
color: #900;
margin:10px;
font-size:18px;
font-style:italic;
border-bottom:1px dotted #CCC;
width:20%;
}
.done{
color: #090;
margin:10px;
font-size:18px;
font-style:italic;
border-bottom:1px dotted #CCC;
width:25%;
}</pre>
<pre>
</pre>
<pre><div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline; white-space: normal;">
Copy and Paste the below code in<em style="border: 0px; font-family: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">></em> to Include the <em style="border: 0px; font-family: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><body></em></div>
<div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline; white-space: normal;">
<link href=”stylesheet.css” rel=”stylesheet” type=”text/css” /></div>
<div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline; white-space: normal;">
That’s it we are 70% done, now lets do the coding, add the below code in the  tag, i have add it above the html forms:</div>
<pre><?php

if(isset($_POST['sendmail'])){

$name = $_POST['name'];

$email = $_POST['email'];

$website = $_POST['website'];

$subject = $_POST['subject'];

$message = $_POST['message'];

$to = "support@w3programmers.com";               // << write your own email here

if(empty($name) OR empty($email) OR empty($subject) OR empty($message)){

echo "<div class='errors'>Sorry, You must fill the required fields<strong>(*)</strong></div>";

}else{

@mail($to,$subject,$message,"From: $name  <$email>");

echo "<div class='done'>Email has been sent, we will get back to you ASP!</strong></div>";

}

}?>
</pre>
<div>
</div>
<div>
<span style="background-color: white; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; text-align: justify; white-space: normal;">Now Our Output Look Like</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1KlfRoMM87BZFHM01Kd4oNf7t-aQZCXTYkisav0eyLg1wvix3jdirnVlm7KRP8kDDqE7LF5pe895WrRKWUtkl2Rj-Au2Bwcwhnt6fw8nnGV-jvUyeYCtKGm-oLGD_TNK0IHM6FM__5-oc/s1600/contactus.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1KlfRoMM87BZFHM01Kd4oNf7t-aQZCXTYkisav0eyLg1wvix3jdirnVlm7KRP8kDDqE7LF5pe895WrRKWUtkl2Rj-Au2Bwcwhnt6fw8nnGV-jvUyeYCtKGm-oLGD_TNK0IHM6FM__5-oc/s320/contactus.png" width="270" /></a></div>
<div>
<span style="background-color: white; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; text-align: justify; white-space: normal;">
</span></div>
</pre>
</div>
</div>

A Simple Contact Us Forms Using PHP

In this tutorial i will show you, how to make a simple and clean contact us form using Php and Css, a simple contact us form with name, em...

2:45 AM

CRUD with PHP and MySQL

<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuy3h4S7E32ZwPOFVZFFVlBf7zZ1LD8DzU2RHdJJRqHRDMQcsweeNjzkIgotzJ0DpOCy3TChSqCbHFYKqJbhoqpRH6Hl_9DqUEZZSMb0M0gbe5y-EmVKWuS9OXIzCqARDIhURrrIXzaavX/s1600/php-crud.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="170" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuy3h4S7E32ZwPOFVZFFVlBf7zZ1LD8DzU2RHdJJRqHRDMQcsweeNjzkIgotzJ0DpOCy3TChSqCbHFYKqJbhoqpRH6Hl_9DqUEZZSMb0M0gbe5y-EmVKWuS9OXIzCqARDIhURrrIXzaavX/s320/php-crud.jpg" width="320" /></a></div>
<div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
In this tutorial we learn create, read, and update data Using PHP and MySQL. The programmers called it CRUD. CRUD means CREATE, READ, UPDATE and DELETE.</div>
<div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
Now we will focus on how to create new database record with PHP and MySQL.</div>
<div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
It is much better if you’ll create a separate file for connecting PHP to MySQL Database and just include it to any of your PHP files that needs it.</div>
<div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
For example, I will create a file named “config.php” (Configuration and then opening of the database) in our phpcrud folder and inside this file are the following codes:</div>
<pre><?php

$dbhost = "localhost";

$dbuser = "root";

$dbpass = "";

$dbname = "phpcrud";

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');

mysql_select_db($dbname) or die ('Unable to select database!');

?>
</pre>
<div>
<div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
Just to explain the above code…</div>
<div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
$dbhost = “localhost”;</div>
<div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
-$dbhost is the MySQL server that you are using. If you’re using your computer as your testing server, its value is usually “localhost”.</div>
<div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
$dbuser = “root”;</div>
<div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
$dbpass = “”;</div>
<div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
-These are the MySQL username and password that you have created or configured. The “root” and blank (“”) password are the usual settings when you haven’t configured it in your localhost. But you can changed them. For example, you are using PHPMyAdmin to manage your database, just find the privileges link.</div>
<div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
$dbname = “phpcrud “;</div>
<div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
-It is the name of your database.</div>
<div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die (‘Error connecting to mysql’);</div>
<div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
-It is the syntax for connecting to MySQL database. mysql_connect($dbhost, $dbuser, $dbpass) will do but you may add the or die (‘Error connecting to mysql’) for debugging purposes. The $conn variable is used for closing the database connection later.</div>
<div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
mysql_select_db($dbname) or die (‘Unable to select database!’);</div>
<div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
-This is the command for selecting the database you want to be connected with. In our example above, the $dbname (database name) is “phpcrud”.</div>
<div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
Sample table and data, you can run this script in your phpcrud database:</div>
<pre>CREATE TABLE IF NOT EXISTS `users` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `firstname` varchar(32) NOT NULL,
 `lastname` varchar(32) NOT NULL,
 `username` varchar(32) NOT NULL,
 `password` varchar(32) NOT NULL,
 `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=52 ;

INSERT INTO `users` (`id`, `firstname`, `lastname`, `username`, `password`, `modified`) VALUES
(28, 'John', 'Dalisay', 'john', 'john123', '2011-09-23 14:36:19'),
(39, 'aaa', 'aaa', 'aaa', 'aaa', '2011-09-23 15:44:04'),
(40, 'bbb', 'bbb', 'bbb', 'bbb', '2011-09-23 15:44:13'),
(41, 'ccc', 'ccc', 'ccc', 'ccc', '2011-09-23 15:44:32'),
(46, 'XXXDDD', '', '', '', '2011-09-23 17:13:15'),
(47, 'www', 'www', 'www', 'www', '2011-09-23 17:21:38'),
(48, 'HEHEHEHEHE', '', '', '', '2011-09-23 18:50:10'),
(49, 'www', 'www', 'www', 'www', '2011-09-23 19:28:24'),
(50, 'EEEE', 'EEEE', 'EEEE', 'EEEE', '2011-09-24 05:01:36'),
(51, 'asdf', 'asdf', 'asdf', 'asdf', '2011-10-04 18:44:19');
</pre>
</div>
<div>
<span style="background-color: white; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; text-align: justify;">Our insert.php will have the following code:</span></div>
<div>
<pre><html>

<head>

<title>Create - PHP CRUD</title>

</head>

<body>

<?php

if(isset($_POST['save'])){

//include database configuration

include 'config.php';

extract($_REQUEST);

//sql insert statement

$query=mysql_query("insert into users SET firstname='$firstname', lastname='$lastname', username='$username', password='$password'") or die(mysql_error());

//insert query to the database

if($query){

//if successful query

echo "New record was saved.";

}

<table>

<tr>

<td>Firstname</td>

</tr>

<tr>

<td>Lastname</td>

</tr>

<tr>

<td>Username</td>

</tr>

<tr>

<td>Password</td>

<tr>

<td>

</td>

</tr>

</table>

</form>

</body>

</html>
</pre>
</div>
<div>
<br /></div>
<div>
<strong style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">When the form is filled up and submitted, it will look like this:</strong></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2Bg2wwBPleNI7jTvynadFIkqy1pPGqJoRHOnoD-4ZKtTIyGdRlRxhMxYOO_4isP5N0Ct2cmCY7YTd_2YRNKdpK1Rr0AGLAA6-QosAMvjZnetbEucY6odnaUXsk6CsBO1S0QfJmvucZ0qT/s1600/phpcrud1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2Bg2wwBPleNI7jTvynadFIkqy1pPGqJoRHOnoD-4ZKtTIyGdRlRxhMxYOO_4isP5N0Ct2cmCY7YTd_2YRNKdpK1Rr0AGLAA6-QosAMvjZnetbEucY6odnaUXsk6CsBO1S0QfJmvucZ0qT/s1600/phpcrud1.png" /></a></div>
<div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
Now we will simply display data from MySQL database to HTML table with the help of PHP.</div>
<div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
Our <strong style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">show_data.php </strong>will have the following code:</div>
<pre><?php

//include database configuration

include 'config.php';

//selecting records

$sql="select firstname, lastname, username from users";

//query the database

$rs=mysql_query($sql) or die($sql.">>".mysql_error());

//count how many records found

$num=mysql_num_rows($rs);

if($num>0){ //check if more than 0 record found

<tr>

<th>Firstname</th>

<th>Lastname</th>

<th>Username</th>

</tr>

<?php

//retrieve our table contents

while($row=mysql_fetch_array($rs)){

//extract row

//this will make $row['firstname'] to

//just $firstname only

extract($row);

//creating new table row per record

<tr>

</tr>

<?php

}

</table>

<?php

}else{ //if no records found

echo "No records found.";

}

?>
</pre>
<div>
<strong style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">Our output will look like:</strong></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhScG3bkomBnBN9nkHdq97kxScv6iRzIZYeliFZRafpzPpBSsDAwwIBq4UAdd4iKq9CkcwVOgTmnAKc64ocvj0v3X_fJ8voyHiaZigHIXFgCJH1p4w-R6rsAsSBAU05_a0rSYnhr32IOaG1/s1600/phpcrud2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhScG3bkomBnBN9nkHdq97kxScv6iRzIZYeliFZRafpzPpBSsDAwwIBq4UAdd4iKq9CkcwVOgTmnAKc64ocvj0v3X_fJ8voyHiaZigHIXFgCJH1p4w-R6rsAsSBAU05_a0rSYnhr32IOaG1/s1600/phpcrud2.png" /></a></div>
<div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
Now we’re going to do a code that update a record from our MySQL database using PHP.</div>
<div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
First, we have to display our data to a table and put a new column called “action”. On the action column we’re gonna have the edit link for each record. Our <strong style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">update.php</strong> will have the following code:</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtRSOPGWzQMoDRLo8QxXTMQI7gyQ0owrBJltF5wpmt1tH60qJPYuDf8yQtPY6bwAXWPtUAe2NEhCcFwOpNT2rgnPQhfhuoeTbuKNC2GpCXlMaUlusGVTJD3iyD8_GczcUHGb2nmqZbDIPi/s1600/phpcrud3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="313" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtRSOPGWzQMoDRLo8QxXTMQI7gyQ0owrBJltF5wpmt1tH60qJPYuDf8yQtPY6bwAXWPtUAe2NEhCcFwOpNT2rgnPQhfhuoeTbuKNC2GpCXlMaUlusGVTJD3iyD8_GczcUHGb2nmqZbDIPi/s320/phpcrud3.png" width="320" /></a></div>
<pre><?php

//include database configuration

include 'config.php';

//selecting records

$query=mysql_query("select id, firstname, lastname, username from users");

//count how many records found

$num=mysql_num_rows($query);

if($num>0){ //check if more than 0 record found

<tr>

<th>Firstname</th>

<th>Lastname</th>

<th>Username</th>

<th>Action</th>

</tr>

<?php

//retrieve our table contents

while($row=mysql_fetch_array($query)){

//extract row

//this will make $row['firstname'] to

//just $firstname only

extract($row);

//creating new table row per record

<tr>

<td>

</td>

</tr>

<?php

}

</table>

<?php

}else{ //if no records found

echo "No records found.";

}

?>
</pre>
<div>
<strong style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">The code above should look like this on our browser:</strong></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtsrjRvSN-ynAeI8xba2wIKoj-YLUo4T32IDtQ65jC1x7lu4tasL7lDbGoEfgnXoOBhJKgV9j8WV3TAVf_lWN8tJi0pOORHvkbdDomUPVJHYwQ82D4ahwFc_JxAEHoYivjoACZNVGaQ7cp/s1600/phpcrud3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="313" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtsrjRvSN-ynAeI8xba2wIKoj-YLUo4T32IDtQ65jC1x7lu4tasL7lDbGoEfgnXoOBhJKgV9j8WV3TAVf_lWN8tJi0pOORHvkbdDomUPVJHYwQ82D4ahwFc_JxAEHoYivjoACZNVGaQ7cp/s320/phpcrud3.png" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="background-color: white; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; text-align: justify;">Then once the user clicked an edit link for a record, the user will be redirected to the edit screen which is our </span><strong style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">edit.php</strong><span style="background-color: white; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; text-align: justify;">, we’ll have the following code:</span></div>
<pre><?php

if(isset($_REQUEST['id'])){

include('config.php');

if(isset($_REQUEST['edit'])){

extract($_REQUEST);

//update the record if the form was submitted

$query=mysql_query("update users set firstname='$firstname', lastname='$lastname', username='$username', password='$password' where id='$id'") or die(mysql_error());

if($query){

//this will be displayed when the query was successful

echo "<div>Record was edited.</div>";

}

$id=$_REQUEST['id'];

//this query will select the user data which is to be used to fill up the form

$query=mysql_query("select * from users where id='$id'") or die(mysql_error());

$num=mysql_num_rows($query);

//just a little validation, if a record was found, the form will be shown

//it means that there's an information to be edited

if($num>0){

$row=mysql_fetch_assoc($query);

extract($row);

<table>

<tr>

<td>Firstname</td>

</tr>

<tr>

<td>Lastname</td>

</tr>

<tr>

<td>Username</td>

</tr>

<tr>

<td>Password</td>

<tr>

<td>

</td>

</tr>

</table>

</form>

<?php

}else{

echo "<div>User with this id is not found.</div>";

}

else{

echo "<div> You are not authorized to view this page";

}

echo "<a href='index.php'>Back To List</a>";

?>
</pre>
<div>
<span style="background-color: white; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; text-align: justify;">The code above should look like this:</span></div>
<div>
<strong style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;"><br /></strong></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7VDRmm5ylrGfJqvpM_3s0qbGbaYyr1TENNLGCcnoavAIqEfU2qBefX31K5GNeY0aMBCkimst49nEooyah3dmpg-baUqPIoyw2bITSRIzqpqDZFgPFQDu0Qf8rVHyyjzKsUOPXsTwxW08G/s1600/phpcrud4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7VDRmm5ylrGfJqvpM_3s0qbGbaYyr1TENNLGCcnoavAIqEfU2qBefX31K5GNeY0aMBCkimst49nEooyah3dmpg-baUqPIoyw2bITSRIzqpqDZFgPFQDu0Qf8rVHyyjzKsUOPXsTwxW08G/s1600/phpcrud4.png" /></a></div>
<div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
Now we’re gonna do a code that can delete record from your database.</div>
<div style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin-bottom: 1.625em; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
This code uses JavaScript as prompt to the user if he really want to delete certain record. A pop up will appear once the user clicked the delete link. On our index.php, we’ll have the following code:</div>
<pre><html>

<head>

<title>Delete Record</title>

</head>

<body>

<?php

//include database configuration

include 'config.php';

//check if an action was set, we use GET this time since we get the action data from the url

isset($_GET['action']) ? $action=$_GET['action'] : $action="";

if($action=='delete'){ //if the user clicked ok, run our delete query

$id=$_REQUEST['id'];

$query = mysql_query("DELETE FROM users WHERE id='$id'") or die(mysql_error());

if($query){

//this will be displayed when the query was successful

echo "<div>Record was deleted.</div>";

}

//selecting records

$query2=mysql_query("select * from users") or die(mysql_error());

//count how many records found

$num=mysql_num_rows($query2);

if($num>0){ //check if more than 0 record found

echo "<table border='1'>";//start table

//creating our table heading

echo "<tr>";

echo "<th>Firstname</th>";

echo "<th>Lastname</th>";

echo "<th>Username</th>";

echo "<th>Action</th>"; //we're gonna add this column for delete action

echo "</tr>";

//retrieve our table contents

while($row=mysql_fetch_array($query2)){

//extract row

//this will make $row['firstname'] to

//just $firstname only

extract($row);

//creating new table row per record

echo "<tr>";

echo "<td>{$firstname}</td>";

echo "<td>{$lastname}</td>";

echo "<td>{$username}</td>";

//we will have the delete link here, you can also put your edit link here, but for this tutorial we will just include the delete link

echo "<td>";

echo "<a href='#' onclick='delete_user( {$id} );'>Delete</a>";

echo "</td>";

echo "</tr>";

}

echo "</table>";//end table

}else{ //if no records found

echo "No records found.";

}

function delete_user( id ){

//this script helps us to

var answer = confirm('Are you sure?');

if ( answer ){ //if user clicked ok

//redirect to url with action as delete and id to the record to be deleted

window.location = 'index.php?action=delete&id=' + id;

}

</script>

</body>

</html>
</pre>
<div>
<br /></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHGcZFqugb2b05Uv6Nf0hoUNMhJixbOkE730E_twC-E6690WKznIuiD56hu2_1nHUe4niqNrksP8ZMHVsPlPEbikCsXeUraOX1_lbb3LstVS9AUf-VxUXdbSUObPN1pOn76zHNNK6tL4DN/s1600/phpcrud5.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHGcZFqugb2b05Uv6Nf0hoUNMhJixbOkE730E_twC-E6690WKznIuiD56hu2_1nHUe4niqNrksP8ZMHVsPlPEbikCsXeUraOX1_lbb3LstVS9AUf-VxUXdbSUObPN1pOn76zHNNK6tL4DN/s1600/phpcrud5.jpg" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<strong style="background-color: white; border: 0px; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24px; margin: 0px; outline: 0px; padding: 0px; text-align: justify; vertical-align: baseline;">Our code should look like this on the browser:</strong></div>
<br /></div>

CRUD with PHP and MySQL

In this tutorial we learn create, read, and update data Using PHP and MySQL. The programmers called it CRUD. CRUD means CREATE, READ, UP...

2:42 AM