<?php $query="CREATE TABLE IF NOT EXISTS `post`(post_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, name TEXT, content TEXT)"; ?>
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8" name="viewport" content="width=device-width, initial-scale=1" /> <link rel="stylesheet" type="text/css" href="css/bootstrap.css" /> </head> <body> <nav class="navbar navbar-default"> <div class="container-fluid"> <a class="navbar-brand" href="https://sourcecodester.com">Sourcecodester</a> </div> </nav> <div class="col-md-3"></div> <div class="col-md-6 well"> <h3 class="text-primary">PHP - Submit Post In SQLite3</h3> <hr style="border-top:1px dotted #ccc;"/> <div class="col-md-4"> <form method="POST" action="submit.php"> <div class="form-group"> <label>Name</label> <input type="text" class="form-control" name="name" required="required"/> </div> <div class="form-group"> <textarea class="form-control" name="content" required="required" style="resize:none; height:150px;"></textarea> </div> <center><button class="btn btn-primary" name="submit" >Submit</button></center> </form> </div> <div class="col-md-8"> <?php require'conn.php'; while($fetch=$query->fetchArray()){ echo "<div class='well'><h5>".$fetch['name']."</h5><hr style='border-top:1px solid #ccc;'/><p>".$fetch['content']."</p></div>"; } ?> </div> </div> </body> </html>