https://legacy.forums.gravityhelp.com/topic/special-character-problem-when-importing-entires-into-new-table Gravity Support Forums Topic: Special Character problem when importing entires into new table en-US Mon, 20 Apr 2026 12:04:46 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/special-character-problem-when-importing-entires-into-new-table#post-99598 Thu, 06 Dec 2012 09:25:39 +0000 Chris Hajer 99598@https://legacy.forums.gravityhelp.com/ <p>You're welcome. </p> https://legacy.forums.gravityhelp.com/topic/special-character-problem-when-importing-entires-into-new-table#post-98745 Tue, 04 Dec 2012 09:14:15 +0000 byork 98745@https://legacy.forums.gravityhelp.com/ <p>That's exactly it! Thank you so much. Perfect answer for what I was looking for.<br /> Thank you! </p> https://legacy.forums.gravityhelp.com/topic/special-character-problem-when-importing-entires-into-new-table#post-98468 Mon, 03 Dec 2012 19:33:47 +0000 Chris Hajer 98468@https://legacy.forums.gravityhelp.com/ <p>This is an issue with your own code rather than the Gravity Forms export routine?</p> <p>To escape values before inserting them, if they may have apostrophes or single quotes, you can use the PHP function <strong>mysql_real_escape_string</strong>.</p> <p><a href="http://php.net/manual/en/function.mysql-real-escape-string.php" rel="nofollow">http://php.net/manual/en/function.mysql-real-escape-string.php</a> </p> <pre><code>[php] $firstname = mysql_real_escape_string($entry[&#39;2.3&#39;]); $lastname = mysql_real_escape_string($entry[&#39;2.6&#39;]);</code></pre> <p>You might need to do that with more fields, but that is basically how to do it. Not related to Gravity Forms at all, just PHP and MySQL. </p> https://legacy.forums.gravityhelp.com/topic/special-character-problem-when-importing-entires-into-new-table#post-98448 Mon, 03 Dec 2012 17:29:58 +0000 byork 98448@https://legacy.forums.gravityhelp.com/ <p>I am exporting the entry data into a table, trouble is, any entry that has an apostrophe in the name (O'Donnel) does not come thru. Error log showing name field as 'O'Connor'</p> <p>I assume that the apostrophe needs to be escaped - but I cannot figure how to do it. Would I do it in the hook in the functions.php file?:</p> <p>// Pulls gravity form entries into xml and outputs<br /> <pre><code>add_action(&#39;gform_after_submission_6&#39;, &#39;input_fields&#39;, 8, 4); function input_fields($entry, $form){ global $wpdb; $promocode = $entry[&#39;7&#39;]; $conferenceid = $entry[&#39;6&#39;]; $conferencechoice = $entry[&#39;1&#39;]; $firstname = $entry[&#39;2.3&#39;]; $lastname = $entry[&#39;2.6&#39;]; $phone = $entry[&#39;3&#39;]; $email = $entry[&#39;4&#39;]; $optinternal = $entry[&#39;5.1&#39;]; $optexternal = $entry[&#39;5.2&#39;]; $SQL = &quot;INSERT INTO fsleads ( userid, promocode, conferenceid, conferencechoice, firstname, lastname, phone, email, optinternal, optexternal, uploaded ) VALUES ( &#39;&#39;, &#39;$promocode&#39;, &#39;$conferenceid&#39;, &#39;$conferencechoice&#39;, &#39;$firstname&#39;, &#39;$lastname&#39;, &#39;$phone&#39;, &#39;$email&#39;, &#39;$optinternal&#39;, &#39;$optexternal&#39; , &#39;N&#39; )&quot;; $wpdb-&gt;query($SQL);</code></pre>