We make this blog is to help people that want to learn basic and advanced of web design and programming without school with technologies as PHP, HTML, JavaScript, MySql, CPanel, jQuery, Ajax, PHP MVC, ASP.NET, ASP.NET MVC, XML, JSON, Joomla, WordPress, Drupal.noreply@blogger.com (Unknown)Wed, 18 Dec 2024 19:15:01 -0800Blogger http://www.blogger.com50125http://video-tutorial-from-youtube.blogspot.com/en-usnoAPP INFORMATION SOLUTIONPHP,HTML,JavaScript,MySql,CPanel,jQuery,Ajax,PHP,MVC,ASP,NET,ASP,NET,MVC,XML,JSON,Joomla,WordPress,DrupalWe make this blog is to help people that want to learn basic and advanced of web design and programming without school with technologies as PHP, HTML, JavaScript, MySql, CPanel, jQuery, Ajax, PHP MVC, ASP.NET, ASP.NET MVC, XML, JSON, Joomla, WordPress, Drupal.Web Design and Programming TutorialMa Chanvadanaknoreply@blogger.comMa Chanvadanakhttp://video-tutorial-from-youtube.blogspot.com/2015/03/php-tutorials-how-to-crud-with-php-and.htmlWed, 11 Mar 2015 00:41:00 -0700tag:blogger.com,1999:blog-745581822751602580.post-8992751316391366344<span style="font-family: Arial, Helvetica, sans-serif;">This video learn how to CRUD with PHP and MySQL</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">What is CRUD?</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">C is Create</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">R is Remove</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">U is Update</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">D is Display</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMwEJaSVrLvO-HaB0GmOuigzINLWz5Vjeu2OqseiWu-uF2NeYFepvMH29Uaj1ObwhxWaE53b1bqt7BCMGEYoJNhpop72o0GiKYIpCUUYxM8WDxyq8n-WZXGuqs3PVm0o8YtFvc7Rcy_ow/s1600/49.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMwEJaSVrLvO-HaB0GmOuigzINLWz5Vjeu2OqseiWu-uF2NeYFepvMH29Uaj1ObwhxWaE53b1bqt7BCMGEYoJNhpop72o0GiKYIpCUUYxM8WDxyq8n-WZXGuqs3PVm0o8YtFvc7Rcy_ow/s1600/49.png" height="225" width="400" /></a></div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">In this video I have an example want to show you with</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">my web hosting using GoDaddy</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">I have domain name want2learn.info and&nbsp;</span><span style="font-family: Arial, Helvetica, sans-serif;">database name is ´test_customer_db´ and table name&nbsp;</span><span style="font-family: Arial, Helvetica, sans-serif;">is ´tbl_customers´.</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">I have 5 fields in this table</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">- customerid</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">- firstname</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">- lastname</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">- address</span><br /> <br /> <span style="font-family: Arial, Helvetica, sans-serif;">- contact</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">And then write php codes&nbsp;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Create file config.php to connect with database</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;?php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">$mysql_hostname = "localhost";</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$mysql_user = "test2015";</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$mysql_password = "test2015";</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$mysql_database = "test_customer_db";</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Opps some thing went wrong");</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">mysql_select_db($mysql_database, $bd) or die("Opps some thing went wrong");</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">?&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Create file index.php to display customers</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;?php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">include('includes/config.php');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">$sql = "SELECT * FROM tbl_customers ORDER BY firstname";</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$rsd = mysql_query($sql);</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">?&gt;</span><br /> <br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;html xmlns="http://www.w3.org/1999/xhtml"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;head&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;meta content="text/html; charset=utf-8" http-equiv="Content-Type" /&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;title&gt;Display Customers&lt;/title&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;/head&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;body&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;a href="new_customer.php" title="Add New Customer"&gt;Add New Customer&lt;/a&gt;&lt;br/&gt;&lt;br/&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;table border="1" cellpadding="3" cellspacing="3"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;tr&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;th width="30"&gt;No. &lt;/th&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;th width="120"&gt;Customer Id&lt;/th&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;th width="120"&gt;First Name&lt;/th&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;th width="120"&gt;Last Name&lt;/th&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;th width="120"&gt;Address&lt;/th&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;th width="100"&gt;Contact&lt;/th&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;th width="25"&gt;&amp;nbsp; &lt;/th&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;th width="25"&gt;&amp;nbsp; &lt;/th&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;/tr&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;?php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$n = 0;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>while($row = mysql_fetch_array($rsd))</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>{<span class="Apple-tab-span" style="white-space: pre;"> </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$n = $n + 1;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$f1 = $row['customerid'];</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$f2 = $row['firstname'];<span class="Apple-tab-span" style="white-space: pre;"> </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$f3 = $row['lastname'];</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$f4 = $row['address'];</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$f5 = $row['contact'];<span class="Apple-tab-span" style="white-space: pre;"> </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>?&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;tr&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;td&gt;&lt;?php echo $n; ?&gt;&lt;/td&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;td&gt;&lt;?php echo $f1; ?&gt;&lt;/td&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;td&gt;&lt;?php echo $f2; ?&gt;&lt;/td&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;td&gt;&lt;?php echo $f3; ?&gt;&lt;/td&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;td&gt;&lt;?php echo $f4; ?&gt;&lt;/td&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;td&gt;&lt;?php echo $f5; ?&gt;&lt;/td&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;td&gt;&lt;a href="update_customer.php?id=&lt;?php echo $f1 ?&gt;"&gt;Edit&lt;/a&gt;&lt;/td&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;td&gt;&lt;a href="delete_customer_data.php?id=&lt;?php echo $f1 ?&gt;"&gt;Delete&lt;/a&gt;&lt;/td&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;/tr&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;?php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>} //while</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>?&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;/table&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;/body&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;/html&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Create file new_customer.php to add new customer form</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;html xmlns="http://www.w3.org/1999/xhtml"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;head&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;meta content="text/html; charset=utf-8" http-equiv="Content-Type" /&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;title&gt;Add New Customer&lt;/title&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;/head&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;body&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;form method="post" action="save_customer_data.php"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>Customer Id&lt;br/&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;input type="text" name="f1"/&gt;&lt;br/&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>First Name&lt;br/&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;input type="text" name="f2"/&gt;&lt;br/&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>Last Name&lt;br/&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;input type="text" name="f3"/&gt;&lt;br/&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>Address&lt;br/&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;textarea rows="3" name="f4"&gt;&lt;/textarea&gt;&lt;br/&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>Contact&lt;br/&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;input type="text" name="f5"/&gt;&lt;br/&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;input type="submit" value="Save" title="Save"/&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;/form&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;/body&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;/html&gt;</span><br /> <br /> <span style="font-family: Arial, Helvetica, sans-serif;">Create file save_customer_data.php to save customer data into database</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;?php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>include('includes/config.php');<span class="Apple-tab-span" style="white-space: pre;"> </span></span><br /> <span class="Apple-tab-span" style="white-space: pre;"><span style="font-family: Arial, Helvetica, sans-serif;"> </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$f1 = $_POST['f1']; //Customer id</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$f2 = $_POST['f2']; //First Name</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$f3 = $_POST['f3']; //Last Name</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$f4 = $_POST['f4']; //Address</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$f5 = $_POST['f5']; //Contact</span><br /> <span class="Apple-tab-span" style="white-space: pre;"><span style="font-family: Arial, Helvetica, sans-serif;"> </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>mysql_query("INSERT INTO tbl_customers (customerid, firstname, lastname, address, contact) VALUES ('". $f1 ."', '". $f2 ."', '". $f3 ."', '". $f4 ."', '". $f5 ."')");</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>mysql_close($bd);</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>header("location: http://www.want2learn.info/website/");</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">?&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Create file delete_customer_data.php to delete customer from database</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;?php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">include('includes/config.php');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">$id = $_GET['id'];</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">mysql_query("DELETE FROM tbl_customers WHERE customerid='". $id ."'");</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">mysql_close($bd);</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">ob_start();</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">header("location: http://www.want2learn.info/website/");</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;"></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">?&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Create file update_customer.php to update customer</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;html xmlns="http://www.w3.org/1999/xhtml"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;head&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;meta content="text/html; charset=utf-8" http-equiv="Content-Type" /&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;title&gt;Update Customer&lt;/title&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;/head&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;body&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;form action="save_update_customer_data.php" method="post"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;?php<span class="Apple-tab-span" style="white-space: pre;"> </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>include('includes/config.php');<span class="Apple-tab-span" style="white-space: pre;"> </span></span><br /> <span class="Apple-tab-span" style="white-space: pre;"><span style="font-family: Arial, Helvetica, sans-serif;"> </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$id = $_GET['id'];</span><br /> <span class="Apple-tab-span" style="white-space: pre;"><span style="font-family: Arial, Helvetica, sans-serif;"> </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$result = mysql_query("SELECT * FROM tbl_customers WHERE customerid='". $id ."'") or die($result."&lt;br/&gt;&lt;br/&gt;".mysql_error());</span><br /> <span class="Apple-tab-span" style="white-space: pre;"><span style="font-family: Arial, Helvetica, sans-serif;"> </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>while($row = mysql_fetch_array($result, MYSQL_BOTH))</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>{<span class="Apple-tab-span" style="white-space: pre;"> </span> &nbsp;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>echo "&lt;input name='f1' value='". $id ."' type='hidden'/&gt;";</span><br /> <span class="Apple-tab-span" style="white-space: pre;"><span style="font-family: Arial, Helvetica, sans-serif;"> </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>echo "First Name&lt;br/&gt;";</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>echo "&lt;input name='f2' value='". $row['firstname'] ."' type='text'/&gt;&lt;br/&gt;";</span><br /> <span class="Apple-tab-span" style="white-space: pre;"><span style="font-family: Arial, Helvetica, sans-serif;"> </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>echo "Last Name&lt;br/&gt;";</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>echo "&lt;input name='f3' value='". $row['lastname'] ."' type='text'/&gt;&lt;br/&gt;";</span><br /> <span class="Apple-tab-span" style="white-space: pre;"><span style="font-family: Arial, Helvetica, sans-serif;"> </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>echo "Address&lt;br/&gt;";<span class="Apple-tab-span" style="white-space: pre;"> </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>echo "&lt;textarea name='f4' rows='3'&gt;". $row['address'] ."&lt;/textarea&gt;&lt;br/&gt;";<span class="Apple-tab-span" style="white-space: pre;"> </span></span><br /> <span class="Apple-tab-span" style="white-space: pre;"><span style="font-family: Arial, Helvetica, sans-serif;"> </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>echo "Contact&lt;br/&gt;";</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>echo "&lt;input name='f5' value='". $row['contact'] ."' type='text'/&gt;&lt;br/&gt;";<span class="Apple-tab-span" style="white-space: pre;"> </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">?&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;br/&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;input type="submit" title="Update" value="Update"/&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;/form&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;/body&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;/html&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Create file save_update_customer_data.php to save update customer into database</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;?php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">include('includes/config.php');<span class="Apple-tab-span" style="white-space: pre;"> </span></span><br /> <span class="Apple-tab-span" style="white-space: pre;"><span style="font-family: Arial, Helvetica, sans-serif;"> </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">if(isset($_POST['f1'], $_POST['f2'], $_POST['f3'], $_POST['f4'], $_POST['f5'])){<span class="Apple-tab-span" style="white-space: pre;"> </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">$f1 = $_POST['f1']; //Customer id</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$f2 = $_POST['f2']; //First Name</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$f3 = $_POST['f3']; //Last Name</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$f4 = $_POST['f4']; //Address</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$f5 = $_POST['f5']; //Contact</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">mysql_query("UPDATE tbl_customers SET firstname='". $f2 ."', lastname='". $f3 ."', address='". $f4 ."', contact='". $f5 ."' WHERE customerid='". $f1 ."'");</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">mysql_close($bd);</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">header("location: http://www.want2learn.info/website/");</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">}<span class="Apple-tab-span" style="white-space: pre;"> </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;"></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">?&gt;</span><br /> <div> <br /></div> <center> <iframe allowfullscreen="" frameborder="0" height="510" src="https://www.youtube.com/embed/a_8Og637QfI" width="100%"></iframe> </center> 0noreply@blogger.com (Ma Chanvadanak)http://video-tutorial-from-youtube.blogspot.com/2015/02/how-to-create-website-pizza-shop-using.htmlPHP PaypalThu, 26 Feb 2015 01:27:00 -0800tag:blogger.com,1999:blog-745581822751602580.post-4809816937244165020<div> <span style="font-family: Arial, Helvetica, sans-serif;">This video learn how to create website Pizza shop using PHP with PayPal REST API</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipsNQlqU0Ajtp3QStgBmdyDosOuwarI-fo9QKTM67rlqIGVlB15glGbpjDmwC0Lxocpnn1ZQoChrRxlvsw7nZW9JPtnC6G-EqHDolh6AQNN430CGsJJaJLY1Lq_ex-fcYtlpevf2nTRYs/s1600/php-paypal.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEipsNQlqU0Ajtp3QStgBmdyDosOuwarI-fo9QKTM67rlqIGVlB15glGbpjDmwC0Lxocpnn1ZQoChrRxlvsw7nZW9JPtnC6G-EqHDolh6AQNN430CGsJJaJLY1Lq_ex-fcYtlpevf2nTRYs/s1600/php-paypal.png" height="225" width="400" /></a></div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Step 1</span></div> <span style="font-family: Arial, Helvetica, sans-serif;"></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"> Pizza App using PayPal REST API<br /><a href="https://github.com/paypal/rest-api-sample-app-php">https://github.com/paypal/rest-api-sample-app-php</a><br /><br />Step 2</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">- Create database "paypal_pizza_app</span><span style="font-family: Arial, Helvetica, sans-serif;">" in phpmyadmin</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">- Extract source codes with step 1 and then create table with install folder</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Step 3</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">- You have a paypal account and status verified&nbsp;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">- Setup API Access in your profile&nbsp;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Step 4</span><br /> <div> <span style="font-family: Arial, Helvetica, sans-serif;">Login into paypal developer and create app<br /><a href="https://developer.paypal.com/developer">https://developer.paypal.com/developer</a></span><br /> <br /></div> <span style="font-family: Arial, Helvetica, sans-serif;">Step 5</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">Update file&nbsp;</span><span style="font-family: Arial, Helvetica, sans-serif;">bootstrap.php in app folder for</span><span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;connection parameters</span><span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;and&nbsp;</span><span style="font-family: Arial, Helvetica, sans-serif;">SDK Configuration with client id and secret with step 3</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Step 6</span><br /> <div> <span style="font-family: Arial, Helvetica, sans-serif;">Download Composer<br /><a href="https://getcomposer.org/download/">https://getcomposer.org/download/</a></span><br /> <br /> <div> <span style="font-family: Arial, Helvetica, sans-serif;">Step 7</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">Composer Update<br /><br />Open command (Window + R) and then write commands here<br /><br />c:\cd xampp<br /><br />C:\xampp&gt;cd php<br /><br />C:\xampp\php&gt;php -r "eval('?&gt;'.file_get_contents('https://getcomposer.org/installer'));"<br /><br />Create file composer.bat in c:/xampp/php/</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">@ECHO OFF</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">SET SUBDIR=%~dp0</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">php %</span><span style="font-family: Arial, Helvetica, sans-serif;">SUBDIR%\composer.phar %*</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br />Run composer.bat</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">Step 8</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">Copy file&nbsp;composer.phar paste to c:/xampp/htdocs/pizza</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">and then write command</span></div> <span style="font-family: Arial, Helvetica, sans-serif;"><br />C:\xampp\htdocs\pizza&gt; php composer.phar self-update<br />C:\xampp\htdocs\pizza&gt; php composer.phar install</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://www.naeemrana.com/technology/how-to-install-composer-dependency-manager-for-php-in-windows/">Read more</a></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">Step 9</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">Demo</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">http://localhost/pizza</span><br /> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> </div> <br /> <center> <iframe allowfullscreen="" frameborder="0" height="510" src="https://www.youtube.com/embed/PqqDRqUh0Cc" width="100%"></iframe> </center> 0noreply@blogger.com (Ma Chanvadanak)http://video-tutorial-from-youtube.blogspot.com/2015/02/how-to-display-data-from-database-using.htmlBootstrapSat, 21 Feb 2015 23:11:00 -0800tag:blogger.com,1999:blog-745581822751602580.post-8434077245602995030<span style="font-family: Arial, Helvetica, sans-serif;">This video learn how to display data from database using bootstrap responsive table with pagination.</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-SNdy7SO7RFfgjyM-Vp4gFSA1G2QOv9YgqJyaV-A7Dy4rq-1KtEba7TK_whuqsas_enfNFagPkN85zu5pxEI-B_9NYLl3UGGHlOmcHTU3k4DObi_Qo8YsVykJ0ut0qA2eYowb9Zoyxvc/s1600/boot4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-SNdy7SO7RFfgjyM-Vp4gFSA1G2QOv9YgqJyaV-A7Dy4rq-1KtEba7TK_whuqsas_enfNFagPkN85zu5pxEI-B_9NYLl3UGGHlOmcHTU3k4DObi_Qo8YsVykJ0ut0qA2eYowb9Zoyxvc/s1600/boot4.png" height="225" width="400" /></a></div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Before you start learn with me you have bootstrap</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">step 1</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Go to download bootstrap from www.getbootstrap.com</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">step 2</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Go to XAMPP and then create web project with display pagination</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">step 3</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Extract bootstrap zip file to c:/xampp/htdocs/websitebootstrap/</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">step 4</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Go to phpmyadmin and then create database name "maps"</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <br /> <center> </center> <span style="font-family: Arial, Helvetica, sans-serif;">CREATE DATABASE maps;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">and then create table "markers"</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">CREATE TABLE `markers` (</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; `name` VARCHAR( 60 ) NOT NULL ,</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; `address` VARCHAR( 80 ) NOT NULL ,</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; `lat` FLOAT( 10, 6 ) NOT NULL ,</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; `lng` FLOAT( 10, 6 ) NOT NULL ,</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; `type` VARCHAR( 30 ) NOT NULL</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">) ENGINE = MYISAM ;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">and then insert data</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">INSERT INTO `markers` (`name`, `address`, `lat`, `lng`, `type`) VALUES ('Pan Africa Market', '1521 1st Ave, Seattle, WA', '47.608941', '-122.340145', 'restaurant');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">INSERT INTO `markers` (`name`, `address`, `lat`, `lng`, `type`) VALUES ('Buddha Thai &amp; Bar', '2222 2nd Ave, Seattle, WA', '47.613591', '-122.344394', 'bar');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">INSERT INTO `markers` (`name`, `address`, `lat`, `lng`, `type`) VALUES ('The Melting Pot', '14 Mercer St, Seattle, WA', '47.624562', '-122.356442', 'restaurant');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">INSERT INTO `markers` (`name`, `address`, `lat`, `lng`, `type`) VALUES ('Ipanema Grill', '1225 1st Ave, Seattle, WA', '47.606366', '-122.337656', 'restaurant');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">INSERT INTO `markers` (`name`, `address`, `lat`, `lng`, `type`) VALUES ('Sake House', '2230 1st Ave, Seattle, WA', '47.612825', '-122.34567', 'bar');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">INSERT INTO `markers` (`name`, `address`, `lat`, `lng`, `type`) VALUES ('Crab Pot', '1301 Alaskan Way, Seattle, WA', '47.605961', '-122.34036', 'restaurant');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">INSERT INTO `markers` (`name`, `address`, `lat`, `lng`, `type`) VALUES ('Mama\'s Mexican Kitchen', '2234 2nd Ave, Seattle, WA', '47.613975', '-122.345467', 'bar');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">INSERT INTO `markers` (`name`, `address`, `lat`, `lng`, `type`) VALUES ('Wingdome', '1416 E Olive Way, Seattle, WA', '47.617215', '-122.326584', 'bar');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">INSERT INTO `markers` (`name`, `address`, `lat`, `lng`, `type`) VALUES ('Piroshky Piroshky', '1908 Pike pl, Seattle, WA', '47.610127', '-122.342838', 'restaurant');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">and then write php codes for connect to database </span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">config.php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;?php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$mysql_hostname = "localhost";</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$mysql_user = "root";</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$mysql_password = "";</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$mysql_database = "maps";</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Opps some thing went wrong");</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">mysql_select_db($mysql_database, $bd) or die("Opps some thing went wrong");</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">?&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">and then create index.php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;?php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">include('includes/config.php');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">$per_page = 5;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$adjacents = 5;&nbsp;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">$pages_query = mysql_query("SELECT COUNT(id), name, address, lat, lng, type FROM markers") or die(mysql_error());</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">//get total number of pages to be shown from &nbsp;total result</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$pages = ceil(mysql_result($pages_query, 0) / $per_page);</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">//get current page from URL ,if not present set it to 1</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$page = (isset($_GET['page'])) ? (int)$_GET['page'] : 1 ;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">//calculate actual start page with respect to Mysql&nbsp;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$start = ($page - 1) * $per_page;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">//execute a mysql query to retrieve &nbsp;all result from current page by using LIMIT keyword in mysql</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">//if &nbsp;query &nbsp;fails stop further execution and show mysql error</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">$query = mysql_query("SELECT id, name, address, lat, lng, type FROM markers LIMIT $start, $per_page") or die(mysql_error());</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">$pagination="Pagination";</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">//if current page is first show first only else reduce 1 by current page</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$Prev_Page = ($page==1)?1:$page - 1;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">//if current page is last show last &nbsp;only else add &nbsp;1 to &nbsp;current page</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$Next_Page = ($page&gt;=$pages)?$page:$page + 1;<span class="Apple-tab-span" style="white-space: pre;"> </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">//if we are not on first page show first link</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">if($page!=1) $pagination.= '&lt;a href="?page=1"&gt;First&lt;/a&gt;';</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">//if we are not on first page show previous link</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">if($page!=1) $pagination.='&lt;a href="?page='.$Prev_Page.'"&gt;Previous&lt;/a&gt;';</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">//we are going to display 5 links on pagination bar</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$numberoflinks=5;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">//find the number of links to show on right of current page</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$upage=ceil(($page)/$numberoflinks)*$numberoflinks;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">//find the number of links to show on left of current page</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$lpage=floor(($page)/$numberoflinks)*$numberoflinks;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">//if &nbsp;number of links on left of current page are zero we start from 1</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$lpage=($lpage==0)?1:$lpage;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">//find the number of links to show on right of current page and make sure it must be less than total number of pages</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$upage=($lpage==$upage)?$upage+$numberoflinks:$upage;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">if($upage&gt;$pages)$upage=($pages-1);</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">//start building links from left to right of current page</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">for($x=$lpage; $x&lt;=$upage; $x++){</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">//if current building link is current page we don't show link,we show as text else we show as linkn<span class="Apple-tab-span" style="white-space: pre;"> </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$pagination.=($x == $page) ? ' &lt;strong&gt;'.$x.'&lt;/strong&gt;' : ' &lt;a href="?page='.$x.'"&gt;'.$x.'&lt;/a&gt;' ;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">//we show next link and last link if user doesn't on last page</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">if($page!=$pages) $pagination.= &nbsp;' &nbsp;&lt;a href="?page='.$Next_Page.'"&gt;Next&lt;/a&gt;';</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">if($page!=$pages) $pagination.= &nbsp;' &lt;a href="?page='.$pages.'"&gt;Last&lt;/a&gt;';</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;"></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">?&gt;</span><br /> <div> <br /></div> <div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;!DOCTYPE html&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;html lang="en"&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;head&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;meta content="width=device-width, initial-scale=1" name="viewport"&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;title&gt;How To Display Data From Database Using Bootstrap Responsive Table With Pagination</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;/title&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;link href="css/bootstrap.min.css" rel="stylesheet"&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;/head&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;body&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;div class="container-fluid"&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;h3&gt;Display Location Address&lt;/h3&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;div class="table-responsive"&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span> &nbsp;&lt;table class="table"&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span> &nbsp; &nbsp;&lt;tr&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span> &nbsp; &nbsp;<span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;th&gt;Location&lt;/th&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span> &nbsp; &nbsp;<span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;th&gt;Address&lt;/th&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span> &nbsp; &nbsp;<span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;th&gt;Latitude&lt;/th&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span> &nbsp; &nbsp;<span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;th&gt;Longtitude&lt;/th&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span> &nbsp; &nbsp;<span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;th&gt;Type&lt;/th&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span> &nbsp; &nbsp;&lt;/tr&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span> &nbsp; &nbsp;&lt;?php<span class="Apple-tab-span" style="white-space: pre;"> </span></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>while($row = mysql_fetch_array($query))</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>{<span class="Apple-tab-span" style="white-space: pre;"> </span></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$f1 = $row['name'];<span class="Apple-tab-span" style="white-space: pre;"> </span></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$f2 = $row['address'];</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$f3 = $row['lat'];</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$f4 = $row['lng'];</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$f5 = $row['type'];</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>?&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;tr&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;td&gt;&lt;?php echo $f1 ?&gt;&lt;/td&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;td&gt;&lt;?php echo $f2 ?&gt;&lt;/td&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;td&gt;&lt;?php echo $f3 ?&gt;&lt;/td&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;td&gt;&lt;?php echo $f4 ?&gt;&lt;/td&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;td&gt;&lt;?php echo $f5 ?&gt;&lt;/td&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;/tr&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;?php</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>} //while</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>?&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span> &nbsp;&lt;/table&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;/div&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;nav&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span> &nbsp;&lt;ul class="pager"&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span> &nbsp; &nbsp;&lt;li&gt;&lt;a href="#"&gt;&lt;?php echo $pagination; ?&gt;&lt;/a&gt;&lt;/li&gt;<span class="Apple-tab-span" style="white-space: pre;"> </span> &nbsp; &nbsp;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span> &nbsp;&lt;/ul&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;/nav&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;/div&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;!-- jQuery (necessary for Bootstrap's JavaScript plugins) --&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js"&gt;&lt;/script&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;!-- Include all compiled plugins (below), or include individual files as needed --&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;script src="js/bootstrap.min.js"&gt;&lt;/script&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;/body&gt;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;/html&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Demo</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">http://localhost/websitebootstrap</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">Source</span><br /> <span style="color: #0000ee; font-family: Arial, Helvetica, sans-serif;"><u><a href="http://downloads.ziddu.com/download/24385321/boostrap_exp1.zip.html">http://downloads.ziddu.com/download/24385321/boostrap_exp1.zip.html</a></u></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">Read more blog</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://www.freeonlinelecture.com/">http://www.freeonlinelecture.com</a></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">Follow Us with Facebook</span><br /> <a href="https://www.facebook.com/pages/PHP-Tutorial/782239958529506" style="font-family: Arial, Helvetica, sans-serif;">https://www.facebook.com/pages/PHP-Tutorial/782239958529506</a></div> </div> <br /> <center> <iframe allowfullscreen="" frameborder="0" height="390" src="https://www.youtube.com/embed/NgrDTmSqqA4" width="100%"></iframe> </center> 0noreply@blogger.com (Ma Chanvadanak)http://video-tutorial-from-youtube.blogspot.com/2015/02/godaddy-review-with-cheap-price-1-per.htmlMiscellaneousSat, 21 Feb 2015 19:25:00 -0800tag:blogger.com,1999:blog-745581822751602580.post-1557018968229586651<span style="font-family: Arial, Helvetica, sans-serif;">This video about GoDaddy review with cheap&nbsp;price $1 per month Hosting + Free domain! Stick it to the slow websites!</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1xSLX2LDt_W4I3q9XeDu3cLb-M0JaK9oX1wkU9NoIP-Ii8MfSkKJqzqfJ8JWaCu26TzYRstl_bHElnbkOGs2-ip9rtCtD57a8N1gR33DsNkqNyJsQ4BOy9Mt0U1IHDT0y-VjHyORBWJ0/s1600/godaddy.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1xSLX2LDt_W4I3q9XeDu3cLb-M0JaK9oX1wkU9NoIP-Ii8MfSkKJqzqfJ8JWaCu26TzYRstl_bHElnbkOGs2-ip9rtCtD57a8N1gR33DsNkqNyJsQ4BOy9Mt0U1IHDT0y-VjHyORBWJ0/s1600/godaddy.png" height="225" width="400" /></a></div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">I Recommended</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">For web design and developer buy it to learn and improve&nbsp;their project experiments and work with a good web hosting.</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;"><b>ECONOMY WEB HOSTING</b></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">- 1 Website</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">- 100 GB Storage</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">- Unlimited Bandwidth</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">- 100 Email Addresses</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">- Free domain with annual plan.&nbsp;<a href="https://www.godaddy.com/hosting/web-hosting.aspx">Read more</a></span><span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;"><b>Buy Now</b></span><br /> <a href="http://www.dpbolvw.net/click-7577222-10864024" style="font-family: Arial, Helvetica, sans-serif;">http://www.dpbolvw.net/click-7577222-10864024</a><span style="font-family: Arial, Helvetica, sans-serif;"></span><br /> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Read more blog</span><br /> <a href="http://www.freeonlinelecture.com/" style="font-family: Arial, Helvetica, sans-serif;">http://www.freeonlinelecture.com</a></div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">Follow Us with Facebook</span><br /> <a href="https://www.facebook.com/pages/PHP-Tutorial/782239958529506" style="font-family: Arial, Helvetica, sans-serif;">https://www.facebook.com/pages/PHP-Tutorial/782239958529506</a><br /> <br /> <center> <iframe allowfullscreen="" frameborder="0" height="510" src="https://www.youtube.com/embed/iUmDYDf6wtE" width="100%"></iframe> </center> 0noreply@blogger.com (Ma Chanvadanak)http://video-tutorial-from-youtube.blogspot.com/2015/02/codeigniter-tutorial-how-to-login-using.htmlCodeIgniterFri, 20 Feb 2015 02:04:00 -0800tag:blogger.com,1999:blog-745581822751602580.post-2784551906975555218<span style="font-family: Arial, Helvetica, sans-serif;">This video learn how to login using Codeigniter.</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEieCbXnUvGELKJX5yZN_hf6V5s82YGxnvjK2fTLwvOlMFYtsbdRXSP4m7tLDfjszkWjg8bXn5AqnOUIKYXQtzCU6lykps8ZIybt4rVoRENimSqMTPz8Jha8RtsOXqoiWY8C5yXKWheMQQs/s1600/code8.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEieCbXnUvGELKJX5yZN_hf6V5s82YGxnvjK2fTLwvOlMFYtsbdRXSP4m7tLDfjszkWjg8bXn5AqnOUIKYXQtzCU6lykps8ZIybt4rVoRENimSqMTPz8Jha8RtsOXqoiWY8C5yXKWheMQQs/s1600/code8.png" height="225" width="400" /></a></div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">1- Create Database "logindb" and then create table</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">CREATE TABLE tbl_users (</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">userid tinyint(4) NOT NULL AUTO_INCREMENT,</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">username varchar(10) NOT NULL,</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">password varchar(100) NOT NULL,</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">PRIMARY KEY (userid)</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">)ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">2- Insert New Row</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">INSERT INTO tbl_users(username,password) VALUES('demo',md5('test'));</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">3- Download Codeigniter</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;- Create web directory name or web root 'loginwebsite'</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;- Extract codeigniter to web root 'loginwebsite'</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp;application</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp;system</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp;index.php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">4- Update application/config/database.php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">$db['default']['hostname'] = 'localhost';</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$db['default']['username'] = 'root';</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$db['default']['password'] = '';</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$db['default']['database'] = 'logindb';</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">5- Update $route['default_controller'] = "loginwebsite"; in application/config/routes.php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">6- Update application/config/autoload.php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">$autoload['libraries'] = array('database','session');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$autoload['helper'] = array('url');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">7- Update encryption_key in application/config/config.php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">$config['encryption_key'] = 'APANtByIGI1BpVXZTJgcsAG8GZl8pdwwa84'</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">8- Create User Model in application/models/user.php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;?php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">Class User extends CI_Model</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">{</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;function login($username, $password)</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;{</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;$this -&gt; db -&gt; select('userid, username, password');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;$this -&gt; db -&gt; from('tbl_users');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;$this -&gt; db -&gt; where('username', $username);</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;$this -&gt; db -&gt; where('password', MD5($password));</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;$this -&gt; db -&gt; limit(1);</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;$query = $this -&gt; db -&gt; get();</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;if($query -&gt; num_rows() == 1)</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;{</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp;return $query-&gt;result();</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;else</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;{</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp;return false;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">?&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">9- Create Login Controller in application/controllers/login.php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">class Login extends CI_Controller {</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;function __construct()</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;{</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;parent::__construct();</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;function index()</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;{</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;$this-&gt;load-&gt;helper(array('form'));</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;$this-&gt;load-&gt;view('login_view');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">?&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">10- Create Login View in application/views/login_view.php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;html xmlns="http://www.w3.org/1999/xhtml"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;&lt;head&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;&lt;title&gt;Simple Login with CodeIgniter&lt;/title&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;&lt;/head&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;&lt;body&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;&lt;h1&gt;Simple Login with CodeIgniter&lt;/h1&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;&lt;?php echo validation_errors(); ?&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;&lt;?php echo form_open('verifylogin'); ?&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp;&lt;label for="username"&gt;Username:&lt;/label&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp;&lt;input type="text" size="20" id="username" name="username"/&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp;&lt;br/&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp;&lt;label for="password"&gt;Password:&lt;/label&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp;&lt;input type="password" size="20" id="passowrd" name="password"/&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp;&lt;br/&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp;&lt;input type="submit" value="Login"/&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;&lt;/form&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;&lt;/body&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;/html&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">11- Create VerifyLogin Controller in application/controllers/verifylogin.php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">class VerifyLogin extends CI_Controller {</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;function __construct()</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;{</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;parent::__construct();</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;$this-&gt;load-&gt;model('user','',TRUE);</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;function index()</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;{</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;//This method will have the credentials validation</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;$this-&gt;load-&gt;library('form_validation');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;$this-&gt;form_validation-&gt;set_rules('username', 'Username', 'trim|required|xss_clean');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;$this-&gt;form_validation-&gt;set_rules('password', 'Password', 'trim|required|xss_clean|callback_check_database');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;if($this-&gt;form_validation-&gt;run() == FALSE)</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;{</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp;//Field validation failed. &nbsp;User redirected to login page</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp;$this-&gt;load-&gt;view('login_view');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;else</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;{</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp;//Go to private area</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp;redirect('home', 'refresh');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;function check_database($password)</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;{</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;//Field validation succeeded. &nbsp;Validate against database</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;$username = $this-&gt;input-&gt;post('username');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;//query the database</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;$result = $this-&gt;user-&gt;login($username, $password);</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;if($result)</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;{</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp;$sess_array = array();</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp;foreach($result as $row)</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp;{</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp;$sess_array = array(</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'userid' =&gt; $row-&gt;userid,</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;'username' =&gt; $row-&gt;username</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp;);</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp;$this-&gt;session-&gt;set_userdata('logged_in', $sess_array);</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp;}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp;return TRUE;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;else</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;{</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp;$this-&gt;form_validation-&gt;set_message('check_database', 'Invalid username or password');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp;return false;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">?&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">12- Create Home Controller in application/controllers/home.php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">session_start(); //we need to call PHP's session object to access it through CI</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">class Home extends CI_Controller {</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;function __construct()</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;{</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;parent::__construct();</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;function index()</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;{</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;if($this-&gt;session-&gt;userdata('logged_in'))</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;{</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp;$session_data = $this-&gt;session-&gt;userdata('logged_in');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp;$data['username'] = $session_data['username'];</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp;$this-&gt;load-&gt;view('home_view', $data);</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;else</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;{</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp;//If no session, redirect to login page</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp;redirect('login', 'refresh');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;function logout()</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;{</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;$this-&gt;session-&gt;unset_userdata('logged_in');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;session_destroy();</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;redirect('home', 'refresh');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">?&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">13- Create Home View in application/views/home_view.php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;html xmlns="http://www.w3.org/1999/xhtml"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;&lt;head&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;&lt;title&gt;Simple Login with CodeIgniter - Private Area&lt;/title&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;&lt;/head&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;&lt;body&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;&lt;h1&gt;Home&lt;/h1&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;&lt;h2&gt;Welcome &lt;?php echo $username; ?&gt;!&lt;/h2&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp;&lt;a href="home/logout"&gt;Logout&lt;/a&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp;&lt;/body&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;/html&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">14- Demo</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">http://localhost/loginwebsite/index.php/login</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">15- Source</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://downloads.ziddu.com/download/24382218/loginwebsite.zip.html">http://downloads.ziddu.com/download/24382218/loginwebsite.zip.html</a></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Read more blog</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://www.freeonlinelecture.com/">http://www.freeonlinelecture.com</a></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">Follow Us with Facebook</span><br /> <a href="https://www.facebook.com/pages/PHP-Tutorial/782239958529506" style="font-family: Arial, Helvetica, sans-serif;">https://www.facebook.com/pages/PHP-Tutorial/782239958529506</a><br /> <div> <br /></div> <center> <iframe allowfullscreen="" frameborder="0" height="510" src="https://www.youtube.com/embed/xNqUvQpUIKM" width="100%"></iframe> </center> 0noreply@blogger.com (Ma Chanvadanak)http://video-tutorial-from-youtube.blogspot.com/2015/02/codeigniter-tutorial-how-to-remove.htmlCodeIgniterThu, 19 Feb 2015 20:43:00 -0800tag:blogger.com,1999:blog-745581822751602580.post-5861312047336095851<span style="font-family: Arial, Helvetica, sans-serif;">This video learn how to remove index from URL with Codeigniter using .htaccess</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <br /> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKZu41gTmMm7Mtoms_Cnvc01oihgBkgQQbUcPA8oEOK5xtB74qpdjSyApjipZyjJga2oEQgv6mVBEvLygS-i-bZ54URy6yTb9J6JCSLa4tHtbD47Uqw0dYLuiYQT73hyZo5jmabiWvYBs/s1600/code7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKZu41gTmMm7Mtoms_Cnvc01oihgBkgQQbUcPA8oEOK5xtB74qpdjSyApjipZyjJga2oEQgv6mVBEvLygS-i-bZ54URy6yTb9J6JCSLa4tHtbD47Uqw0dYLuiYQT73hyZo5jmabiWvYBs/s1600/code7.png" height="225" width="400" /></a></div> <span style="font-family: Arial, Helvetica, sans-serif;">Demo</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://downloads.ziddu.com/download/24381792/curlwebsite.zip.html">http://downloads.ziddu.com/download/24381792/curlwebsite.zip.html</a></span><br /> <div style="text-align: justify;"> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Read more blog</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://www.freeonlinelecture.com/">http://www.freeonlinelecture.com</a></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">Follow Us with Facebook</span><br /> <a href="https://www.facebook.com/pages/PHP-Tutorial/782239958529506" style="font-family: Arial, Helvetica, sans-serif;">https://www.facebook.com/pages/PHP-Tutorial/782239958529506</a><br /> <br /></div> <center> <iframe allowfullscreen="" frameborder="0" height="390" src="https://www.youtube.com/embed/hamnILYRwxs" width="100%"></iframe> </center> 0noreply@blogger.com (Ma Chanvadanak)http://video-tutorial-from-youtube.blogspot.com/2015/02/php-mysql-login-using-bootstrap.htmlBootstrapThu, 19 Feb 2015 04:04:00 -0800tag:blogger.com,1999:blog-745581822751602580.post-3858001685233144145<span style="font-family: Arial, Helvetica, sans-serif;">This video learn about PHP-MySQL Login Using Bootstrap</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBieDkm4iQl1nMP1sC7jzQRhk_Abx0lAmDP_e3SLJoEB2AFN0DnJNJIuWBGvuaYGy5CIoUZ7AYfLATrJ-yiZ5pqStWyYSPLAQJBMYvbs04MYUIjXtsCVeLAyn3c7-ww5FZ6RRWkRNX1EI/s1600/boot3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBieDkm4iQl1nMP1sC7jzQRhk_Abx0lAmDP_e3SLJoEB2AFN0DnJNJIuWBGvuaYGy5CIoUZ7AYfLATrJ-yiZ5pqStWyYSPLAQJBMYvbs04MYUIjXtsCVeLAyn3c7-ww5FZ6RRWkRNX1EI/s1600/boot3.png" height="225" width="400" /></a></div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">1- Create Database "bootstrap" and then create table</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">CREATE TABLE tbl_users</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">- userid</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">- username</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">- password</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">2- Insert New Row</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">INSERT INTO tbl_users(username,password) VALUES('demo@gmail.com',md5('test'));</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">3- Download Bootstrap</span><br /> <br /> <span style="font-family: Arial, Helvetica, sans-serif;">4- Write PHP-MySQL codes for login</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Create web directory name or web root 'clogin'</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Extract bootstrap with css, js, fonts to clogin</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Create folder includes in web root</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">config.php (Save to includes)</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;?php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$mysql_hostname = "localhost";</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$mysql_user = "root";</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$mysql_password = "";</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$mysql_database = "bootstrap";</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Opps some thing went wrong");</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">mysql_select_db($mysql_database, $bd) or die("Opps some thing went wrong");</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">?&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">index.php (Save to web root)</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;?php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">header("location: login.php");</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">?&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">login.php (Save to web root)</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;?php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">session_start();</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">include("includes/config.php");</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">if($_SERVER["REQUEST_METHOD"] == "POST")</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">{</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">// username and password sent from form&nbsp;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$myusername = addslashes($_POST['username']);&nbsp;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$mypassword = md5(addslashes($_POST['password']));</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">$sql = "SELECT userid FROM tbl_users WHERE username='$myusername' and password='$mypassword'";</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$result = mysql_query($sql);</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$count = mysql_num_rows($result);</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">// If result matched $myusername and $mypassword, table row must be 1 row</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">if($count == 1){</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">//session_register("myusername");</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$_SESSION['login_admin']=$myusername;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">header("location: http://localhost/clogin/admin/");</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">?&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;!DOCTYPE html&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;html&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;head&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;meta charset="utf-8"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;meta http-equiv="X-UA-Compatible" content="IE=edge"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;meta name="viewport" content="width=device-width, initial-scale=1"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;meta name="description" content=""&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;meta name="author" content=""&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;link rel="icon" href=""&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;title&gt;PHP-MySQL Login Using Bootstrap&lt;/title&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;!-- Bootstrap core CSS --&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;link href="css/bootstrap.min.css" rel="stylesheet"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;!-- Custom styles for this template --&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;link href="css/signin.css" rel="stylesheet"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;/head&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;body&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;div class="container"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &lt;form class="form-signin" method="post"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;h2 class="form-signin-heading"&gt;Login&lt;/h2&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;label for="inputEmail" class="sr-only"&gt;Email address&lt;/label&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;input name="username" type="email" id="inputEmail" class="form-control" placeholder="Email address" required autofocus&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;label for="inputPassword" class="sr-only"&gt;Password&lt;/label&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;input name="password" type="password" id="inputPassword" class="form-control" placeholder="Password" required&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;div class="checkbox"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;label&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;input type="checkbox" value="remember-me"&gt; Remember me</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/label&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;button class="btn btn-lg btn-primary btn-block" type="submit"&gt;Sign in&lt;/button&gt; &nbsp; &nbsp; &nbsp; &nbsp;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &lt;/form&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;/div&gt; &lt;!-- /container --&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;/body&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;/html&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">logout.php (Save to Web root)</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;?php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">session_start();</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">if(session_destroy())</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">{</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">header("Location: index.php");</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">?&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Create folder admin in web root</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">index.php (Save to admin)</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;!DOCTYPE html&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;html lang="en"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &lt;head&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;meta charset="utf-8"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;meta http-equiv="X-UA-Compatible" content="IE=edge"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;meta name="viewport" content="width=device-width, initial-scale=1"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;meta name="description" content=""&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;meta name="author" content=""&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;link rel="icon" href="../../favicon.ico"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;title&gt;Dashboard Bootstrap&lt;/title&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;!-- Bootstrap core CSS --&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;link href="../css/bootstrap.min.css" rel="stylesheet"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;style&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; body {</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; <span class="Apple-tab-span" style="white-space: pre;"> </span>padding-top: 50px;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>.starter-template {</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span> &nbsp;padding: 40px 15px;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span> &nbsp;text-align: center;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;/style&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &lt;/head&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &lt;body&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;nav class="navbar navbar-inverse navbar-fixed-top"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &lt;div class="container"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;div class="navbar-header"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;span class="sr-only"&gt;Toggle navigation&lt;/span&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;span class="icon-bar"&gt;&lt;/span&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;span class="icon-bar"&gt;&lt;/span&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;span class="icon-bar"&gt;&lt;/span&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/button&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;a class="navbar-brand" href="#"&gt;Dashboard&lt;/a&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;div id="navbar" class="collapse navbar-collapse"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;ul class="nav navbar-nav"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;li class="active"&gt;&lt;a href="#"&gt;Home&lt;/a&gt;&lt;/li&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;li&gt;&lt;a href="#about"&gt;About&lt;/a&gt;&lt;/li&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;li&gt;&lt;a href="#contact"&gt;Contact&lt;/a&gt;&lt;/li&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;li&gt;&lt;a href="../logout.php"&gt;Log Out&lt;/a&gt;&lt;/li&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/ul&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&lt;!--/.nav-collapse --&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &lt;/div&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;/nav&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;div class="container"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &lt;div class="starter-template"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;h1&gt;Dashboard&lt;/h1&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;p class="lead"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; Dashboard page is under construction</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;/p&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &lt;/div&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;/div&gt;&lt;!-- /.container --&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;!-- Bootstrap core JavaScript</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; ================================================== --&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;!-- Placed at the end of the document so the pages load faster --&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js"&gt;&lt;/script&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;script src="../js/bootstrap.min.js"&gt;&lt;/script&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &lt;/body&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;/html&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Demo</span><br /> <a href="http://downloads.ziddu.com/download/24380544/clogin.zip.html"><span style="font-family: Arial, Helvetica, sans-serif;">http://downloads.ziddu.com/download/24380544/clogin.zip.html</span></a><br /> <br /> <span style="font-family: Arial, Helvetica, sans-serif;">Read more blog</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://www.freeonlinelecture.com/">http://www.freeonlinelecture.com</a></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">Follow Us with Facebook</span><br /> <a href="https://www.facebook.com/pages/PHP-Tutorial/782239958529506" style="font-family: Arial, Helvetica, sans-serif;">https://www.facebook.com/pages/PHP-Tutorial/782239958529506</a><br /> <br /> <center> <iframe allowfullscreen="" frameborder="0" height="390" src="https://www.youtube.com/embed/1kJWxm4_olk" width="100%"></iframe> </center> 1noreply@blogger.com (Ma Chanvadanak)http://video-tutorial-from-youtube.blogspot.com/2015/02/bootstrap-tutorial-how-to-create_19.htmlBootstrapThu, 19 Feb 2015 01:03:00 -0800tag:blogger.com,1999:blog-745581822751602580.post-4346617258253321666<span style="font-family: Arial, Helvetica, sans-serif;">This video learn how to create website using CodeIgniter and Bootstrap</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <br /> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi4iVSsXM7Zf5XHNhWCRvDFef9CWBHyIEYoGGuOKGoP2UqNyevFowucXygvChrX_lLmi4QAZILU15M5IAeLGS_CgLFvIxxdFbjnFATPgUnnfqTqyhqi0dbDzMXjQKVwt6vSTxBapd6JfFA/s1600/boot2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi4iVSsXM7Zf5XHNhWCRvDFef9CWBHyIEYoGGuOKGoP2UqNyevFowucXygvChrX_lLmi4QAZILU15M5IAeLGS_CgLFvIxxdFbjnFATPgUnnfqTqyhqi0dbDzMXjQKVwt6vSTxBapd6JfFA/s1600/boot2.png" height="225" width="400" /></a></div> <span style="font-family: Arial, Helvetica, sans-serif;"><b><br /></b></span><span style="font-family: Arial, Helvetica, sans-serif;"><b>Learn CodeIgniter</b></span><br /> <div style="text-align: justify;"> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: Arial, Helvetica, sans-serif;">CodeIgniter is a powerful PHP framework with a very small footprint, built for developers who need a simple and elegant toolkit to create full-featured web applications.&nbsp;</span><a href="http://www.codeigniter.com/" style="font-family: Arial, Helvetica, sans-serif;">Read more</a></div> <div style="text-align: justify;"> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: Arial, Helvetica, sans-serif;"><b>Learn Bootstrap</b></span></div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif; text-align: justify;">Bootstrap is the most popular HTML, CSS, and JS framework for developing responsive, mobile first projects on the web.&nbsp;</span><a href="http://getbootstrap.com/" style="font-family: Arial, Helvetica, sans-serif; text-align: justify;">Read more</a><br /> <div style="text-align: justify;"> <br /></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">Demo</span><br /> <span style="color: #0000ee; font-family: Arial, Helvetica, sans-serif;"><u><a href="http://downloads.ziddu.com/download/24380383/website.zip.html">http://downloads.ziddu.com/download/24380383/website.zip.html</a></u></span><br /> <br /> <span style="font-family: Arial, Helvetica, sans-serif;">Read more blog</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://www.freeonlinelecture.com/">http://www.freeonlinelecture.com</a></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">Follow Us with Facebook</span><br /> <a href="https://www.facebook.com/pages/PHP-Tutorial/782239958529506" style="font-family: Arial, Helvetica, sans-serif;">https://www.facebook.com/pages/PHP-Tutorial/782239958529506</a></div> <br /> <center> <iframe allowfullscreen="" frameborder="0" height="390" src="https://www.youtube.com/embed/tosIzbWtXLI" width="100%"></iframe> </center> 0noreply@blogger.com (Ma Chanvadanak)http://video-tutorial-from-youtube.blogspot.com/2015/02/bootstrap-tutorial-how-to-create.htmlBootstrapWed, 18 Feb 2015 03:09:00 -0800tag:blogger.com,1999:blog-745581822751602580.post-8833381947035937519<span style="font-family: Arial, Helvetica, sans-serif;">This video learn how to create website using Bootstrap</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <br /> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHEMC2_bJ3DY2zgGW0pe3qj4TRnDORtpC7iCNn-VJO62cgMW4vfTkyfxZGBbdNv3zZSShPcxvhNA3Ic0uZOBjDE7Ty_cEjFaMbmWsI8VY3OKDPJ8vCyZdtmE7M362P3pkZ-q7SKdZEG6Y/s1600/boot1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHEMC2_bJ3DY2zgGW0pe3qj4TRnDORtpC7iCNn-VJO62cgMW4vfTkyfxZGBbdNv3zZSShPcxvhNA3Ic0uZOBjDE7Ty_cEjFaMbmWsI8VY3OKDPJ8vCyZdtmE7M362P3pkZ-q7SKdZEG6Y/s1600/boot1.png" height="225" width="400" /></a></div> <span style="font-family: Arial, Helvetica, sans-serif;"><b><br /></b></span> <span style="font-family: Arial, Helvetica, sans-serif;"><b>Learn Bootstrap</b></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif; text-align: justify;">Bootstrap is the most popular HTML, CSS, and JS framework for developing responsive, mobile first projects on the web.&nbsp;</span><a href="http://getbootstrap.com/" style="font-family: Arial, Helvetica, sans-serif; text-align: justify;">Read more</a><br /> <div style="text-align: justify;"> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Demo</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://downloads.ziddu.com/download/24380054/bootstrap.zip.html">http://downloads.ziddu.com/download/24380054/bootstrap.zip.html</a></span><br /> <br /> <span style="font-family: Arial, Helvetica, sans-serif;">Read more blog</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://www.freeonlinelecture.com/">http://www.freeonlinelecture.com</a></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">Follow Us with Facebook</span><br /> <a href="https://www.facebook.com/pages/PHP-Tutorial/782239958529506" style="font-family: Arial, Helvetica, sans-serif;">https://www.facebook.com/pages/PHP-Tutorial/782239958529506</a></div> <br /> <br /> <center> <iframe allowfullscreen="" frameborder="0" height="390" src="https://www.youtube.com/embed/56wwegKz5rg" width="100%"></iframe> </center> 0noreply@blogger.com (Ma Chanvadanak)http://video-tutorial-from-youtube.blogspot.com/2015/02/aspnet-tutorial-add-menu-and-link-to.htmlASP.NETMon, 16 Feb 2015 03:22:00 -0800tag:blogger.com,1999:blog-745581822751602580.post-4141003481891642994<span style="font-family: Arial, Helvetica, sans-serif;">This video learn how to add menu and link pages in Asp.net MVC Template</span><br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLPn1RjHPP0xvVjFEzeRjvuvEXxEA7zPf6ksVp0PiHG0NlBenSka2GiADCev2p-ByYf7kVU73PVbazy8e6URDxnmzsAlFUoKOW92WMKIrnYPMwCIjG0ywMc5IyT0_BF1RFQpGsVCehpNE/s1600/14.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLPn1RjHPP0xvVjFEzeRjvuvEXxEA7zPf6ksVp0PiHG0NlBenSka2GiADCev2p-ByYf7kVU73PVbazy8e6URDxnmzsAlFUoKOW92WMKIrnYPMwCIjG0ywMc5IyT0_BF1RFQpGsVCehpNE/s1600/14.png" height="303" width="400" /></a></div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;"><b>Learn About ASP.NET MVC</b></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif; text-align: justify;">ASP.NET MVC gives you a powerful, patterns-based way to build dynamic websites that enables a clean separation of concerns and that gives you full control over markup for enjoyable, agile development. ASP.NET MVC includes many features that enable fast, TDD-friendly development for creating sophisticated applications that use the latest web standards.&nbsp;</span><a href="http://www.asp.net/mvc" style="font-family: Arial, Helvetica, sans-serif; text-align: justify;">Read more</a><br /> <br /> <div> <span style="font-family: Arial, Helvetica, sans-serif;">Read more blog</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://www.freeonlinelecture.com/">http://www.freeonlinelecture.com</a></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">Follow Us with Facebook</span><br /> <a href="https://www.facebook.com/pages/PHP-Tutorial/782239958529506" style="font-family: Arial, Helvetica, sans-serif;">https://www.facebook.com/pages/PHP-Tutorial/782239958529506</a></div> <br /> <center> <iframe allowfullscreen="" frameborder="0" height="510" src="https://www.youtube.com/embed/UYpSJtOUua4" width="100%"></iframe> </center> 0noreply@blogger.com (Ma Chanvadanak)http://video-tutorial-from-youtube.blogspot.com/2015/02/aspnet-tutorial-create-website-using.htmlASP.NETMon, 16 Feb 2015 03:18:00 -0800tag:blogger.com,1999:blog-745581822751602580.post-3535382475224558179<span style="font-family: Arial, Helvetica, sans-serif;">This video learn about&nbsp;how to create website using Asp.net MVC&nbsp;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <br /> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjb2X1VmJ04CkWgP6n6NwvpSFO0Tq1Xk1NsJzq8Y6W5SGkPmNfN-FQkK91ng8He1KoBGNOtMLXUiceq7OayVtVcgzFFUbV-gd0qViijkMWSPwfsVZ5ce1ep40xBybTBoFPYHwTouzQodnY/s1600/asp.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjb2X1VmJ04CkWgP6n6NwvpSFO0Tq1Xk1NsJzq8Y6W5SGkPmNfN-FQkK91ng8He1KoBGNOtMLXUiceq7OayVtVcgzFFUbV-gd0qViijkMWSPwfsVZ5ce1ep40xBybTBoFPYHwTouzQodnY/s1600/asp.png" height="225" width="400" /></a></div> <span style="font-family: Arial, Helvetica, sans-serif;"><b><br /></b></span> <br /> <div style="text-align: justify;"> <span style="font-family: Arial, Helvetica, sans-serif;"><b>Learn About ASP.NET MVC</b></span></div> <br /> <div style="text-align: justify;"> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <span style="font-family: Arial, Helvetica, sans-serif; text-align: justify;">ASP.NET MVC gives you a powerful, patterns-based way to build dynamic websites that enables a clean separation of concerns and that gives you full control over markup for enjoyable, agile development. ASP.NET MVC includes many features that enable fast, TDD-friendly development for creating sophisticated applications that use the latest web standards. </span><a href="http://www.asp.net/mvc" style="font-family: Arial, Helvetica, sans-serif; text-align: justify;">Read more</a><br /> <br /> <div> <span style="font-family: Arial, Helvetica, sans-serif;">Read more blog</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://www.freeonlinelecture.com/">http://www.freeonlinelecture.com</a></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Follow Us with Facebook</span><br /> <a href="https://www.facebook.com/pages/PHP-Tutorial/782239958529506" style="font-family: Arial, Helvetica, sans-serif;">https://www.facebook.com/pages/PHP-Tutorial/782239958529506</a><br /> <br /></div> <center> <iframe allowfullscreen="" frameborder="0" height="510" src="https://www.youtube.com/embed/07DEoRExAfE" width="100%"></iframe> </center> 0noreply@blogger.com (Ma Chanvadanak)http://video-tutorial-from-youtube.blogspot.com/2015/02/codeigniter-tutorial-how-to-login-with.htmlCodeIgniterMon, 16 Feb 2015 02:55:00 -0800tag:blogger.com,1999:blog-745581822751602580.post-2695947246902500135<span style="font-family: Arial, Helvetica, sans-serif;">This video learn how to login with Facebook using CodeIgniter.</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <br /> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWzyLXr-n5tkIlNmdzrWN2-Uz_Zq1UNgJ-PIcaOqJ3DRuVqXjUa_5xpcYaPghGwhFxNg2LfgZ_ZSTrsva9kV14_cAJEY7BrcaYzeEefPC49K1p0_-O7CzRjX4YV19HdRgHb8qcABCkFSU/s1600/code6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWzyLXr-n5tkIlNmdzrWN2-Uz_Zq1UNgJ-PIcaOqJ3DRuVqXjUa_5xpcYaPghGwhFxNg2LfgZ_ZSTrsva9kV14_cAJEY7BrcaYzeEefPC49K1p0_-O7CzRjX4YV19HdRgHb8qcABCkFSU/s1600/code6.png" height="225" width="400" /></a></div> <span style="font-family: Arial, Helvetica, sans-serif;"><b><br /></b></span> <span style="font-family: Arial, Helvetica, sans-serif;"><b>Facebook.php</b> (Save to application/config folder)</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;?php if (!defined('BASEPATH')) exit('No direct script access allowed');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">$config['appId'] &nbsp; = 'Your App ID';</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$config['secret'] &nbsp;= 'Your App Secret';</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;"></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">?&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;"><b>Welcome.php</b>&nbsp;</span><span style="font-family: Arial, Helvetica, sans-serif;">(Save to application/controllers folder)</span><br /> <div> <br /></div> <div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">class Welcome extends CI_Controller {</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>public function __construct(){</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>parent::__construct();</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; // To use site_url and redirect on this controller.</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;load-&gt;helper('url');</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>}</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>public function login(){</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$this-&gt;load-&gt;library('facebook'); // Automatically picks appId and secret from config</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; // OR</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; // You can pass different one like this</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; //$this-&gt;load-&gt;library('facebook', array(</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; // &nbsp; &nbsp;'appId' =&gt; 'APP_ID',</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; // &nbsp; &nbsp;'secret' =&gt; 'SECRET',</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; // &nbsp; &nbsp;));</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$user = $this-&gt;facebook-&gt;getUser();</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; if ($user) {</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; try {</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $data['user_profile'] = $this-&gt;facebook-&gt;api('/me');</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } catch (FacebookApiException $e) {</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $user = null;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; }else {</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;facebook-&gt;destroySession();</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; }</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; if ($user) {</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $data['logout_url'] = site_url('welcome/logout'); // Logs off application</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // OR&nbsp;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Logs off FB!</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // $data['logout_url'] = $this-&gt;facebook-&gt;getLogoutUrl();</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; } else {</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $data['login_url'] = $this-&gt;facebook-&gt;getLoginUrl(array(</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'redirect_uri' =&gt; site_url('welcome/login'),&nbsp;</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'scope' =&gt; array("email") // permissions here</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ));</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; }</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;load-&gt;view('login',$data);</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>}</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; public function logout(){</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;load-&gt;library('facebook');</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; // Logs off session from website</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;facebook-&gt;destroySession();</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; // Make sure you destory website session as well.</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; redirect('welcome/login');</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; }</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;">}</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> </div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><b>login.php</b>&nbsp;</span><span style="font-family: Arial, Helvetica, sans-serif;">(Save to application/views folder)</span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <div> <span style="font-family: Arial, Helvetica, sans-serif;"></span><br /> <div> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;html&gt;</span></div> <span style="font-family: Arial, Helvetica, sans-serif;"> </span> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div> <span style="font-family: Arial, Helvetica, sans-serif;"> <div> &lt;head&gt;</div> <div> &lt;title&gt;Login with Facebook Using CodeIgniter&lt;/title&gt;</div> <div> &lt;/head&gt;</div> <div> <br /></div> <div> &lt;body&gt;</div> <div> <br /></div> <div> &lt;div class="container"&gt;</div> <div> <span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;form&gt;</div> <div> <span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;!-- @user_profile check when user login successed &nbsp;--&gt;</div> <div> <span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;?php if (@$user_profile): &nbsp;// call var_dump($user_profile) to view all data ?&gt;</div> <div> <span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;!-- Display profile photo --&gt;</div> <div> <span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;img src="https://graph.facebook.com/&lt;?=$user_profile['id']?&gt;/picture?type=large" style="width: 140px; height: 140px;"&gt;</div> <div> <span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;!-- Display profile name --&gt;</div> <div> <span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;h2&gt;&lt;?=$user_profile['name']?&gt;&lt;/h2&gt;</div> <div> <span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;!-- Create link to facebook profile --&gt;</div> <div> <span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;a href="&lt;?=$user_profile['link']?&gt;"&gt;View Profile&lt;/a&gt;</div> <div> <span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;!-- Create link logout --&gt;</div> <div> <span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;a href="&lt;?= $logout_url ?&gt;"&gt;Logout&lt;/a&gt;&nbsp;</div> <div> <span class="Apple-tab-span" style="white-space: pre;"> </span> &nbsp; &nbsp;&lt;!-- Display login when start home page first --&gt;</div> <div> <span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;?php else: ?&gt;</div> <div> <span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;h2&gt;Login with Facebook Using CodeIgniter&lt;/h2&gt;</div> <div> <span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;a href="&lt;?= $login_url ?&gt;"&gt;Login&lt;/a&gt;&nbsp;</div> <div> <span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;?php endif; ?&gt;</div> <div> <span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;/form&gt;</div> <div> &lt;/div&gt;</div> <div> <br /></div> <div> &lt;/body&gt;</div> <div> <br /></div> <div> &lt;/html&gt;</div> <div> <br /></div> <div> libraries download from demo and then extract to application/libraries folder</div> <div> <br /></div> </span></div> <span style="font-family: Arial, Helvetica, sans-serif;">Demo</span><br /> <span style="color: #0000ee; font-family: Arial, Helvetica, sans-serif;"><u><a href="http://downloads.ziddu.com/download/24375128/cfblogin.zip.html">http://downloads.ziddu.com/download/24375128/cfblogin.zip.html</a></u></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Read more blog</span><br /> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://www.freeonlinelecture.com/">http://www.freeonlinelecture.com</a></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">Follow Us with Facebook</span><br /> <a href="https://www.facebook.com/pages/PHP-Tutorial/782239958529506" style="font-family: Arial, Helvetica, sans-serif;">https://www.facebook.com/pages/PHP-Tutorial/782239958529506</a><br /> <br /></div> <center> <iframe allowfullscreen="" frameborder="0" height="510" src="https://www.youtube.com/embed/HcASJnYre6s" width="100%"></iframe> </center> 2noreply@blogger.com (Ma Chanvadanak)http://video-tutorial-from-youtube.blogspot.com/2015/02/php-tutorial-how-to-post-comment-into.htmlFacebookSun, 15 Feb 2015 21:11:00 -0800tag:blogger.com,1999:blog-745581822751602580.post-8868072921669446370<span style="font-family: Arial, Helvetica, sans-serif;">This video learn how to post comment into Facebook Page using PHP-MySQL</span><br /> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1kJGxCKVSVnXoljtybQLkjx3_JYB6KfNoH8Rqq6KRQJsFlwtpXznUvaugoY_HZDTK7yItutlPTNPz0rT6WCmR7SW4f2vzxqwFhc1ELkkk8LH5nQ2dU4lPcaELcikg21L40EQnpTyyEu0/s1600/facebook2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1kJGxCKVSVnXoljtybQLkjx3_JYB6KfNoH8Rqq6KRQJsFlwtpXznUvaugoY_HZDTK7yItutlPTNPz0rT6WCmR7SW4f2vzxqwFhc1ELkkk8LH5nQ2dU4lPcaELcikg21L40EQnpTyyEu0/s1600/facebook2.png" height="225" width="400" /></a></div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Demo</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://downloads.ziddu.com/download/24374578/to-Post-Comment-Into-Facebook-Page-Using-PHP-MySQL.zip.html">http://downloads.ziddu.com/download/24374578/to-Post-Comment-Into-Facebook-Page-Using-PHP-MySQL.zip.html</a></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Read more blog</span><br /> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://www.freeonlinelecture.com/">http://www.freeonlinelecture.com</a></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Follow Us with Facebook</span><br /> <a href="https://www.facebook.com/pages/PHP-Tutorial/782239958529506" style="font-family: Arial, Helvetica, sans-serif;">https://www.facebook.com/pages/PHP-Tutorial/782239958529506</a></div> <div> <br /></div> <center> <iframe allowfullscreen="" frameborder="0" height="510" src="https://www.youtube.com/embed/-gZOKPllG7M" width="100%"></iframe> </center> 1noreply@blogger.com (Ma Chanvadanak)http://video-tutorial-from-youtube.blogspot.com/2015/02/blogger-tutorial-how-to-add-facebook.htmlBloggerSun, 15 Feb 2015 01:22:00 -0800tag:blogger.com,1999:blog-745581822751602580.post-4743988544616376807<span style="font-family: Arial, Helvetica, sans-serif;">This video learn how to add Facebook like box in Blogger</span><br /> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgId849ulB4KLjwlqHdjPXhgE5YIg038nmzsqm18GDhi88JCA6FSiMb8-rLoQHuqgMh9PI6ho8BvwCST-jROTg7EVrNeoLcFno-kpDRe1EFKNwjvwGXXSBI_LrUsDaSE4-AGGCLJ_wMOVU/s1600/blogger4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgId849ulB4KLjwlqHdjPXhgE5YIg038nmzsqm18GDhi88JCA6FSiMb8-rLoQHuqgMh9PI6ho8BvwCST-jROTg7EVrNeoLcFno-kpDRe1EFKNwjvwGXXSBI_LrUsDaSE4-AGGCLJ_wMOVU/s1600/blogger4.png" height="225" width="400" /></a></div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">PayPal is the faster, safer way to send money, make an online payment, receive money or set up a merchant account.&nbsp;<a href="http://paypal.com/">Read more</a></span><br /> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Read more blog</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://www.freeonlinelecture.com/">http://www.freeonlinelecture.com</a></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">Follow Us with Facebook</span><br /> <a href="https://www.facebook.com/pages/PHP-Tutorial/782239958529506" style="font-family: Arial, Helvetica, sans-serif;">https://www.facebook.com/pages/PHP-Tutorial/782239958529506</a></div> <br /> <center> <iframe allowfullscreen="" frameborder="0" height="510" src="https://www.youtube.com/embed/v65Aq9rV5Bs" width="100%"></iframe> </center> 0noreply@blogger.com (Ma Chanvadanak)http://video-tutorial-from-youtube.blogspot.com/2015/02/paypal-tutorial-how-to-create-paypal.htmlMake MoneySat, 14 Feb 2015 21:21:00 -0800tag:blogger.com,1999:blog-745581822751602580.post-3997668500737422952<span style="font-family: Arial, Helvetica, sans-serif;">This video learn how to create&nbsp;PayPal Buy Now, Add to Cart, Donate, Buy Gift Certificate button.</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <br /> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJ40jkLSGC7VRFk-yhGANMNtxFbJLpbxOJ82cpt2X0RVYYaK_IKEcQnmXGC2llYqwagiF06jbhkvJ5fp3GS1FBk9UZsB0PA8BLogUuzGPqhKtu-HC_ycdm-ylVWNAdh5H4oOB2v2m494E/s1600/paypal-logo.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhJ40jkLSGC7VRFk-yhGANMNtxFbJLpbxOJ82cpt2X0RVYYaK_IKEcQnmXGC2llYqwagiF06jbhkvJ5fp3GS1FBk9UZsB0PA8BLogUuzGPqhKtu-HC_ycdm-ylVWNAdh5H4oOB2v2m494E/s1600/paypal-logo.png" height="225" width="400" /></a></div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">PayPal is the faster, safer way to send money, make an online payment, receive money or set up a merchant account. <a href="http://paypal.com/">Read more</a></span><br /> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Read more blog</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://www.freeonlinelecture.com/">http://www.freeonlinelecture.com</a></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">Follow Us with Facebook</span><br /> <a href="https://www.facebook.com/pages/PHP-Tutorial/782239958529506" style="font-family: Arial, Helvetica, sans-serif;">https://www.facebook.com/pages/PHP-Tutorial/782239958529506</a> <br /> <br /> <center> <iframe allowfullscreen="" frameborder="0" height="510" src="https://www.youtube.com/embed/_Bc3HmkZ0BM" width="100%"></iframe> </center> </div> 0noreply@blogger.com (Ma Chanvadanak)http://video-tutorial-from-youtube.blogspot.com/2015/02/blogger-tutorial-how-to-posts-and-pages.htmlBloggerSat, 14 Feb 2015 00:31:00 -0800tag:blogger.com,1999:blog-745581822751602580.post-4557054674684053817<span style="font-family: Arial, Helvetica, sans-serif;">This video learn how to posts, and pages blogger.</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <br /> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBL9foKRLVK5Av-LldRQtMZ2oJSBK8npeit0iAVUtO20tLbRoPc54OGeRmwxdDtpoCC1VP9TZ3XSwigiqz6pIEKH2dOZIvCqxpQwIqTMQrHpZUi6565OVxfu3PGsBz5AMFvfSPKorJ9TY/s1600/blogger3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhBL9foKRLVK5Av-LldRQtMZ2oJSBK8npeit0iAVUtO20tLbRoPc54OGeRmwxdDtpoCC1VP9TZ3XSwigiqz6pIEKH2dOZIvCqxpQwIqTMQrHpZUi6565OVxfu3PGsBz5AMFvfSPKorJ9TY/s1600/blogger3.png" height="225" width="400" /></a></div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Read more blog</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://www.freeonlinelecture.com/">http://www.freeonlinelecture.com</a></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">Follow Us with Facebook</span><br /> <a href="https://www.facebook.com/pages/PHP-Tutorial/782239958529506" style="font-family: Arial, Helvetica, sans-serif;">https://www.facebook.com/pages/PHP-Tutorial/782239958529506</a><br /> <br /> <center> <iframe allowfullscreen="" frameborder="0" height="510" src="https://www.youtube.com/embed/cbtuTGON-E4" width="100%"></iframe> </center> 0noreply@blogger.com (Ma Chanvadanak)http://video-tutorial-from-youtube.blogspot.com/2015/02/how-to-watch-your-youtube-statistics.htmlMake MoneyFri, 13 Feb 2015 20:57:00 -0800tag:blogger.com,1999:blog-745581822751602580.post-8843317650779024046<span style="font-family: Arial, Helvetica, sans-serif;">This video learn how to watch your YouTube Statistics using social blade.</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <br /> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTQOIoeZYaKhY9zhCeGEG_uCwJgPolomo69Lp1JFBlC8CsyOrSGwpsCVUz8esak-4Olb_AepfQ_5VfVVOhefdduFbyE0vKZMxNLQ0vIfVdhJpqtl3FnAyYlYZ2IWtZ0aUM95IkcvFBTGs/s1600/socialblade.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTQOIoeZYaKhY9zhCeGEG_uCwJgPolomo69Lp1JFBlC8CsyOrSGwpsCVUz8esak-4Olb_AepfQ_5VfVVOhefdduFbyE0vKZMxNLQ0vIfVdhJpqtl3FnAyYlYZ2IWtZ0aUM95IkcvFBTGs/s1600/socialblade.png" height="225" width="400" /></a></div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">About Social blade</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">INFORMATION</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">DATA</span><br /> <div style="text-align: justify;"> <span style="font-family: Arial, Helvetica, sans-serif;">Social Blade compiles data from YouTube, Twitch, and Instagram and uses the data to make statistical graphs and charts tracking progress and growth. We include information such as estimated earnings and future projections, providing both numerical data and graphs. Statistics are freely available to anyone using our website or smartphone apps. Social Blade currently tracks over 2.7 million YouTube channels and 352,000 Twitch channels. Social Blade has over 630,000 unique visitors every month.</span></div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">SUPPORT</span><br /> <div style="text-align: justify;"> <span style="font-family: Arial, Helvetica, sans-serif;">Social Blade provides support for our users through several channels. We have a support ticket system where specific questions can be asked and answered by experts. We also provide more general support through our Tip of the Week videos, live chat, and forum.</span></div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;"></span> <span style="font-family: Arial, Helvetica, sans-serif;">Besides providing support about Social Blade, we also aim to help our users with questions about YouTube and Twitch.&nbsp;</span><a href="http://socialblade.com/info" style="font-family: Arial, Helvetica, sans-serif;">Read more</a><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Read more blog</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://www.freeonlinelecture.com/">http://www.freeonlinelecture.com</a></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">Follow Us with Facebook</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="https://www.facebook.com/pages/PHP-Tutorial/782239958529506">https://www.facebook.com/pages/PHP-Tutorial/782239958529506</a></span> <br /> <br /> <center> <iframe allowfullscreen="" frameborder="0" height="390" src="https://www.youtube.com/embed/T794bsHj5Uw" width="100%"></iframe> </center> 1noreply@blogger.com (Ma Chanvadanak)http://video-tutorial-from-youtube.blogspot.com/2015/02/blogger-tutorial-how-to-setup-3rd-party.htmlBloggerFri, 13 Feb 2015 01:14:00 -0800tag:blogger.com,1999:blog-745581822751602580.post-3184635108445478448<span style="font-family: Arial, Helvetica, sans-serif;">This video learn how to setup 3rd party url for your blogger address with GoDaddy domain name.</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <br /> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjK_znCm-z22qy5_Wyqawbs-hm2Q_HAeDzSg2VLSaRGWXbL9BPIxqIuwy3NJJJnKxywrKX0pNY2UTG-PHI8kiNPtzA15WrzzeDdyYrDOd_VudFgBKsyi9rMzNwdCnIIy2rdGh8EpW9wJCw/s1600/blogger2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjK_znCm-z22qy5_Wyqawbs-hm2Q_HAeDzSg2VLSaRGWXbL9BPIxqIuwy3NJJJnKxywrKX0pNY2UTG-PHI8kiNPtzA15WrzzeDdyYrDOd_VudFgBKsyi9rMzNwdCnIIy2rdGh8EpW9wJCw/s1600/blogger2.png" height="225" width="400" /></a></div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Read more blog</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://www.freeonlinelecture.com/">http://www.freeonlinelecture.com</a></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">Follow Us with Facebook</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="https://www.facebook.com/pages/PHP-Tutorial/782239958529506">https://www.facebook.com/pages/PHP-Tutorial/782239958529506</a></span><br /> <div> <br /></div> <br /> <center> <iframe allowfullscreen="" frameborder="0" height="510" src="https://www.youtube.com/embed/zVr9v2u2Lv4" width="100%"></iframe> </center> 0noreply@blogger.com (Ma Chanvadanak)http://video-tutorial-from-youtube.blogspot.com/2015/02/blogger-tutorial-how-to-create-blogger.htmlBloggerThu, 12 Feb 2015 23:48:00 -0800tag:blogger.com,1999:blog-745581822751602580.post-7377522107768118035<span style="font-family: Arial, Helvetica, sans-serif;">This video learn how to create Blogger.</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <br /> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTO2rUtnV4DahL4HCQbJJCzUvWQUtdMtWkpssL-_UXr5vhfn_b11CN8S9_oAyzx4T-u6gSRpqR2QGUL5T9NtycqixVIAN0-PnElyWdMkX2_2S2CXGPFis1KB70hBC1zKtcvbsaEdM7sQM/s1600/blogger1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTO2rUtnV4DahL4HCQbJJCzUvWQUtdMtWkpssL-_UXr5vhfn_b11CN8S9_oAyzx4T-u6gSRpqR2QGUL5T9NtycqixVIAN0-PnElyWdMkX2_2S2CXGPFis1KB70hBC1zKtcvbsaEdM7sQM/s1600/blogger1.png" height="225" width="400" /></a></div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="color: #222222; font-family: arial, sans-serif; font-size: 16px; line-height: 1.2; text-align: justify;">Blogger</span><span style="color: #222222; font-family: arial, sans-serif; font-size: 16px; line-height: 1.2; text-align: justify;">&nbsp;</span><span style="color: #222222; font-family: arial, sans-serif; font-size: 16px; line-height: 1.2; text-align: justify;">is a blog-publishing service that allows multi-user blogs with time-stamped entries. It was developed by Pyra Labs, which was bought by Google in 2003. Generally, the blogs are hosted by Google at a subdomain of blogspot.com. A user can have up to 100 blogs per account.</span><br /> <span style="font-family: Arial, Helvetica, sans-serif; text-align: justify;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif; text-align: justify;">Read more blog</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://www.freeonlinelecture.com/">http://www.freeonlinelecture.com</a></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">Follow Us with Facebook</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="https://www.facebook.com/pages/PHP-Tutorial/782239958529506">https://www.facebook.com/pages/PHP-Tutorial/782239958529506</a></span><br /> <br /> <center> <iframe allowfullscreen="" frameborder="0" height="510" src="https://www.youtube.com/embed/1TJTJffbIS4" width="100%"></iframe> </center> 0noreply@blogger.com (Ma Chanvadanak)http://video-tutorial-from-youtube.blogspot.com/2015/02/google-tutorial-how-to-use-google.htmlGoogleThu, 12 Feb 2015 23:37:00 -0800tag:blogger.com,1999:blog-745581822751602580.post-2264941147991373647<span style="font-family: Arial, Helvetica, sans-serif;">This video learn how to use Google AdWords Keyword Planner</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <br /> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5akfxJqWQfqX9tyhkFclN2x7FhvZsEqzFQvgR-aEck_dI66CMoRG2YKHzf2GF3kl-0FrKFPnIILkv1lA8fH22BlPEVw4DIsMdF8XoIvG3JbXkN9lIjGNW2MLDgP3qaNYOdFiFbUPqTPs/s1600/google1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5akfxJqWQfqX9tyhkFclN2x7FhvZsEqzFQvgR-aEck_dI66CMoRG2YKHzf2GF3kl-0FrKFPnIILkv1lA8fH22BlPEVw4DIsMdF8XoIvG3JbXkN9lIjGNW2MLDgP3qaNYOdFiFbUPqTPs/s1600/google1.png" height="225" width="400" /></a></div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Google AdWords, you now have the power to reach new customers across the web whether they are on desktops, laptops, tablets or mobile devices.</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"></span><br /> <div> <span style="font-family: Arial, Helvetica, sans-serif;">Advertise on the Google Network which is split into the Search Network (which includes Google and other search sites like AOL) and the Display Network (which includes variety of news sites, blogs and other niche sites) Sign-up today.</span><a href="https://services.google.com/fb/forms/semseao/?utm_campaign=awo&amp;utm_source=en-ha-apac-seao-bk-AWS&amp;utm_medium=ha&amp;utm_term=google%20adwords&amp;gclid=Cj0KEQiAu_GmBRDhtK-kzqKcuJwBEiQAJvB8n0HoKrOa2bp_2_WwlYuJHxRTGxplw0KfAMF8ZZq9fcsaAhwl8P8HAQ" style="font-family: Arial, Helvetica, sans-serif;">Red more</a></div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Read more blog</span><br /> <div> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://video-tutorial-from-youtube.blogspot.com/">http://www.freeonlinelecture.com/</a></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">Follow Us with Facebook</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="https://www.facebook.com/pages/PHP-Tutorial/782239958529506">https://www.facebook.com/pages/PHP-Tutorial/782239958529506</a></span><br /> <br /> <center> <iframe allowfullscreen="" frameborder="0" height="510" src="https://www.youtube.com/embed/UcVbz3ke8uM" width="100%"></iframe> </center> </div> 0noreply@blogger.com (Ma Chanvadanak)http://video-tutorial-from-youtube.blogspot.com/2015/02/flash-php-tutorial-how-to-insert-data.htmlFlash PHP MySqlTue, 10 Feb 2015 23:34:00 -0800tag:blogger.com,1999:blog-745581822751602580.post-6777241774114142474<span style="font-family: Arial, Helvetica, sans-serif;">This video learn how to insert data from database using Flash with PHP.</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <br /> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkuZRHDPHUJsM3XKobg13AavEenRaXnbcugEBByH9RqqU4Vyr2vd1zOEC9Zw-X23yEZfOx09Rov40B2aDU80tw6S9fJ_-q4tKAvhj558-2jTSs31wTsL26aIt2wMqs6YVJ_kLcc8ABhNw/s1600/flash2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkuZRHDPHUJsM3XKobg13AavEenRaXnbcugEBByH9RqqU4Vyr2vd1zOEC9Zw-X23yEZfOx09Rov40B2aDU80tw6S9fJ_-q4tKAvhj558-2jTSs31wTsL26aIt2wMqs6YVJ_kLcc8ABhNw/s1600/flash2.png" height="225" width="400" /></a></div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">1- Watch Related Video</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="https://www.youtube.com/watch?v=jgQpnL3ip9E">https://www.youtube.com/watch?v=jgQpnL3ip9E</a></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">2- Create file new_student.php in XAMPP ('C:\xampp\htdocs\phpflash')</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;?php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; //Capture data from $_POST array</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; $name = $_POST['Fullname'];</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; //Connection to database</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; $connect = mysql_connect("localhost", "root", "");</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; mysql_select_db ("mydb", $connect);</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; //Perform the query</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; $result = mysql_query("INSERT INTO students (fullname) VALUES ('$name')");</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">?&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">3- Create flash project "new_student.fla"</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">- Insert Text Tool and then set instance name 'Fullname'</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">- Insert Button from Components and then set instance name 'submit'</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Write codes in Actions - Frame</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">submit.addEventListener("mouseDown", sendData);</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">function sendData(evt:Event)</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">{</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>//for those using PHP</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>var students:URLRequest = new URLRequest("http://localhost/phpflash/new_student.php");</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>students.method = URLRequestMethod.POST;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>var posts:URLVariables = new URLVariables();</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>posts.Fullname = Fullname.text;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>students.data = posts;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>var loader:URLLoader = new URLLoader();</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>loader.dataFormat = URLLoaderDataFormat.VARIABLES;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>loader.load(students);</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">4- demo</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://downloads.ziddu.com/download/24366374/phpflash_1.zip.html">http://downloads.ziddu.com/download/24366374/phpflash_1.zip.html</a></span> <br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Read more blog:</span><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://video-tutorial-from-youtube.blogspot.com/">http://video-tutorial-from-youtube.blogspot.com/</a></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">Follow Us with Facebook</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="https://www.facebook.com/pages/PHP-Tutorial/782239958529506">https://www.facebook.com/pages/PHP-Tutorial/782239958529506</a></span><br /> <br /> <center> <iframe allowfullscreen="" frameborder="0" height="390" src="https://www.youtube.com/embed/Tc2GMDqsdC8" width="100%"></iframe> </center> 0noreply@blogger.com (Ma Chanvadanak)http://video-tutorial-from-youtube.blogspot.com/2015/02/flash-php-tutorial-how-to-display-data.htmlFlash PHP MySqlTue, 10 Feb 2015 20:53:00 -0800tag:blogger.com,1999:blog-745581822751602580.post-1958312402599875490<span style="font-family: Arial, Helvetica, sans-serif;">This video learn how to display data from database using Flash with PHP.</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <br /> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhoa1Bzw9WMqmMQo4OV_U5a9q_ldiejPdG6aKYM-mV7l2b_maO5cwfrz5Qxh43gbauVPOC7ncMgaSzjqxYfWodGet8sv3VDua5i-14l1pBHq91kvXlg-f4zT2BqJb84vqFB5VocFlx0zOg/s1600/flash1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhoa1Bzw9WMqmMQo4OV_U5a9q_ldiejPdG6aKYM-mV7l2b_maO5cwfrz5Qxh43gbauVPOC7ncMgaSzjqxYfWodGet8sv3VDua5i-14l1pBHq91kvXlg-f4zT2BqJb84vqFB5VocFlx0zOg/s1600/flash1.png" height="225" width="400" /></a></div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">1- Create Database 'mydb' in phpmyadmin and then create table 'students'</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Table Fields:</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">- studentid</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">- fullname</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">2- Create file student.php in XAMPP ('C:\xampp\htdocs\phpflash')</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;?php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$link = mysql_connect("localhost", "root", "");</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>mysql_select_db("mydb");</span><br /> <span class="Apple-tab-span" style="white-space: pre;"><span style="font-family: Arial, Helvetica, sans-serif;"> </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$query = "select * from students";</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$results = mysql_query($query);</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&nbsp;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>echo "&lt;?xml version=\"1.0\"?&gt;\n";</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>echo "&lt;students&gt;\n";</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>while($line = mysql_fetch_array($results)){</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>echo "&lt;name&gt;" . $line["fullname"] . "&lt;/name&gt;\n";</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>echo "&lt;/students&gt;\n";</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>mysql_close($link);</span><br /> <span class="Apple-tab-span" style="white-space: pre;"><span style="font-family: Arial, Helvetica, sans-serif;"> </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">?&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">3- Create flash project "student.fla"</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Insert list from Components</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Write codes in Actions - Frame</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">var theXML:XML = new XML();</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">theXML.ignoreWhite = true;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">theXML.onLoad = function()</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">{</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>var nodes = this.firstChild.childNodes;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>for (i = 0; i &lt; nodes.length; i++)</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>{</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>theList.addItem(nodes[i].firstChild.nodeValue,i);</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">};</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">theXML.load("http://localhost/phpflash/student.php");</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">4- demo</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://downloads.ziddu.com/download/24366143/phpflash.zip.html">http://downloads.ziddu.com/download/24366143/phpflash.zip.html</a></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Read more blog:</span><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://video-tutorial-from-youtube.blogspot.com/">http://video-tutorial-from-youtube.blogspot.com/</a></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">Follow Us with Facebook</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="https://www.facebook.com/pages/PHP-Tutorial/782239958529506">https://www.facebook.com/pages/PHP-Tutorial/782239958529506</a></span> <br /> <br /> <center> <iframe allowfullscreen="" frameborder="0" height="390" src="https://www.youtube.com/embed/jgQpnL3ip9E" width="100%"></iframe> </center> 0noreply@blogger.com (Ma Chanvadanak)http://video-tutorial-from-youtube.blogspot.com/2015/02/joomla-tutorial-manual-install-joomla.htmlJoomlaMon, 9 Feb 2015 03:01:00 -0800tag:blogger.com,1999:blog-745581822751602580.post-1397699833848727254<span style="font-family: Arial, Helvetica, sans-serif;">This video learn about manual install joomla using XAMPP.</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <br /> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYi6pfDsXICLqevLLI-PfHO7-g9iHcz4JqV3kYhe0l0aVQl-8BwtalpFlgDyB9iQ5oe2wulAVmEs0dQCoW7jQDpdMJg0LQIFFnj7kY1QwySKMdm2G_Y9I-6X-hE3FGmL-gKhcbDuhIZkg/s1600/joomla3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYi6pfDsXICLqevLLI-PfHO7-g9iHcz4JqV3kYhe0l0aVQl-8BwtalpFlgDyB9iQ5oe2wulAVmEs0dQCoW7jQDpdMJg0LQIFFnj7kY1QwySKMdm2G_Y9I-6X-hE3FGmL-gKhcbDuhIZkg/s1600/joomla3.png" height="225" width="400" /></a></div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Joomla is an award-winning content management system (CMS), which enables you to build Web sites and powerful online applications.</span><br /> <center> </center> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Link Download</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://www.joomla.org/download.html">http://www.joomla.org/download.html</a></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Read more blog:</span><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://video-tutorial-from-youtube.blogspot.com/">http://video-tutorial-from-youtube.blogspot.com/</a></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">Follow Us with Facebook</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="https://www.facebook.com/pages/PHP-Tutorial/782239958529506">https://www.facebook.com/pages/PHP-Tutorial/782239958529506</a></span><br /> <br /> <center> <iframe allowfullscreen="" frameborder="0" height="510" src="https://www.youtube.com/embed/TayRqfMOLqs" width="100%"></iframe> </center> 0noreply@blogger.com (Ma Chanvadanak)http://video-tutorial-from-youtube.blogspot.com/2015/02/codeigniter-tutorial-how-to-update-data.htmlCodeIgniterSun, 8 Feb 2015 23:11:00 -0800tag:blogger.com,1999:blog-745581822751602580.post-5759941289051767337<span style="font-family: Arial, Helvetica, sans-serif;">This video learn how to update data from database using CodeIgniter.</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <br /> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGm3BY9rQcvTZDAfH20u88NI-claOWTVv6hv0PYiy-L0XbYXWrw2axjNoCCR_ZGzkOZFv0Br8CO0ruGX6LxisDYQUG4DejQk9tdJY4Czdv1a26vZNtUJJ8SIfGoCUyUOmmWj02_8-ps2g/s1600/code5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGm3BY9rQcvTZDAfH20u88NI-claOWTVv6hv0PYiy-L0XbYXWrw2axjNoCCR_ZGzkOZFv0Br8CO0ruGX6LxisDYQUG4DejQk9tdJY4Czdv1a26vZNtUJJ8SIfGoCUyUOmmWj02_8-ps2g/s1600/code5.png" height="225" width="400" /></a></div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">1- Watch Related Video Before Start</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="https://www.youtube.com/watch?v=LGatnohVQK4">https://www.youtube.com/watch?v=LGatnohVQK4</a></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">2- Update file autoload.php in "application/config"</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Before&nbsp;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$autoload['helper'] = array();</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">After</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$autoload['helper'] = array('url', 'form', 'html');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">3- Create file update_student.php for Contollers (Save to "application/controllers")</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;?php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">class update_student extends CI_Controller{</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>function __construct(){</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>parent::__construct();</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$this-&gt;load-&gt;model('update_student_model');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>function show_student_id() {</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$id = $this-&gt;uri-&gt;segment(3);</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$data['students'] = $this-&gt;update_student_model-&gt;show_students();</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$data['single_student'] = $this-&gt;update_student_model-&gt;show_student_id($id);</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$this-&gt;load-&gt;view('update_student', $data);</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>}</span><br /> <span class="Apple-tab-span" style="white-space: pre;"><span style="font-family: Arial, Helvetica, sans-serif;"> </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>function update_student_id1() {</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$id= $this-&gt;input-&gt;post('sid');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$data = array(</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>'studentid' =&gt; $this-&gt;input-&gt;post('studentid'),</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>'firstname' =&gt; $this-&gt;input-&gt;post('firstname'),</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>'lastname' =&gt; $this-&gt;input-&gt;post('lastname'),</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>'sex' =&gt; $this-&gt;input-&gt;post('sex')</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>);</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$this-&gt;update_student_model-&gt;update_student_id1($id, $data);</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$this-&gt;show_student_id();</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>redirect('student');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>//echo 'You have been update this student.&lt;br&gt;&lt;a href=http://localhost/student/manage_student/&gt;Go Back&lt;/a&gt;';</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">?&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">4- Create file update_student_model.php for Models (Save to "application/models")</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;?php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">class update_student_model extends CI_Model{</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>// Function To Fetch All Students Record</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>function show_students(){</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$query = $this-&gt;db-&gt;get('students');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$query_result = $query-&gt;result();</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>return $query_result;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>}</span><br /> <span class="Apple-tab-span" style="white-space: pre;"><span style="font-family: Arial, Helvetica, sans-serif;"> </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>// Function To Fetch Selected Student Record</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>function show_student_id($data){</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$this-&gt;db-&gt;select('*');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$this-&gt;db-&gt;from('students');</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$this-&gt;db-&gt;where('studentid', $data);</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$query = $this-&gt;db-&gt;get();</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$result = $query-&gt;result();</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>return $result;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>}</span><br /> <span class="Apple-tab-span" style="white-space: pre;"><span style="font-family: Arial, Helvetica, sans-serif;"> </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>// Update Query For Selected Student</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>function update_student_id1($id, $data){</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$this-&gt;db-&gt;where('studentid', $id);</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$this-&gt;db-&gt;update('students', $data);</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">?&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">5- Create file update_student.php for Views (Save to "application/views")</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;html xmlns="http://www.w3.org/1999/xhtml"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;head&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;meta http-equiv="Content-Type" content="text/html; charset=utf-8" /&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;title&gt;Update Students&lt;/title&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;/head&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;body&gt;<span class="Apple-tab-span" style="white-space: pre;"> </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;h1&gt;Update Data&lt;/h1&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;?php foreach ($single_student as $student): ?&gt;<span class="Apple-tab-span" style="white-space: pre;"> </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;form method="post" action="http://localhost/student/student/update_student/"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;input type="hidden" name="sid" value="&lt;?php echo $student-&gt;studentid; ?&gt;"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;label&gt;Student ID :&lt;/label&gt;&lt;br&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;input type="text" name="studentid" value="&lt;?php echo $student-&gt;studentid; ?&gt;"&gt;&lt;br&gt;&lt;br&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;label&gt;First Name :&lt;/label&gt;&lt;br&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;input type="text" name="firstname" value="&lt;?php echo $student-&gt;firstname; ?&gt;"&gt;&lt;br&gt;&lt;br&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;label&gt;Last Name :&lt;/label&gt;&lt;br&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;input type="text" name="lastname" value="&lt;?php echo $student-&gt;lastname; ?&gt;"&gt;&lt;br&gt;&lt;br&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;label&gt;Sex :&lt;/label&gt;&lt;br&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;input type="text" name="sex" value="&lt;?php echo $student-&gt;sex; ?&gt;"&gt;&lt;br&gt;&lt;br&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;input type="submit" id="submit" name="dsubmit" value="Update"&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;/form&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;?php endforeach; ?&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &lt;br&gt;&lt;a href='http://localhost/student/manage_student/'&gt;Go Back&lt;/a&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;/body&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;/html&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">6- Add link in file manage_student.php for Views</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;td&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;a href='http://localhost/student/student/show/&lt;?php echo $studentid; ?&gt;'&gt;Update&lt;/a&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&lt;/td&gt;</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">7- Add route code with routes.php in "application/config"</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">$route['student'] = "manage_student";</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$route['student/show/(:any)'] = 'update_student/show_student_id/$1';</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">$route['student/update_student'] = 'update_student/update_student_id1';</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Demo</span><br /> <span style="color: #0000ee; font-family: Arial, Helvetica, sans-serif;"><u><a href="http://downloads.ziddu.com/download/24362137/student_update.zip.html">http://downloads.ziddu.com/download/24362137/student_update.zip.html</a></u></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">Read more blog:</span><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://video-tutorial-from-youtube.blogspot.com/">http://video-tutorial-from-youtube.blogspot.com/</a></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">Follow Us with Facebook</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="https://www.facebook.com/pages/PHP-Tutorial/782239958529506">https://www.facebook.com/pages/PHP-Tutorial/782239958529506</a></span> <br /> <br /> <center> <iframe allowfullscreen="" frameborder="0" height="510" src="https://www.youtube.com/embed/yt1ztnuPB5Y" width="100%"></iframe> </center> 0noreply@blogger.com (Ma Chanvadanak)http://video-tutorial-from-youtube.blogspot.com/2015/02/codeigniter-tutorial-how-to-delete-data.htmlCodeIgniterSun, 8 Feb 2015 05:43:00 -0800tag:blogger.com,1999:blog-745581822751602580.post-3123836403100541133<span style="font-family: Arial, Helvetica, sans-serif;">This video learn how to delete data from database using CodeIgniter.</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <br /> <div class="separator" style="clear: both; text-align: center;"> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMqLLUsX0-2iBKKBT4EpagK3wngYC1FepO94uYNoSX4DvFVfF85RTDbDPmhemgbsDG-mc9WCvylt2barIYthr7DN_9OQ8VHinnw76Flsl2iXgQAbbKJdQUGLBDldtkg8p_pGar5lC2Ogs/s1600/code4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMqLLUsX0-2iBKKBT4EpagK3wngYC1FepO94uYNoSX4DvFVfF85RTDbDPmhemgbsDG-mc9WCvylt2barIYthr7DN_9OQ8VHinnw76Flsl2iXgQAbbKJdQUGLBDldtkg8p_pGar5lC2Ogs/s1600/code4.png" height="225" width="400" /></a></div> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Watch Related Video</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="https://www.youtube.com/watch?v=AuQ3e8qvu18">https://www.youtube.com/watch?v=AuQ3e8qvu18</a></span><br /> <br /> <span style="font-family: Arial, Helvetica, sans-serif;">Add Function "delete_student_id" in&nbsp;manage_student.php (Controllers)</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">//This is delete function. I created function name is delete_student_id have one parameter is $studentid</span><br /> <br /> <span style="font-family: Arial, Helvetica, sans-serif;">function delete_student_id($studentid) {</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>//this function call to del_student_id method in file manage_student_model</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$this-&gt;manage_student_model-&gt;del_student_id($studentid);<span class="Apple-tab-span" style="white-space: pre;"> </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>//This is status to show when you delete it ready<span class="Apple-tab-span" style="white-space: pre;"> </span></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>echo 'You have been delete this student.&lt;br&gt;&lt;a href=http://localhost/student/manage_student/&gt;Go Back&lt;/a&gt;';</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Add Function "del_student_id" in&nbsp;manage_student_model.php (Models)</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">//This function is important</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">//function to Delete selected record from table name students </span><span class="Apple-tab-span" style="font-family: Arial, Helvetica, sans-serif; white-space: pre;"> </span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">function del_student_id($studentid){</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; //Where studentid=$studentid is parameter get value from controller manage_student</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;db-&gt;where('studentid', $studentid);</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;">&nbsp; &nbsp; &nbsp; &nbsp; //delete from table students and then update to database</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><span class="Apple-tab-span" style="white-space: pre;"> </span>$this-&gt;db-&gt;delete('students'); &nbsp;&nbsp;</span><br /> <br /> <span style="font-family: Arial, Helvetica, sans-serif;">}</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">Add this code to routers.php</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;">$route['student/delete/(:any)'] = 'manage_student/delete_student_id/$1';</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span> <span style="font-family: Arial, Helvetica, sans-serif;"></span> <span style="font-family: Arial, Helvetica, sans-serif;">Demo</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://downloads.ziddu.com/download/24360486/student.zip.html">http://downloads.ziddu.com/download/24360486/student.zip.html</a></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">Read more blog:</span><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;"><a href="http://video-tutorial-from-youtube.blogspot.com/">http://video-tutorial-from-youtube.blogspot.com/</a></span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><br /></span><span style="font-family: Arial, Helvetica, sans-serif;">Follow Us with Facebook</span><br /> <span style="font-family: Arial, Helvetica, sans-serif;"><a href="https://www.facebook.com/pages/PHP-Tutorial/782239958529506">https://www.facebook.com/pages/PHP-Tutorial/782239958529506</a></span> <br /> <br /> <center> <iframe allowfullscreen="" frameborder="0" height="510" src="https://www.youtube.com/embed/LGatnohVQK4" width="100%"></iframe> </center> 0noreply@blogger.com (Ma Chanvadanak)