Sqlite php for beginners

Very important : tutorial for php sqlite. Not sql, not mysql, etc

you can't have a tutorial for sqlite without sql. that's like an eggless omelette: it doesn't exist!

94 Replies

the EXACT SAME base syntax works for sqlite and mysql sql is just the "base" language where all others derive from you can write most queries for mysql and sqlite, with 0 modifications

glutonium•16mo ago

i think she was talking about OP xD

glutonium•16mo ago

what is "php sqlite" ? what's the diff between "php sqlite" and "sqlite"

lanszelot•16mo ago

Sqlite you are using dbbrowser, or terminal Php sqlite you using website. You manage sql with php

lanszelot•16mo ago

Here is a few php sqlite :https://gist.github.com/bladeSk/6294d3266370868601a7d2e50285dbf5

Gist

SQLite3 PHP Quickstart Tutorial

SQLite3 PHP Quickstart Tutorial. GitHub Gist: instantly share code, notes, and snippets.

glutonium•16mo ago

php sqlite is just an extension provided by php to interact with the sqlite DB? so what's the diff between the usage? what I'm understanding it's the same thing sqlite and php sqlite php sqlite is just the extension name which uses the same sqlite

lanszelot•16mo ago

Please open the link. Is that same? Which sqlite have variables? $database Did you see any sql with variables?

glutonium•16mo ago

well I don't use sql or php that's why m asking lmao i mean i did practice sql, but a year ago don't quite Exactly remember everything

lanszelot•16mo ago

I understand, but you confusing everyone. And no one will answer

glutonium•16mo ago

u r looking for video tutorials

lanszelot•16mo ago

Any. Text, video, anything is good Video tutorials shows create database and that's it

glutonium•16mo ago

if u just search php sqlite u get all that

glutonium•16mo ago

the manual isn't enough?

lanszelot•16mo ago

Those are not . That is nothing. Create database and insert. And gone How to update? How to delete? How to count?

glutonium•16mo ago

aaah discord

lanszelot•16mo ago

I did search . 1 week ago I am lookig and looking

glutonium•16mo ago

i mean just search up whenever u need something if u don't find 1 compact guide then just Search individual operations

lanszelot•16mo ago

Problem is you not try those. Just drop me images. Those are not working I have to use variables. Not text. If you create php file and copy , you realise error here error there Not working

glutonium•16mo ago

what issue r u facing rn with your project? i believe u know how to connect but i assume your issue is you don't know how to do CRUD operation??

lanszelot•16mo ago

Simple insert with variables. How to? With apostrophes or without? Create read update delete Crud Yes I know I know sql I don't know sql in php Why are you testing me? Why I would like to lie?

glutonium•16mo ago

calm down I'm not testing you I'm trying to understand the exact problem u have rn i am not talking about sql I'm asking if u know how to do these with php sqlite cause if u know how to do CRUD with php sqlite, what issue do u have then? not knowing how to use variables?

glutonium•16mo ago

in which case search it up https://stackoverflow.com/questions/19333792/how-to-use-php-variables-make-query-for-sqlite3

Stack Overflow

how to use php variables make query for sqlite3

