title: How to insert data into a wordpress table using a custom function
body: <p>I have a wordpress app hosted on Azure, and I need to insert data into the wp_posts table, using a custom function since I'm running this script as a background job and I cannot use wordpress functions since the script is not on the wordpress folder.</p>
  
  <p>I've tried:</p>
  
  <pre><code>mysql_query("INSERT INTO wp_posts(post_title, post_content, post_status, post_type, comment_status, page_template), VALUES($title, $sum, 'publish', 'post', 'closed', 'content.php')");
  </code></pre>
  
  <p>But I get the following error:  <strong>PHP Warning:  mysql_query(): An attempt was made to access a socket in a way forbidden by its access permissions.</strong></p>
  
  <p>The log file is as follows:</p>
  
  <pre><code>[04/07/2014 09:51:47 &gt; adf9f5: SYS INFO] Status changed to Initializing
  [04/07/2014 09:51:47 &gt; adf9f5: SYS INFO] Run script 'data.php' with script host - 'PhpScriptHost'
  [04/07/2014 09:51:47 &gt; adf9f5: SYS INFO] Status changed to Running
  [04/07/2014 09:51:48 &gt; adf9f5: ERR ] PHP Warning:  mysql_query(): An attempt was made to access a socket in a way forbidden by its access permissions.
  [04/07/2014 09:51:48 &gt; adf9f5: ERR ]  in C:\DWASFiles\Sites\abacuskenya\Temp\jobs\triggered\y\rdksuocv.xbx\data.php on line 50
  [04/07/2014 09:51:48 &gt; adf9f5: ERR ] PHP Warning:  mysql_query(): A link to the server could not be established in   C:\DWASFiles\Sites\abacuskenya\Temp\jobs\triggered\y\rdksuocv.xbx\data.php on line 50
  [04/07/2014 09:51:48 &gt; adf9f5: ERR ] PHP Warning:  mysql_insert_id(): An attempt was made to access a socket in a way forbidden by its access permissions.
  </code></pre>
  
  <p>How do I get my script to insert data into that table using a custom function other than wordpress's wp_insert_post</p>
  
  <p>My data.php is as follows:</p>
  
  <pre><code>&lt;?php
  define('DB_NAME', '**********');
  define('DB_USER', '********');
  define('DB_PASSWORD', '**************');
  define('DB_HOST', '*******');
  
  $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
  
  if (!$link){
      die('Could not connect: ' . mysql_error());
  }
  
  $db_selected = mysql_select_db(DB_NAME, $link);
  
  if(!$db_selected){
      die('Cannot use '. DB_NAME . ': ' .mysql_error());
  }
  $pages = array("page0", "page1", "page2", "page3", "page4");
      foreach($pages as $page){
          $json_feed = "http://digitalrand.net/api/url_data/?key=*****&amp;pass=*****%&amp;".$page;
          $json = file_get_contents($json_feed);
          $obj = json_decode($json, true);
              foreach($obj as $article_array){
  
              $url = $article_array['url'];
              $domain = $article_array['domain'];
              $favicon = $article_array['favicon'];
              $title = $article_array['title'];
              $category = $article_array['category'];
              $large_summary = $article_array['summary'];
              $sum = implode(',',$large_summary);
              $images = $article_array['images'];
  
              $image_array = reset($images);
              $image = $image_array["image"];
  
              $sql = "INSERT INTO wp_posts(post_title, post_content, post_status, post_type, comment_status, page_template), VALUES($title, $sum, 'publish', 'post', 'closed', 'content.php')";
              echo $sql;
  
              mysql_query($sql);
  
              $post_id = mysql_insert_id();
              echo "The Post ID is " . $post_id . "&lt;br&gt;";
  
              $data = array($favicon, $domain, $image);
  
              $value = implode(',',$data);
  
  
              //$a = add_post_meta($post_id, 'post_favicon_domain_image', $value, true);
              $sql2 = "INSERT INTO wp_postmeta(post_id, meta_key, meta_value), VALUES($post_id, 'post_favicon_domain_image', $value)";
              mysql_query($sql2);
              //echo $a;
              }
      }
  </code></pre>