https://script.spoken-tutorial.org/index.php?title=PHP-and-MySQL/C3/MySQL-Part-2/English-timed&feed=atom&action=historyPHP-and-MySQL/C3/MySQL-Part-2/English-timed - Revision history2024-03-29T09:41:44ZRevision history for this page on the wikiMediaWiki 1.23.17https://script.spoken-tutorial.org/index.php?title=PHP-and-MySQL/C3/MySQL-Part-2/English-timed&diff=36804&oldid=prevPoojaMoolya at 05:24, 28 April 20172017-04-28T05:24:06Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 05:24, 28 April 2017</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 202:</td>
<td colspan="2" class="diff-lineno">Line 202:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|-</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|-</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|06:51</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|06:51</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>|So let's '''refresh''' this<del class="diffchange diffchange-inline">.</del></div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>|So let's '''refresh''' this<ins class="diffchange diffchange-inline">,</ins>In fact I'll change this back to "localhost" because I'm getting back on track here and then let's '''refresh'''.</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">|-</del></div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">|06:52</del></div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">|</del>In fact I'll change this back to "localhost" because I'm getting back on track here and then let's '''refresh'''.</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|-</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|-</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|07:03</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|07:03</div></td></tr>
<tr><td colspan="2" class="diff-lineno">Line 242:</td>
<td colspan="2" class="diff-lineno">Line 239:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|08:00</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|08:00</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|See you soon!  This is Juanita Jayakar, dubbing for the Spoken Tutorial Project.</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|See you soon!  This is Juanita Jayakar, dubbing for the Spoken Tutorial Project.</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|}</ins></div></td></tr>
</table>PoojaMoolyahttps://script.spoken-tutorial.org/index.php?title=PHP-and-MySQL/C3/MySQL-Part-2/English-timed&diff=22209&oldid=prevSandhya.np14 at 12:44, 27 May 20152015-05-27T12:44:56Z<p></p>
<a href="https://script.spoken-tutorial.org/index.php?title=PHP-and-MySQL/C3/MySQL-Part-2/English-timed&diff=22209&oldid=16235">Show changes</a>Sandhya.np14https://script.spoken-tutorial.org/index.php?title=PHP-and-MySQL/C3/MySQL-Part-2/English-timed&diff=16235&oldid=prevGaurav at 10:43, 2 September 20142014-09-02T10:43:04Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 10:43, 2 September 2014</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 216:</td>
<td colspan="2" class="diff-lineno">Line 216:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|This is working well.</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|This is working well.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|-</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|-</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>|<del class="diffchange diffchange-inline">7</del>:23</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>|<ins class="diffchange diffchange-inline">07</ins>:23</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|Its quite useful to have these errors and then we can get users to report back if they don't exist.</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|Its quite useful to have these errors and then we can get users to report back if they don't exist.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|-</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|-</div></td></tr>
</table>Gauravhttps://script.spoken-tutorial.org/index.php?title=PHP-and-MySQL/C3/MySQL-Part-2/English-timed&diff=13317&oldid=prevPratik kamble at 06:21, 10 July 20142014-07-10T06:21:29Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 06:21, 10 July 2014</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>{| border=1</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>{| border=1</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|'''Time'''</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|'''Time'''</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>|''Narration'''</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>|<ins class="diffchange diffchange-inline">'</ins>''Narration'''</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|-</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|-</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|00:02</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|00:02</div></td></tr>
</table>Pratik kamblehttps://script.spoken-tutorial.org/index.php?title=PHP-and-MySQL/C3/MySQL-Part-2/English-timed&diff=13316&oldid=prevPratik kamble at 06:21, 10 July 20142014-07-10T06:21:19Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 06:21, 10 July 2014</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 21:</td>
<td colspan="2" class="diff-lineno">Line 21:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|As this is mysql php tutorial, I'll show you how to insert data using mysql or php.</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|As this is mysql php tutorial, I'll show you how to insert data using mysql or php.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|-</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|-</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>|<del class="diffchange diffchange-inline">0</del>:49</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>|<ins class="diffchange diffchange-inline">00</ins>:49</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|Now first of all we need to connect to our database.</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|Now first of all we need to connect to our database.</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|-</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|-</div></td></tr>
</table>Pratik kamblehttps://script.spoken-tutorial.org/index.php?title=PHP-and-MySQL/C3/MySQL-Part-2/English-timed&diff=13315&oldid=prevPratik kamble at 06:21, 10 July 20142014-07-10T06:21:02Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 06:21, 10 July 2014</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>{| border=1</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>{| border=1</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">!</del>Time</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">|'''</ins>Time<ins class="diffchange diffchange-inline">'''</ins></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">!</del>Narration</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">|''</ins>Narration<ins class="diffchange diffchange-inline">'''</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|-</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|-</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|00:02</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>|00:02</div></td></tr>
</table>Pratik kamblehttps://script.spoken-tutorial.org/index.php?title=PHP-and-MySQL/C3/MySQL-Part-2/English-timed&diff=5115&oldid=prevSneha at 06:53, 11 July 20132013-07-11T06:53:24Z<p></p>
<a href="https://script.spoken-tutorial.org/index.php?title=PHP-and-MySQL/C3/MySQL-Part-2/English-timed&diff=5115&oldid=5113">Show changes</a>Snehahttps://script.spoken-tutorial.org/index.php?title=PHP-and-MySQL/C3/MySQL-Part-2/English-timed&diff=5113&oldid=prevSneha at 06:50, 11 July 20132013-07-11T06:50:00Z<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 06:50, 11 July 2013</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">\</del>{| border=1</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>{| border=1</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>!Time</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>!Time</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>!Narration</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>!Narration</div></td></tr>
</table>Snehahttps://script.spoken-tutorial.org/index.php?title=PHP-and-MySQL/C3/MySQL-Part-2/English-timed&diff=5111&oldid=prevSneha at 06:49, 11 July 20132013-07-11T06:49:05Z<p></p>
<a href="https://script.spoken-tutorial.org/index.php?title=PHP-and-MySQL/C3/MySQL-Part-2/English-timed&diff=5111&oldid=2390">Show changes</a>Snehahttps://script.spoken-tutorial.org/index.php?title=PHP-and-MySQL/C3/MySQL-Part-2/English-timed&diff=2390&oldid=prevMinal: Created page with '{| border=1 !Time !Narration |- |0:0 |Hi. In the first part of the tutorial we created a table inside our database "php academy" and we created our fields with all the relevant d…'2013-01-02T12:29:10Z<p>Created page with '{| border=1 !Time !Narration |- |0:0 |Hi. In the first part of the tutorial we created a table inside our database "php academy" and we created our fields with all the relevant d…'</p>
<p><b>New page</b></p><div>{| border=1<br />
!Time<br />
!Narration<br />
|-<br />
|0:0<br />
|Hi. In the first part of the tutorial we created a table inside our database "php academy" and we created our fields with all the relevant data to go with it... datatypes etc.<br />
|-<br />
|0:14<br />
|Now we will insert some dummy data inside our database by doing this.<br />
|-<br />
|0:21<br />
|I'll not click this "Insert" button here because by clicking this button here, we get very easy to use interface where we can type in firstname, lastname, date of birth using the calender function over here.<br />
|-<br />
|0:33<br />
|You can see that just popped up.<br />
|-<br />
|0:35<br />
|And we can also enter our gender here.<br />
|-<br />
|0:37<br />
|As this is mysql php tutorial, I'll show you how to insert data using mysql or php.<br />
|-<br />
|0:49<br />
|Now first of all we need to connect to our database.<br />
|-<br />
|0:52<br />
|Under "mysql dot php" file, we will use the "include" function to include our file "connect dot php".<br />
|-<br />
|1:00<br />
|Now if this is not in the same directory, you know that you can say "sub directory and then connect".<br />
|-<br />
|1:07<br />
|Please specify this properly.<br />
|-<br />
|1:09<br />
|If you dont want the page to execute... if you don't want the "Rest of the page" to execute here, you can use the "require" function.<br />
|-<br />
|1:18<br />
|The "require" function kills the page if this isn't found from here on.<br />
|-<br />
|1:23<br />
|The "include" will include it and then it will continue to echo or continue to run the rest of the page.<br />
|-<br />
|1:29<br />
|If you use the "require" function, it will in fact "kill" if this cannot be included.<br />
|-<br />
|1:34<br />
|So what I will say is "require connect dot php" just to say that if you can't connect to the database, the rest of this page is meaningless.<br />
|-<br />
|1:41<br />
|We will get loads of rubbish upon the page.<br />
|-<br />
|1:44<br />
|ok... so if "require connect dot php" and inside connect dot php we need to start our php mysql functions.<br />
|-<br />
|1:52<br />
|Firstly you need to know - we will start with our variable called "connect" and this will use the function "mysql_connect".<br />
|-<br />
|2:01<br />
|That's the first function you need to learn.<br />
|-<br />
|2:03<br />
|Its a very very important function that enables you to connect to your database mysql.<br />
|-<br />
|2:08<br />
|This takes 3 parameters.<br />
|-<br />
|2:11<br />
|The first one here is the webserver itself - the address of the webserver.<br />
|-<br />
|2:17<br />
|I'll use my computer at the moment with a local webserver with my local host.<br />
|-<br />
|2:22<br />
|This can also be written as 127.0.0.1 if you wish, as a substitute for local host.<br />
|-<br />
|2:32<br />
|I prefer typing "local host" personally.<br />
|-<br />
|2:35<br />
|Now I'll use the standard username and password given to me.<br />
|-<br />
|2:41<br />
|This is "root". <br />
|-<br />
|2:42<br />
|My password doesn't exist because I don't have a password. <br />
|-<br />
|2:50<br />
|We have established our connection but what happens if this connection is not initialized properly.<br />
|-<br />
|2:56<br />
|What we can do after this, is write "or die" and in brackets we can specify an error message for example "connection failed".<br />
|-<br />
|3:02<br />
|So lets presume at the moment this connection works.<br />
|-<br />
|3:11<br />
|I'll echo out a piece of code saying "connected".<br />
|-<br />
|3:18<br />
|Ok now if this does connect successfully the rest of the script will run and echo out "connected" otherwise it would just give you this text and won't run the rest of the page.<br />
|-<br />
|3:26<br />
|So what I will do is, I will open backup here.<br />
|-<br />
|3:30<br />
|Refresh and you can see "connect dot php" and "mysql dot php" and I'll click on mysql dot php.<br />
|-<br />
|3:37<br />
|The reason I'm not clicking connect is because inside mysql we require "connect dot php" anyway.<br />
|-<br />
|3:44<br />
|So as long as these are both saved, we can just run mysql dot php.<br />
|-<br />
|3:48<br />
|We have connected successfully.<br />
|-<br />
|3:50<br />
|Now if I were to say change this to something like "I dont exist" then we get a connection error because that host name doesn't exist, .... at least on this computer.<br />
|-<br />
|4:08<br />
|I can refresh and .... its taking a long time...... ok there we are.<br />
|-<br />
|4:14<br />
|You can see that we have got mysql error here and we have connection failed text just here, that we specified earlier.<br />
|-<br />
|4:21<br />
|Ok.. so we have got unknown mysql server host.<br />
|-<br />
|4:25<br />
|If you ever get this error you know what to look out for.<br />
|-<br />
|4:27<br />
|This is the host I specified and you can see what line its on and all our usual debugging message code.<br />
|-<br />
|4:36<br />
|So lets presume that I...ummm.... in fact what I can do first is show you another useful thing or "die" you can also specify another function here.<br />
|-<br />
|4:46<br />
|This is the second function that you should learn.<br />
|-<br />
|4:50<br />
|Its "mysql error" - just put brackets like that - and when we refresh our page keeping the "I don't exist".<br />
|-<br />
|4:57<br />
|We can refresh and its taking its time.....<br />
|-<br />
|5:06<br />
|Ok there we are.<br />
|-<br />
|5:07<br />
|What we have basically done is we echoed out the same error message that php has given us anyway.<br />
|-<br />
|5:12<br />
|However if your.. ummm.... how do I say - if your error reporting is turned off for your user, this will give out what you want.<br />
|-<br />
|5:24<br />
|Now we don't echo out this to the user.<br />
|-<br />
|5:26<br />
|lets say we go up here and say "error reporting".<br />
|-<br />
|5:30<br />
|Please see the error reporting tutorial I made, if you haven't. <br />
|-<br />
|5:33<br />
|If you have...ummm.... set this to '0'.<br />
|-<br />
|5:40<br />
|This will turn off all error reporting.<br />
|-<br />
|5:43<br />
|So what happens is this error here will be ignored but our specific error will be given out to the user.<br />
|-<br />
|5:49<br />
|Lets refresh here.... again its taking its time...so I apologize....<br />
|-<br />
|5:58<br />
|There you go. We can just say that we got our specific error out there, ok?<br />
|-<br />
|6:03<br />
|Presuming that we have connected successfully using this function and if not, then we have given out this error message, the next thing to do is to select our database<br />
|-<br />
|6:13<br />
|To do this, we use the "mysql_select db" function.<br />
|-<br />
|6:20<br />
|This takes exactly 1 parameter and that's the name of your database.<br />
|-<br />
|6:24<br />
|So we click on "php myadmin" again, we can see that our database name is "phpacademy".<br />
|-<br />
|6:31<br />
|So if I just type "phpacademy" this should work.<br />
|-<br />
|6:36<br />
|Again we could use this or die feature.<br />
|-<br />
|6:40<br />
|Using our die function we can specify a mysql_error if it doesn't exist or anything like that.<br />
|-<br />
|6:47<br />
|So lets refresh this.<br />
|-<br />
|6:50<br />
|In fact I'll change this back to "local host" because I'm getting back on track here and then lets refresh.<br />
|-<br />
|6:59<br />
|So that's connected and if this is not found we are giving out a mysql_error.<br />
|-<br />
|7:04<br />
|Lets try that - "I don't exist" and refresh and "Unknown database "idon'texist"".<br />
|-<br />
|7:12<br />
|This is working well.<br />
|-<br />
|7:14<br />
|Its quite useful to have these errors and then we can get users to report back if they don't exist.<br />
|-<br />
|7:20<br />
|So its "phpacademy" there.<br />
|-<br />
|7:23<br />
|I presume everything is ok and lets refresh.<br />
|-<br />
|7:29<br />
|Change this back to "phpacademy" and save that.<br />
|-<br />
|7:33<br />
|Refresh and we have been connected successfully. <br />
|-<br />
|7:36<br />
|What I'll do is keep a log of this and say that I am connected successfully.<br />
|-<br />
|7:41<br />
|I'll end our paragraph after this to continue with the rest of our code.<br />
|-<br />
|7:42<br />
|Next thing is to write some data to our database which we will cover in our next tutorial.<br />
|-<br />
|7:56<br />
|See you soon! This is Juanita Jayakar dubbing for the Spoken Tutorial Project.</div>Minal