Check Traffic Sources

<div dir="ltr" style="text-align: left;" trbidi="on"> <div class="post-body entry-content" id="post-body-3102427741334969112" itemprop="description articleBody" style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 1.4; position: relative; width: 528px;"> <div dir="ltr" trbidi="on"> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTwYz8xGaGIuQPtdMSGXIGk-Bi1DR-pRHS-fDKMO7xNE4xA2WS-1tBeVRbuR3LfW_DZTwlY6bQdnk424L3fhlmCboVzB3_fMuUt8SZ8sYNq3Eip5YKKxHJWkykdgtH7oxMKY_Lg0XL6jc/s1600/trafiic+source.jpg" imageanchor="1" style="clear: right; color: #771100; float: right; margin-bottom: 1em; margin-left: 1em; text-decoration: none;"><img border="0" height="155" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTwYz8xGaGIuQPtdMSGXIGk-Bi1DR-pRHS-fDKMO7xNE4xA2WS-1tBeVRbuR3LfW_DZTwlY6bQdnk424L3fhlmCboVzB3_fMuUt8SZ8sYNq3Eip5YKKxHJWkykdgtH7oxMKY_Lg0XL6jc/s1600/trafiic+source.jpg" style="border: none; position: relative;" width="200" />Click to large</a></div> <b></b><br /> <div dir="ltr" trbidi="on"> <b><b style="line-height: 1.4;">Currently Working on the stuff:</b></b></div> <b> </b>if(isset($_GET['token'])) {<br /> $token = sanitize($_GET['token']);<br /> $sqlcheck = "select `traficsource_source` from `traficsource` where `traficsource_source`='{$token}'";<br /> $result = $dbLink->query($sqlcheck);<br /> if($result->num_rows == 0) <span class="Apple-tab-span" style="white-space: pre;"> </span>{<br /> $sql1="INSERT INTO `traficsource`<br /> (`traficsource_source`, `traficsource_count`, `traficsource_insert`, `traficsource_update`)<br /> VALUES<br /> ('{$token}', '1', CURRENT_TIMESTAMP, now())"; $result = $dbLink->query($sql1);<br /> } else {<br /> $sql1="update `traficsource` set `traficsource_count`=(`traficsource_count`+1),`traficsource_update`=now() where `traficsource_source`='{$token}'"; $result = $dbLink->query($sql1);<br /> }<br /> }</div> </div> </div>

Check Traffic Sources