<?php /** * Simple example of extending the SQLite3 class and changing the __construct * parameters, then using the open method to initialize the DB. */ class MyDB extends SQLite3 { funct...

glutonium•16mo ago

u r asking for a tutorial but u said it yourself, u have been looking for tutorials but none suffices you so if u can't find a compact solution for all your problems search individually

lanszelot•16mo ago

could you help me please how can I paste here php code?

glutonium•16mo ago

aah just copy paste in codeblock ```php // your code ```

lanszelot•16mo ago

<?php
$nev = "Dorothy";
//file create or open if exist
$receptekData = new SQLite3("receptekdb.sqlite", SQLITE3_OPEN_CREATE | SQLITE3_OPEN_READWRITE);
//error handling
$receptekData->enableExceptions(true);
//create table if not exist
$receptekData->query('CREATE TABLE IF NOT EXISTS "receptek" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
nev VARCHAR(100) NOT NULL,
)');

    $receptekData->exec('BEGIN');
    $receptekData->query('INSERT INTO "receptek" (
    nev
    VALUES (
    "$nev"
    )');
    $receptekData->exec('COMMIT');
    $receptekData->close();

<?php
$nev = "Dorothy";
//file create or open if exist
$receptekData = new SQLite3("receptekdb.sqlite", SQLITE3_OPEN_CREATE | SQLITE3_OPEN_READWRITE);
//error handling
$receptekData->enableExceptions(true);
//create table if not exist
$receptekData->query('CREATE TABLE IF NOT EXISTS "receptek" (
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
nev VARCHAR(100) NOT NULL,
)');

    $receptekData->exec('BEGIN');
    $receptekData->query('INSERT INTO "receptek" (
    nev
    VALUES (
    "$nev"
    )');
    $receptekData->exec('COMMIT');
    $receptekData->close();

this is php sqlite create db , create table, insert data but try it

glutonium•16mo ago

m on mobile

lanszelot•16mo ago

inside you cannot found Dorothy the insert data will be $nev

glutonium•16mo ago

what does "nev" mean

lanszelot•16mo ago

if I take out apostrophy error message "nev" is not a variable $nev is variable

glutonium•16mo ago

ik but I'm asking the meaning

lanszelot•16mo ago

$nev sore "DOrothy" look at the top of the code php use variables what I have to give to sql php code results store in variables if someone write her name in insert box, and I would like to store, and phone number, or count something, and after she press the button to save datas, all those datas are in variables

glutonium•16mo ago

sorry but may ik what the issue is with the code u explained what it does or is supposed to do what bug does this code have

lanszelot•16mo ago

so I have to give those variables value to the sql database

glutonium•16mo ago

it doesn't create a column named dorothy?

lanszelot•16mo ago

I wrote to you : that code save into the database $name, not Dorothy

glutonium•16mo ago

you might be doing some syntax error in the place where u r inserting data

Jochem•16mo ago

PHP does not do variable replacement inside single quoted strings

$name = "Jochem";
echo "$name\n";
echo '$name\n';

$name = "Jochem";
echo "$name\n";
echo '$name\n';

output

Jochem
$name

Jochem
$name

lanszelot•16mo ago

that is php only not php sqlite not the same

glutonium•16mo ago

r u sure?

Jochem•16mo ago

it really is the same

lanszelot•16mo ago

php does not do "CREATE TABLE" too

Jochem•16mo ago

    $receptekData->query("INSERT INTO 'receptek' (
    nev
    VALUES (
    '$nev'
    )");

    $receptekData->query("INSERT INTO 'receptek' (
    nev
    VALUES (
    '$nev'
    )");

try that

glutonium•16mo ago

that's the sqlite part variable replacement is php part but whatever, try what jochem said

lanszelot•16mo ago

Your code

Jochem•16mo ago

not my code at all, you didn't replace the quotes just after the opening bracket you can't have single quotes in a single quoted string, just as you can't have double quotes in a double quoted string not without escaping them, at least

glutonium•16mo ago

what if u do "'$nav'"

Jochem•16mo ago

that's not going to work, it's still in the original string PHP strings are multiline

glutonium•16mo ago

hmm ok \ won't work here either?

Jochem•16mo ago

it will, but you can also just switch the quotes from double to single

glutonium•16mo ago

lanszelot•16mo ago

I am on it, please give me a minute Fatal error: Uncaught Exception: near ")": syntax error in

Jochem•16mo ago

did you change the end quote?

lanszelot•16mo ago

copy paste you said I wrote wrong, so I copy paste it

Jochem•16mo ago

did you change the CREATE TABLE part back too?

lanszelot•16mo ago

no. how should I have to?

glutonium•16mo ago

i think u might wanna know more about the syntax as well since u r having issues with quotes

Jochem•16mo ago

yeah, I'd honestly recommend going through the base part of PHP's manual, it explains string syntax excellently

lanszelot•16mo ago

this is why I am looking a tutorial

glutonium•16mo ago

I'm talking about php

Jochem•16mo ago

this isn't a "php sqlite" issue, this is a very basic PHP issue

glutonium•16mo ago

not php sqlite

Jochem•16mo ago

you've got an extra comma at the end of nev VARCHAR

lanszelot•16mo ago

Fatal error: Uncaught Exception: near "VALUES": syntax error in I got extra, because I am doing fast, just write this quick error in 14

Jochem•16mo ago

you're missing a closing parenthesis after 'nev'

glutonium•16mo ago

damn man u really need to fix these bugs yourself

Jochem•16mo ago

I strongly recommend you take some time and learn the basics of the tools you're using

glutonium•16mo ago

☝️ r u doing some sort of assignment? or school or college project?

lanszelot•16mo ago

no only hobby

glutonium•16mo ago

then why rush? take it slow and learn slowly

lanszelot•16mo ago

1 week ago I try to do this. I am not rush. I need a tutorial. To learn

glutonium•16mo ago

u r in rush u r facing issue with basic php bugs u should practice that first

lanszelot•16mo ago

I wrote quick

glutonium•16mo ago

and that's rush

lanszelot•16mo ago

and I have dislexy I wrote this to you to not wait

glutonium•16mo ago

how long have u been practicing php?

Jochem•16mo ago

you need to take a step back and learn more of the basics. You were asking for a PHP sqlite tutorial, but the issue you've presented here was simply a misunderstanding of the very basics of the way PHP handles strings. You don't have the background information necessary to identify what tutorials you need to follow, so you need to take a step back to the basics of the tools you're using

lanszelot•16mo ago

few years

glutonium•16mo ago

really?

lanszelot•16mo ago

yes

glutonium•16mo ago

i doubt but ok

lanszelot•16mo ago

I created a family tree site to my mom

glutonium•16mo ago

lanszelot•16mo ago

never mind I am still looking some sql php tutorial one week ago just waste time

glutonium•16mo ago

Jochem•16mo ago

@lanszelot please don't delete your questions when you're done with them. Others might still be able to learn from the answers people gave

ἔρωςOP•16mo ago

i was thinking about this

lanszelot•16mo ago

I try to delete all, because it was not solved

Jochem•16mo ago

Still might help someone, so please don't

lanszelot•16mo ago

I think it only confuse anyone php sqlite tutorial not found anywhere

Jochem•16mo ago

You never know what helps someone else. It's gone to leave it up

lanszelot•16mo ago

in this case sorry, I just try to do what I thought it is good and what I thought I have to do

Gaming

Programming

Sqlite php for beginners

Did you find this page helpful?