Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <title>db1 test</title>
- </head>
- <body>
- <form id="myForm" action="userInfo.php" method="post">
- Username: <input type="text" name="username" /><br />
- Name: <input type="text" name="name" /><br />
- Favourite Number: <input type="text" name="favouritenumber" /><br />
- <button id="sub">Save</button>
- </form>
- <span id="result"></span>
- <script src="/script/jquery-1.8.1.min.js" type="text/javascript"></script>
- <script src="/script/my_script.js" type="text/javascript"></script>
- </body>
- </html>
- <?php
- $host = "localhost";
- $port = "8889";
- $servername = "$host:$port";
- $username = "forest";
- $password = "";
- $db = "db1";
- // Create connection
- $conn = new mysqli_connect($servername, $username, $password, $db);
- // Check connection
- if ($conn - > connect_error) {
- die("Connection failed: ".$conn - > connect_error);
- }
- ?>
- <?php
- include_once "/includes/db1.php";
- $username = $_POST['username'];
- $name = $_POST['name'];
- $favouritenumber = $_POST['favouritenumber'];
- if(mysqli_query("INSERT INTO user(username,name,favouritenumber) VALUES ('$username', '$name', '$favouritenumber')"))
- echo "Successfully Inserted";
- //echo "<a href='login_success.php'>Back to main page</a>";
- else {
- echo "ERROR not entered";
- }
- // close connection
- mysqli_close();
- [1]: https://stackoverflow.com/questions/2973202/mysql-fetch-array-mysql-fetch-assoc-mysql-fetch-row-mysql-num-rows-etc
Add Comment
Please, Sign In to add comment