Ask a question    Sign Up Sign In
  1. Home
  2. php - Sql Update Error

493 votes
1 answers

php - Sql Update Error

Get the solution ↓↓↓

Solution:

You need to change your query like below:-

$sql = $db->prepare("UPDATE uyeler SET fname=?, lname=?, mail=?, password=?, country=?, sex=?, facebook=?, twitter=?, instagram=?, snapchat=? WHERE mail ='{$_SESSION['kullanici']}'");

Note:- it will be better if youparameterized. your lastSESSION value also in the same way.

493
votes

Answer

Solution:

YourUPDATE query is incorrect. You have to explicitly assign value for each column

$sql = $db->prepare("UPDATE uyeler SET fname = ?, lname = ?, ... WHERE mail ='{$_SESSION['kullanici']}'");
Write your answer



Share solution ↓

Additional Information:
Link To Source
People are also looking for solutions of the problem: script cache:clear returned with error code 255

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.

Similar questions

Find the answer in similar questions on our website.

272 How to insert 100 records in mysql procedure and loop in MySQL procedure not in PHP?
931 PHP and mysql integration with apache tomcat 6 in linux
478 php - XAMPP Apache Won't Start with Modified php5ts.dll
49 mysqli - PHP Not inserting record due to Null id
64 php - Laravel: SQL LEFT JOIN with an INSERT (FOREIGN KEYS)
962 php - Symfony3 Form Error - A form with an empty name cannot have a parent form
522 PHP 5.4 code update - Creating default object from empty value warnings in foreach and objects array
289 sql - Select result in grouped row using fetch and while in PHP
239 codeigniter - When i'm transfering to another page getting data(s) (PHP Error Message:Trying to get property of non-object)
323 php - How to return value from stored procedure using PDO on MSSQL database

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/

Welcome to programmierfrage.com

programmierfrage.com is a question and answer site for professional web developers, programming enthusiasts and website builders. Site created and operated by the community. Together with you, we create a free library of detailed answers to any question on programming, web development, website creation and website administration.

Get answers to specific questions

Ask about the real problem you are facing. Describe in detail what you are doing and what you want to achieve.

Help Others Solve Their Issues

Our goal is to create a strong community in which everyone will support each other. If you find a question and know the answer to it, help others with your knowledge.