I want to insert data into my database but the outout is
<?php echo ''.pq('#giro_0 td[align="right"]')->html();?>
how to get it into
$sql = "INSERT INTO ing(aaa,bbb,ccc)
VALUES(CURDATE(),'bbb', XXX )";
where the XXX is so i can put the value into my database.
Isn't it just inserting the value into the query?
$sql = "INSERT INTO ing(aaa,bbb,ccc)
VALUES(CURDATE(),'bbb', " . pq('#giro_0 td[align="right"]')->html() . " )";
You put it in a variable instead of echoing it.
$html = pq('#giro_0 td[align="right"]')->html();
Then you stick a placeholder in your SQL:
$sql = "INSERT INTO ing(aaa,bbb,ccc) VALUES(CURDATE(),'bbb', ? )";
Then you use whatever function your database API uses to populate placeholders.
$stmt->bind_param('s', $html);