Can not insert data into SQLite3 database

[Betikci Boris]

Can not insert data into SQLite3 database through browser however i
can easily insert data into my db from konsole, in both attmpts i used
php 5.2.6 on 2.6.25.* linux kernel

i think there is a problem with my php setup but i could not find
it...

here is the code;
----------------------------------------------------------------------------------------
$db = new PDO("sqlite:bar.db");
$sql = "select * from user";

$query = "insert into user values(null,'foo','bar')";
$db->query($query);
print_r($db->query($query));
print_r($db->query($sql));

foreach ($db->query($sql) as $row)
print $row['id'] . " " . $row['text'] . " " . $row['text2'] .
"<br>";

unset($db);
------------------------------------------------------------------------------------------

first print_r() function prints nothing, actually "select" works,
"insert" wouldn't....

What's the problem?

[Jerry Stuckle]

Betikci Boris wrote:

Can not insert data into SQLite3 database through browser however i
can easily insert data into my db from konsole, in both attmpts i used
php 5.2.6 on 2.6.25.* linux kernel

i think there is a problem with my php setup but i could not find
it...

here is the code;
----------------------------------------------------------------------------------------
$db = new PDO("sqlite:bar.db");
$sql = "select * from user";

$query = "insert into user values(null,'foo','bar')";
$db->query($query);
print_r($db->query($query));
print_r($db->query($sql));

foreach ($db->query($sql) as $row)
print $row['id'] . " " . $row['text'] . " " . $row['text2'] .
"<br>";

unset($db);
------------------------------------------------------------------------------------------

first print_r() function prints nothing, actually "select" works,
"insert" wouldn't....

What's the problem?

Enable all errors and display them - in your php.ini file, ensure you have:

display_error=on
error_reporting=E_ALL
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[Betikci Boris]

On Aug 30, 4:38*pm, Jerry Stuckle <[e-mail]:

Betikci Boris wrote:

Can not insert data into SQLite3 database through browser however i
can easily insert data into my db from konsole, in both attmpts i used
php 5.2.6 on 2.6.25.* linux kernel

i think there is a problem with my php setup but i could not find
it...

here is the code;
----------------------------------------------------------------------------------------
$db = new PDO("sqlite:bar.db");
$sql = "select * from user";

$query = "insert into user values(null,'foo','bar')";
$db->query($query);
print_r($db->query($query));
print_r($db->query($sql));

*foreach ($db->query($sql) as $row)
* * print $row['id'] . " " . $row['text'] . " " . $row['text2'] .
"<br>";

unset($db);
------------------------------------------------------------------------------------------

first print_r() function prints nothing, actually "select" works,
"insert" wouldn't....

What's the problem?

Enable all errors and display them - in your php.ini file, ensure you have:

display_error=on
error_reporting=E_ALL

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[e-mail]
==================

i've tried with try catch but that's the point there is nothing to
report.. According to this function =print_r($db->query($query));
query returns 0 or even -1,

I think the problem with mod_php configuration on cli with php
everything works fine ...

[Jerry Stuckle]

Betikci Boris wrote:

On Aug 30, 4:38 pm, Jerry Stuckle <[e-mail]:

>Betikci Boris wrote:

>>Can not insert data into SQLite3 database through browser however i
can easily insert data into my db from konsole, in both attmpts i used
php 5.2.6 on 2.6.25.* linux kernel
i think there is a problem with my php setup but i could not find
it...
here is the code;
----------------------------------------------------------------------------------------
$db = new PDO("sqlite:bar.db");
$sql = "select * from user";
$query = "insert into user values(null,'foo','bar')";
$db->query($query);
print_r($db->query($query));
print_r($db->query($sql));
foreach ($db->query($sql) as $row)
print $row['id'] . " " . $row['text'] . " " . $row['text2'] .
"<br>";
unset($db);
------------------------------------------------------------------------------------------
first print_r() function prints nothing, actually "select" works,
"insert" wouldn't....
What's the problem?

Enable all errors and display them - in your php.ini file, ensure you have:

display_error=on
error_reporting=E_ALL

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[e-mail]
==================

i've tried with try catch but that's the point there is nothing to
report.. According to this function =print_r($db->query($query));
query returns 0 or even -1,

I think the problem with mod_php configuration on cli with php
everything works fine ...

I didn't say use try and catch. Please try what I wrote.

PHP base code doesn't generally throw exceptions. But it does provide
error information if you have it configured to do so.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[Betikci Boris]

On Aug 31, 4:10*am, Jerry Stuckle <[e-mail]:

Betikci Boris wrote:

On Aug 30, 4:38 pm, Jerry Stuckle <[e-mail]:

Betikci Boris wrote:
Can not insert data into SQLite3 database through browser however i
can easily insert data into my db from konsole, in both attmpts i used
php 5.2.6 on 2.6.25.* linux kernel
i think there is a problem with my php setup but i could not find
it...
here is the code;
----------------------------------------------------------------------------------------
$db = new PDO("sqlite:bar.db");
$sql = "select * from user";
$query = "insert into user values(null,'foo','bar')";
$db->query($query);
print_r($db->query($query));
print_r($db->query($sql));
*foreach ($db->query($sql) as $row)
* * print $row['id'] . " " . $row['text'] . " " . $row['text2'] .
"<br>";
unset($db);
------------------------------------------------------------------------------------------
first print_r() function prints nothing, actually "select" works,
"insert" wouldn't....
What's the problem?
Enable all errors and display them - in your php.ini file, ensure you have:

display_error=on
error_reporting=E_ALL

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[e-mail]
==================

i've tried with try catch but that's the point there is nothing *to
report.. *According to this function =print_r($db->query($query));
query returns 0 or even -1,

I think the problem with mod_php configuration on cli with php
everything works fine ...

I didn't say use try and catch. *Please try what I wrote.

PHP base code doesn't generally throw exceptions. *But it does provide
error information if you have it configured to do so.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[e-mail]
==================

In php.ini;

display_error=on
error_reporting=E_ALL & ~E_NOTICE

[Jerry Stuckle]

Betikci Boris wrote:

On Aug 31, 4:10 am, Jerry Stuckle <[e-mail]:

>Betikci Boris wrote:

>>On Aug 30, 4:38 pm, Jerry Stuckle <[e-mail]:
Betikci Boris wrote:
Can not insert data into SQLite3 database through browser however i
can easily insert data into my db from konsole, in both attmpts i used
php 5.2.6 on 2.6.25.* linux kernel
i think there is a problem with my php setup but i could not find
it...
here is the code;
----------------------------------------------------------------------------------------
$db = new PDO("sqlite:bar.db");
$sql = "select * from user";
$query = "insert into user values(null,'foo','bar')";
$db->query($query);
print_r($db->query($query));
print_r($db->query($sql));
foreach ($db->query($sql) as $row)
print $row['id'] . " " . $row['text'] . " " . $row['text2'] .
"<br>";
unset($db);
------------------------------------------------------------------------------------------
first print_r() function prints nothing, actually "select" works,
"insert" wouldn't....
What's the problem?
Enable all errors and display them - in your php.ini file, ensure you have:
display_error=on
error_reporting=E_ALL
i've tried with try catch but that's the point there is nothing to
report.. According to this function =print_r($db->query($query));
query returns 0 or even -1,
I think the problem with mod_php configuration on cli with php
everything works fine ...

I didn't say use try and catch. Please try what I wrote.

PHP base code doesn't generally throw exceptions. But it does provide
error information if you have it configured to do so.

In php.ini;

display_error=on
error_reporting=E_ALL & ~E_NOTICE

That still isn't what I asked you to put in your php.ini file!

Do you always have this much trouble following a simple request?

Sorry, I'm not in the habit of wasting my time. Find someone else to
help you.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[Betikci Boris]

On Aug 31, 5:04*pm, Jerry Stuckle <[e-mail]:

Betikci Boris wrote:

On Aug 31, 4:10 am, Jerry Stuckle <[e-mail]:

Betikci Boris wrote:
On Aug 30, 4:38 pm, Jerry Stuckle <[e-mail]:
Betikci Boris wrote:
Can not insert data into SQLite3 database through browser however i
can easily insert data into my db from konsole, in both attmpts i used
php 5.2.6 on 2.6.25.* linux kernel
i think there is a problem with my php setup but i could not find
it...
here is the code;
----------------------------------------------------------------------------------------
$db = new PDO("sqlite:bar.db");
$sql = "select * from user";
$query = "insert into user values(null,'foo','bar')";
$db->query($query);
print_r($db->query($query));
print_r($db->query($sql));
*foreach ($db->query($sql) as $row)
* * print $row['id'] . " " . $row['text'] . " " . $row['text2']

[Betikci Boris]

On Sep 1, 12:08*pm, Betikci Boris <[e-mail]:

On Aug 31, 5:04*pm, Jerry Stuckle <[e-mail]:

Betikci Boris wrote:

