orbitter Posted March 2, 2008 Share Posted March 2, 2008 :'( hi there if anyone can help me please, i have a mysql database which stores php files. what i need help with is how to actually output the content of those files randomly in a web browser, can anyone help me pleaseeee??? :'( the code for inserting the data in the files is this: <?php $script1 = "file1.php"; mysql_query("INSERT INTO my_scripts (script_name) VALUES ('$script1')"); $script2 = "file2.php"; mysql_query("INSERT INTO my_scripts (script_name) VALUES ('$script2')"); $script3 = "file3.php"; mysql_query("INSERT INTO my_scripts (script_name) VALUES ('$script3')"); ?> can anyone help me with the code to actually output the content of these files randomly?? Link to comment https://forums.phpfreaks.com/topic/94040-outputting-php-file-from-mysql/ Share on other sites More sharing options...
pocobueno1388 Posted March 2, 2008 Share Posted March 2, 2008 Try this: <?php $query = mysql_query("SELECT script_name FROM my_scripts")or die(mysql_error()); $row = mysql_fetch_assoc($query); //this will add the content (hopefully) include "{$row['script_name']}"; ?> Link to comment https://forums.phpfreaks.com/topic/94040-outputting-php-file-from-mysql/#findComment-481747 Share on other sites More sharing options...
orbitter Posted March 2, 2008 Author Share Posted March 2, 2008 thanks for the script, this seems to be outputting just one file. could you show me how to output the content of a randomly selected file??? Link to comment https://forums.phpfreaks.com/topic/94040-outputting-php-file-from-mysql/#findComment-481750 Share on other sites More sharing options...
pocobueno1388 Posted March 2, 2008 Share Posted March 2, 2008 <?php $query = mysql_query("SELECT script_name FROM my_scripts ORDER BY RAND() LIMIT 1")or die(mysql_error()); $row = mysql_fetch_assoc($query); include "{$row['script_name']}"; ?> Link to comment https://forums.phpfreaks.com/topic/94040-outputting-php-file-from-mysql/#findComment-481751 Share on other sites More sharing options...
orbitter Posted March 2, 2008 Author Share Posted March 2, 2008 works liek a charm thanksss Link to comment https://forums.phpfreaks.com/topic/94040-outputting-php-file-from-mysql/#findComment-481758 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.