nats

Can somebody plz tell me the Php code to display the HTML code snippet or any other language code which has been stored in the MySQL database & is retrieved on the browser without interpretation? My application includes a text box where the user gives an input of any text content which could also be an HTML code. This code is stored in the Database as it is by retaining the tags, but when I display it on the web page it interprets the code & shows the Output.

Hey thanks a lot......... The download works fine; but now again there is another problem.. While downloading a PDF file, it says an unknown file type...but after downloading, if I open it with Acrobat, the file opens successfully... This happens only with PDF files & not with any other file extension.

here is the code: <?php $dbcon = mysql_connect("localhost", "root", ""); mysql_select_db("xyz", $dbcon); $id = $_GET['id']; $query = "SELECT name, ext, size, path FROM uploads WHERE id = '$id'"; $result = mysql_query($query) or die('Error, query failed'); list($fileName, $fileType, $fileSize, $filePath) = mysql_fetch_array($result); echo $filePath; header("Content-Disposition: attachment; filename=\"$fileName\""); header("Content-length: $fileSize"); header("Content-type: $fileType"); readfile('$filePath'); ?>

Frndz I need ur help urgently... I am not able to open the file which has been downloaded from the server... The download dialogue works perfectly fine but on opening the file I get the following warning: Warning: readfile($filePath) [function.readfile]: failed to open stream: No such file or directory in ......

There wasn't anything relevant .... If u cud plz suggest some....

hey guys I need a tutorial which can guide me through the process of converting an excel file to html format... Plz help urgently...

The application which I am developing lets me upload files on the server....They are stored in various folders... But I also have to provide a view option for these files - which means I have to retrieve the files from the server & display it in an HTML format within my portal...& that is what I'm unaware of ... Can anybody plz help ?

Hey Guys, I am looking out for a search engine code which will help me to search through all the tables in my database & at the same time also through the folders in which I have uploaded my files... Can anyone suggest me some useful links....

I want to be able to create radio buttons in my form dynamically. I have a database which has a table with some names in it, so I want to be able to create a radio button for each name I find in the table. Pretend that there are 3 names, then when I open the form I should be able to see 3 radio buttons: ¤ name 1 ¤ name 2 ¤ name 3 How do I do this ? Can anyone please suggest some useful links or provide some help with the code...

thanx Russell Well i had the same thing in my mind...but now i hav 1 more doubt.. is there ne way we can handle wrong dates set in the server machine.. coz my project has features where we have to store the date of post, date of submission etc.. if the server is set to a wrong date then the server time which will be stored in the database, will be wrong. So is there ne way to handle this problem (other than manually setting the correct date in the server) ?

Well I liked the idea suggested by RusselReal... But since I am a beginner in php....I needed some more help... If someone could help me out with the code....It would be of great thanks..

That is what I'm presently doing.......explicitly mentioning the storage engine while creation of the tables.... But I wanted a way through which I can make InnoDB as the default engine so that the storage engine need not be specified repeatedly...

Is there any way out to make InnoDB as my default storage engine rather than MyISAM?....in phpMyAdmin(xampp) Currently I have to change the settings in my.cnf file eveytime before I start....So I want a way out through which I can make InnoDB as my default engine...

This a an e-learning portal which is currently on an intranet level(i.e within the college campus)...wherein multiple users can login through different terminals...& the stuff which they upload is being stored into the server's database...(into a field called as Date_of_submission having type as DateTime) How do I enter the server's current date into the database while some user is trying to upload a file?

I am trying to upload files into MySQL database using PHP...& I've already done that..but I also want the current date & time of uploading to be stored in the database(the files can be uploaded from any terminal in an intranet). Now the problem here is that, the current date comes form the system's date & is the stored into the database...but different systems have different dates and none of them are consistent... Hence I wanted to know if there is a way out to avoid this whole mess...