The problem with the query

I can not find an answer to why this query does not work:

$query = pg_query($connect, sprintf("INSERT INTO table (uid, urzid, time_开发者_高级运维start, time_stop2, date_start, date_stop, cycle) VALUES ($uid, $pom, '$time1', '$time2', '$data1', '$data2', $cykl)"));

I get a warning: PG_QUERY() [FUNCTION.PG-QUERY]: QUERY FAILED: ERROR: SYNTAX ERROR AT OR NEAR "," AT CHARACTER 96

It seems to me that the error is associated with.'' $ time1, $ Time2 and $ date1, $ date2 are in accordance with the format for date and time.

You have to provide a format to the function sprintf

See the doc

And moreover, there's no needs at all of sprintf in this case.

We cannot guess what content is in your variables. Please run this code and paste the result:

echo "INSERT INTO table (uid, urzid, time_start, time_stop2, date_start, date_stop, cycle) VALUES ($uid, $pom, '$time1', '$time2', '$data1', '$data2', $cykl)";

You will find the syntax error.

The best way to avoid this kind of errors (and, even more importantly, to prevent SQL injection), is to use a library such as PDO and to use placeholders for variables.

Update: now that we could see what your variables look like, try this:

$query = pg_query($connect, "INSERT INTO table (uid, urzid, time_start, time_stop2, date_start, date_stop, cycle) VALUES ('$uid', '$pom', '$time1', '$time2', '$data1', '$data2', '$cykl')");

Don't forget to have a look at the above comment for best practices, however.

You have to add extra parameters :

$world = "World";
$foo = sprintf("Hello %s", $world);

However, as you are in a double quoted string you don't need sprintf :

$foo = "Hello $world";

Try reversing quoting, " => ', " => ' ... saves me a lot pain always.