Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $dbHost = "localhost";
- $dbUser = "root";
- $dbPass = "root";
- $dbName = "test23052017";
- $dbConnection = mysqli_connect($dbHost, $dbUser, $dbPass, $dbName);
- if(mysqli_connect_errno()){
- die("Database connection error ".mysqli_connect_error()." => ".mysqli_connect_errno());
- }
- $query = "UPDATE users
- SET lastname = 'Zovko', zip_code = 71000
- WHERE name = 'Ivo'";
- $result = mysqli_query($dbConnection, $query);
- if($result && mysqli_affected_rows($dbConnection) == 1){
- echo "Success";
- } else {
- die("Query failed ".mysqli_error($dbConnection));
- }
- mysqli_close($dbConnection);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement