Re: [PHP-DB] Forms : Validating user input is integer

2001-04-05 Thread boclair
Thanks Steve, It is not my choice re javascript in this case I have tried to use the functions is_int($input_var) and is_integer($input_var) and the !versions as you suggest but with failures. Example 1_ if ((@!$submit) || (!is_int($input_var)) ) { echo "error"; include

[PHP-DB] display formatting with a while loop

2001-04-05 Thread olinux
hey all, well, i dont know that a while loop will be my solution, i think that it may. What i would like to do is to display 4 variables and then create another column. the toughy is that i an using a series of IF'f inside the while. So something like this: while ($1 4) { if ($var1 == 1)

[PHP-DB] ODBC again

2001-04-05 Thread Fernando Buitrago
My code is: $conn = odbc_connect("encuneweb","",""); $result1 = odbc_prepare($conn, "SELECT * FROM PERSONAS WHERE email = '$v_mail')"; if (!odbc_execute($result1)) echo "nuevo usuario"; $insertar_persona = "INSERT INTO Personas (Nombre, Apellido1, Apellido2, mail, telefono1)

Re: [PHP-DB] display formatting with a while loop

2001-04-05 Thread olinux
what if i put the if statements inside of another if statement and then set the $i back to 1. if ($1 = 4) { $display .= "/tdtd"; $i = 1; } how exactly would i do this, or is it totally wrong? olinux - Original Message - From: "olinux" [EMAIL PROTECTED] To: "PHP-DB" [EMAIL

[PHP-DB] Problem with frames

2001-04-05 Thread Bartek Pawlik
Hi! I have a following problem: I have a script in PHP, say "script1.php", there is a form and submit button. What I want is, after pressing the button, I want to load 2 frames in one window, but (MOST IMPORTANT), I want to pass all variables from form to BOTH frames at once. Please help,

Re: [PHP-DB] Problem with frames

2001-04-05 Thread olinux
Use sessions begin script2.php - the form processor like this session_start(); session_register('variable'); session_register('another_variable'); $variable = $valueyouwanttostore; $another_variable = $anothervaluetostore; just register any variable name, notice, there is no "$" when

RE: [PHP-DB] ODBC again

2001-04-05 Thread richarda
BDY.RTF -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] ODBC again

2001-04-05 Thread Daevid Vincent
shouldn't that be: $result1 = odbc_prepare($conn, "SELECT * FROM PERSONAS WHERE email = '$v_mail'"); you have your double quotes at the end in the wrong place. they should be before the ") not after )" daevid.com -Original Message- From: Fernando Buitrago [mailto:[EMAIL PROTECTED]]

Re: [PHP-DB] SELECT statement

2001-04-05 Thread Jeffrey A Schoolcraft
* Julio Cuz, Jr. ([EMAIL PROTECTED]) wrote: Ron, Thanks for your help, but my problem still there even when I made the following changes: $sql = "SELECT * FROM \"Remodel\" WHERE Email=\"".$find."\""; You don't have to quote the table name either. You can probably get away with

Re: [PHP-DB] Forms : Validating user input is integer

2001-04-05 Thread boclair
- Original Message - From: Matt Williams [EMAIL PROTECTED] To: boclair [EMAIL PROTECTED] Sent: Thursday, April 05, 2001 9:03 PM Subject: RE: [PHP-DB] Forms : Validating user input is integer To gain the full benefit of your suggestion I find that I can validate for a wrong entry

RE: [PHP-DB] Microsoft Access DB PHP

2001-04-05 Thread Andrew Hill
James, Sure - just connect via ODBC and use the odbc_functions in PHP. Best regards, Andrew -- Andrew Hill - OpenLink Software Director Technology Evangelism Universal Data Access Integration http://www.openlinksw.com -Original Message- From:

RE: Re: [PHP-DB] HELP URGENT

2001-04-05 Thread richarda
BDY.RTF -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Re: INFORMIX INFO PROBLEM (Fwd)

2001-04-05 Thread Misterio X . - Anonymo
Two system tables, SYSTABLES and SYSCOLUMNS contain the information you want. Just select it out with an ordinary select statement. "select * from systables". -- mail.pt - Um mail para todos - em http://mail.pt/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

Re: [PHP-DB] Forms : Validating user input is integer

2001-04-05 Thread Boclair
"boclair" [EMAIL PROTECTED] wrote in message 004801c0bdc7$13afbe00$[EMAIL PROTECTED]">news:004801c0bdc7$13afbe00$[EMAIL PROTECTED]... | | - Original Message - | From: Matt Williams [EMAIL PROTECTED] | To: boclair [EMAIL PROTECTED] | Sent: Thursday, April 05, 2001 9:03 PM | Subject: RE:

Re: [PHP-DB] Oracle vs MS SQL vs MySQL

2001-04-05 Thread Misterio X . - Anonymo
JUST STAY AWAY FROM INFORMIX!!! I've a very good experience with Oracle and Mysql... -- mail.pt - Um mail para todos - em http://mail.pt/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact

RE: [PHP-DB] Forms : Validating user input is integer

2001-04-05 Thread Matt Williams
or even just elseif (!eregi("[^a-zA-Z]"),$num)) { } But that would not stop other characters. M@ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail:

RE: [PHP-DB] Microsoft Access DB PHP

2001-04-05 Thread James Kneebone
I should have classified it a bit more. The server is currently Unix but I have an option (one that I don't really want to take) of having the whole website, etc being moved to one of the NT servers. I read something about iODBC or something like that, but I'm not too familiar on that topic. I

[PHP-DB] odbc_exec and error handling in transact sql

2001-04-05 Thread Ilse
Hello, I have a problem with odbc_exec in combination with error handling in my stored procedure on sql server7. When an error in the stored procedure occurs, the procedure finishes with no problems but the return value of the odbc_exec function is false. The problem with this false return

Re: [PHP-DB] Forms : Validating user input is integer

2001-04-05 Thread Boclair
"Matt Williams" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... | | or even just | elseif (!eregi("[^a-zA-Z]"),$num)) { } | | But that would not stop other characters. | | M@ Whoops! Careless of me. The line should read, and as I tested it, elseif

Fw: [PHP-DB] Prob with Ingres II (apache DSO) - repost

2001-04-05 Thread systems
I'm trying to create a 'libphp4.so', including Ingres support (-with-ingres= ), and everything on the PHP side seemed to go ok - no errors in the make. But an ./apachectl configtest gives this: Syntax error on line 205 of .. httpd.conf Cannot load ... libphp4.so into server:

RE: [PHP-DB] Forms : Validating user input is integer

2001-04-05 Thread Matt Williams
Whoops! Careless of me. The line should read, and as I tested it, elseif (eregi("[a-zA-Z]",$num)) { } Do you see any problem with this? Yes, same thing it will accept other character like !*- etc... try if(!eregi("^[0-9]+[0-9]*$",$num) { //error } M@ -- PHP Database

Re: [PHP-DB] odbc_exec and error handling in transact sql

2001-04-05 Thread Renze Munnik
Ilse wrote: Hello, I have a problem with odbc_exec in combination with error handling in my stored procedure on sql server7. When an error in the stored procedure occurs, the procedure finishes with no problems but the return value of the odbc_exec function is false. The problem with

Re: [PHP-DB] odbc_exec and error handling in transact sql

2001-04-05 Thread Ilse
Hallo Renze, Bedankt voor je reactie. The problem is that the stored procedure in the odbc_exec didn't went wrong. It encountered an error, handled it and finished the final part of the code successfully. Unfortunately, the odbc_exec returns false. The stored procedure has an output parameter

Re: [PHP-DB] passing parameters between forms

2001-04-05 Thread Theo de Jong
with input type=hidden value=$var name=var you can pass variables right through a form . Have to do things differently when working with security issues at hand though. !-- search2.php -- HTML BODY H1This is the Displaying page/H1 ?php if(mem_id)

[PHP-DB] ocibindbyname: ORA-01008: not all variables bound

2001-04-05 Thread Paul Fernandez
Hello, The goal here is to insert a single row, then get a numerical value "id" (generated by the insert trigger) to use in another insert statement. I get, "ORA-01008: not all variables bound" when running this script: ? $query = "insert into table (col1, col2) values ($val1,$val2) returning

Re: [PHP-DB] ocibindbyname: ORA-01008: not all variables bound

2001-04-05 Thread Joe Brown
Don't have a whole lot of practice with the OCIBindByName function, but I seem to be having success within a recursive select statement. I'm not useing the operator in my implementation. Don't know if that's a good or a bad thing (yet), but it seems to be functioning properly. The third

Re: [PHP-DB] ocibindbyname: ORA-01008: not all variables bound

2001-04-05 Thread Thies C. Arntzen
On Thu, Apr 05, 2001 at 12:47:37PM -0400, Joe Brown wrote: Don't have a whole lot of practice with the OCIBindByName function, but I seem to be having success within a recursive select statement. I'm not useing the operator in my implementation. Don't know if that's a good or a bad thing

Re: [PHP-DB] display formatting with a while loop

2001-04-05 Thread Theo de Jong
looks like you could load the desired variables in an array($y,$x) where $y ranges from 0 to 3.. then you could echo the 4 rows walking through array(0,$x), array(1,$x), etc. "olinux" [EMAIL PROTECTED] schrieb in im Newsbeitrag: 000a01c0bdb6$7ec21500$[EMAIL PROTECTED] what if i put the if

RE: [PHP-DB] Fatal error: Call to unsupported or undefined functi on mysql_connect()

2001-04-05 Thread Jason Vance
"Call to undefined function" means it doesn't know the name of the function you are calling. Hi there, i've had this error as well, using Redhat Linux 7.0. For me, i'm using the RPM's to install apache+PHP+MySQL, however, the php-mysql add-on module is unable to recognize the dependant module

[PHP-DB] Is there a way to make the field to show more data that showing part of it?

2001-04-05 Thread Scott Fletcher
Hi! I found an interesting PHP issues here. I use the "odbc_result_all" to display everything in the database on the webpage. I got this instead of what I expect. All datas in the field get cut off when displaying it on the website. The MS-SQL database showed all of the data in that

[PHP-DB] Passing Arrays

2001-04-05 Thread Jordan Elver
Hi, How can I pass an array between two pages. I've tried using serialize and unserialize. But it doen't return an array. When I use gettype() on it, it say's that the typ-e is boolean? Any ideas? Cheers, Jord -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail:

Re: [PHP-DB] mysql_result()

2001-04-05 Thread Jordan Elver
Thanks for everyones help with this one, all suggestions appreciated. Cheers, Jord On Wednesday 04 April 2001 17:06, you wrote: Jordan, If you know your result is going to product one row, try using: $row=mysql_fetch_array($result, MSQL_ASSOC); // returns an assoc array where the field

Re: [PHP-DB] Varible insert

2001-04-05 Thread rjones
Shannon, If your customer can exit out before they have completed all the forms do you want their partial information in your database? If you do not want incomplete records you will want to wait until all fields have been completed before inserting. Look into using sessions to store and pass

Re: [PHP-DB] Passing Arrays

2001-04-05 Thread rjones
Jordan, Look at Implode() and Explode() for string manipulation of arrays. Rich - Original Message - From: "Jordan Elver" [EMAIL PROTECTED] To: "PHP Database Mailing List" [EMAIL PROTECTED]; "PHP General Mailing List" [EMAIL PROTECTED] Sent: Thursday, April 05, 2001 7:56 AM Subject:

[PHP-DB] Protecting files

2001-04-05 Thread Mick Lloyd
Can anyone point me to a tutorial that explains in words of one syllable how to protect files/directories without using .htaccess and .htpasswd. I have log-in screens that search an authorized users database for name, password, level before they can get into the site. But each time someone (ie

Re: [PHP-DB] Forms : Validating user input is integer

2001-04-05 Thread boclair
- Original Message - From: Matt Williams [EMAIL PROTECTED] To: Boclair [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, April 05, 2001 11:28 PM Subject: RE: [PHP-DB] Forms : Validating user input is integer The line should read, and as I tested it, elseif

Re: [PHP-DB] Protecting files

2001-04-05 Thread Ron Brogden
At 03:09 AM 4/5/2001 +0100, Mick Lloyd wrote: But how do I then protect the directories/scripts from anyone wanting to have a look (not that they're worth much!). Create a .htaccess file that contains the following: deny from all Place it in the directories you wish to protect. Next, create

RE: [PHP-DB] Microsoft Access DB PHP

2001-04-05 Thread Fernando Buitrago
Well, PHP has a odbc funcions, all the reference located in www.php.net by the way, ASPEdit 2000 tool has a complete referene about these funcions and PHP, ASP, Perl and others. Try to use this. Is Good. Regards Fernando -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] Protecting files

2001-04-05 Thread Miles Thompson
Mick, Since you have the login screens, etc. already, once a user is authenticated, start a session and register a session variable, using a meaningful value fetched from the database. I use "member_id", but anything will do. At the very top of each page you want to protect, with no spaces

[PHP-DB] Reference

2001-04-05 Thread Fernando Buitrago
I need all the referece Offline Of PHP, where is this?. regards -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Convertion Types

2001-04-05 Thread Fernando Buitrago
Where is the functions referece of convertion types like: isinteger. Regards. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] DIferents types in SQL

2001-04-05 Thread Fernando Buitrago
I need to know if the Query is possible with differents types of fields and variables to insert or update statements. PHP sad me that error parse. Regards. Note: I need the reference of convertions type's funcions. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail:

[PHP-DB] Help! installation class redeclare error vbulletlite

2001-04-05 Thread aaron
I'm usiing vbulletlite version 1.1 on IIS 4.0 w/mysql 3.x I run the install script which creates the database, when I select to continue I receive the error. fatal error: cannot redeclare class db_sql_vb in ./db_mysql.php on line 6 I've tried stopping IIS, mysql, but nothing works. I hope you

Re: [PHP-DB] Forms : Validating user input is integer

2001-04-05 Thread Boclair
"boclair" [EMAIL PROTECTED] wrote in message 002101c0bd8e$30742e60$[EMAIL PROTECTED]">news:002101c0bd8e$30742e60$[EMAIL PROTECTED]... | I have a problem with a user input in a form required to be an | integer, creating a variable for a mysql query. | | I have instances where integer, 0, is being

Re: [PHP-DB] Forms : Validating user input is integer

2001-04-05 Thread Boclair
Ben Udall [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... | boclair wrote: | I have a problem with a user input in a form required to be an | integer, creating a variable for a mysql query. | | I have instances where integer, 0, is being typed as letter,o. |

[PHP-DB] oracle and php

2001-04-05 Thread Novotn Petr
Hi all, I am begginer in using ORACLE 8i DB with PHP, so please, could anybody help me ? When I try to connect or use any OCI or ORA function, it only say me Fatal error: Call to unsupported or undefined function ocilogon() in /home/httpd/html/ora.php3 on line 8 here is the part of code: ?

Re: [PHP-DB] oracle and php

2001-04-05 Thread Vlad
It seems that you must include support of oracle functions (special module) in your configuration file. In windows it is php.ini file. Hi all, I am begginer in using ORACLE 8i DB with PHP, so please, could anybody help me ? When I try to connect or use any OCI or ORA function, it only say me