Jump to content

Ingolme

Moderator
  • Content Count

    14,368
  • Joined

  • Last visited

  • Days Won

    95

Everything posted by Ingolme

  1. You're mixing object-oriented mysqli with procedural mysql and your INSERT query is missing the VALUES section.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. You will need to specify a unique key in your table. Which of those fields has to be unique?
  7. 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.
  8. An INSERT query always creates a new record. If you want to update a record, you need to use an UPDATE query.
  9. Ingolme

    Responsiveness

    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
  10. 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.
  11. That is not the flex-grow property, it is the flex-basis property.
  12. 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.
  13. Please do not reply to old topics.
  14. 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.
  15. Are you referring to the SASS tutorial? https://www.w3schools.com/sass/default.asp SASS is a CSS preprocessor: https://sass-lang.com/
  16. 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.
  17. In UTF-8 encoding, any Unicode character with a code higher than 127 is split into multiple bytes. Each byte starts off with a number of 1s indicating how many of the following bytes belong to the same character. UTF-8 encoded bytes have structures like the following: 0XXXXXXX 110XXXXX 10XXXXXX 1110XXXX 110XXXXX 10XXXXXX Your character has to be split into two bytes because its Unicode value is highter than 127. Its binary representation is: 10111101. These bits are split into the following two UTF-8 bytes: 11000010 10111101. The hexadecimal representation of t
  18. I think it looks correct. It is passing a two-byte UTF-8 encoded character. The %## encoding in a URL can only have two characters following the %. If you have a multi-byte character, each byte will be encoded on its own. The server should be able to decode it without a problem as long as it is treating strings as UTF-8.
  19. It has an error because you forgot to declare i with the var keyword.
  20. This pattern should work: ([0-9]{9})?
  21. The best way to learn is to set yourself a project and try to accomplish it. Along the way you'll run into problems you don't know how to solve. When you do, you do research on those specific things and that is how you learn. You will find tools in Java which do what you need them to. The more problems you run into while developing something, the more things you will learn when researching the solutions to those problems. On the other hand, try not to start a project that is too far out of your reach.
  22. This is the behaviour I would expect to see from inline elements. Most likely setting them to display: block will solve the issue.
  23. What is self.view? It looks like you may be using some kind of framework. Without knowing which framework you are using and how the framework works I can't tell you how to solve this.
  24. Use an <a> tag, give it a class attribute and then remove the underline using the class as a seletor. <div class="w3-panel"> <a href="other-page.html" class="box-link"> ... </a> </div> CSS: .box-link { text-decoration: none; }
  25. You can use the border-spacing property to set the spacing between the cells horizontally and vertically. table { border-spacing: 0 5px; }
×
×
  • Create New...