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
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
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
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 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" ) {
$
> 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
he
> 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') = "mo
> 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", $que
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) )
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
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
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
$
> 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 y
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://w
> 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
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)){
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
17 matches
Mail list logo