title: i want to save scraped content directly to database please correct this
body: <p>i want to save scraped content directly to database please correct this</p>
  
  <p>i only want to save in text format, without password and only code
  others like title expires (none) all remain the same</p>
  
  <pre><code>&lt;?php
  include('simple_html_dom.php');
  
  $code = file_get_html('http://domain.com/')-&gt;plaintext; 
  
  $con=mysqli_connect("&lt;dbhost&gt;","&lt;dbuser&gt;","&lt;dbpass&gt;","&lt;dbname&gt;");
  if (mysqli_connect_errno())
    {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }
  $dati = date('Y-m-d H:i:s');
  
  $pid = pid + 1; // 
  </code></pre>
  
  <blockquote>
    <p><strong>help with this also</strong> pid increase with every post</p>
  </blockquote>
  
  <pre><code>mysqli_query($con,"INSERT INTO `paste` (`pid`, `poster`, `posted`, `code`, `parent_pid`, `format`, `codefmt`, `codecss`, `expires`, `expiry_flag`, `password`)
  VALUES  ($pid, 'Untitled', $dati, $code, 0, 'text', '&lt;div class="text"&gt;&lt;ol&gt;&lt;li class="li1"&gt;&lt;div class="de1"&gt;' . $code . '&lt;/div&gt;&lt;/li&gt;\n&lt;/ol&gt;&lt;/div&gt;', '/**\n * GeSHi (C) 2004 - 2007 Nigel McNie, 2007 - 2008 Benny Baumann\n * (http://qbnz.com/highlighter/ and http://geshi.org/)\n */\n.text .de1, .text .de2 {font: normal normal 12px monospace; margin:0; padding:0; background:none; vertical-align:top;}\n.text  {font-family:monospace;}\n.text .imp {font-weight: bold; color: red;}\n.text li, .text .li1 {background: #ffffff;}\n.text .ln {width:1px;text-align:right;margin:0;padding:0 2px;vertical-align:top;}\n.text .li2 {background: #f4f4f4;}\n.text span.xtra { display:block; }\n', NULL, 'f', 'EMPTY')");
  ?&gt;
  </code></pre>