Latest posts of: murdock

Hello, I was installing dsl linux
with php connected to sqlite the topical sentences work

http://damnsmalllinux.org/static/act-Print/f-16/t-3036.html

but only for a php sqlite select

but to work with insert I get error

example:
index7.php
---------------
<html>
<head>
<title>DSL</title>
</head>
<body>
<h1>INSERT</h1>
<br><hr>
<form action="http://localhost/env.php" method="post">
<ul>
<li>Name: <input type="text" name="nombre" size="20"><br>
<li>Email: <input type="text" name="correo" size="20"><br>
<li>Web Site: <input type="text" name="web" size="20"><br>
<li>Comment: <input type="text" name="comm" size="20"><br>
</ul>
<input type="submit" value="Ok"><br>
<input type="reset" value="Delete"><br>
</form>
<hr>
</body>
</html>

env.php
-----------
<?php
require "sqlite.php";
$db = 'comment_section.db';
sqlite_connect($db) or die ("Could not connect");
$sql = "insert into comments(name,
email,
website_url,
comment ) values ('$_POST[nombre]',
'$_POST[correo]',
'$_POST[web]',
'$_POST[comm]' );
sqlite_query($sql, $db) or die (Query Failed);
?>

Result:
---------
________________________________________________________________________________
sqlite_exec: insert into comments(name, email, website_url, comment)values('pedro', 'pepe@mail.com',
'pepino.wordpress.com','viejo boludo' )
________________________________________________________________________________
________________________________________________________________________________
sqlite_query result:
SQL error: unable to open database file
SQL error: unable to open database file
SQL error: unable to open database file
________________________________________________________________________________
Query Failed