[PHP-DB] Check for SNMP device down

2003-09-12 Thread Balaji H. Kasal

Hi,

   I am running SNMP queries using PHP through browser. 
I am successfully able to run SNMPGET, SNMPWALK etc when able to talk with 
particular device or host. But Whenever not able to talk (may be bec' 
device is down, link is down etc.) SNMP (from localhost) gives No 
responce from the host as error message. 

   I am not able to report this error message, as it is local error 
message. Is there any otherway or any modification needs to be done?

Thanks in advance!

-- 
Regards,
--Balaji

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] Check for SNMP device down

2003-09-12 Thread Balaji H. Kasal

Hi,

   I am running SNMP queries using PHP through browser. 
I am successfully able to run SNMPGET, SNMPWALK etc when able to talk with 
particular device or host. But Whenever not able to talk (may be bec' 
device is down, link is down etc.) SNMP (from localhost) gives No 
responce from the host as error message. 

   I am not able to report this error message, as it is local error 
message. Is there any otherway or any modification needs to be done?

Thanks in advance!

-- 
Regards,
--Balaji

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] Whios request record in database

2003-09-12 Thread IS
I want to record the whois requests people do, not the whois output, in
a MySQL database. 

The following code I'm playing with, but it doesn't write anything to my
table. What's wrong?

?php
 if(!$name)
 {
  print(form name=\\ action=\$PHP_SELF\ method=\post\
  input type=\text\ name=\name\
  input type=\submit\ name=\name\
  /form);
  $db_name='dbname';
  $db_user='username';
  $db_password='password';
  $table='tablename';
  // Connect to the database
  $db_conn = mysql_connect(localhost,$db_user,$db_password);
  if (!$db_conn)
  {
   die (ERROR: Cannot connect to the database.);
   //exit();
  }
  $ip = $REMOTE_ADDR;
  $insert=select * from $table;
  $db_query=mysql_db_query($db_name,$insert);
  if($name)
  {
   if($dbquery)
   { print(Done.);
   }
   else
   { print(Didn't work.);
   }
  }
 }
?

--IS

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP-DB] Whios request record in database

2003-09-12 Thread Jacob A. van Zanen
In order to insert data into database you'll need an insert statement
I only see select * from $table


Jack



-Original Message-
From: IS [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 12, 2003 1:32 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Whios request record in database


I want to record the whois requests people do, not the whois output, in
a MySQL database. 

The following code I'm playing with, but it doesn't write anything to my
table. What's wrong?

?php
 if(!$name)
 {
  print(form name=\\ action=\$PHP_SELF\ method=\post\
  input type=\text\ name=\name\
  input type=\submit\ name=\name\
  /form);
  $db_name='dbname';
  $db_user='username';
  $db_password='password';
  $table='tablename';
  // Connect to the database
  $db_conn = mysql_connect(localhost,$db_user,$db_password);
  if (!$db_conn)
  {
   die (ERROR: Cannot connect to the database.);
   //exit();
  }
  $ip = $REMOTE_ADDR;
  $insert=select * from $table;
  $db_query=mysql_db_query($db_name,$insert);
  if($name)
  {
   if($dbquery)
   { print(Done.);
   }
   else
   { print(Didn't work.);
   }
  }
 }
?

--IS

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] UPDATE Query

2003-09-12 Thread Shaun
Hi,

I have (amogst others) three tables in my database named Bookings, User, and
Representative. A User and a Representative are different types of user,
however I now want to merge these tables into one - User. When a Booking is
made, the User_ID and the Rep_ID are stored in the Booking table. I have now
merged the two tables (User and Representative), how can I update the Rep_ID
column in Bookings so that it refers to the User_ID for each Representative
in the User table?

Thanks for your help

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] Re: PHP connection to remote Access database on NT

2003-09-12 Thread Robert Twitty
You cannot use FreeTDS to connect to an Access database.  You also cannot
use odbc on Linux either.  The only way to connect to an Access database
from Linux is with something like EasySoft's ODBC-ODBC bridge or ODBTP.

-- bob

On Thu, 11 Sep 2003, nabil wrote:

 Yes , and I done myself to mssql on windows from linux/apache

 you have to use odbc .. use FreeTDS , it is free and open soured... and work
 like a charm

 Nabil


 John Almberg [EMAIL PROTECTED] wrote in message
 news:[EMAIL PROTECTED]
  Here's a question I hoped I'd never have to ask...
 
  Is it possible for PHP, running on a Linux/Apache webserver, to connect
  to an Access database running on a remote NT box? The NT box is a back
  office server behind a firewall.
 
  In a nutshell, the customer wants his website to be able to record
  on-line sales in his Access-based Point of Sale system. The POS system
  will be running simultaneously.
 
  I haven't done much work with Access, but my impression is that it locks
  tables and there might be some difficulties sharing write access to the
  data, but I could be wrong about this.
 
  Is there any way Access can be stretched to do this kind of thing?
 
  Thanks.
 
  -- John

 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] tutorial

2003-09-12 Thread NOVIANTO DWIATMOJO
Hi everyone

i'm a newbie in php, mysql and linux but i want to learn about it can you 
guys help me or give me referal to any tutorial links.
thank you for your kindness.

thanks :P

sorry for my english :- [
_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* 
http://join.msn.com/?page=features/junkmail

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Re: [PHP-DB] Re: PHP connection to remote Access database on NT

2003-09-12 Thread Mark

--- Robert Twitty [EMAIL PROTECTED] wrote:
 You cannot use FreeTDS to connect to an Access database.  You also
 cannot
 use odbc on Linux either.  The only way to connect to an Access
 database
 from Linux is with something like EasySoft's ODBC-ODBC bridge or
 ODBTP.

or iodbc (http://www.iodbc.org/)

 
 -- bob
 
 On Thu, 11 Sep 2003, nabil wrote:
 
  Yes , and I done myself to mssql on windows from linux/apache
 
  you have to use odbc .. use FreeTDS , it is free and open
 soured... and work
  like a charm
 
  Nabil
 
 
  John Almberg [EMAIL PROTECTED] wrote in message
  news:[EMAIL PROTECTED]
   Here's a question I hoped I'd never have to ask...
  
   Is it possible for PHP, running on a Linux/Apache webserver, to
 connect
   to an Access database running on a remote NT box? The NT box is
 a back
   office server behind a firewall.
  
   In a nutshell, the customer wants his website to be able to
 record
   on-line sales in his Access-based Point of Sale system. The POS
 system
   will be running simultaneously.
  
   I haven't done much work with Access, but my impression is that
 it locks
   tables and there might be some difficulties sharing write
 access to the
   data, but I could be wrong about this.
  
   Is there any way Access can be stretched to do this kind of
 thing?
  
   Thanks.
  
   -- John
 
  --
  PHP Database Mailing List (http://www.php.net/)
  To unsubscribe, visit: http://www.php.net/unsub.php
 
 
 
 -- 
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 


=
Mark Weinstock
[EMAIL PROTECTED]
***
You can't demand something as a right unless you are willing to fight to death to 
defend everyone else's right to the same thing.
***

__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] Whios request record in database

2003-09-12 Thread jeffrey_n_Dyke

couple possible problems.
1. register globals being off and you're using variables like $name instead
of $_POST['name'].
2.  you're not asking that anything be written to the database, only
selecting
  $insert=select * from $table;
  $db_query=mysql_db_query($db_name,$insert);

3. you're cheking if $name exists in the same code block that you've only
entered if $name does NOT exist.  you have some overlapping/unlclosed if
brackets

hth
Jeff



   
 
  IS 
 
  [EMAIL PROTECTED]To:   [EMAIL PROTECTED] 

   cc: 
 
  09/12/2003 07:31 Subject:  [PHP-DB] Whios request record 
in database  
  AM   
 
   
 
   
 




I want to record the whois requests people do, not the whois output, in
a MySQL database.

The following code I'm playing with, but it doesn't write anything to my
table. What's wrong?

?php
 if(!$name)
 {
  print(form name=\\ action=\$PHP_SELF\ method=\post\
  input type=\text\ name=\name\
  input type=\submit\ name=\name\
  /form);
  $db_name='dbname';
  $db_user='username';
  $db_password='password';
  $table='tablename';
  // Connect to the database
  $db_conn = mysql_connect(localhost,$db_user,$db_password);
  if (!$db_conn)
  {
   die (ERROR: Cannot connect to the database.);
   //exit();
  }
  $ip = $REMOTE_ADDR;
  $insert=select * from $table;
  $db_query=mysql_db_query($db_name,$insert);
  if($name)
  {
   if($dbquery)
   { print(Done.);
   }
   else
   { print(Didn't work.);
   }
  }
 }
?

--IS

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] best upload method

2003-09-12 Thread David Smith
 which is the best upload file method ?
 file uploads or FTP commands from PHP

Now that's the most open ended question I've read all day. Here, flip a
coin. If it falls heads, FTP. If it falls tails, the other one. Even
still, I'm not sure I understand the question: File uploads or FTP command
from PHP? One of your options is just the question restated...

Regardless and all sarcasm aside, this question depends seriously on the
application.

:)

--Dave

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] Connect to Oracle DB

2003-09-12 Thread Frederico Madeia
Dear friends,

How i connect one server running PHP(linux) to other server running
Oracle(linux) ??
when i tryed to connect with ora_logon, the server return me: Call to
undefined function: ora_logon().

In php.net describe some functions to connect to oracle,. but how i make
to do work ???
I must install oracle on same server that runing php ??

Tanks.

-- 
Frederico Madeira
Coordenador de Suporte
N. Landim Comrcio Ltda
PABX: 81. 3497.3029
e-mail: [EMAIL PROTECTED]


Re: [PHP-DB] Connect to Oracle DB

2003-09-12 Thread Martin Marques
El Vie 12 Sep 2003 15:52, Frederico Madeia escribi:
 Dear friends,

 How i connect one server running PHP(linux) to other server running
 Oracle(linux) ??
 when i tryed to connect with ora_logon, the server return me: Call to
 undefined function: ora_logon().

 In php.net describe some functions to connect to oracle,. but how i make
 to do work ???
 I must install oracle on same server that runing php ??

1) Oracle and PHP can be on different servers (in some cases it's better to 
have them separeted).
2) they don't even have to be on the same OS, even though it's a good idea.
3) Your erro is due to the fact that you don't have an oracle-featured PHP 
installed, so you have to recompile PHP with the --with-oracle option, or try 
to get a shared library for oracle support for your PHP version.

-- 
Porqu usar una base de datos relacional cualquiera,
si pods usar PostgreSQL?
-
Martn Marqus  |[EMAIL PROTECTED]
Programador, Administrador, DBA |   Centro de Telematica
   Universidad Nacional
del Litoral
-

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] Connect to Oracle DB

2003-09-12 Thread Frederico Madeia
Martin,

In some doc that i've read when i compile the php i must put yhe
$ORACEL_HOME path, so if oracle isn't instaled on same machine ???

-- 

Frederico Madeira
Coordenador de Suporte
N. Landim Comrcio Ltda
PABX: 81. 3497.3029
e-mail: [EMAIL PROTECTED]


Em Sex, 2003-09-12 s 13:15, Martin Marques escreveu:

 El Vie 12 Sep 2003 15:52, Frederico Madeia escribi:
  Dear friends,
 
  How i connect one server running PHP(linux) to other server running
  Oracle(linux) ??
  when i tryed to connect with ora_logon, the server return me: Call to
  undefined function: ora_logon().
 
  In php.net describe some functions to connect to oracle,. but how i make
  to do work ???
  I must install oracle on same server that runing php ??
 
 1) Oracle and PHP can be on different servers (in some cases it's better to 
 have them separeted).
 2) they don't even have to be on the same OS, even though it's a good idea.
 3) Your erro is due to the fact that you don't have an oracle-featured PHP 
 installed, so you have to recompile PHP with the --with-oracle option, or try 
 to get a shared library for oracle support for your PHP version.




Re: [PHP-DB] best upload method

2003-09-12 Thread open-mind
Sorry but I didn't know which is the name of the first method
I will rephrase
which is the best method to upload a file to server ??

this:
//
$result =
move_uploaded_file($HTTP_POST_FILES['img_6'][tmp_name],dir/filename.jpg)
;
$result = $result ? OK:NOT OK;
print $result;


or ... this:
/
$conn_id = ftp_connect($ftp_server);
$upload = ftp_put($conn_id, $destination_file, $source_file,
FTP_BINARY);
ftp_quit($conn_id);


how depends on the application ?

- Original Message -
From: David Smith [EMAIL PROTECTED]
To: open-mind [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, September 12, 2003 9:04 PM
Subject: Re: [PHP-DB] best upload method


  which is the best upload file method ?
  file uploads or FTP commands from PHP

 Now that's the most open ended question I've read all day. Here, flip a
 coin. If it falls heads, FTP. If it falls tails, the other one. Even
 still, I'm not sure I understand the question: File uploads or FTP command
 from PHP? One of your options is just the question restated...

 Regardless and all sarcasm aside, this question depends seriously on the
 application.

 :)

 --Dave



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php