Damn Small Linux (DSL) Forums
Welcome, Guest. Please login or register.
Did you miss your activation email?
August 20, 2018, 05:34:11 AM

Login with username, password and session length
News
The new DSL forums are now open.
Stats
9857 Posts in 307 Topics by 333 Members
Latest Member: SaomonprigN
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
|-+  Recent Posts
Pages: [1] 2 3 ... 10
 1 
 on: August 19, 2018, 12:36:39 AM 
Started by murdock - Last post by CNK
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:
https://linux.die.net/man/1/sqlite3

Of course a more complete guide will be the SQLite official documentation:
https://sqlite.org/docs.html

 2 
 on: August 17, 2018, 12:40:02 PM 
Started by murdock - Last post by murdock
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

 3 
 on: August 14, 2018, 11:02:46 PM 
Started by murdock - Last post by CNK
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?

 4 
 on: August 14, 2018, 03:55:57 PM 
Started by murdock - Last post by 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

 5 
 on: August 10, 2018, 10:00:14 AM 
Started by Juli63G067 - Last post by Juli63G067
The form of strapless Grecian adorn dress gives intensive pleating around the bust line with metallic salt high middle bands, in addition to being great for compact busted women.

Check out my blog post - fringed dress black (http://www.cercosaceramica.com/?option=com_k2&view=itemlist&task=user&id=1010344)

 6 
 on: August 10, 2018, 05:16:38 AM 
Started by MPS - Last post by Navaruki
Being in good times is a great way to increase my understanding. Thank you very much.

 7 
 on: August 10, 2018, 05:16:17 AM 
Started by lifeisgreat - Last post by Navaruki
We sincerely hope that this discussion will make it even more clear.

Pages: [1] 2 3 ... 10
Powered by SMF 1.1.20 | SMF © 2013, Simple Machines
Mercury design by Bloc