2015-12-30
2015-11-16
2015-11-13
Checks Effect
|
<div class="kas-checks-slideOne"> <input type="checkbox" name="Status1" class="" id="slide1" checked="checked"> <label for="slide1"></label> </div> |
|
<div class="kas-checks-slideTwo bg"> <input type="checkbox" name="Status2" class="" id="slide2" checked="checked"> <label for="slide2"></label> </div> |
|
<div class="kas-checks-slideThree bg"> <input type="checkbox" name="Status3" class="" id="slide3"> <label for="slide3"></label> </div> |
|
<div class="kas-checks-slideFour bg-dr-gray"> <input type="checkbox" name="Status9" class="" id="slide9"> <label for="slide9"></label> </div> |
|
<div class="kas-checks-slideFive bg-dr-gray"> <input type="checkbox" name="Status10" class="" id="slide10" checked="checked"> <label for="slide10"></label> </div> |
|
<div class="kas-checks-slideSix bg-lg-gray"> <input type="checkbox" name="Status11" class="" id="slide11" checked="checked"> <label for="slide11"></label> </div> |
|
<div class="kas-checks-roundedOne"> <input type="checkbox" name="Status4" class="" id="slide4" checked="checked"> <label for="slide4"></label> </div> |
|
<div class="kas-checks-roundedTwo"> <input type="checkbox" name="Status5" class="" id="slide5" checked="checked"> <label for="slide5"></label> </div> |
|
<div class="kas-checks-roundedThree"> <input type="checkbox" name="Status12" class="" id="slide12" checked="checked"> <label for="slide12"></label> </div> |
|
<div class="kas-checks-squaredOne"> <input type="checkbox" name="Status6" class="" id="slide6" checked="checked"> <label for="slide6"></label> </div> |
|
<div class="kas-checks-squaredTwo"> <input type="checkbox" name="Status7" class="" id="slide7" checked="checked"> <label for="slide7"></label> </div> |
|
<div class="kas-checks-squaredThree"> <input type="checkbox" name="Status8" class="" id="slide8" checked="checked"> <label for="slide8"></label> </div> |
|
<div class="kas-checks-squaredFour"> <input type="checkbox" name="Status13" class="" id="slide13" checked="checked"> <label for="slide13"></label> </div> |
|
<div class="kas-checks-squaredFive"> <input type="checkbox" name="Status14" class="" id="slide14" checked="checked"> <label for="slide14"></label> </div> |
...
<script type="text/javascript" src="https://cdn.datatables.net/r/dt/dt-1.10.9/datatables.min.js"></script> <script type="text/javascript" src="https://code.jquery.com/jquery-1.11.3.min.js"></script> <script type="text/javascript" src="https://cdn.datatables.net/1.10.9/js/jquery.dataTables.min.js"></script>
2015-11-08
<script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-apollo.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-apollo.min.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-basic.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-basic.min.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-clj.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-clj.min.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-css.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-css.min.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-dart.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-dart.min.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-erlang.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-erlang.min.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-go.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-go.min.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-hs.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-hs.min.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-lisp.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-lisp.min.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-llvm.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-llvm.min.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-lua.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-lua.min.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-matlab.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-matlab.min.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-ml.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-ml.min.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-mumps.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-mumps.min.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-n.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-n.min.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-pascal.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-pascal.min.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-proto.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-proto.min.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-r.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-r.min.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-rd.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-rd.min.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-scala.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-scala.min.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-sql.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-sql.min.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-tcl.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-tcl.min.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-tex.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-tex.min.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-vb.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-vb.min.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-vhdl.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-vhdl.min.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-wiki.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-wiki.min.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-xq.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-xq.min.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-yaml.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/lang-yaml.min.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/prettify.css" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/prettify.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/prettify.min.css" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/prettify.min.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/run_prettify.js" type="text/javascript"> </script> <script src="https://cdnjs.cloudflare.com/ajax/libs/prettify/r298/run_prettify.min.js" type="text/javascript"> </script>
2015-10-28
2:15 PM
Appo, Blackberry, CMD, Command Prompt, Fedora, HP, hTc, Kali Linux, Lenovo, LG, Mac, Mackintosh, MS SQL, Nokia, Samsung, Sony, Terminal, Ubuntu, Windows, Windows 10
0
2:14 PM
Ajax, Android, Angular JS, Backbone JS, Cake PHP, Codignator, Corel Draw, Druple, HTML, Illustrator, In Design, Javascript, Joombla, jquery, JSON, mysql, Photoshop, PHP, Yee
0
Datatable Examples
Name | Position | Office | Age | Salary |
---|---|---|---|---|
Name | Position | Office | Age | Salary |
Tiger Nixon | System Architect | Edinburgh | 61 | $320,800 |
Garrett Winters | Accountant | Tokyo | 63 | $170,750 |
Ashton Cox | Junior Technical Author | San Francisco | 66 | $86,000 |
Cedric Kelly | Senior Javascript Developer | Edinburgh | 22 | $433,060 |
Airi Satou | Accountant | Tokyo | 33 | $162,700 |
Brielle Williamson | Integration Specialist | New York | 61 | $372,000 |
Herrod Chandler | Sales Assistant | San Francisco | 59 | $137,500 |
Rhona Davidson | Integration Specialist | Tokyo | 55 | $327,900 |
Colleen Hurst | Javascript Developer | San Francisco | 39 | $205,500 |
Sonya Frost | Software Engineer | Edinburgh | 23 | $103,600 |
Jena Gaines | Office Manager | London | 30 | $90,560 |
Quinn Flynn | Support Lead | Edinburgh | 22 | $342,000 |
Charde Marshall | Regional Director | San Francisco | 36 | $470,600 |
Haley Kennedy | Senior Marketing Designer | London | 43 | $313,500 |
Tatyana Fitzpatrick | Regional Director | London | 19 | $385,750 |
Michael Silva | Marketing Designer | London | 66 | $198,500 |
Paul Byrd | Chief Financial Officer (CFO) | New York | 64 | $725,000 |
Gloria Little | Systems Administrator | New York | 59 | $237,500 |
Bradley Greer | Software Engineer | London | 41 | $132,000 |
Dai Rios | Personnel Lead | Edinburgh | 35 | $217,500 |
Jenette Caldwell | Development Lead | New York | 30 | $345,000 |
Yuri Berry | Chief Marketing Officer (CMO) | New York | 40 | $675,000 |
Caesar Vance | Pre-Sales Support | New York | 21 | $106,450 |
Doris Wilder | Sales Assistant | Sidney | 23 | $85,600 |
Angelica Ramos | Chief Executive Officer (CEO) | London | 47 | $1,200,000 |
Gavin Joyce | Developer | Edinburgh | 42 | $92,575 |
Jennifer Chang | Regional Director | Singapore | 28 | $357,650 |
Brenden Wagner | Software Engineer | San Francisco | 28 | $206,850 |
Fiona Green | Chief Operating Officer (COO) | San Francisco | 48 | $850,000 |
Shou Itou | Regional Marketing | Tokyo | 20 | $163,000 |
Michelle House | Integration Specialist | Sidney | 37 | $95,400 |
Suki Burks | Developer | London | 53 | $114,500 |
Prescott Bartlett | Technical Author | London | 27 | $145,000 |
Gavin Cortez | Team Leader | San Francisco | 22 | $235,500 |
Martena Mccray | Post-Sales support | Edinburgh | 46 | $324,050 |
Unity Butler | Marketing Designer | San Francisco | 47 | $85,675 |
Howard Hatfield | Office Manager | San Francisco | 51 | $164,500 |
Hope Fuentes | Secretary | San Francisco | 41 | $109,850 |
Vivian Harrell | Financial Controller | San Francisco | 62 | $452,500 |
Timothy Mooney | Office Manager | London | 37 | $136,200 |
Jackson Bradshaw | Director | New York | 65 | $645,750 |
Olivia Liang | Support Engineer | Singapore | 64 | $234,500 |
Bruno Nash | Software Engineer | London | 38 | $163,500 |
Sakura Yamamoto | Support Engineer | Tokyo | 37 | $139,575 |
Thor Walton | Developer | New York | 61 | $98,540 |
Finn Camacho | Support Engineer | San Francisco | 47 | $87,500 |
Serge Baldwin | Data Coordinator | Singapore | 64 | $138,575 |
Zenaida Frank | Software Engineer | New York | 63 | $125,250 |
Zorita Serrano | Software Engineer | San Francisco | 56 | $115,000 |
Jennifer Acosta | Junior Javascript Developer | Edinburgh | 43 | $75,650 |
Cara Stevens | Sales Assistant | New York | 46 | $145,600 |
Hermione Butler | Regional Director | London | 47 | $356,250 |
Lael Greer | Systems Administrator | London | 21 | $103,500 |
Jonas Alexander | Developer | San Francisco | 30 | $86,500 |
Shad Decker | Regional Director | Edinburgh | 51 | $183,000 |
Michael Bruce | Javascript Developer | Singapore | 29 | $183,000 |
Donna Snider | Customer Support | New York | 27 | $112,000 |
<table id="example10001" class="display" cellspacing="0" width="100%">
<thead>
<tr> <th>Name</th> <th>Position</th> <th>Office</th> <th>Age</th> <th>Salary</th> </tr> </thead>
<tfoot> <tr> <th>Name</th> <th>Position</th> <th>Office</th> <th>Age</th> <th>Salary</th> </tr> </tfoot>
<tbody> <tr> <td>Tiger Nixon</td> <td>System Architect</td> <td>Edinburgh</td> <td>61</td> <td>$320,800</td> </tr> <tr> <td>Garrett Winters</td> <td>Accountant</td> <td>Tokyo</td> <td>63</td> <td>$170,750</td> </tr> <tr> <td>Ashton Cox</td> <td>Junior Technical Author</td> <td>San Francisco</td> <td>66</td> <td>$86,000</td> </tr> <tr> <td>Cedric Kelly</td> <td>Senior Javascript Developer</td> <td>Edinburgh</td> <td>22</td> <td>$433,060</td> </tr> <tr> <td>Airi Satou</td> <td>Accountant</td> <td>Tokyo</td> <td>33</td> <td>$162,700</td> </tr> <tr> <td>Brielle Williamson</td> <td>Integration Specialist</td> <td>New York</td> <td>61</td> <td>$372,000</td> </tr> <tr> <td>Herrod Chandler</td> <td>Sales Assistant</td> <td>San Francisco</td> <td>59</td> <td>$137,500</td> </tr> <tr> <td>Rhona Davidson</td> <td>Integration Specialist</td> <td>Tokyo</td> <td>55</td> <td>$327,900</td> </tr> <tr> <td>Colleen Hurst</td> <td>Javascript Developer</td> <td>San Francisco</td> <td>39</td> <td>$205,500</td> </tr> <tr> <td>Sonya Frost</td> <td>Software Engineer</td> <td>Edinburgh</td> <td>23</td> <td>$103,600</td> </tr> <tr> <td>Jena Gaines</td> <td>Office Manager</td> <td>London</td> <td>30</td> <td>$90,560</td> </tr> <tr> <td>Quinn Flynn</td> <td>Support Lead</td> <td>Edinburgh</td> <td>22</td> <td>$342,000</td> </tr> <tr> <td>Charde Marshall</td> <td>Regional Director</td> <td>San Francisco</td> <td>36</td> <td>$470,600</td> </tr> <tr> <td>Haley Kennedy</td> <td>Senior Marketing Designer</td> <td>London</td> <td>43</td> <td>$313,500</td> </tr> <tr> <td>Tatyana Fitzpatrick</td> <td>Regional Director</td> <td>London</td> <td>19</td> <td>$385,750</td> </tr> <tr> <td>Michael Silva</td> <td>Marketing Designer</td> <td>London</td> <td>66</td> <td>$198,500</td> </tr> <tr> <td>Paul Byrd</td> <td>Chief Financial Officer (CFO)</td> <td>New York</td> <td>64</td> <td>$725,000</td> </tr> <tr> <td>Gloria Little</td> <td>Systems Administrator</td> <td>New York</td> <td>59</td> <td>$237,500</td> </tr> <tr> <td>Bradley Greer</td> <td>Software Engineer</td> <td>London</td> <td>41</td> <td>$132,000</td> </tr> <tr> <td>Dai Rios</td> <td>Personnel Lead</td> <td>Edinburgh</td> <td>35</td> <td>$217,500</td> </tr> <tr> <td>Jenette Caldwell</td> <td>Development Lead</td> <td>New York</td> <td>30</td> <td>$345,000</td> </tr> <tr> <td>Yuri Berry</td> <td>Chief Marketing Officer (CMO)</td> <td>New York</td> <td>40</td> <td>$675,000</td> </tr> <tr> <td>Caesar Vance</td> <td>Pre-Sales Support</td> <td>New York</td> <td>21</td> <td>$106,450</td> </tr> <tr> <td>Doris Wilder</td> <td>Sales Assistant</td> <td>Sidney</td> <td>23</td> <td>$85,600</td> </tr> <tr> <td>Angelica Ramos</td> <td>Chief Executive Officer (CEO)</td> <td>London</td> <td>47</td> <td>$1,200,000</td> </tr> <tr> <td>Gavin Joyce</td> <td>Developer</td> <td>Edinburgh</td> <td>42</td> <td>$92,575</td> </tr> <tr> <td>Jennifer Chang</td> <td>Regional Director</td> <td>Singapore</td> <td>28</td> <td>$357,650</td> </tr> <tr> <td>Brenden Wagner</td> <td>Software Engineer</td> <td>San Francisco</td> <td>28</td> <td>$206,850</td> </tr> <tr> <td>Fiona Green</td> <td>Chief Operating Officer (COO)</td> <td>San Francisco</td> <td>48</td> <td>$850,000</td> </tr> <tr> <td>Shou Itou</td> <td>Regional Marketing</td> <td>Tokyo</td> <td>20</td> <td>$163,000</td> </tr> <tr> <td>Michelle House</td> <td>Integration Specialist</td> <td>Sidney</td> <td>37</td> <td>$95,400</td> </tr> <tr> <td>Suki Burks</td> <td>Developer</td> <td>London</td> <td>53</td> <td>$114,500</td> </tr> <tr> <td>Prescott Bartlett</td> <td>Technical Author</td> <td>London</td> <td>27</td> <td>$145,000</td> </tr> <tr> <td>Gavin Cortez</td> <td>Team Leader</td> <td>San Francisco</td> <td>22</td> <td>$235,500</td> </tr> <tr> <td>Martena Mccray</td> <td>Post-Sales support</td> <td>Edinburgh</td> <td>46</td> <td>$324,050</td> </tr> <tr> <td>Unity Butler</td> <td>Marketing Designer</td> <td>San Francisco</td> <td>47</td> <td>$85,675</td> </tr> <tr> <td>Howard Hatfield</td> <td>Office Manager</td> <td>San Francisco</td> <td>51</td> <td>$164,500</td> </tr> <tr> <td>Hope Fuentes</td> <td>Secretary</td> <td>San Francisco</td> <td>41</td> <td>$109,850</td> </tr> <tr> <td>Vivian Harrell</td> <td>Financial Controller</td> <td>San Francisco</td> <td>62</td> <td>$452,500</td> </tr> <tr> <td>Timothy Mooney</td> <td>Office Manager</td> <td>London</td> <td>37</td> <td>$136,200</td> </tr> <tr> <td>Jackson Bradshaw</td> <td>Director</td> <td>New York</td> <td>65</td> <td>$645,750</td> </tr> <tr> <td>Olivia Liang</td> <td>Support Engineer</td> <td>Singapore</td> <td>64</td> <td>$234,500</td> </tr> <tr> <td>Bruno Nash</td> <td>Software Engineer</td> <td>London</td> <td>38</td> <td>$163,500</td> </tr> <tr> <td>Sakura Yamamoto</td> <td>Support Engineer</td> <td>Tokyo</td> <td>37</td> <td>$139,575</td> </tr> <tr> <td>Thor Walton</td> <td>Developer</td> <td>New York</td> <td>61</td> <td>$98,540</td> </tr> <tr> <td>Finn Camacho</td> <td>Support Engineer</td> <td>San Francisco</td> <td>47</td> <td>$87,500</td> </tr> <tr> <td>Serge Baldwin</td> <td>Data Coordinator</td> <td>Singapore</td> <td>64</td> <td>$138,575</td> </tr> <tr> <td>Zenaida Frank</td> <td>Software Engineer</td> <td>New York</td> <td>63</td> <td>$125,250</td> </tr> <tr> <td>Zorita Serrano</td> <td>Software Engineer</td> <td>San Francisco</td> <td>56</td> <td>$115,000</td> </tr> <tr> <td>Jennifer Acosta</td> <td>Junior Javascript Developer</td> <td>Edinburgh</td> <td>43</td> <td>$75,650</td> </tr> <tr> <td>Cara Stevens</td> <td>Sales Assistant</td> <td>New York</td> <td>46</td> <td>$145,600</td> </tr> <tr> <td>Hermione Butler</td> <td>Regional Director</td> <td>London</td> <td>47</td> <td>$356,250</td> </tr> <tr> <td>Lael Greer</td> <td>Systems Administrator</td> <td>London</td> <td>21</td> <td>$103,500</td> </tr> <tr> <td>Jonas Alexander</td> <td>Developer</td> <td>San Francisco</td> <td>30</td> <td>$86,500</td> </tr> <tr> <td>Shad Decker</td> <td>Regional Director</td> <td>Edinburgh</td> <td>51</td> <td>$183,000</td> </tr> <tr> <td>Michael Bruce</td> <td>Javascript Developer</td> <td>Singapore</td> <td>29</td> <td>$183,000</td> </tr> <tr> <td>Donna Snider</td> <td>Customer Support</td> <td>New York</td> <td>27</td> <td>$112,000</td> </tr>
</tbody>
</table>
...
<script> $(document).ready(function() { $('#example10001').DataTable( { "dom": '<"top"l><"search"f>rt<"bottom"ip><"clear">' } ); $("div.toolbar").html('<b>Custom tool bar! Text/images etc.</b>'); } ); </script>
<script type="text/javascript" src="https://cdn.datatables.net/r/dt/dt-1.10.9/datatables.min.js"></script> <script type="text/javascript" src="https://code.jquery.com/jquery-1.11.3.min.js"></script> <script type="text/javascript" src="https://cdn.datatables.net/1.10.9/js/jquery.dataTables.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/r/dt/dt-1.10.9/datatables.min.js"></script> <script type="text/javascript" src="https://code.jquery.com/jquery-1.11.3.min.js"></script> <script type="text/javascript" src="https://cdn.datatables.net/1.10.9/js/jquery.dataTables.min.js"></script>
2015-06-09
MySQL Create DB
A database holds one or multiple tables.
Create a Database
The CREATE DATABASE statement is used to create a database in MySQL.
Syntax
CREATE DATABASE database_name
Example
The following example creates a database called "my_db":<?php $con = mysql_connect("localhost","peter","abc123"); if (!$con) { die('Could not connect: ' . mysql_error()); } if (mysql_query("CREATE DATABASE my_db",$con)) { echo "Database created"; } else { echo "Error creating database: " . mysql_error(); } mysql_close($con); ?>
Create a Table
The CREATE TABLE statement is used to create a table in MySQL.
Syntax
CREATE TABLE table_name ( column_name1 data_type, column_name2 data_type, column_name3 data_type, .... )
We must add the CREATE TABLE statement to the mysql_query() function to execute the command.
Example
The following example creates a table named "Persons", with three columns. The column names will be "FirstName", "LastName" and "Age":<?php $con = mysql_connect("localhost","peter","abc123"); if (!$con) { die('Could not connect: ' . mysql_error()); } // Create database if (mysql_query("CREATE DATABASE my_db",$con)) { echo "Database created"; } else { echo "Error creating database: " . mysql_error(); } // Create table mysql_select_db("my_db", $con); $sql = "CREATE TABLE Persons ( FirstName varchar(15), LastName varchar(15), Age int )"; // Execute query mysql_query($sql,$con); mysql_close($con); ?>
The data type specifies what type of data the column can hold. For a complete reference of all the data types available in MySQL, go to complete Data Types reference.
MySQL Connect
The free MySQL database is very often used with PHP.
Create a Connection to a MySQL Database
Before you can access data in a database, you must create a connection to the database.
In PHP, this is done with the mysql_connect() function.
Syntax
mysql_connect(servername,username,password);
Parameter
|
Description
|
servername
|
Optional. Specifies the server to connect to. Default value is "localhost:3306"
|
username
|
Optional. Specifies the username to log in with. Default value is the name of the user that owns the server process
|
password
|
Optional. Specifies the password to log in with. Default is ""
|
Example
In the following example we store the connection in a variable ($con) for later use in the script. The "die" part will be executed if the connection fails:
<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
// some code
?>
Closing a Connection
The connection will be closed automatically when the script ends. To close the connection before, use the mysql_close() function:
<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
// some code
mysql_close($con);
?>