XAMPP sqlite data base with PHP

Question

Someone recently marked my question as a duplicate however I don't think it is but I am not sure how to unmark it and now I don't think anyone will answer it so I am just reposting it and saying that it is not a duplicate.

I am trying to make a website that has a database connected to it. I am on a Mac. I downloaded XAMPP and have developed the form on my webpage that I am going to use to get data from the user. I have tested that and it seems to be working. I then followed XAMPP instructions on how to create a sqlite db through the terminal and then connect to that database through php. I was able to read things from that database with a select statement however when I went to go insert into it, it said that it was a read only copy and that I could not insert. I was wondering if there was a line of code that I was missing? Or some setting that I had to change?

I looked into making a folder writable but there are conflicting things out there and I don't want to mess anything up if that really is the problem.

Here is a picture of the error that is displaying

Here is my PHP code, I can also share the HTML if you need it:

    <html> 

    <style type="text/css">
    body {background-color:#666666; color: white;}
    </style> 

    <body>
    <h1 align = "center">

    <img src="housebackground.jpg" alt="Mountain View" style="width:97%;height:228px;" ></h1>

    <h1 align = "center">Submission Status</h1>

    <?php
       $db = new SQLite3('mydb.sq3');

       $StructureName = $_POST["StructureName"];
       $Author = $_POST["Author"];
       $YearBuilt = $_POST["YearBuilt"];
       $EraBuilt = $_POST["EraBuilt"];
       $YearDestroyed = $_POST["YearDestroyed"];
       $EraDestroyed = $_POST["EraDestroyed"];
       $Latitude = $_POST["Latitude"];
       $Longitude = $_POST["Longitude"];
       $StructureLink = $_POST["StructureLink"];


       $db->exec("INSERT INTO info VALUES (null, '$StructureName', '$Author', $YearBuilt, '$EraBuilt', $YearDestroyed, '$EraDestroyed', $Latitude, $Longitude, '$StructureLink');"); 


       unset($db); 
    ?>

    <br><br>
    </body>
    </html>

I think you have missing single quotations in two of your variables $Latitude and $Longitude — Amr Aly
– Amr Aly, Commented Mar 15, 2017 at 23:08
@AmrAly Hm I don't think I need them there or around the YearBuilt and YearDestroyed since they are integers and floats. — Jessica Napolitano
– Jessica Napolitano, Commented Mar 15, 2017 at 23:28
Actually i think you need them. have you tried what i've suggested? — Amr Aly
– Amr Aly, Commented Mar 15, 2017 at 23:30

Amr Aly · Accepted Answer · 2017-03-17 02:03:54Z

1

First of all change the permissions for the file

sudo chmod 775 mydb.sq3

Second change the directory permissions

sudo chmod -R 775 the_path_to_your_folder

answered Mar 17, 2017 at 2:03

Amr Aly

3,9152 gold badges18 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

Jessica Napolitano Over a year ago

This still is not working :( Is there another route I can take?

Amr Aly Over a year ago

Try sudo chgrp www-data mydb.sq3.

Jessica Napolitano Over a year ago

it is saying that www-data is an invalid group name. Sorry I am also new to the idea of a group. Do I need to add a new group before i can do this?

Amr Aly Over a year ago

Have u tried to check the permissions for the folder containing the database check this video

Amr Aly Over a year ago

No need since it's not my video. I just searched for it.

|

Collectives™ on Stack Overflow

XAMPP sqlite data base with PHP

1 Answer 1

9 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related