Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Warning: mysqli_error() expects exactly 1 parameter, 0 given in C:xampphtdocsSLRUpdate S110 PC01.php on line 24
- Could not Update data:
- <?php
- $host="localhost"; // Host name
- $username="root"; // Mysql username
- $password=""; // Mysql password
- $db_name="slr"; // Database name
- $tbl_name="s110_pc01"; // Table name
- // Connect to server and select database.
- $link = mysqli_connect("$host", "$username", "$password")or die("cannot connect");
- mysqli_select_db($link, $db_name)or die("cannot select DB");
- // Get values from form
- $soft_name=$_POST['soft_name'];
- $installed_date=$_POST['installed_date'];
- $expiry_date=$_POST['expiry_date'];
- $product_key=$_POST['product_key'];
- $sql = "UPDATE SET soft_name='$_POST[soft_name]', installed_date='$_POST[installed_date]', expiry_date='$_POST[expiry_date]', product_key='$_POST[product_key]' WHERE soft_id='$_POST[soft_id]'";
- $result=mysqli_query($link,$sql);
- if(! $result )
- {
- die('Could not Update data: ' . mysqli_error());
- }
- echo "Successfully updatedn";
- mysqli_close($con);
- ?>
- <input type="button"value="Finish"onclick="window.location.href='Update S110 PC01 Data.php'">
- </form>
- </table>
- </div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement