How To

How to write connection class to mysql database using php

June 28, 2016April 12, 2022 Pradeep Maurya

Hello! In this post, you will learn to how to write and test the OOP based connection class to mysql database using php. see below..how to do it.. connection.php


<?php

/** @author tutorialswebsite
*@ copyright 2016

*/

class createDBConnection // create a class for make connection
{

var $host="localhost";
var $username="username";
var $password="password";
var $database="database name";
var $dbconn;
function connectToDatabase() //specify the server details for mysql
{

$conn=mysql_connect($this->host,$this->username,$this->password);

if(!$conn)//testing the connection
{
die("Cannot connect to the database");

}else{

$this->dbconn=$conn;
echo "Connection established";

}
return $this->dbconn;

}

function selectDatabase() // selecting the database
{

//use php inbuild function foer select database

mysql_select_db($this->database);

if(mysql_error()) // if error occured display the error message 
{
echo "Cannot find the database".$this->database;

}

echo "Database Selected..";
}

function closeConnection() // close the connection
{
mysql_close($this->dbconn);

echo "Connection closed";

}

}

?>

<?php

/** @author tutorialswebsite

class createDBConnection // create a class for make connection

{

var $host="localhost";

var $username="username";

var $password="password";

var $database="database name";

var $dbconn;

function connectToDatabase() //specify the server details for mysql

{

$conn=mysql_connect($this->host,$this->username,$this->password);

if(!$conn)//testing the connection

{

die("Cannot connect to the database");

}else{

$this->dbconn=$conn;

echo "Connection established";

}

return $this->dbconn;

}

function selectDatabase() // selecting the database

{

//use php inbuild function foer select database

mysql_select_db($this->database);

if(mysql_error()) // if error occured display the error message

{

echo "Cannot find the database".$this->database;

}

echo "Database Selected..";

}

function closeConnection() // close the connection

{

mysql_close($this->dbconn);

echo "Connection closed";

}

Now you have create the database connection class let’s see…

Expand +

How to show image thumbnail before upload with jQuery

June 1, 2016April 12, 2022 Pradeep Maurya

Now, i am going to Share: How to show image thumbnail before upload with jQuery Step 1:- Put the following code in <body></body> section.


<div id="previewimg"></div>
<input id="upload_file" class="img" name="image" type="file" />

Step 2:- Put the script code in <head></head> section.


<script src="http://code.jquery.com/jquery-1.10.2.js"></script>
<script type="text/javascript">// <![CDATA[
$(function() { $("#upload_file").on("change", function() { var files = !!this.files ? this.files : []; if (!files.length || !window.FileReader) return; // no file selected, or no FileReader support if (/^image/.test( files[0].type)){ // only image file var reader = new FileReader(); // instance of the FileReader reader.readAsDataURL(files[0]); // read the local file reader.onloadend = function(){ // set image data as background of div $("#previewimg").css("background-image", "url("+this.result+")"); } } }); });
// ]]></script>

$(function() { $("#upload_file").on("change", function() { var files = !!this.files ? this.files : []; if (!files.length || !window.FileReader) return; // no file selected, or no FileReader support if (/^image/.test( files[0].type)){ // only image file var reader = new FileReader(); // instance of the FileReader reader.readAsDataURL(files[0]); // read the local file reader.onloadend = function(){ // set image data as background of div $("#previewimg").css("background-image", "url("+this.result+")"); } } }); });

// ]]></script>

Step 3:- Put following CSS…

Expand +

How to integrate Gravity Forms with Google Spreadsheets:

February 10, 2016August 4, 2022 Pradeep Maurya

Gravity Forms is an extremely popular Forms plugin for the WordPress. When someone submits a form created with Gravity Forms, the form data is saved inside the MySQL database . There are step by step process to integrate Gravity Forms with…

Expand +

How to create pagination using PHP and MYSQL

February 4, 2016April 12, 2022 Pradeep Maurya

Paging (Pagination) means showing Database results in multiple pages instead of one long page. if we have more than 100 records in database and we want to show all results but not in a single page, so we can devide…

Expand +

How to create line chart in php and my sql

January 30, 2016April 12, 2022 Pradeep Maurya

Line chart graph is very usefull to show sell and purchase graph layout of monthly, weekly, yearly as we want. To create line graph: first ,we create a index.php file to show garph and second, create get_line_chart.php to get data…

Expand +

How to create first HTML Page

January 22, 2016April 12, 2022 Pradeep Maurya

step-1: First, Open your text editor and create a new text file, then type something like this:


<!DOCTYPE html>
<html>
<head>
  <title>Hi there</title>
</head>
<body>
  This is a page
  a simple page
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Hi there</title>

</head>

<body>

This is a page

a simple page

</body>

</html>

Step-2: After this save the page like: my_page.html Step-3: find the file you just created and open it with your browser (double-click,…

Expand +