Saqib Ali wrote:
Hello All,
What are best practices for deleting records in a DB. We need the
ability to restore the records.
Two obvious choices are:
1) Flag them deleted or undeleted
2) Move the deleted records to seperate table for deleted records.
We have a complex schema. However the
Hello,
A while back I posted a question in relation to XSL namespaces and
callbacks, but never got a response, not even a flame, which I found a
bit odd for this list. :P I know this is pretty cutting-edge for PHP
since the XSL library has only been used in PHP 5, well, except for the
On 8/11/05, Leon Vismer [EMAIL PROTECTED] wrote:
Hi Robin
Many thanks for this,
how would one extend this to support the following:
$str = insert into userComment (userID, userName, userSurname) values (0,
'Leon', 'mcDonald');
one does not want
$str = insert into user_comment
hi, i have a big php script with alot of db inserts and updates, what i
want to do it's to log all this db commands into a table. I was wonderig
if there is a better way to do this than the insert into logs_table the
actual queryes.
ty
signature.asc
Description: OpenPGP digital signature
FSA wrote:
hi, i have a big php script with alot of db inserts and updates, what i
want to do it's to log all this db commands into a table. I was wonderig
if there is a better way to do this than the insert into logs_table the
actual queryes.
ty
Depending the amount of queries and the
Torgny Bjers wrote:
FSA wrote:
hi, i have a big php script with alot of db inserts and updates, what i
want to do it's to log all this db commands into a table. I was wonderig
if there is a better way to do this than the insert into logs_table the
actual queryes.
ty
Depending the amount of
this is a local script with a medium amount of data to log i just
thaught it's a litle barbarian :) to actualy do inserts in the log
table for all queryes. That's why i thaught maibe there is a simple more
reliable way.
Torgny Bjers wrote:
FSA wrote:
hi, i have a big php script with alot of db
[snip]
hi, i have a big php script with alot of db inserts and updates, what i
want to do it's to log all this db commands into a table. I was wonderig
if there is a better way to do this than the insert into logs_table the
actual queryes.
[/snip]
Don't forget, your database may be keeping logs
Hello,
I'm curious to know if there is a php command that can get the IP of the
server it's running on. I could always do this...
$results = exec(/sbin/ifconfig ethernet device | grep broadcast | awk
'{print $2}', $value);
but I would prefer to not have to use system commands for this.
Would
[snip]
I'm curious to know if there is a php command that can get the IP of the
server it's running on. I could always do this...
$results = exec(/sbin/ifconfig ethernet device | grep broadcast | awk
'{print $2}', $value);
but I would prefer to not have to use system commands for this.
Would
Tom Cruickshank wrote:
Hello,
I'm curious to know if there is a php command that can get the IP of the
server it's running on. I could always do this...
$results = exec(/sbin/ifconfig ethernet device | grep broadcast | awk
'{print $2}', $value);
but I would prefer to not have to use
Tom Cruickshank wrote:
Hello,
I'm curious to know if there is a php command that can get the IP of the
server it's running on. I could always do this...
$results = exec(/sbin/ifconfig ethernet device | grep broadcast | awk
'{print $2}', $value);
but I would prefer to not have to use system
Thanks for all the info guys!
Apparantly I'm still not quite awake yet.
Tom
On 8/12/05, John Nichel [EMAIL PROTECTED] wrote:
Tom Cruickshank wrote:
Hello,
I'm curious to know if there is a php command that can get the IP of the
server it's running on. I could always do this...
On Thu, Aug 11, 2005 at 02:39:57PM +0100 or thereabouts, I. Gray wrote:
Hi.
I'd like to find or write a script that I can run every so often (hourly
for example) from cron that will check my pop3 mailboxes for any emails
with SPAM in the subject line and either delete them or
Ted Passey wrote:
Jochem,
Thanks for your help...I can see your a great PHP programmer.
flattery gets you everywhere - even if it isn't true.
I'm not that bad - but lets leave the 'great' for those that really are -
you know people who develop/invent the actual language - people who
write
I made a left frame, then made the three pages, and all the frames show
fine. But this is not my problem! I made a leftpane which has code to
check if user exists (its for a login script). In the code for the login
FORM I set it to go directly to the userpane file. It works fine! It
recognizes
Some years ago i did this with ASP and a VB activex component i belive you
can access a Activex from php.
Angelo
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: php-general@lists.php.net
Sent: Friday, August 12, 2005 2:24 AM
Subject: Re: [PHP]
Saqib Ali wrote:
Hello All,
What are best practices for deleting records in a DB. We need the
ability to restore the records.
Two obvious choices are:
1) Flag them deleted or undeleted
2) Move the deleted records to seperate table for deleted records.
We have a complex schema. However the
Is this something you're looking for?
http://www.phpfreaks.com/scripts/User_Authentication/16.php
Thanks, if i try one, i let you now
Saludos!
xfedex
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Some years ago i did this with ASP and a VB activex component i belive you
can access a Activex from php.
Angelo
Maybe, but i prefer to get away as much i can from Activex.just to
think about it makes me shiver =P
Saludos!
xfedex
--
PHP General Mailing List (http://www.php.net/)
To
How would I organize this block in order to convert it into an array
for my form field names.
For instance if my field has:
pHome Phone Number:/p input maxlength=6 size=6
name=area_code id=area_code value={$_POST['area_code']} nbsp;
input maxlength=6 size=6
Your message dated Fri, 12 Aug 2005 16:07:30 -0400 with subject Returned
mail: Data format error has been submitted to the moderator of the LLTI
list: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hello Bruce,
Friday, August 12, 2005, 1:39:54 PM, you wrote:
I believe this can be done with an array.
any assistance is greatly appreciated!
I've been working on a validation function for quite a while now that
does what you're asking. I keep adding to it as I run across stuff I
didn't need
Hello,
I have problem 'cannot load mysql' with MySQL on PHP5( recently migrating grom
PHP4 to PHP5).
I was do the following actions to resolve the problem, but failed .
1. uncommented extension=php_mysql.dll
2. put php_mysql.dll on c:/php/ext
3. put libmysql.dll both on c:/winnt and
I apology for mysql question posted here, but, as I said once, I like
you guys more! :)
have two tables: orders and special_orders. foreign key is trans_no.
I can't figure it out how to create a query that pulls orders from the
orders tables that are NOT in special_orders table?
Thanks for
First I'll appologize for the cheuvanistic remark the other poster had. I
know he had good intentions...
So I don't know smarty, but it seems to me you're grabbing only one row
here:
$projects = $db-getAssoc()
Normally in straight PHP, I would do something like.
While ($row =
I apology for mysql question posted here, but, as I said once, I like you
guys more! :)
have two tables: orders and special_orders. foreign key is trans_no.
I can't figure it out how to create a query that pulls orders from the
orders tables that are NOT in special_orders table?
I can never
George B wrote:
I made a left frame, then made the three pages, and all the frames show
fine. But this is not my problem! I made a leftpane which has code to
check if user exists (its for a login script). In the code for the login
FORM I set it to go directly to the userpane file. It works
I tried this one:
SELECT trans_no
FROM orders
WHERE trans_no IN (
SELECT trans_no
FROM special_orders )
but gives me an error:
You have an error in your SQL syntax. Check the manual that corresponds
to your MySQL server version for the right syntax to use near 'SELECT
trans_no FROM
Hi, folks. I'm running into an incredibly bizarre problem with a
header() redirect of which I cannot see the cause.
We have a CMS here where I work, in two separate production and training
environments.
Last night I implemented a new events manager module, copying all
necessary files from
[EMAIL PROTECTED] wrote:
I apology for mysql question posted here, but, as I said once, I like
you guys more! :)
I like my wife more than I like the people on these lists, but I don't
go asking her my MySQL questions. I go to the MySQL list for that.
What you like doesn't make your post any
don't get this one:
from mysql.com:
SELECT s1 FROM t1 WHERE s1 NOT IN (SELECT s1 FROM t2);
my query:
select trans_no from orders where trans_no not in (select trans_no from
special_orders);
and I'm getting an error:
You have an error in your SQL syntax. Check the manual that corresponds
ok. accept critique. :(
@moderator: please take my mysql questions off the php list.
I apology to everybody for any inconviniance.
-afan
John Nichel wrote:
[EMAIL PROTECTED] wrote:
I apology for mysql question posted here, but, as I said once, I like
you guys more! :)
I like my wife
[EMAIL PROTECTED] wrote:
I tried this one:
SELECT trans_no
FROM orders
WHERE trans_no IN (
SELECT trans_no
FROM special_orders )
but gives me an error:
You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near
take what other say with a grain of salt.. im sure you're using php to
pull info from mysql anyway..
the fact is without mysql php would be nowhere where it is today.. its
like peanut butter w/o the jelly..
see my reply in the other email.. im sure it will work for you.
[EMAIL PROTECTED]
Pablo Gosse wrote:
[snip]
$conn-Execute(delete from cms_events where e_id = {$fd['e_id']}) or
$this-CMS_error(2,$this-mod_name,$query,$conn-ErrorMsg());
header(Location:{$this-CMS_base_path}mods/events_manager/cms.events_ma
nager.dsp.php);
[snip]
Can anyone think of any reason
hello,
sorry in advance if my question is naive.. i'm trying to allow file
uploads. optimally i'd like to store these files (jpgs, mostly) directly to
a folder in my httpdocs.. i've heard something about file uploads not being
allowed if server is set to safemode.. not sure why but i've been
Pablo Gosse wrote:
Can anyone think of any reason why the above code, just those two lines,
would redirect correctly in one environment, yet simply redirect to the
currently existing page in another?
I can think of a few, and my first instinct is to check to see whether
your script produces
I am having an issue with building dynamic checkboxes.. They appeared to be
working properly...but then all the checkboxes in the array are checking
ater the initial checkbox is selected.
I am building a sticky form to present the data. so anything checked in the
HTML would be dynamically checked
Sebastian wrote:
take what other say with a grain of salt.. im sure you're using php to
pull info from mysql anyway..
And he might be using Apache on Linux like the majority of PHP users.
More than likely outputting some HTML and maybe some JavaScript.
Probably using a PC too. So what?
Hai all,
This is naha, I am very new to PHP as well as this group, I am in need of
your guidence all my way.
Now I am doing a project using PHP, in that I created a form.
That form has a field called e-mailid, to validate that I need a script
(function), whether I have to write it in the
Nahalingam Kanakavel wrote:
Now I am doing a project using PHP, in that I created a form.
That form has a field called e-mailid, to validate that I need a script
(function), whether I have to write it in the server side or client side,
which one is better?. I need your suggestions, If any
42 matches
Mail list logo