Click to large Currently Working on the stuff: if(isset($_GET['token'])) { $token = sanitize($_GET['token']); $sqlcheck = "select `traficsource_source` from `traficsource` where `traficsource_source…

Read more »

Text Slider

<div dir="ltr" style="text-align: left;" trbidi="on"><b><span style="color: #660000; font-size: large;">Running Example:</span></b><br /> <div class="moduletable topimg span12"><div align="center" class="mod-custom mod-custom__topimg" style="background-image: url('images/topimg.jpg');"><input id="h1countvalue" name="h1countvalue" type="hidden" value="1" /> <br /> <h1 class="h1_title" id="h1_title1" style="display: block;">PHP is a server side language.</h1><h1 class="h1_title" id="h1_title2" style="display: none;">JQUERY is a client side language.</h1><h1 class="h1_title" id="h1_title3" style="display: none;">CSS is used for styling attribute to be called at once.</h1><h1 class="h1_title" id="h1_title4" style="display: none;">MYSQL is used for storing the database.</h1></div></div><div dir="ltr" style="text-align: left;" trbidi="on"><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">Here I am describing, how to used Text slider:</div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"><br /> </div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">First we need to define style:</div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"><b>  .h1_title </b></div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">{ font-size: 20px;line-height: 22px;font-family: 'Patua One', cursive;font-weight: normal; text-transform: uppercase; letter-spacing: 4px; color:#e7decf;text-align:<wbr></wbr>center; width:50%;padding-top: 25px;display:none; }</div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"><br /> </div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"><b>HTML to be define:</b></div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"><div class="textslider"></div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"><input type="hidden" id="h1countvalue" name="h1countvalue" value="1"/></div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"><br /> </div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"><span style="white-space: pre-wrap;"></span><h1 class="h1_title" id="h1_title1" style="display:block;">WE OFFER OUR CLIENT EXPERT LEGAL ADVICE<br>ALWAYS PROTECT CLIENTS INTERESTS</h1></div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"><br /> </div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"><span style="white-space: pre-wrap;"></span><h1 class="h1_title" id="h1_title2">WE OFFER OUR CLIENT EXPERT LEGAL ADVICE<br>ALWAYS PROTECT CLIENTS INTERESTS</h1></div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"><br /> </div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"><span style="white-space: pre-wrap;"></span><h1 class="h1_title" id="h1_title3">WE OFFER OUR CLIENT EXPERT LEGAL ADVICE<br>ALWAYS PROTECT CLIENTS INTERESTS</h1></div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"><br /> </div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"><span style="white-space: pre-wrap;"></span><h1 class="h1_title" id="h1_title4">WE OFFER OUR CLIENT EXPERT LEGAL ADVICE<br>ALWAYS PROTECT CLIENTS INTERESTS</h1></div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"></div></div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"><br /> </div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"><b>Follwing is the Javascript function:</b></div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">function changeh1()</div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">{</div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">var h1count = $('#h1countvalue').val();</div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">var totalh1 = 4;   // define how much h1 we need to show on slider</div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">if(h1count<totalh1) { h1count = Number(h1count)+1; } else { h1count=1; }</div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">$('.h1_title').css('<wbr></wbr>display','none');</div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">$('.h1_title').fadeOut('<wbr></wbr>fast');</div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">$('#h1_title'+h1count).<wbr></wbr>fadeIn('slow');</div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">$('#h1countvalue').val(<wbr></wbr>h1count);</div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">}</div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"><br /> </div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"><b>Now we need to call function as a regular Internal:</b></div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">setInterval(function(){<wbr style="background-color: transparent;"></wbr>changeh1()},5000);   // 5000 is equal to 5 Second, It is defined on Miliseconds.  </div><div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"><br /> </div></div></div>

Text Slider

Running Example: PHP is a server side language.JQUERY is a client side language.CSS is used for styling attribute to be called at once.MYSQL is used for storing the database.Here I am describing, h…

Read more »

PHP Variable

<div dir="ltr" style="text-align: left;" trbidi="on"> <br /> <div dir="ltr" style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;" trbidi="on"> <div dir="ltr" trbidi="on"> <div style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuTUsagMrh-fGK5TYF88sPKqFomqd91YS0mS7-hv0_-jgUzEmXOxn-oStKFGaiPaq6iA35Nq4mdfkreDKMdXWTTyPuEdLIS2oKNzsEujfRo90zeizWsrWmjy2aG7wNHYM_A-wOrEWwsaY/s1600/all+variables.jpg" imageanchor="1" style="color: #771100; text-decoration: none;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuTUsagMrh-fGK5TYF88sPKqFomqd91YS0mS7-hv0_-jgUzEmXOxn-oStKFGaiPaq6iA35Nq4mdfkreDKMdXWTTyPuEdLIS2oKNzsEujfRo90zeizWsrWmjy2aG7wNHYM_A-wOrEWwsaY/s320/all+variables.jpg" style="border: none; position: relative;" /></a><br /><div style="text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuTUsagMrh-fGK5TYF88sPKqFomqd91YS0mS7-hv0_-jgUzEmXOxn-oStKFGaiPaq6iA35Nq4mdfkreDKMdXWTTyPuEdLIS2oKNzsEujfRo90zeizWsrWmjy2aG7wNHYM_A-wOrEWwsaY/s1600/all+variables.jpg" imageanchor="1" style="color: #771100; text-decoration: none;"></a>Click to Enlarge</div> </div> Here I am Describing Basic of Variable.<br /><br />There are many type of variable used in PHP.<br /><br />Following are some:<br /><br /><ul style="line-height: 1.4; list-style-image: initial; list-style-position: initial; margin: 0.5em 0px; padding: 0px 2.5em;"> <li style="border: none; margin: 0px 0px 0.25em; padding: 0px;"><b>Variable from GET Method </b></li> <li style="border: none; margin: 0px 0px 0.25em; padding: 0px;"><b>Variable from POST Method </b></li> <li style="border: none; margin: 0px 0px 0.25em; padding: 0px;"><b>Variable Used in a PHP program itself</b></li> <li style="border: none; margin: 0px 0px 0.25em; padding: 0px;"><b>Variable from SESSION </b><b> </b></li> <li style="border: none; margin: 0px 0px 0.25em; padding: 0px;"><b>Variable from COOKIES</b></li> </ul> <b><br /></b></div> <br /><div style="clear: both;"> </div> <table border="2"><tbody> <tr class="tableheading" style="background: rgb(12, 15, 73); color: #ebc7c7; font-size: 14px; font-weight: bold; text-transform: uppercase;"><td style="padding: 10px;"><div style="text-align: center;"> <b>VARIABLE TYPE</b></div> </td><td style="padding: 10px;"><h3 style="margin: 0px; position: relative; text-align: center;"> <b>DESCRIPTION</b></h3> </td></tr> <tr class="tablecontent1" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; color: #050000; font-family: tahoma;"><td style="padding: 10px;"><div style="text-align: center;"> GET Method Variable</div> </td><td style="padding: 10px;"><b>Variable Used as</b>: Array<br /><hr /> <b>Using Technique</b>: As Following:<br /><ul style="line-height: 1.4; list-style-image: initial; list-style-position: initial; margin: 0.5em 0px; padding: 0px 2.5em;"> <li style="border: none; margin: 0px 0px 0.25em; padding: 0px;">By referencing in URL i.e. filname.php?variable1=value1&variable2=value2</li> <li style="border: none; margin: 0px 0px 0.25em; padding: 0px;">By Sending by FORM method will be GET i.e. By HTML Input fields like text, password, select etc.</li> </ul> <hr /> <b>Validity/ Scope:</b> Till they reference in URl or sent by Forms<br /><hr /> <b>Calling as: </b>Called as $_GET['variable1'] and $_GET['variable2']</td></tr> <tr class="tablecontent2" style="background: rgb(238, 238, 238); color: #051808; font-family: tahoma;"><td style="padding: 10px;"><div style="text-align: center;"> POST Method Variable</div> </td><td style="padding: 10px;"><b>Variable Used as</b>: Array<br /><hr /> <b>Using Technique</b>: As Following:<br /><ul style="line-height: 1.4; list-style-image: initial; list-style-position: initial; margin: 0.5em 0px; padding: 0px 2.5em;"> <li style="border: none; margin: 0px 0px 0.25em; padding: 0px;">By Sending by FORM method will be POST i.e. By HTML Input fields like text, password, select etc.</li> </ul> <hr /> <b>Validity/ Scope:</b> Till sent by Forms and the File is running<br /><hr /> <b>Calling as: </b>Called as $_POST['variable1'] and $_POST['variable2']</td></tr> </tbody></table> </div> <div style="background-color: white; color: #cc0000; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 22px; font-weight: bold;"> <br /><div style="text-align: right;"> To be continue ............</div> </div> </div>

PHP Variable

Click to Enlarge Here I am Describing Basic of Variable.There are many type of variable used in PHP.Following are some: Variable from GET Method  Variable from POST Method  Variable Used in a PHP pro…

Read more »

Basic Website standard must to be maintain in web development

<div dir="ltr" style="text-align: left;" trbidi="on"> <br /> <div class="post-footer" style="-webkit-text-stroke-width: 0px; background-color: white; color: #999999; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 1.6; margin: 0.5em 0px 0px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;"> <div class="post-footer-line post-footer-line-1"> <span class="post-comment-link" style="margin-left: 0px; margin-right: 1em;"></span><span class="reaction-buttons" style="margin-right: 0px;"></span></div> </div> <br /> <div class="post-body entry-content" id="post-body-8822093338269056221" itemprop="description articleBody" style="-webkit-text-stroke-width: 0px; background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 1.4; orphans: auto; position: relative; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; width: 528px; word-spacing: 0px;"> <div dir="ltr" style="text-align: left;" trbidi="on"> <div> <b>Here we are describing Basic standard to maintain for Proper optimize website</b></div> <div> <span style="color: #222222; font-family: arial, sans-serif; font-size: xx-small;"><span style="background-color: white;"><br /></span></span></div> <div> <span style="color: #222222; font-family: arial, sans-serif; font-size: xx-small;"><span style="background-color: white;">Website Standard to Maintain</span></span><br /><div class="separator" style="clear: both; text-align: center;"> <span style="color: #222222; font-family: arial, sans-serif; font-size: xx-small;"><span style="background-color: white;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj07E5Kk2pM8vo5L0XSzO3o-zejYzZhL58miCV3WM42ejjeg2c9iwCwp4s7WE5U3X5I-A99jj2CvGBu_4qYg3DTZKBoOUI-n80SCa_s3wCJBXhoxUB1n_qaBf9ckMtd8-0SRbzKLO33mFfi/s1600/Standard-Website-Design-Package.jpg" imageanchor="1" style="clear: right; color: #771100; float: right; margin-bottom: 1em; margin-left: 1em; text-decoration: none;"><img alt="Web Development Help" border="0" height="122" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj07E5Kk2pM8vo5L0XSzO3o-zejYzZhL58miCV3WM42ejjeg2c9iwCwp4s7WE5U3X5I-A99jj2CvGBu_4qYg3DTZKBoOUI-n80SCa_s3wCJBXhoxUB1n_qaBf9ckMtd8-0SRbzKLO33mFfi/s1600/Standard-Website-Design-Package.jpg" style="border: none; position: relative;" title="Basic Website Standard" width="200" /></a></span></span></div> <span style="color: #222222; font-family: arial, sans-serif; font-size: xx-small;"><span style="background-color: white;"><div style="text-align: right;"> </div> </span></span></div> <div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"> <ul style="line-height: 1.4; list-style: disc; margin: 0.5em 0px; padding: 0px 2.5em;"> <li style="border: none; margin: 0px 0px 0.25em 15px; padding: 0px; text-indent: 0px;">Proper Title of all pages</li> <li style="border: none; margin: 0px 0px 0.25em 15px; padding: 0px; text-indent: 0px;">Meta Tag and description correct on all pages</li> <li style="border: none; margin: 0px 0px 0.25em 15px; padding: 0px; text-indent: 0px;">Create Sitemap with Priority on XML</li> <li style="border: none; margin: 0px 0px 0.25em 15px; padding: 0px; text-indent: 0px;">Don’t include sitemap.xml and robot.txt in search Engine or as Back links </li> <li style="border: none; margin: 0px 0px 0.25em 15px; padding: 0px; text-indent: 0px;">Verified the site on webmasters provided by various search Engine</li> <li style="border: none; margin: 0px 0px 0.25em 15px; padding: 0px; text-indent: 0px;">Proper Navigation to site</li> <li style="border: none; margin: 0px 0px 0.25em 15px; padding: 0px; text-indent: 0px;">Sitemap on front for user to easily browse the whole website</li> <li style="border: none; margin: 0px 0px 0.25em 15px; padding: 0px; text-indent: 0px;">Standard HTMl docs type and CSS Validation</li> </ul> </div> </div> <div style="clear: both;"> </div> </div> </div>

Basic Website standard must to be maintain in web development

Here we are describing Basic standard to maintain for Proper optimize website Website Standard to Maintain Proper Title of all pages Meta Tag and description correct on all pages Create Sitemap with …

Read more »

How to connect to Database using PHP

<div dir="ltr" style="text-align: left;" trbidi="on"> <b style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;"><span style="color: red;">How to connect to Database:</span></b><br /> <b style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;"><br /></b><span style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;"></span> <div class="separator" style="background-color: white; clear: both; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhechpe6W-9DvaOM9QveUtua0V5JfBj_LroQazEosK8KuPfy-xw8FZzEXnKxpmw9YfvdMnCqtQf3sW01AP6zwraczgNoJOEufWv0jEu6cAWdir4etLiILd5cKT8hhoM-t6lxCoo-M9ZObj5/s1600/db-connection1.jpg" imageanchor="1" style="clear: right; color: #771100; float: right; margin-bottom: 1em; margin-left: 1em; text-decoration: none;"><img border="0" height="212" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhechpe6W-9DvaOM9QveUtua0V5JfBj_LroQazEosK8KuPfy-xw8FZzEXnKxpmw9YfvdMnCqtQf3sW01AP6zwraczgNoJOEufWv0jEu6cAWdir4etLiILd5cKT8hhoM-t6lxCoo-M9ZObj5/s1600/db-connection1.jpg" style="border: none; position: relative;" width="320" /></a></div> <b style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;"><br /></b><span style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">Here we will know about the database connectivity on PHP.</span><br /> <br style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;" /> <span style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">Firstly we have to check database credential of the server,</span><br /> <br style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;" /> <span style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">Usually They are as following:</span><br /> <b style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">For Local Server (i.e. XAMPP/ WAMPP etc.)</b><br /> <span style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">Server: localhost</span><br /> <span style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">Username: root</span><br /> <span style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">Password:   (blank)</span><br /> <b style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">For Server  (i.e. cpanel, window etc)</b><br /> <span style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">Server: localhost  or domain name of the website</span><br /> <span style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">Username: can be created by Hosting panel using Database wizard (Cpanel) or Option proided on the same</span><br /> <span style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">Password:  same as above</span><br /> <br style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;" /> <b style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">We have to create a database to connect with a particular database for a particular  website or Program.</b><br /> <br style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;" /> <span style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">Now we will define all on a variable:</span><br /> <span style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;"><?php</span><br /> <b style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">$databaseserver</b><span style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;"> = "localhost";   // can be changed as required</span><br /> <b style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">$databaseuser =  "</b><span style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">dbadmin</span><b style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">";   // </b><span style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">as exapmle I have taken it dbadmin</span><br /> <b style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">$databasepassword</b><span style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;"> = "W3help@123";  // as exapmle,  use password as strong, use Capital, small, Number and special Character. Probability of such password guessing is less</span><br /> <b style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">$databasename</b><span style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;"> = "wehlpdatabase";   //  can be changed as required</span><br /> <span style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">?></span><br /> <div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"> <b>I am describing two ways for running database query from PHP</b></div> <div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;"> <br /></div> <div style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: 13px;"> <b><span style="color: #741b47;">###    One Way  ###</span></b></div> <span style="background-color: white; color: #a64d79; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;"><?php</span><br /> <div style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #a64d79;">// database connection</span></div> <div style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #a64d79;">$dbLink = new mysqli(<b>$<span style="font-family: 'Times New Roman'; font-size: x-small;">databaseserver</span><span style="font-family: 'Times New Roman'; font-size: x-small;"> </span>,$<span style="font-family: 'Times New Roman'; font-size: x-small;">databaseuser </span>,$<span style="font-family: 'Times New Roman'; font-size: x-small;">databasepassword</span><span style="font-family: 'Times New Roman'; font-size: x-small;"> </span>,$<span style="font-family: 'Times New Roman'; font-size: x-small;">databasename</span><span style="font-family: 'Times New Roman'; font-size: x-small;"> </span></b>);</span></div> <div style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #a64d79;">if (!@$dbLink)  { echo "OOPPS.......<br/> something went wrong"; }</span></div> <div style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #a64d79;">// database connection</span></div> <div style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #a64d79;"><br /></span></div> <div style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: 13px;"> <div> <span style="color: #a64d79;">// create query</span></div> <div> <span style="color: #a64d79;">$sql  = "select * from table";   // change the query as required</span></div> <div> <span style="color: #a64d79;">// create query</span></div> <div> <span style="color: #a64d79;"><br /></span></div> </div> <div style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #a64d79;">// sql run</span></div> <div style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #a64d79;">$result = $dbLink->query($sql);</span></div> <div style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #a64d79;">// sql run</span></div> <div style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #a64d79;"><br /></span></div> <div style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #a64d79;">// for no results</span></div> <div style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #a64d79;">if($result->num_rows == 0)  {  </span></div> <div style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #a64d79;">// for no results</span></div> <div style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #a64d79;">// write code for no results here</span></div> <div style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #a64d79;">// for no results</span></div> <div style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #a64d79;">} else {  while($row = $result->fetch_assoc()) {  </span></div> <div style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #a64d79;">// for getting every result</span></div> <div style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #a64d79;">/* </span></div> <div style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #a64d79;">write code here for results</span></div> <div style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #a64d79;">$row is a array for results with index attribute of database's table </span></div> <div style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #a64d79;">for example id is a attribute of any table</span></div> <div style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #a64d79;">you can echo it using  $row['id'];</span></div> <div style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #a64d79;">*/</span></div> <div style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #a64d79;">// for getting every result</span></div> <div style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #a64d79;">}  // while loop end</span></div> <div style="background-color: white; color: #333333; font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #a64d79;">}  // else part of no resulta</span></div> <div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;"> <span style="color: #a64d79;">?></span></div> <div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;"> <div style="font-family: arial, sans-serif; font-size: 13px;"> <b><span style="color: #741b47;">###    One Way  ###</span></b></div> </div> <div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;"> <b><br /></b></div> <div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;"> <b><span style="color: #351c75;">###  Another way  ###</span></b></div> <div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;"> <div> <span style="color: #674ea7;"><?php</span></div> <div> <span style="color: #674ea7;">mysql_connect(<b style="font-family: arial, sans-serif; font-size: 13px;">$<span style="font-family: 'Times New Roman'; font-size: x-small;">databaseserver</span><span style="font-family: 'Times New Roman'; font-size: x-small;"> </span>,$<span style="font-family: 'Times New Roman'; font-size: x-small;">databaseuser </span>,$<span style="font-family: 'Times New Roman'; font-size: x-small;">databasepassword</span><span style="font-family: 'Times New Roman'; font-size: x-small;"> </span>,$<span style="font-family: 'Times New Roman'; font-size: x-small;">databasename</span></b>);</span></div> <div> <span style="color: #674ea7;">// checking the connection</span></div> <div> <span style="color: #674ea7;">if (mysql_connect_errno())</span></div> <div> <span style="color: #674ea7;">  {</span></div> <div> <span style="color: #674ea7;">  <span style="font-family: arial, sans-serif; font-size: 13px;">echo "OOPPS.......<br/> something went wrong";</span></span></div> <div> <span style="color: #674ea7;">  }</span></div> <div> <span style="color: #674ea7;"><br /></span></div> <div> <span style="color: #674ea7;">$result = mysql_query("select * from table");   // run query in server</span></div> <div> <span style="color: #674ea7;">$numrow = mysql_num_rows($result);  // check how much row in results</span></div> <div> <span style="color: #674ea7;">if($numrow>0)  { while($row = mysql_fetch_array($result))   {  // while loop</span></div> <div> <div style="font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #674ea7;">// for getting every result</span></div> <div style="font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #674ea7;">/* </span></div> <div style="font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #674ea7;">write code here for results</span></div> <div style="font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #674ea7;">$row is a array for results with index attribute of database's table </span></div> <div style="font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #674ea7;">for example id is a attribute of any table</span></div> <div style="font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #674ea7;">you can echo it using  $row['id'];</span></div> <div style="font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #674ea7;">*/</span></div> <div style="font-family: arial, sans-serif; font-size: 13px;"> <span style="color: #674ea7;">// for getting every result</span></div> </div> <div> <span style="color: #674ea7;"> }  // while loop </span></div> <div> <span style="color: #674ea7;">} else {</span></div> <div> <span style="color: #674ea7;">// no results code here</span></div> <div> <span style="color: #674ea7;">// code for no results</span></div> <div> <span style="color: #674ea7;">// no results code here</span></div> <div> <span style="color: #674ea7;">}</span></div> <div> <span style="color: #674ea7;"><br /></span></div> <div> <span style="color: #674ea7;">?></span></div> </div> <div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;"> <b><span style="color: #351c75;">###  Another way  ###</span></b></div> </div>

How to connect to Database using PHP

How to connect to Database: Here we will know about the database connectivity on PHP. Firstly we have to check database credential of the server, Usually They are as following: For Local Server (i.e.…

Read more »

Visitor Count for Website in PHP

<div dir="ltr" style="text-align: left;" trbidi="on"> <span style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;">Hello,</span><br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;" /><span style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;">Here I am writing a small program in PHP for  checking how much user have visited our website using COOKIES, MYSQL and IP address of the user.</span><br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;" /><span style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;">First we have to create cookies for the new user.</span><br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;" /><br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;" /><span style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;">This the code we will use for that: (I have make a cookies for 30 days)</span><br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;" /><span style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;">setcookie('ipaddress',$_SERVER['REMOTE_ADDR'],time()+(60*60*24*30));</span><br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;" /><br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;" /><span style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;">Secondly we have to create a table on database to store the number of Visitors.</span><br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;" /><span style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;">I have created a table i.e. </span><b style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;">usercounter </b><span style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;">with following attribute:  (Initially Insert value with o and 1 on useripid )</span><br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;" /><br /> <ul style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px; list-style-image: initial; list-style-position: initial; margin: 0.5em 0px; outline: none; padding: 0px 0px 0px 2em;"> <li style="margin: 0px; outline: none; padding: 0px;">useripid   (INT type - AUTO-INCREMENT)</li> <li style="margin: 0px; outline: none; padding: 0px;">lastaddress   (VARCHAR    -   Last visitor IP)</li> <li style="margin: 0px; outline: none; padding: 0px;">userqua   (INT)   (Counter for visitor)  (Initially 0)</li> <li style="margin: 0px; outline: none; padding: 0px;">lastmodified   (TIMESTAMP)   (Last modified time for database)</li> </ul> <div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px; margin: 0px; outline: none; padding: 0px;"> Now we have to check whether user are coming on website for first time or He has already visited.</div> <div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px; margin: 0px; outline: none; padding: 0px;"> if(isset($_COOKIE['ipaddress'])) {</div> <div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px; margin: 0px; outline: none; padding: 0px;"> // check is the same ip</div> <div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px; margin: 0px; outline: none; padding: 0px;"> if($_COOKIE['ipaddress']==$_SERVER['REMOTE_ADDR']) {  // nothing to do.</div> <div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px; margin: 0px; outline: none; padding: 0px;"> // check is the same ip</div> <div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px; margin: 0px; outline: none; padding: 0px;">  } else { // diffrent IP</div> <div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px; margin: 0px; outline: none; padding: 0px;"> // update the database</div> <br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;" /> <div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px; margin: 0px; outline: none; padding: 0px;"> $sqlupdate="UPDATE `userip` SET `lastaddress`='{$_SERVER['REMOTE_ADDR']}',`userqua`=(`userqua`+1),`lastmodified`=now() WHERE  `useripid` =1;";</div> <div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px; margin: 0px; outline: none; padding: 0px;"> <div style="margin: 0px; outline: none; padding: 0px;"> setcookie('ipaddress',$_SERVER['REMOTE_ADDR'],time()+(60*60*24*30));</div> <div style="margin: 0px; outline: none; padding: 0px;"> $resultupdate = $dbLink->query($sqlupdate);</div> </div> <br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;" /> <div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px; margin: 0px; outline: none; padding: 0px;"> // update the database </div> <div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px; margin: 0px; outline: none; padding: 0px;"> } // diffrent IP</div> <div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px; margin: 0px; outline: none; padding: 0px;"> } else  {  // first time user</div> <div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px; margin: 0px; outline: none; padding: 0px;"> // set the cookies</div> <div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px; margin: 0px; outline: none; padding: 0px;"> setcookie('ipaddress',$_SERVER['REMOTE_ADDR'],time()+(60*60*24*30));</div> <div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px; margin: 0px; outline: none; padding: 0px;"> // update on database</div> <br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;" /> <div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px; margin: 0px; outline: none; padding: 0px;"> $sqlupdate="UPDATE `userip` SET `lastaddress`='{$_SERVER['REMOTE_ADDR']}',`userqua`=(`userqua`+1),`lastmodified`=now()</div> <div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px; margin: 0px; outline: none; padding: 0px;"> <div style="margin: 0px; outline: none; padding: 0px;"> WHERE  `useripid` =1"; </div> <div style="margin: 0px; outline: none; padding: 0px;"> $resultupdate = $dbLink->query($sqlupdate);</div> </div> <div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px; margin: 0px; outline: none; padding: 0px;"> // update on database</div> <br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;" /> <div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px; margin: 0px; outline: none; padding: 0px;"> } // first time user</div> <br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;" /><span style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;">//  check the counter</span><br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;" /><span style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;">$sqlcheck = "SELECT `userqua` FROM  `userip` where `useripid`=1";  // query</span><br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;" /><span style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;">$resultcheck=$dbLink->query($sqlcheck); // run the query</span><br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;" /><span style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;">if($resultcheck) { if($resultcheck->num_rows == 0) { // no result or zero results</span><br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;" /><span style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;">$userquata="Refresh"; </span><br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;" /><span style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;">} else { $rowcheck = $resultcheck->fetch_assoc();  $userquata = $rowcheck ['userqua']; </span><br style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;" /><span style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px;">} } ?></span><br /> <div style="background-color: white; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 19.600000381469727px; margin: 0px; outline: none; padding: 0px;"> // check the counter</div> </div>

Visitor Count for Website in PHP

Hello,Here I am writing a small program in PHP for  checking how much user have visited our website using COOKIES, MYSQL and IP address of the user.First we have to create cookies for the new user.Th…

Read more »