Skip to content

Instantly share code, notes, and snippets.

@harshityadav95
Created October 9, 2021 18:10
Show Gist options
  • Save harshityadav95/c7da09c48dc57f37b96c6c03f7f3545b to your computer and use it in GitHub Desktop.
Save harshityadav95/c7da09c48dc57f37b96c6c03f7f3545b to your computer and use it in GitHub Desktop.
<?php
class MyDB extends SQLite3
{
function __construct()
{
$this->open('test.db');
}
}
$db = new MyDB();
if(!$db){
echo $db->lastErrorMsg();
} else {
echo "Opened database successfully\n";
}
?>
<center>
<form action="" method="POST" enctype="multipart/form-data">
<input type="hidden" name="action" value="submit">
Your name:<br>
<input name="name" type="text" value="" size="30"/><br>
Your Age:<br>
<input name="age" type="text" value="" size="30"/><br>
Your email:<br>
<input name="email" type="text" value="" size="30"/><br>
Your message:<br>
<textarea name="message" rows="7" cols="30"></textarea><br><br>
<input type="submit" value="Submit"/>
</form>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
</center>
<?php
$name=$_REQUEST['name'];
$age=$_REQUEST['age'];
$email=$_REQUEST['email'];
$message=$_REQUEST['message'];
$sql =<<<EOF
INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (1, '$name', '$age', '$email', '$message' );
EOF;
$ret = $db->exec($sql);
if(!$ret){
echo $db->lastErrorMsg();
} else {
echo "Records created successfully\n";
}
$db->close();
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment