Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Ingolme

  1. Your update query does not have a WHERE clause, so it updates every single row in the table. Use a WHERE clause to restrict the update to a particular row. See examples in the MySQL tutorial: https://www.w3schools.com/sql/sql_update.asp
  2. From that error is looks as if you forgot to put a $ on your variable name on line 12.
  3. You will probably run into a syntax error because the values are not quoted.
  4. That's not the correct syntax for an UPDATE query. The correct syntax is: (https://www.w3schools.com/php/php_mysql_update.asp) UPDATE table_name SET column1=value, column2=value2,... WHERE some_column=some_value
  5. What error are you getting and what does your new code look like?
  6. You have to determine why it did not work and then solve that problem.
  7. That code looks valid, but it is different than the code you posted in this topic. It is an INSERT query, so it will only ever create new records and not change existing ones.
  8. Look carefully for differences between your SQL and the SQL Syntax shown in this tutorial page: https://www.w3schools.com/php/php_mysql_insert.asp
  9. It's best you go through the MySQL section of the PHP tutorial and learn how to do it. You won't learn if you don't go through the effort and next time you run into a problem you'll just be asking other people to write the code for you again.
  10. You're mixing object-oriented mysqli with procedural mysql and your INSERT query is missing the VALUES section.
  11. Without seeing your code I can't tell what's wrong but it looks like you're probably mixing up the procedural and object-oriented versions of the functions.
  12. Use mysqli_error() to find out what went wrong with the query. It looks like you forgot to add a VALUES() section to your INSERT query.
  13. I'm not sure what an ERP is, but it seems to be storing data with the wrong encoding in the database. The only solution is to detect the encoding of the string and convert it after retrieving it from the database, as you were trying earlier. If utf8_encode() is not working, it means that the encoding is probably not ISO-8859-1. I don't think I can help much if mb_detect_encoding() is not working. You will have to find out why the function is not available.
  14. If you don't have a unique key, it won't find a duplicate, so it will not update any of the records and it will create a new one instead. After adding the ON DUPLICATE KEY UPDATE section to your query, the code now has 8 "%s" placeholders, but you are only passing in four values to the sprintf() function.
  15. You will need to specify a unique key in your table. Which of those fields has to be unique?
  16. If your HTML document has the encoding set to UTF-8 using a <meta> tag and your PHP files are UTF-8 encoded, any form data should automatically be converted to UTF-8 no matter what the user pastes in. If you have a database connection, make sure that the encoding of the connection is UTF-8 as well.
  17. An INSERT query always creates a new record. If you want to update a record, you need to use an UPDATE query.
  18. Ingolme


    If they're telling you to just use Wordpress, I would hardly call them professionals. The first step, before applying media queries, is to make everything flexible. Don't give fixed widths to anything. For example, the header, section and footer you can set max-width instead of width: #header, section, footer { max-width: 1080px; } The site content and side bar need to be replaced with percentage values: #sitecontent.sitecontentleft { width: 72.22%; } #sidebar.sidebarright-index { width: 25%; } The media queries will only be necessary once things get too small to
  19. What does your code look like? There is no way the "&" could be interpreted as an operator if it is inside a string unless you have a severe security vulnerability in your code.
  20. That is not the flex-grow property, it is the flex-basis property.
  21. I think you could use getComputedStyle() to find out what background image has been applied and then generate an <img> tag. It's a bit complicated, especially if you want to keep everything exactly where it is. You'll have to pull out the values of background-size and background position and use them to set the size and position of the <img> tag. Repeating backgrounds would make things a lot more complicated.
  22. Please do not reply to old topics.
  23. You cannot pass values to addEventListener callbacks. Callbacks have to be just the name of the function without parentheses. If you use parenthesis, you will call the function immediately and assign its return value as an event listener instead.
  24. Are you referring to the SASS tutorial? https://www.w3schools.com/sass/default.asp SASS is a CSS preprocessor: https://sass-lang.com/
  25. It is probably faster to reach them by email. I am not sure how frequently they look at the forums. At the bottom of each page is a button labeled "Report error". If you click on it it displays the email address (help@w3schools.com) to which you can indicate a mistake on any page.
  • Create New...