users
filemanager=# create table users
filemanager-# (uid SERIAL,
filemanager(# username varchar(50),
filemanager(# password varchar(50),
filemanager(# accesslevel integer,
filemanager(# PRIMARY KEY (uid)
filemanager(# );
directories
filemanager=# create table directories
filemanager-# (directoryid SERIAL,
filemanager(# directoryname varchar(50),
filemanager(# datecreated datetime,
filemanager(# uid integer,
filemanager(# PRIMARY KEY (directoryid),
filemanager(# FOREIGN KEY (uid) REFERENCES users(uid));
I am trying to Insert information from a user front end into the directories table, specifically, I am attempting to insert data into the uid field, and that is where I am getting the following error:
Warning: pg_last_error(): 1 is not a valid PostgreSQL link resource in /usr/local/www/data-dist/filemanager/makedir.php on line 81
Error in query: INSERT INTO directories (directoryname,datecreated,uid) VALUES (hello,now(),1) .
Can anyone help? As I understand I cannot insert into the directories table until I have checked that the constraint is true, is that correct? I await replies