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
|