Hi - I ran across a php script where the data file was created in /tmp, so I tried that, and it works! I found some errors in my insert command, basically they were differences in insert as opposed to reading a tab-delimited file as I was doing in sqlite3. For example, two commas are interpreted as a NULL when reading, but NULLs have to be explicitly entered in the insert command. Also, strings have to be quoted. Anyway, I am now at the stage where its just a matter of learning PHP, because all the system stuff is working. This I can do. Thanks Simon, for your help on this.
Frank Simon Slavin-3 wrote: > > Frank, > > I think you might get things done faster if you take a step back from your > own application and try to get a simpler PHP application working. You > need to learn how the PDO system works and also what it takes to get > Apache to store data on your computer. > > Test it command by command: make something to create a blank database, run > your program, then use the Finder to see if the file appeared. Once it > does, delete the file. > > Add a command to you PHP application to try to create a blank table and > see if the table appeared. Once it does, delete the file. > > Then try to put one record in it and see whether the record appeared. > Once it does, delete the file. > > Each time you add a new command in your PHP program, use the sqlite3 > command-line utility to look inside the database file and check to see if > the command had the right result. > > Simon. > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/Sqlite-and-php-tp26754013p26788685.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
