Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <form action="form.php" method="post">
- First name:<br/>
- <input type="text" id="fname" name="fname">
- <br/>
- Last name:<br/>
- <input type="text" id="lname" name="lname">
- <br/>
- Mobile:<br/>
- <input type="text" id="mobile" name="mobile">
- <br/>
- <input type="submit" value="Submit">
- </form>
- <?php
- $servername = "localhost";
- $username = "database1";
- $password = "xxxxxxxx";
- $dbname = "database1";
- $servernameS = "localhost";
- $usernameS = "database2";
- $passwordS = "xxxxxxxx";
- $dbnameS = "database2";
- // Create connection
- $conn = new mysqli($servername, $username, $password, $dbname);
- $connS = new mysqli($servernameS, $usernameS, $passwordS, $dbnameS);
- // Check connection
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- if ($connS->connect_error) {
- die("Connection failed: " . $connS->connect_error);
- }
- //escape variables for security
- $fname = mysqli_real_escape_string($conn, $_POST['fname']);
- $lname = mysqli_real_escape_string($conn, $_POST['lname']);
- $mobile = mysqli_real_escape_string($conn, $_POST['mobile']);
- $sql = "INSERT INTO mytable (fname,lname,mobile)
- VALUES ('$fname','$lname','$mobile')";
- if ($conn->query($sql) === TRUE) {
- echo "Successfully Saved";
- } else {
- echo "Error: Go back and Try Again ! " . $sql . "<br>" . $conn->error;
- }
- if ($connS->query($sql) === TRUE) {
- echo "Successfully Saved";
- } else {
- echo "Error: Go back and Try Again ! " . $sql . "<br>" . $connS->error;
- }
- $conn->close();
- $connS->close();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement