I have site on Ensim Linux.. Trying to implement php code which loads data using this statement.
(basepath is set to /var/www/html).. in an include file
$infile = $config[\'basepath\'] .\'/admin/test.txt\';
$sql=\"LOAD DATA LOCAL INFILE \'\". $infile .\"\' INTO TABLE default_comm_propTEMP_IDX\"
Any way, this command works great at the command line while logged in as root or the site admin.. But when I run it from php using web browser, it is trying to find the text file to load in the /var/www/html/admin directory of the SERVER and not within the site.. Of course it\'s not at the root server it\'s in the site directory\'s /var..
Does anyone know how to get it to refer to the /var/www/html of the site and not the server? This is taking forever...
Thanks!
Monica