Contact Us Script Using sqlite

Submitted by gateluv on Tuesday, August 6, 2013 - 22:44.

Sqlite is a relational database management system contained in a small C programming library. Sqlite is a popular embedded database system that stores records in a little file on the system source code. Data can be retrieved through the use of write and read ability of sqlite. Moreover, Instead of saving the record into a RDMS tool like “phpmyadmin”, Sqlite can be used instead as it will save the record into a separate file on the host machine. To create a contact us page on our website using sqlite. The following PHP code will create the file that will contain the messages that our website visitor send to us. 1. Index page (index.php) In this index page, The sqlite_open() function is used to open the database file (contact.sql) at the host machine and the $error is the variable that trigger an error message if the database file is missing or not correctly spelt. The $create variable is used to create the tables that will be in the database file with id, names and msg as the column names. The last part is the code that is used to post the names and the messages that the visitor types into the field and they will be saved into the “contact.sql” file in the host machine i.e www directory.

<?php
error_reporting(0);
$feedback="";
$sqlite=sqlite_open("contact.sql",066,$error);
if(!$sqlite) echo ("$error");
 
$create=("CREATE TABLE contact(id INTEGER AUTOINCREMENT,names VARCHAR(50),msg VARCHAR(50))");
$function=sqlite_exec($sqlite,$create,$error);
if(!$create) echo ("$error");
 
if(isset($_POST["submit"]) && $_POST["names"] && $_POST["msg"]){
        $feedback="Message Sent";
 
        $names=sqlite_escape_string($_POST["names"]);
        $msg=sqlite_escape_string($_POST["msg"]);
 
        $insert="INSERT INTO contact(names,msg) VALUES('$names','$msg');";
        $insert2=sqlite_exec($sqlite,$insert,$error);
        if(!$insert2) echo ("$error");
 
        sqlite_close($sqlite);
}
?>
<html>
<head>
<title>Contact Us</title>
</head>
<body>
<center>
<p><a href="messages.php">[Messages]</a></p>
<form action="index.php" method="post">
<table width="50%" border="1">
        <tr>
                <th scope="col"> <p><font color="red">Contact Us Page Script using sqlite</font></p>
                        <p>Names:
                                <input type="text" name="names" size="25" placeholder="Enter Names">
                        </p>
                        <p>
                                <textarea name="msg" rows="2" cols="40" placeholder="Enter Your Message"></textarea>
                        </p>
                        <p>
                                <input type="submit" name="submit" value="Send Message">
                        </p>
                        <p><font color="#0000FF"><?php echo $feedback;?></font></p>
                </th>
        </tr>
</table>
</center>
</body>
</html>

2. Received Messages list (messages.php) This code is used to retrieve all the messages that have been stored inside the contact.sql file at the host machine.

<?php
$sqlite=sqlite_open("contact.sql",0666,$error);
if(!$sqlite)  die($error);
 
$query="SELECT *FROM contact";
$result=sqlite_query($sqlite,$query);
while($row=sqlite_fetch_array($result,SQLITE_ASSOC)){
?>
<html>
<head>
<title>Messages Received</title>
</head>
<body>
<link rel='stylesheet' type='text/css' href='style.css'/>
<center>
<div class="commentWrapper">
        <div style="width:500px;float:center; padding-top:5px;" align="right"> <b style="color:blue; cursor:pointer;"><?php echo $row["names"]; ?></b> </div>
        <br clear="all">
        <div style="width:500px;float:left; padding-top:5px;" align="left"> <b style="color:black; cursor:pointer;"><?php echo $row["msg"]; ?></b> </div>
        <br clear="all">
        </center>
</div>
<?php } ?>
</center>
</body>
</html>

3. Style.css for the cascading and styling of the messages retrieved.

.commentWrapper
{
        width:500px;
        border: solid 1px #cbcbcb;
        background-color: #FFF;
        box-shadow: 0 2px 20px #cbcbcb;
        -moz-box-shadow: 0 2px 20px #cbcbcb;
        -webkit-box-shadow: 0 2px 20px #cbcbcb;
        -webkit-border-radius: 10px;-moz-border-radius: 10px;border-radius: 10px;
        padding-left:5px;
        font-family:Verdana, Geneva, sans-serif; font-size:11px;
        color:black;
        margin-bottom:10px;
        padding-left:10px;
        padding-right:10px;
}

Conclusion, with the help of sqlite, we can store record into a file without using phpMyAdmin or any other tools.

Add new comment

122 views