Ingolme

Please do not reply to old topics.

The <use> tag just includes the content exactly as it is in the <defs> element. You cannot put attributes on the <use> tag and expect them to be applied to the included elements.

You cannot put HTML inside an SVG.

The code might display some warnings due to undefined indices and the email won't contain the correct content, but I don't see anything that would prevent it from sending an email. Make sure that the string in the $_POST[] array matches the name attribute of the <input> or <textarea> element.

If this object is wrapped in an <a> tag, use CSS to set the text-decoration of that link to "none".

To make an icon a link, wrap it in an <a> tag. If you want something to happen when submit is clicked, you will need to write PHP software to handle the form data.

The variable "func" is being used as a function in the body.

Contenteditable won't save the edits you make to the page. The changes are only visible on the computer of the person who is editing the page and disappear as soon as the tab is closed. If you want to make a page editable, your best option is to install a CMS like Wordpress or similar. There is no way to do this with just HTML or even Javascript.

If that works, it probably will update any row which has a name.

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

From that error is looks as if you forgot to put a $ on your variable name on line 12.

You will probably run into a syntax error because the values are not quoted.

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

What error are you getting and what does your new code look like?

You have to determine why it did not work and then solve that problem.

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.

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

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.

You're mixing object-oriented mysqli with procedural mysql and your INSERT query is missing the VALUES section.

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.

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.

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.

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.

You will need to specify a unique key in your table. Which of those fields has to be unique?

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.