Database Connectivity in Wordpress,Wordpress database tutorial
Wordpress is complete dynamic CMS of PHP,Wordpress provide database connectity when we install wordpress CMS then we can not say wordpress has database connectivity manually but it is mandatory in installation time.
Wordpress CMS provide table also WP_POST is the most impotent table where we can store records .
Wordpress page and post both store record using this.
Code or database operation.
Wordpress provide global $wpdb for database operation
Step for database
Database operation in wordpress:-
1) create database
2) create table as per requirement
3) create page template to create form
4) global $wpdb
Syntax for data selection:-
$wpdb->get_results( "SELECT id, name FROM mytable" );
Syntax for data insertion:-
$wpdb->insert(
'table',
array(
'column1' => 'value1',
'column2' => 123
),
);
Syntax for data updation:-
$wpdb->update(
'table',
array(
'column1' => 'value1', // string
'column2' => 'value2' // integer (number)
),
array( 'ID' => 1 )
);
Syntax for data deletion:-
$wpdb->delete( 'table', array( 'ID' => 1 ) );
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Complete code of database
create table in wordpress exiting database
create table wp_student(rno varchar(50),sname varchar(50),branch varchar(50),sem varchar(50))
Code page template:-
<?php
/*
Template name: Student Template
*/
get_header();
?>
<section>
<div style="margin-left: 50px;margin-top: 50px;float:left;">
<form action="" method="post">
<input type="text" name="txtrno" placeholder="Enter rno" />
<br>
<br>
<input type="text" name="txtsname" placeholder="Enter name" />
<br>
<br>
<input type="text" name="txtbranch" placeholder="Enter branch" />
<br>
<br>
<input type="text" name="txtsem" placeholder="Enter sem" />
<br>
<br>
<input type="submit" name="btnsubmit" value="Submit" />
</form>
<?php
global $wpdb;
if(isset($_REQUEST['btnsubmit']))
{
$rno=$_REQUEST['txtrno'];
$sname=$_REQUEST['txtsname'];
$branch=$_REQUEST['txtbranch'];
$sem=$_REQUEST['txtsem'];
$res= $wpdb->insert('wp_student',
array( 'rno' => $rno,
'sname' =>$sname,
'branch'=>$branch,
'sem' =>$sem));
// $conn= mysqli_connect('localhost','root','','scsdb');
// mysqli_query($conn,"INSERT INTO `wp_student` (`rno`, `sname`, `branch`, `sem`) VALUES ('g', 's', 's', 's')");
}
?>
</div>
<div style="margin-left: 40px;margin-top: 50px;float:left;">
<p>View Student Record Here</p>
<table border="1">
<tr><th>RNO</th><th>Sname</th><th>Branch</th><th>Sem</th></tr>
<?php
$res = $wpdb->get_results( "SELECT rno,sname,branch,sem FROM wp_student");
foreach ($res as $x) {
echo "<tr><td>".$x->rno,"</td><td>".$x->sname."</td><td>".$x->branch."</td><td>".$x->sem."</td></tr>";
}
?>
</table>
</div>
</section>
<?php
get_footer();
?>
تعليقات
إرسال تعليق
POST Answer of Questions and ASK to Doubt