Databases
StackOverflow2013
Postsdbo
POInsert query with special character in php
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POInsert query with special character in php
    primarykey
    data
    text
    <p>Here is my code</p> <pre><code>&lt;?php $con = mysql_connect('localhost','test','test'); mysql_select_db('test',$con); require_once("xml2json.php"); $testXmlFile = 'mytest.xml'; $xmlStringContents = file_get_contents($testXmlFile); $jsonContents = ""; $jsonContents = xml2json::transformXmlStringToJson($xmlStringContents); $obj =json_decode($jsonContents); $rows = array(); foreach($obj-&gt;rss-&gt;channel-&gt;item as $item) { echo $item-&gt;title."\n"; echo $item-&gt;description."\n"; $rows[] = "('".mysql_real_escape_string($item-&gt;title)."','".mysql_real_escape_string($item-&gt;description)."')"; } $del_horoscope = "delete from jos_horoscope"; mysql_query($del_horoscope); $query = mysql_real_escape_string("INSERT INTO `jos_horoscope` (`title`,`description`) VALUES ".implode(', ',$rows)); mysql_query($query); if (!mysql_query($query)) echo 'Oh no! Something went wrong with the query: '.mysql_error(); ?&gt; </code></pre> <p>I am not able to insert the title and description in DB. It always says </p> <pre><code>Oh no! Something went wrong with the query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'What\'s special today for you\',\'Your birth on the 25th day of the month (7 e' at line 1 </code></pre> <p>Some of the Data which I am trying to insert is </p> <pre><code>What's special today for you Your birth on the 25th day of the month (7 energy) modifies your life path by giving you some special interest in technical, scientific, or other complex and often hard to understand subjects. You may become something of a perfectionist and a stickler for details. Your thinking is logical and intuitive, rational and responsible. Your feelings may run deep, but you are not very likely to let them show. This birthday makes you a more private person, more introspective and perhaps more inflexible. Aries Horoscope for Thursday, April 25, 2013 Although most of us when we make a decision we don`t have to worry what it will impact for the world we live in, but when you make a decision we have to remember that it does impact our society in so many ways. Our choice has to be an ethical one, regardless of the outcome. Your emotions are brought into more conscious focus these few days. You may find that you can more easily communicate your feelings at this time. </code></pre> <p>The First line is title and rest is Description till Aries Horoscope . After that another title starts . Please help me . I tried many options but its not working for me </p> <p>Here is my table structure </p> <p><img src="https://i.stack.imgur.com/xwRhm.png" alt=""></p> <p>Please help me .</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USMohsen Safari
    1. USYogus
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COit's 2013 and people still haven't taken their time to read about XSS and SQL injection...
      singulars
      1. POInsert query with special character in php
      1. USpocesar
    2. CO@pocesar Please guide me ... what improvements I do in my code ..
      singulars
      1. POInsert query with special character in php
      1. USYogus
    3. CO@user2320808 mysql_* functions are depricated, [you can use mysqli_* instead](http://idiallo.com/blog/2013/04/dealing-with-mysql-once-and-for-all.html). Not that it solves your problem but it will be a good start to properly right your query in php
      singulars
      1. POInsert query with special character in php
      1. USIbu
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload