i want to save scraped content directly to database please correct this

Question

i only want to save in text format, without password and only code others like title expires (none) all remain the same

<?php
include('simple_html_dom.php');

$code = file_get_html('http://domain.com/')->plaintext; 

$con=mysqli_connect("<dbhost>","<dbuser>","<dbpass>","<dbname>");
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
$dati = date('Y-m-d H:i:s');

$pid = pid + 1; //

help with this also pid increase with every post

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', '<div class="text"><ol><li class="li1"><div class="de1">' . $code . '</div></li>\n</ol></div>', '/**\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')");
?>

1. `$code = mysqli_real_escape_string($con,$code)` 2. Use Prepare Statement which will do all these for u. — Abhik Chakraborty, Apr 09 '14 at 07:25
So what is the problem with your code does it not work? does it miss something? Provide more details and the error message if any. — Prix, Apr 09 '14 at 07:27
Are talking about PRIMARY index with autoincrement? Read [this](http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html) or [this](http://stackoverflow.com/a/251630/1057527). — machineaddict, Apr 09 '14 at 07:29
php to copy previous msql row and change only two (pid, code) — Aakash Pal, Apr 09 '14 at 07:34
"please correct this" won't work here - nobody will do your homework — Joshua, Apr 09 '14 at 07:39

score 0 · Answer 1 · answered Apr 09 '14 at 07:32

0

/*********** Load In Dom *********/
$html = new DOMDocument;
$html->loadHTML($yourTargetHTML);
$xPath = new DOMXPath($html);
/*********** Load In Dom *********/

answered Apr 09 '14 at 07:32

Ferrakkem Bhuiyan

2,741
2
22
38

i want to save scraped content directly to database please correct this

1 Answers1