Damn Small Linux (DSL) Forums
Welcome, Guest. Please login or register.
Did you miss your activation email?
March 29, 2020, 10:54:03 AM

Login with username, password and session length
The new DSL forums are now open.
11506 Posts in 353 Topics by 432 Members
Latest Member: Aaronenlig
Search:     Advanced search
* Home Help Search Login Register
Get The Official Damn Small Linux Book. Great VPS hosting provided by Tektonic

+  Damn Small Linux (DSL) Forums
|-+  MyDSL Extensions
| |-+  System
| | |-+  sqlite insert from php
« previous next »
Pages: [1] Print
Author Topic: sqlite insert from php  (Read 50205 times)
Posts: 2

View Profile Email
« on: August 14, 2018, 03:55:57 PM »

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


but only for a php sqlite select

but to work with insert I get error

<form action="http://localhost/env.php" method="post">
<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>
<input type="submit" value="Ok"><br>
<input type="reset" value="Delete"><br>

require "sqlite.php";
$db = 'comment_section.db';
sqlite_connect($db) or die ("Could not connect");
$sql = "insert into comments(name,
comment ) values ('$_POST[nombre]',
'$_POST[comm]' );
sqlite_query($sql, $db) or die (Query Failed);

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
Sr. Member
Posts: 269

View Profile
« Reply #1 on: August 14, 2018, 11:02:46 PM »

I've used PHP in DSL without trouble, but I haven't worked with SQLite. I notice that without having set anything up, it displays a "main" database with no file location when the ".databases" command is entered at the SQLite terminal. If you haven't set up your own separate database and were expecting to use the default, this might indicate that you need to set your own location for the database.

Otherwise it looks like some sort of permissions problem. Perhaps the SQLite process isn't running as root?
Posts: 2

View Profile Email
« Reply #2 on: August 17, 2018, 12:40:02 PM »

Ok I put the database in the same folder htdocs of the server monkey that is by default and how can I do to instantiate sqlite as root you know why I the sqlite file will generate it only with the word "sqlite databasename.db" and nothing else I do not know how to pass that file to root
Sr. Member
Posts: 269

View Profile
« Reply #3 on: August 19, 2018, 12:36:39 AM »

As I said, I haven't set up SQLite myself. However if you're now using a database file that doesn't require root permissions to access, I imagine you shouldn't need to worry about running it as root.

For configuration information, I'd recommend reading the manual page:

Of course a more complete guide will be the SQLite official documentation:
Pages: [1] Print 
« previous next »
Jump to:  

Powered by SMF 1.1.20 | SMF © 2013, Simple Machines
Mercury design by Bloc