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
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
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
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
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
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
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) {
This is freaky.
If I change the form method='get' 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,
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
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'] =
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
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
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
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
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 control
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
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
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.
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
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 holding
20 matches
Mail list logo