I have created a form using Bootstrap 2 Form Builder and now I am looking to save the form in JSON format into a MySQL database. However, I am unsure of where to begin with this process. I was able to successfully create the form, but saving it for future use is where I am encountering difficulties.
If you're looking for guidance on saving form variables to a MySQL database, I'll provide a brief example along with some keywords to help you get started.
Below is the basic HTML markup of a form with fields styled using bootstrap classes:
<form action="process_form.php" method="POST" class="form">
<div class="form-group">
<input type="text" name="firstname" placeholder="First name" class="form-control" />
<input type="text" name="lastname" placeholder="Last name" class="form-control" />
<textarea name="message" placeholder="Message" class="form-control"></textarea>
<input type="submit" value="Submit" class="btn btn-primary btn-lg pull-right" />
</div>
</form>
This form includes two important attributes: action and method. The action attribute specifies the script that will process the form data upon submission, while the method attribute defines how the form data should be sent.
Let's examine the content of the process_form.php file:
$servername = "localhost";
$username = "username";
$password = "password";
if (!empty($_POST)) {
if (isset($_POST['firstname']) && isset($_POST['lastname']) && isset($_POST['message']) ) {
try {
$conn = new PDO("mysql:host=$servername;dbname=myDB", $username, $password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$message = $_POST['message'];
$sql = "INSERT INTO messages (firstname,lastname,message) VALUES (:firstname,:lastname,:message)";
$q = $conn->prepare($sql);
$q->execute(array( ':firstname' => $firstname,
':lastname' => $lastname,
':message' => $message));
echo "Successfully inserted";
} catch(PDOException $e) {
echo "Connection failed: " . $e->getMessage();
}
}
}
The code checks for POST requests and validates the expected form variables before attempting to establish a connection to a MySQL database using PHP Data Objects (PDO). If successful, it prepares and executes the SQL statement for inserting data. Any errors are caught and displayed for debugging purposes. There's also an alternative approach discussed for storing JSON data in the database.
// Sample code for creating a JSON string from form variables
$jsonObj = new stdClass();
$jsonObj->firstname = $_POST['firstname'];
$jsonObj->lastname = $_POST['lastname'];
$jsonObj->message = $_POST['message'];
$json = json_encode($jsonObj);
For assistance in creating a form and saving it to a database, I recommend checking out this link. It provides helpful guidance on the process.
I hope you find this information useful.
While browsing the internet, I came across the website and was intrigued by the slider effect featured in the "graphics" section. I am eager to figure out how to replicate that stunning visual effect. ...
I am facing a challenge with deleting multiple items from a DynamoDB table. While the documentation suggests dropping and recreating the whole table, I want to avoid this approach as my table was created using AWS Amplify and I don't want to risk disr ...
I apologize for the simplicity of this question, but I am struggling with an issue and seeking help. Here's the problem: my calculate() method is not clearing text input as expected when testing my page. Below is the HTML markup and script: <!DOC ...
A situation arose where I needed to lazy load a popups module outside of the regular router lazy-loading. In order to achieve this, I made the following adjustments: angular.json "architect": { "build": { ... "options": { ... "lazyM ...
Within my application, I am making a post request using Redux Saga middleware. Below is the code snippet relevant to my post request: function* postNewMessage(newMessage) { console.log(newMessage) const {var1, var2} = newMessage; try { ...
Having some trouble with this code. Can someone help me figure out what's going wrong? function displayData() { var userInput; userInput = document.getElementById(userInputs.firstInput); alert ("You entered: " + userInput); } <form ...
I am currently working with the full calendar feature. Within this framework, I have implemented a modal that allows users to insert new events: <div id="fullCalModal_add_appointment" class="modal fade"> <div class="modal-dialog"> ...
I am currently working on an application that combines JavaScript with Vue.js on the front-end and PHP with Laravel on the back-end. When a GET request is made from the front-end to the back-end at URL /getSummoner/{summonerName}, another GET request is t ...
Is there a way to add a new Date using Spring Data MongoDB? Currently, I am using the following: User = new User(); user.setCreationDate(new Date()); mongoOperation.save(user); The issue with this approach is that it saves the user with the current tim ...
Is it possible to use JavaScript regex to fetch the first function parameter? For instance, when I click on a tag in this page element, how can I extract the inline link? Here's an example: <li><a href="#blog" data-rel="clos ...
How can I prevent the browser from remembering the username and password on my JSP page after submitting the form? I've already tried using autocomplete=off in the JSP code. <form name="indexFrm" id="indexFrm" autocomplete="off" method="post"> ...
I have been experimenting with express.Router to organize my routes and testing post requests using Postman. I noticed that when I make a post request to /test without using router body-parser, everything works fine and I can view the body content. However ...
(Update: The problem has been successfully solved. Check the end of the question for details) I am currently facing a seemingly trivial issue that is causing me a great deal of frustration as I struggle to find a solution: After scaffolding an Angular ap ...
I am working on implementing a Doughnut chart using chartJs in my application. However, I want to set the color of the chart within the <script> tag and retrieve the color from theme/variables.css. In the current code snippet below, there is a hardc ...
Is there a way to load a file inside a container while utilizing an argument to fetch data from the database initially? $('#story').load('test.php'); test.php $st = $db->query("select * from users where id = " . $id); ... proce ...
Looking for a way to toggle a list that appears when a user searches in my app. I want the search results to hide when the search bar is closed. How can I achieve this? I think Angular might be the solution, but I'm stuck on how to implement it. I tri ...
Here is the code I am working with: $("input[id="+id.slice(0,-1)+"-br-"+brand+"].qnt_to_cart").show(); This code generates: input[id=02620-br-FEBI BILSTEIN].qnt_to_cart However, I need it to look like this instead: input[id="02620-br-FEBI BILSTEIN"].q ...
Aim: I am struggling with a button that triggers a function to fetch more items from my Mongoose DataBase and display them in a table row dynamically. I am using the get method to retrieve data from the server side. Despite referring to advice from this po ...
Currently, I'm engaged in a React project that utilizes TypeScript. Within the project, there is an integration of the react-select component into another customized component. The custom wrapped component code is as follows: import * as React from " ...
I am new to Node.js and currently transitioning from a PHP background, eager to learn more about it. My challenge involves using the following Regular Expression: /([A-Z]{2,})+/gim (identifying two or more consecutive letters). The string I am working w ...