PHP Not inserting POST data into database

Question

I am trying to insert data from an automated POST request into a database, but it is not inserting it and is throwing no errors. (None in error log) Code:

<?php
function getBetween($content,$start,$end){
$r = explode($start, $content);
if(isset($r[1])) {$r = explode($end, $r[1]);
return $r[0]; } return''; }

file_put_contents("outputfile.txt", file_get_contents("php://input"), FILE_APPEND );

$cip = $_POST['ipaddr'];
$cid = $_POST['id'];

$conn = mysqli_connect('localhost', '********', '*******');
$sql = "INSERT INTO slso (asid, ips) VALUES ('$cid', '$cip')";
mysqli_query($conn, $sql); mysqli_close($conn);

?>

The content of outputfile.txt is this:

ipaddr=192.168.0.4&id=8&endipaddr=***.**.230.62&id=8&end

However no data is ever inserted into the database. Am I making a simple mistake that I am not noticing?

Does the query fail? Check the return value of mysqli_query. — Halcyon
– Halcyon, Commented Apr 9, 2015 at 0:54
@Halcyon The request is sent by an automated script, so I cant read what the page says — CarlosAllende
– CarlosAllende, Commented Apr 9, 2015 at 0:57
You only have 3 parameters for your connection. mysqli_ php.net/manual/en/function.mysqli-connect.php requires 4; are you not choosing a database? Once you've done that, do mysqli_query($conn, $sql) or die(mysqli_error($conn)); — Funk Forty Niner
– Funk Forty Niner, Commented Apr 9, 2015 at 1:12
Add error reporting to the top of your file(s) right after your opening PHP tag for example <?php error_reporting(E_ALL); ini_set('display_errors', 1); then the rest of your code, to see if it yields anything also. — Funk Forty Niner
– Funk Forty Niner, Commented Apr 9, 2015 at 1:16
Plus, seeing ipaddr=192.168.0.4&id=8&endipaddr=***.**.230.62&id=8&end suggests a GET method, yet you're using two POST arrays. Your question is unclear. Post your HTML form. — Funk Forty Niner
– Funk Forty Niner, Commented Apr 9, 2015 at 1:25

Funk Forty Niner · Accepted Answer · 2015-04-09 01:30:33Z

3

You can only read in from php://input once in PHP versions prior to 5.6.

From the manual

Prior to PHP 5.6, a stream opened with php://input could only be read once; the stream did not support seek operations. However, depending on the SAPI implementation, it may be possible to open another php://input stream and restart reading. This is only possible if the request body data has been saved. Typically, this is the case for POST requests, but not other request methods, such as PUT or PROPFIND.

As a work around you can extract those values from php://input:

$post = file_get_contents("php://input");
file_put_contents("outputfile.txt", $post, FILE_APPEND );

parse_str($str, $output);

$cip = $output['ipaddr'];
$cid = $output['id'];

Another thing is, you only have 3 parameters for your connection. mysqli_ requires 4.

http://php.net/manual/en/function.mysqli-connect.php

Once you've done that, do mysqli_query($conn, $sql) or die(mysqli_error($conn));

edited Apr 9, 2015 at 1:30

Funk Forty Niner

74.2k14 gold badges71 silver badges146 bronze badges

answered Apr 9, 2015 at 0:55

John Conde

220k100 gold badges464 silver badges504 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

CarlosAllende Over a year ago

It is able to write many requests into the text file from php://, and I dont even use that for actually getting the variables

CarlosAllende Over a year ago

I tried that code, and it has the same effect. Writes to outputfile.txt but doesnt put it in the database

Collectives™ on Stack Overflow

PHP Not inserting POST data into database

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related