1. Home
2. php - Changing multiple variable using same ID in SQL

126 votes

0 answers

php - Changing multiple variable using same ID in SQL

Get the solution ↓↓↓

<?php
$conn = mysqli_connect("localhost", "root", "password");
mysqli_select_db($conn, "stiry");
$sql = "UPDATE system SET ad = '".$_POST['ad']."', ph = '".$_POST['ph']."' , usage = 0 WHERE id = 1";
$result = mysqli_query($conn, $sql);
?>
Copy code

I have understand that I have to use comma in order to update multiple variables at the same time. My goal is to update ad, ph and usage when user press submit button in index.php. Withoutusage = 0 in$sql line everything just works fine.

Hereby, usage type isvarchar(15) NOT NULL. Since purpose of usingusage is to check the status of the service which I am planning to test wherebyusage = 1 will represent that user is using my service.

In my database, usage column is recorded as 0 thus I have to change it to 1 as user press submit button.

What is the possible error here?

Undefined asked

2021-12-1

Write your answer

---

Share solution ↓

Additional Information:

Date the issue was resolved:

2021-12-1

Link To Source
Link To Answer People are also looking for solutions of the problem: installation failed, reverting ./composer.json and ./composer.lock to their original content

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

---

Similar questions

Find the answer in similar questions on our website.

458 PHP + SQL - Using SQL Server 'Create To' scripts to create tables through PHP

744 php - Filter content from mysql db with checkboxes using jQuery?

323 php - File format or extension invalid PHPExcel

535 php - Why should you validate forms using javascript?

214 php - Check if a variable has been set with the name of the value of another variable

997 oop - php - access class parent variable not using $this

637 How to check whether $_GET['id'] is set and it's not empty using php

218 php,mysql,html - Display SQL query(conjunction) properly in HTML

562 html - IN PHP , how to have datagrid or gridview

43 php - Using PHPThumb and Thickbox/Colorbox

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

About the technologies asked in this question

PHP

PHP (from the English Hypertext Preprocessor - hypertext preprocessor) is a scripting programming language for developing web applications. Supported by most hosting providers, it is one of the most popular tools for creating dynamic websites. The PHP scripting language has gained wide popularity due to its processing speed, simplicity, cross-platform, functionality and distribution of source codes under its own license.
https://www.php.net/

MySQL

DBMS is a database management system. It is designed to change, search, add and delete information in the database. There are many DBMSs designed for similar purposes with different features. One of the most popular is MySQL. It is a software tool designed to work with relational SQL databases. It is easy to learn even for site owners who are not professional programmers or administrators. MySQL DBMS also allows you to export and import data, which is convenient when moving large amounts of information.
https://www.mysql.com/