On Thursday 16 May 2002 07:40, John Hughes wrote:
> I need to rebuild a PHP-mySQL site that has an extensive table
> structure. Is there a way to DROP all tables that start with a
> certain prefix?
If you have access to the server running mysql then you could try deleting the
actual files holdin
if it's only a one-off thing, you could use php to get all table names
(mysql_list_tables) and then go thru and create an array of the names that
match your criteria, then go thru that array and DROP each one progressivly.
HTH
Beau
// -Original Message-
// From: John Hughes [mailto:[EMA
Hi,
you can collect the form content in to one Formated String and send mail to
the admin with help of mail() function available in php
http://www.php.net/manual/en/function.mail.php
Hope this will help you. If not do feel free to getback.
Thanks
Vinod
--
Vinod Palan A
Calypso Technology, Inc.
Hi,
I Think most of people put connection object in separate file and include
the file when ever need.
And in that connection file I open the connection and its available thought
the file.
Thanks
Vinod
--
Vinod Palan A
Calypso Technology, Inc.
[EMAIL PROTECTED]
(415) 817-2463 Phone
<[EMAIL PRO
I need to rebuild a PHP-mySQL site that has an extensive table
structure. Is there a way to DROP all tables that start with a
certain prefix?
__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
--
PHP Database Mailing L
So I can retrieve it in 4k pieces? That's cool. Thanks!
<>< Ryan
-Original Message-
From: Frank M. Kromann [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 4:37 PM
To: Ryan Jameson (USA)
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Text Field in SQL Server
You can actually contro
You can actually control this on the fly.
odbc_binmode($iRecordSet, 2);
odbc_longreadlen($iRecordSet, 4096);
$str = "";
while ($temp = odbc_result($iRecordSet, "COLUMN_NAME"))
$str .= $temp;
This will set the block size to 4k and when you fetch data until the entire column has
ben fetc
BTW:
0 wasn't the right answer, but I get by with 10. :-)
-Original Message-
From: Ryan Jameson (USA)
Sent: Wednesday, May 15, 2002 4:27 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Text Field in SQL Server
I got it:
In php.ini there is a setting for ODBC called "odbc.defaultl
I got it:
In php.ini there is a setting for ODBC called "odbc.defaultlrl", if you change it to 0
it will hand over everything.
<>< Ryan
-Original Message-
From: Ryan Jameson (USA)
Sent: Wednesday, May 15, 2002 4:17 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Text Field in SQL Server
When I make a field of Text type (MS SQL Server) and attempt to retrieve it from the
database using PHP ODBC I don't get the whole thing. Anyone have any ideas?
Thanks.
<>< Ryan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
huh.. seems to work, now.
I do the following:
session_start();
session_register("form_data");
if($doAction) {
switch($doAction) {
case "Save Information":
// save data in cookies
$HTTP_SESSION_VARS['form_data'] =
array($name,$employer,$e
i would consider trying changing the variable names - so the field on the
form would be called "address", therefore the variable passed through would
be $address, and then have the session variable called "sess_address" or
something like that, and then do
$HTTP_SESSION_VARS['sess_address']=$ad
This is freaky.
If I change the I can see the e_address coming in
correctly, but it gets changed back to old value -- by the
session_register('e_address')??
should I have something along the line of
if(!$e_address) register_session('e_address');
???
On Wednesday, May 15, 2002, at 09:
I believe you.. I added
$HTTP_SESSION_VARS['e_address'] = $e_address;
in my process form code and it's still not updating the var.
snippit from select_class.php where I have reference to $e_address:
session_register("e_address");
...
switch($doAction) {
You need to look up $HTTP_SESSION_VARS['name'] - that's how to change the
variables when they are already set..
i think most people have this problem when they first use sessions!
-Original Message-
From: Terry Romine [mailto:[EMAIL PROTECTED]]
Sent: 15 May 2002 15:49
To: [EMAIL PROT
First, forgive me if this seems to be cross post -- but it does involve
both PHP and MySQL.
My client requirements are:
From their website, they display a list of classes. On registering for a
class, the user is sent to a secure page that is hosted on a different
secured server that does not
Are you using odbc_free_result before odbc_close? The documentation doesn't do it
justice. For SQL server it seems to be the only way to release the connection.
<>< Ryan
-Original Message-
From: Andrew Rall [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 3:40 AM
To: [EMAIL PROT
We need more of your code, as far as I can tell the variables $verify, and
$first_reject don't exist and since they don't it doesn't matter which button is
selected the value is blank.
Radio buttons are a little odd... in this case depending on which is selected it will
either assign $verify
Hi everyone,
I have two radio buttons. Depending on what the users choose I will run an
update statement.
The field that needs to be update are
code_source and verify if radio button 1 is selected
ELSE
UPDATE
reason_rejected and first_reject if radio button 2 is selected
this my two buttons
Appro
I'm having a slight problem closing ODBC connections to my MSSQL7 server. My
configuration is as follows
Web server
---
Redhat Linux 7.3
Apache-1.3.23-11
PHP-4.1.2-7
FreeTDS-0.53-1
unixODBC-2.2.0-5
SQL Server
---
NT4.0+SP6a
MS-SQL7.0+SP3
odbc_close($conid
20 matches
Mail list logo