WDH: MYSQL

<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...