This is the sort of thing I'm doing:-
Code: Select all
mysql_query("CREATE TABLE ALLFILES (
author TINYTEXT,
username VARCHAR(16),
project TINYTEXT,
treeFilename TINYTEXT,
theData MEDIUMBLOB NOT NULL,
comment TINYTEXT,
treeAddress TINYTEXT DEFAULT '',
indent INT DEFAULT 0,
parentID INT DEFAULT -1,
children INT DEFAULT 0,
userIP TINYTEXT,
created TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
fileID INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY (fileID)
)");
#set up $author, $username, etc....
$theData=mysql_real_escape_string(file_get_contents("php://input"));
mysql_query("INSERT INTO ALLFILES
(author,username,project,treeFilename,theData,comment,userIP)
VALUES ('$author','$username','$project','$treeFilename','$theData','$comment','$userIP')
;") or die("error query 02");
Code: Select all
$fp = fopen("files/".$_GET["treeFilename"], "wb" );
fwrite( $fp, file_get_contents("php://input") );
fclose( $fp );
How do I do this?