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:
?php
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 = contents of database.sql ; (where the contents of
the sql file was pasted into the query)
then $results = mysql_db_query(database,
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
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 ) {
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 = contents of database.sql ; (where the
contents
of
the sql file was pasted into the query)
then $results =
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 SELECT SIZE='5' NAME='edit_company_id'\n\tOPTION
VALUE=''\n;
while ( $row
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
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
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
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
16 matches
Mail list logo