On Aug 31, 4:10 am, Jerry Stuckle <[e-mail]:
>Betikci Boris wrote:
>>On Aug 30, 4:38 pm, Jerry Stuckle <[e-mail]:
>>>Betikci Boris wrote:
>>>>Can not insert data intoSQLite3database through browser however i
>>>>can easily insert data into my db from konsole, in both attmpts iused
>>>>php 5.2.6 on 2.6.25.* linux kernel
>>>>i think there is a problem with my php setup but i could not find
>>>>it...
>>>>here is the code;
>>>>----------------------------------------------------------------------------------------
>>>>$db = new PDO("sqlite:bar.db");
>>>>$sql = "select * from user";
>>>>$query = "insert into user values(null,'foo','bar')";
>>>>$db->query($query);
>>>>print_r($db->query($query));
>>>>print_r($db->query($sql));
>>>>*foreach ($db->query($sql) as $row)
>>>>* * print $row['id'] . " " . $row['text'] . " " . $row['text2'] .
>>>>"<br>";
>>>>unset($db);
>>>>------------------------------------------------------------------------------------------
>>>>first print_r() function prints nothing, actually "select" works,
>>>>"insert" wouldn't....
>>>>What's the problem?
>>>Enable all errors and display them - in your php.ini file, ensure you have:
>>>display_error=on
>>>error_reporting=E_ALL
>>i've tried with try catch but that's the point there is nothing *to
>>report.. *According to this function =print_r($db->query($query));
>>query returns 0 or even -1,
>>I think the problem with mod_php configuration on cli with php
>>everything works fine ...
>I didn't say use try and catch. *Please try what I wrote.

>PHP base code doesn't generally throw exceptions. *But it does provide
>error information if you have it configured to do so.

In php.ini;

display_error=on
error_reporting=E_ALL & ~E_NOTICE

That still isn't what I asked you to put in your php.ini file!

Do you always have this much trouble following a simple request?

Sorry, I'm not in the habit of wasting my time. *Find someone else to
help you.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[e-mail]
==================

.. and also;

display_error=on
error_reporting=E_ALL

prints nothing.. *what a strange mod_php malfunction..

Oh! what a shame!
Directory permissions, which is the database located, must allow to
write!...
chmod 777 todir has been removed all problems;)

[Jerry Stuckle]

Betikci Boris wrote:

On Sep 1, 12:08 pm, Betikci Boris <[e-mail]:

>On Aug 31, 5:04 pm, Jerry Stuckle <[e-mail]:

>>Betikci Boris wrote:
On Aug 31, 4:10 am, Jerry Stuckle <[e-mail]:
Betikci Boris wrote:
>On Aug 30, 4:38 pm, Jerry Stuckle <[e-mail]:
>>Betikci Boris wrote:
>>>Can not insert data intoSQLite3database through browser however i
>>>can easily insert data into my db from konsole, in both attmpts i used
>>>php 5.2.6 on 2.6.25.* linux kernel
>>>i think there is a problem with my php setup but i could not find
>>>it...
>>>here is the code;
>>>----------------------------------------------------------------------------------------
>>>$db = new PDO("sqlite:bar.db");
>>>$sql = "select * from user";
>>>$query = "insert into user values(null,'foo','bar')";
>>>$db->query($query);
>>>print_r($db->query($query));
>>>print_r($db->query($sql));
>>> foreach ($db->query($sql) as $row)
>>> print $row['id'] . " " . $row['text'] . " " . $row['text2'] .
>>>"<br>";
>>>unset($db);
>>>------------------------------------------------------------------------------------------
>>>first print_r() function prints nothing, actually "select" works,
>>>"insert" wouldn't....
>>>What's the problem?
>>Enable all errors and display them - in your php.ini file, ensure you have:
>>display_error=on
>>error_reporting=E_ALL
>i've tried with try catch but that's the point there is nothing to
>report.. According to this function =print_r($db->query($query));
>query returns 0 or even -1,
>I think the problem with mod_php configuration on cli with php
>everything works fine ...
I didn't say use try and catch. Please try what I wrote.
PHP base code doesn't generally throw exceptions. But it does provide
error information if you have it configured to do so.
In php.ini;
display_error=on
error_reporting=E_ALL & ~E_NOTICE
That still isn't what I asked you to put in your php.ini file!
Do you always have this much trouble following a simple request?
Sorry, I'm not in the habit of wasting my time. Find someone else to
help you.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[e-mail]
==================

.. and also;

display_error=on
error_reporting=E_ALL

prints nothing.. what a strange mod_php malfunction..

Oh! what a shame!
Directory permissions, which is the database located, must allow to
write!...
chmod 777 todir has been removed all problems;)

Which, would have been indicated by an E_NOTICE message if you would
have followed my initial instructions. You probably changed the wrong
php.ini file.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================