[PHP-DB] temporary files
Im trying to create a way of storing php scripts in a mySQL database and then execute them using temporary files as executable script buffers.. Ive got a mysql table with 4 fields: execID, execName, execDesc and execProc The last one contains php code. This is what i have so far: But i need to get the name of the tempfile in order to include it.. all i have now is the handle_id any help appreciated. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] temporary files
You might consider using tmpnam() instead. tmpnam() doesn't give you a file handle (like tmpfile() does), but rather a file name. Just pass it a directory (like "/tmp") and a prefix to help identify it (can be "" ). It returns the unique file's name, and you could open a file handle to it with fopen(). Keep in mind that you have to unlink() it when you're done. Hope this helps! --Dave Lars Tvedt wrote: Im trying to create a way of storing php scripts in a mySQL database and then execute them using temporary files as executable script buffers.. Ive got a mysql table with 4 fields: execID, execName, execDesc and execProc The last one contains php code. This is what i have so far: But i need to get the name of the tempfile in order to include it.. all i have now is the handle_id any help appreciated. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] mysql < ****.sql thru a php script
I have a large sql file that I would like to load into mysql database from a remote client. Is there a way through a php script to do this? I have tried $query = " "; (where the contents of the sql file was pasted into the query) then $results = mysql_db_query("database", $query); but it fails. Any ideas or experience? R Race -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] DB CODEING HELP!!!!!
this is bugging me. I have tried everything and I cant develop the code without an error. Can someone plese write me simple code that will go through a table and print 3 collums of that table? I cant figure it out
[PHP-DB] finding out the date of the first day of the current week
I am trying to make a small function that will me the date in Y-m-d of the start of the current week (the sunday) I have only the idea of doing it by making a long drawn out script with if, elseif clauses for every day of the week... and then doing something like if ( date('D') = "mon" ) { $sunday = mktime (0,0,0,date("m") ,date("d")-1,date("Y")); } does anyone know a simple way to do this _ Overloaded with spam? With MSN 8, you can filter it out http://join.msn.com/?page=features/junkmail&pgmarket=en-gb&XAPID=32&DI=1059 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] DB CODEING HELP!!!!!
> this is bugging me. I have tried everything and I cant develop > the code without an error. Can someone plese write me simple code > that will go through a table and print 3 collums of that table? I > cant figure it out I don't know which database you're using but say for example it was MySQL here's a very quick and dirty example '; } } mysql_close($link); ?> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] finding out the date of the first day of the current week
> I am trying to make a small function that will me the date in Y-m-d of the > start of the current week (the sunday) I have only the idea of doing it by > making a long drawn out script with if, elseif clauses for every day of > the > week... and then doing something like > > if ( date('D') = "mon" ) { > > $sunday = mktime (0,0,0,date("m") ,date("d")-1,date("Y")); Try this: $Sunday = mktime(0,0,0,date('m'),date('d')-date('w'),date('Y')); ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] mysql < ****.sql thru a php script
> I have a large sql file that I would like to load into mysql database from > a > remote client. Is there a way through a php script to do this? > > I have tried $query = " "; (where the contents > of > the sql file was pasted into the query) > > then $results = mysql_db_query("database", $query); > > but it fails. Any ideas or experience? You can only run one query at a time. If it is a really large file, you'll probably want to make an exec() call to have mysql load the file itself. $result = `mysql -uroot -ppassword database_name < filename.sql` Those are backticks, not single quotes. $result should be empty if everything went well. Adapt to your needs. Or, here's part of a little script I wrote that'll read and execute *.sql files (from MySQLDump). The str_replace() adds in a table prefix. This works with my script using ADOdb, so adapt to your needs. $sql_file = 'survey2.inc'; $file = file($sql_file); foreach($file as $line) { if($line{0} != '#' && strlen($line) > 0) { $query .= trim($line); if(substr($query,-1) == ";") { $query = str_replace('%PREFIX%',$survey->CONF['db_tbl_prefix'],$query); $query = substr($query,0,-1); $rs = $survey->db->Execute($query); if($rs === FALSE) { $error = TRUE; echo '' . $survey->db->ErrorMsg(); } $query = ''; } } } ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] DB CODEING HELP!!!!!
Here, this will pull data and make a select box. Adjust as needed. $result = mysql_query("SELECT company_id, company_name FROM company_table ORDER BY company_name", $db); if (mysql_num_rows($result) > 0) { echo "\n\t\n"; while ( $row = mysql_fetch_array($result,MYSQL_ASSOC) ) { echo "\t".$row['company_name']."\n"; } echo ""; } else echo "No Companies Defined\n"; > -Original Message- > From: Mike Delorme [mailto:[EMAIL PROTECTED] > Sent: Sunday, March 23, 2003 1:11 PM > To: MySQL PHP Database Help > Subject: [PHP-DB] DB CODEING HELP! > > > this is bugging me. I have tried everything and I cant > develop the code without an error. Can someone plese write me > simple code that will go through a table and print 3 collums > of that table? I cant figure it out > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] when click on button, how renew info on page?
hello everyone, with this code, a table is loaded with info from the mysql db with id = '1'. but now i want to make a button, and when it is clicked, he has to renew the table with the info from the db with id ='2' does anyone know has this should be done? thanks in advance! Greetings, Gert Vonck ?> Info_DJ $result0 = mysql_query("SELECT naam,leeftijd,muziekgenre,favoriet_liedje,motto,picture_right FROM info_dj WHERE id='1'") or die (mysql_error()); print"\n"; $field_count = mysql_num_fields($result0); while ($get_info0 = mysql_fetch_row($result0)) { print ""; for($i = 0; $i < $field_count - 1 ; $i++){ $value = $get_info0[$i]; $column = mysql_field_name($result0,$i); print "\t$column$value\n"; } $last = $field_count - 1; print "\n"; } print "\n"; mysql_close(); ?> _ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] mysql timestamps
how do i change the format of a MySQL timestamp (i.e hh:mm:ss DD/MM/ instead of MMDDhhmmss) retrieved from a mysql database with php? thanks in advance -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] DB CODEING HELP!!!!!
hi hth Peter '; while($row = mysql_fetch_array($mysql_result)) {// enter display code here $retval.=' '.$row["Column_name1"].' '.$row["Column_name2"].' '.$row["Column_name3"].' '.$row["Column_name4"].' '; }// end while $retval.=''; //output results print $retval ; //close mysql link mysql_close($link); ?> -Original Message- From: Mike Delorme [mailto:[EMAIL PROTECTED] Sent: 23 March 2003 21:11 To: MySQL PHP Database Help Subject: [PHP-DB] DB CODEING HELP! this is bugging me. I have tried everything and I cant develop the code without an error. Can someone plese write me simple code that will go through a table and print 3 collums of that table? I cant figure it out -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] mysql timestamps
> how do i change the format of a MySQL timestamp (i.e hh:mm:ss DD/MM/ > instead of MMDDhhmmss) retrieved from a mysql database with php? Use SELECT TO_UNIXTIME(your_column) FROM table ... And then use date() in PHP to format the result to your liking. Or, you can use DATE_FORMAT() in your query to format the result to your liking. ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Joining two talbes
Can someone help me understand joining tables, and how I can do this: SELECT clients.business_name, details.quoted_price, details.finish_date FROM clients, details WHERE clients.client_id = details.client_id =" . $HTTP_GET_VARS['id']; Can I do that? thx -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Joining two talbes
> Can someone help me understand joining tables, and how I can do this: > SELECT clients.business_name, details.quoted_price, details.finish_date > FROM clients, details WHERE clients.client_id = details.client_id =" . > $HTTP_GET_VARS['id']; Since when can you do WHERE var1 = var2 = var3 ?? You need to do it such as: WHERE var1 = var2 AND var1 = var3 ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Setting up arrays from queries
When I execute this function: function getTitles() { $this -> openConnection(); $title_query = "select name from categories"; $title_result = mysql_query($title_query); echo "here is title_result: ".mysql_affected_rows(); $i = 0; while ($titles = mysql_fetch_array($title_result, MYSQL_ASSOC)){ $i++;//titles becomes an associative array } echo "#of iterations: ".$i; echo "here is titles: ".end($titles); echo "\n here is titles: ".prev($titles); echo "\n here is titles: ".$this->titles[2]; mysql_free_result($title_result); mysql_close(); } The line: while ($titles = mysql_fetch_array($title_result, MYSQL_ASSOC)){ Does not give me an array, any ideas? Here is the error I get: here is title_result: 6#of iterations: 6 Warning: end() [function.end]: Passed variable is not an array or object in /Users/timbest/Sites/cajunmikes/inc/menupage.php on line 16 I do get a succcessful connection because the of the iterations and the title_result which is from mysql_affected_rows(); Thanks, tired Tim -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] when click on button, how renew info on page?
Yeah.. U Just a need a normal Button, target to the same site with id+1 -Ursprüngliche Nachricht- Von: gert vonck [mailto:[EMAIL PROTECTED] Gesendet: Montag, 24. März 2003 00:28 An: [EMAIL PROTECTED] Betreff: [PHP-DB] when click on button, how renew info on page? hello everyone, with this code, a table is loaded with info from the mysql db with id = '1'. but now i want to make a button, and when it is clicked, he has to renew the table with the info from the db with id ='2' does anyone know has this should be done? thanks in advance! Greetings, Gert Vonck Info_DJ \n"; $field_count = mysql_num_fields($result0); while ($get_info0 = mysql_fetch_row($result0)) { print ""; for($i = 0; $i < $field_count - 1 ; $i++){ $value = $get_info0[$i]; $column = mysql_field_name($result0,$i); print "\t$column$value\n"; } $last = $field_count - 1; print "\n"; } print "\n"; mysql_close(); ?> _ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php