[PHP-DB] Hello

2001-07-12 Thread a
Hello I have an ibm db2 which has jpg images stored as blob fields (about 2M). I seem to have a hard time getting them with PHP and presenting them properly in the browser. (When I try to save it from the DB2 side, it is stored ok). Though i actually get the image i ask for, when i try to

Re: [PHP-DB] Hello

2001-07-12 Thread a
uot;>news:01c10ae1$30a03690$0201a8c0@c1141975c... > Check out http://www.phpbuilder.com/columns/florian19991014.php3. It > deals with MySQL, but the concepts should be the same... it sounds like > there are some steps about handling the binary data in a binary-safe > fashion t

[PHP-DB] Storing JPEGS in MySQL

2005-02-02 Thread A Wood
I'd be grateful if someone could offer me some guidance on where I'm going wrong here, I'm sure I'm 99% of the way there... I want to read in a JPEG from a file upload form (HTML), resize it and store in in a MySQL DB. Then in another script I want to pull it out of t

[PHP-DB] Do persistent dba_popen connections work ?

2002-01-29 Thread S A
I'm trying to use Berkeley DB db2 files with PHP persistent connection dba_popen. When I try persistent connections with dba_open then sometimes I don't get reads working & I never get insert/replace working. Without persistent connections reading & writing work fine. Has anyone else gotten p

[PHP-DB] Cross DB application

2002-04-15 Thread Arcadius A.
Hello ! I'm planning to write a database application for MySQL, and then port it to PostrgeSQL. Is there any library or class that could help me to write/maintain just one source code for both MySQL and PostgreSQL ? Thanks. ARcadius -- PHP Database Mailing List (http://www.php.net

[PHP-DB] MySQL DB CleanUp Help!

2001-08-22 Thread Arcadius A.
Hello ! I'd like to automatically delete old entries from my MySQL Is there any special funcion in PHP or MySQl for doing that ? For that purpose, I've created a PHP script (form) that delete old entries when I submit a form ... but I'd like the scrip to do the job periodical

[PHP-DB] PHP can connect ONLY to MySQL at LOCALHOST !!!

2001-12-08 Thread Arcadius A.
Hello ! How can I set up PHP so that it can connect to MySQL database on romote hosts ? in mysql_connect("the_remote_hostname" , "username" , "password") , the hostname is ignored PHP just connects to my localhost , not to the_remote_host (I'm using PHP4.06 on FreeBSD with APACHE 1.3) Tha

[PHP-DB] Re: PHP can connect ONLY to MySQL at LOCALHOST !!!

2001-12-08 Thread Arcadius A.
Ah ! I got it ... perhaps , the user has no remote access right to the DB.. Arcad -- 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] PHP sort from .... best solution?

2003-06-06 Thread A. Lyse
Hi! Thanks! But I got a problem with the code: The PHP file as it is with the code pasted into it will i'll past at the end of this post. The problem is I get the error: Warning: Invalid argument supplied for foreach() in /home/amotor/www/list_ingresser_artikler.php on line 43 If I put a

[PHP-DB] PHP sort from a database variable..?

2003-06-04 Thread A. Lyse
Please dont kill me for posting here. I dont know where else to post. I'm a newbie and is completly stuck with a php problem :( I got this code (among with more though...): *** $i1=hentIngresser($nettstedid,38,$sprakid,$offsetannet,$antallmotor); $i2=hentIngresser($netts

Re: [PHP-DB] PHP sort from a database variable..?

2003-06-04 Thread A. Lyse
Hope I did this correctly now :) It is a new, "home made" news - system, only I want some new functions to it. I must make the functions myself then :( Here is the info: Array ( [0] => ingress Object ( [artikkelid] => 241 [nettstedid] => 11

Re: [PHP-DB] PHP sort from a database variable..?

2003-06-04 Thread A. Lyse
I get this error: Fatal error: Call to undefined function: sortclassarray() in /home/amotor/www/list_ingresser_artikler.php on line 25 Regards, A. Lyse -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP sort from a database variable..?

2003-06-04 Thread A. Lyse
This might helt some: The php file: http://www.amotor.no/list_ingresser_artikler.php The ingress.lib file: http://www.amotor.no/ingress.lib The comments might be a bit weird. Its norwegian :( Regards, A. Lyse -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] PHP sort from a database variable..?

2003-06-04 Thread A. Lyse
Here is the php file *** '.$i->overskrift.'   ('.$i->publisert.') '.$i->ingress.' ' ; } } ?> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP sort from a database variable..?

2003-06-04 Thread A. Lyse
Almoust now! Got some (alot of errors) but it sorts correct: (see the errors here) http://www.amotor.no/artikler.php Here is altso the PubSysDB: http://www.amotor.no/pubSysDB.lib Regards, A. Lyse -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] PHP sort from a database variable..?

2003-06-04 Thread A. Lyse
It worked. Thanx! Why is this a bad solution? Will it slow down the feed? Regards, A. Lyse -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP sort from .... best solution?

2003-06-04 Thread A. Lyse
Hi again! I talked to the admin guy and he said there is an easyer way to do this (as usual he doenst have the time to show me) so I try here: He gave me a liddle example in c and a light translation to PHP: Bubble sort (exampel written in c, but can "easyly" be translated to php)

Re: [PHP-DB] PHP sort from .... best solution?

2003-06-08 Thread A. Lyse
Hi again! Is it possibile to only show articles from a sertain month. say I want to show all articles from June 2003 (2003 01/06 - 2003 31/06)... the variable here is "publisert" It should be enough info over to help me :) Regards, A. Lyse "A. Lyse" <[EMAIL PROTECTED]

[PHP-DB] Re: PHP help

2003-06-30 Thread Shivanischal A
> My System: > Windows 98 > Apache 1.3.27 > PHP 4 > mysql > > Hello all, I am a PHP beginner and was wondering if I could get some help from some of the more experienced on this list. I have been trying to use an html form (with textboxes, radio buttons, and textareas) to in

[PHP-DB] Re: any ideas?

2003-06-30 Thread Shivanischal A
x27;name'"; > $result = mysql_query($query) or die(mysql_error()); > while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) > { > $count++; > ?> > > // url of site with problem: http://www.momandpopcentral.com - select > a category(arts & crafts) and state(

[PHP-DB] Re: MySQL error message...

2003-06-30 Thread Shivanischal A
CTED]> wrote in message news:[EMAIL PROTECTED] > Hello, > > Does anyone know what would cause this message? > > Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result > resource in c:\program files\easyphp\www\bod-rse\bod\menu.php3 on line 49... > >

[PHP-DB] Re: Hi, simple question

2003-07-01 Thread Shivanischal A
Hi, or u can just try "select last_insert_id() from test" - thats what i do. however even mentioning the table-name doesn't seem to be necessary; i just do it for readability. -shiva "Patrik Fomin" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] &g

[PHP-DB] Configuring PHP with MySQL

2007-12-26 Thread Balaji A
Hi, I have installed following things on windows machine. 1. Apache HTTP Server 2.2.4 2. PHP 5.2.3 3. MySQL 5.0.45 I am getting mysql_connect() not found. I have downloaded libmysql.dll, php_mysql.dll & php_mysqli.dll and copied to c:\php\ext. I have uncommented these dll files in php.ini and

[PHP-DB] Sample script files with 3 different select boxes with mysql conditions in select boxes

2008-01-03 Thread Balaji A
Hi, I have a table with the below fields. (id, title, language, author & link to the book). Initially I want to display a page with 3 select boxes (language, author & title). Initially first select box displays the available language by querying the database. On selecting one language

[PHP-DB] Nestling Array in PHP from MySql

2008-04-09 Thread A. Joseph
Well i need a little ideal on nestling this php array. This what i want to do. Have you heard of online clubing? http://www.disneytreasures.biz/ This how it works, 1) (*Agent*) You bring 3 persons (first you as an agent or officer) 2) The 3 person you brought, brings 3 persons each 3) Again

[PHP-DB] Re: php-db Digest 9 Apr 2008 13:17:18 -0000 Issue 4019

2008-04-09 Thread A. Joseph
The question is. Some nestled calculation. How did club freedom did the calculation, or how will the database structure looks like? *The example is -: * *Joseph* gave birth to *John*, *James,* and *Johnson* *John* gave birth to* Peter*, *Matter*, and *Potter* James gave birth to Juliana, Justin,

[PHP-DB] Re: php-db Digest 9 Apr 2008 13:17:18 -0000 Issue 4019

2008-04-09 Thread A. Joseph
The question is. Some nestled calculation. How did club freedom did the calculation, or how will the database structure looks like? *The example is -: * *Joseph* gave birth to *John*, *James,* and *Johnson* *John* gave birth to* Peter*, *Matter*, and *Potter* James gave birth to Juliana, Justin,

[PHP-DB] Date calculation from MySql table

2008-04-12 Thread A. Joseph
I want to calculate the registed users today Also total users this week Total users this month Total users this year The Mysql table has a row of INT(11) with time() value inserted. I did something like this $today = strtotime("+1 day") Then $sql = "SELECT COUNT(*) FROM tabl

[PHP-DB] Generating random numbers

2008-04-16 Thread A. Joseph
What is the best way to generating random numbers and you are sure that the script will never generate the generated ones? I`m using mysql database, but this out of SQL AUTO_INCREMENT stuff, I need a real random generator that will never generate what has been generated.

[PHP-DB] Designing An API with PHP/MySql

2008-04-18 Thread A. Joseph
How can I design a system that let other people modify record from another server? Like I have registered member on my site, people can use external application to check if the (1) user is registered (2) user is online (3) update user profile on mysite Like the myspace.com stuff, I saw I

[PHP-DB] Array Display

2008-05-06 Thread A. Joseph
Please i knew this not the best place to post this message but i ain`t gat no option i need fast help on this I have a Array and data are grouped according to level, so want to display everybody on same level in same HTML row os if you are on level 0 then you first, to the next people on level

[PHP-DB] Array Display

2008-05-06 Thread A. Joseph
Please i knew this not the best place to post this message but i ain`t gat no option i need fast help on this I have a Array and data are grouped according to level, so want to display everybody on same level in same HTML row os if you are on level 0 then you first, to the next people on level

[PHP-DB] Re: Array Display

2008-05-07 Thread A. Joseph
The display will look like 1 2 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 Everybody on level 1 will be on same row and so on On 5/7/08, A. Joseph <[EMAIL PROTECTED]> wrote: > Please i knew this not the best place to

[PHP-DB] Recommended web developers

2008-06-24 Thread A. Joseph
Which company in India or USA can you recommend to design a complex website for my company. The site will be a social site, will include, Blog, Articles, Shops, Music, Movie, Directory, Pre-paid card system, Culture and Tourism, downloads, file upload and sharing The site is just like yahoo, but

Re: [PHP-DB] Recommended web developers

2008-06-24 Thread A. Joseph
Well, I can also write a good working PHP code but this project did more professionals, like security issues, but the main part of the project is, Dating, The Shop and Music/Movie, The Pre-paid card system and the user financial account, each user can credit his/her account with the card and user

[PHP-DB] I want to remove the last comma

2008-08-12 Thread A. Joseph
This the script $dir = "images"; $d = opendir($dir); $out = " var tinyMCEImageList = new Array(\n"; while(false != ($entry = readdir($d))) { if(preg_match("/(.jpg|.gif|.png)$/", $entry) != false) { $out .= "['{$entry}', '{$dir}/{$entry}'],\n"; } } $out .= ");\n"; This the out put

[PHP-DB] Multi-level marketing system

2008-08-14 Thread A. Joseph
I want to develop a multilevel marketing system, please can someone give me a good starting point, or if you know a system developed for such, tell me. It will be a hierarchical structure. But members will need to earn money on some level Thank U.

[PHP-DB] Random content from MySql DB

2008-08-26 Thread A. Joseph
I`m creating a small application that let users take test online, the user will login and visit the test page, questions and answers are stored in MySql database, i want to display each randomly without repeating. test must to completed between some specific amount of time or else the

[PHP-DB] Matrix programming

2008-09-23 Thread A. Joseph
I need to do some stuff on MLM system so i will be using matrix caculation, i need a tutorial on it. On 9/23/08, Micah Gersten <[EMAIL PROTECTED]> wrote: > > Only is register_globals is on can that reset a variable. You are > correct though, defining directory paths is safer

[PHP-DB] Re: [PHP] Re: Regex for telephone numbers

2010-12-31 Thread a...@ashleysheridan.co.uk
gt; Dear List - > > Thank you for all your help in the past. > > Here is another one > > I would like to have a regex which would validate that a telephone number is > in the format xxx-xxx-. > > Thanks. > > Ethan > > MySQL 5.1 PHP 5 Linux [Debian (sid)] &

Re: [PHP-DB] About PDO::fetchObject

2015-06-11 Thread Stefan A.
27;ItemName' => array('name' => 'name', 'type' => 'string'), 'ItemDescription' => array('name' => 'description', 'type' => 'string') ) )); $item = $mapper->map(); On Thu,

[PHP-DB] Problem width SQL on PHP4

2001-01-14 Thread Sebastian A. Davicco
I need to run SQL funtions on my PHP scripts, the server is an NT4 width service pack 6. I setup php4 and it working ok, but wen i want to run SQL functions (like mssql_connect()) it show me a message saying i have use a non supported funtion. Some idea ?... ill apreciate so much your help

RE: [PHP-DB] Can you recommend a development tool?

2001-02-10 Thread Jeffrey A. Stuart
That's been going on for a VERY long time. And instead of waiting, DUMP Ultradev and take a look at Code Charge (www.codecharge.com). It fills the niche in PHP (and a bunch of other languages as well!) that Ultradev tries to fill in ASP. -- Jeff (FurBall) WebOverdrive Newbie Tech Board

[PHP-DB] RE: [PHP] Printing MySQL into HTML Tables

2001-03-22 Thread Bart A. Verbeek
Hello, Using it myself to... Maybe this will help you out: blabla a headline here " . $row["1"] . ""; $i++; //the counter loops trough the do()while() and prints records if ($i==3) { echo ""; //when the counter reaches 3 it p

RE: [PHP-DB] NEXTVAL Question

2003-12-12 Thread N . A . Morgan
put the schema name before the sequence object you need to increment, i.e. $sql = "select SCHEMA.TEAM_SEQ.NEXTVAL as \"nextval\" from sys.dual"; Regards, Neil Morgan -Original Message- From: Paul Miller [mailto:[EMAIL PROTECTED] Sent: 12 December 2003 00:05 To: [EMAIL PROTECTED] Subject

RE: [PHP-DB] anyone trickier than 'LIKE' ?

2003-12-12 Thread N . A . Morgan
E' ? Hi all, I have this data (eg.) "..big fat buddy..." on the database . If a person enter "big buddy" in the search form , the "...big fat buddy." data will not be found . Any suggestion ? Thanks in advance. select * from table where data like

RE: [PHP-DB] Max DB as Database for PHP

2003-12-16 Thread N . A . Morgan
You could try ODBC instead. Neil Morgan -Original Message- From: Morten Gulbrandsen [mailto:[EMAIL PROTECTED] Sent: 16 December 2003 05:45 To: [EMAIL PROTECTED] Subject: [PHP-DB] Max DB as Database for PHP Hello, Has anyone tried to connect to MaxDB with PHP ? http://www.mysql.com/

RE: [PHP-DB] sql errors?

2003-12-16 Thread N . A . Morgan
statements and for some reason I either get no data (through php, where through a command line I get all the data I need) or errors on the update function. Could someone tell me what I am doing wrong? $sql = mysql_query("SELECT hostname FROM $table WHERE vlan = $_POST[dhcp_hosts]",

RE: [PHP-DB] Embedded DB

2004-01-16 Thread N . A . Morgan
[mailto:[EMAIL PROTECTED] Sent: 16 January 2004 10:08 To: [EMAIL PROTECTED] Subject: [PHP-DB] Embedded DB Hi the List, Could somebody tell me if it exists < embedded database >. I would like to integrate a small database in a terminal that has not a big memory size. Please tell

RE: [PHP-DB] CREATE TABLE problem

2004-01-22 Thread N . A . Morgan
I have had similar problems before. I have just created your table in MySQL. Seems you can't have an AUTO_INCREMENT column that is UNSIGNED. Doesn't mention this in the manual though. Neil Morgan -Original Message- From: js [mailto:[EMAIL PROTECTED] Sent: 21 January 2004 22:34 To: [EMA

RE: [PHP-DB] Problema con MySQL

2004-01-31 Thread Marco A. Ortiz
Buenos días a todos: Espero que alguno de ustedes hable español y me pueda ayudar a descubrir qué está mal en el siguiente código: El objetivo de la función es acceder a una base de Datos (MySQL) y mostrar los registros que cumplan cierta condición. Si no existe ningún registro que cumpla la

[PHP-DB] SMTP authentication

2004-02-09 Thread Marco A. Ortiz
Good afternoon dear friends: I want to ask you, how I must setup my PHP.INI file, to send e-mail from my Web Site if my SMTP server requires authentication. Otherwise, I want to know if exits some kind of “public” SMTP sever that I could use. Thank you very much. mArK

[PHP-DB] ODBC support

2004-03-11 Thread Galbreath, Mark A
Yes, I'm a newbie to PHP, but I got a phpBB2 BBS online in a day and I'm psyched. My problem is, the PHP docs and API mention that ODBC is built into PHP 4.x but I can't figure out how to use it. I would like to access the M$ Access JET engine directly from a PHP page. Any cl

RE: [PHP-DB] ODBC support

2004-03-12 Thread Galbreath, Mark A
This looks really great, Bob...thx! Mark -Original Message- From: Robert Twitty [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 10:19 AM To: Galbreath, Mark A Cc: '[EMAIL PROTECTED]' Subject: Re: [PHP-DB] ODBC support Hi Mark An alternative solution for connecting to

[PHP-DB] ?DHTML Layers with PHP?

2004-03-19 Thread Galbreath, Mark A
I've been sitting here all morning wracking my brains for a way to code a hierarchical menu tree with JavaScript from database data retrieved by PHP, so that the child menus appear on a mouse click. Can PHP do this without JS? The only JS examples I can find use static menu trees, not dy

RE: [PHP-DB] MySQL category tree db sorting

2004-03-19 Thread Galbreath, Mark A
riday, March 19, 2004 11:42 AM To: [EMAIL PROTECTED]; Age Bosma Subject: Re: [PHP-DB] MySQL category tree db sorting From: "Age Bosma" <[EMAIL PROTECTED]> > I'm trying to work out what the most efficient way will be to get the > complete tree structure from top to b

RE: [PHP-DB] ?DHTML Layers with PHP?

2004-03-19 Thread Galbreath, Mark A
This is exactly what I am looking for, so can PHP generate a new "dynamic_page.php" with the add. syntax? Mark -Original Message- From: Paul Miller [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 12:23 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] ?DHTML Layers with P

RE: [PHP-DB] ?DHTML Layers with PHP?

2004-03-19 Thread Galbreath, Mark A
This worked great (except for a couple of formatting issues) - I am able to build the hierarchical menus from database data dynamically with PHP. Thanks for the link! Mark -Original Message- From: Paul Miller [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 12:23 PM This JS

RE: [PHP-DB] An old dog, with a new trick..

2004-03-18 Thread Galbreath, Mark A
dog, with a new trick.. Bueno, héme aquí, un perro viejo tratando de aprender nuevos trucos. Comienzo a desarrollar en PHP, con la idea de conectar bases de datos MySQL y Firebird a las aplicaciones. ¿Me podrían orientar de por dónde comenzar, libros, sitios, algo así? Les estaré muy agradecido, y

RE: [PHP-DB] exporting data to excel

2004-03-25 Thread Galbreath, Mark A
will convert it to a spreadsheet. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals – www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP

RE: [PHP-DB] Re: exporting data to excel

2004-03-25 Thread Galbreath, Mark A
to an excel file. Is > the eaiest way to use PHP's file handling functions? I assume you want to delivery the execl file to a web user. Then there is no need to write the data to disk, you can generate the whole thing on the fly while you deliver it to the user. Here is a basic description

RE: [PHP-DB] exporting data to excel

2004-03-25 Thread Galbreath, Mark A
way cool - thanks for the clues! Mark It's better to TEACH a man how to fish than to GIVE him a fish! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, March 25, 2004 7:46 AM take a look at the header function http://php.net/header an example..

RE: [PHP-DB] exporting data to excel

2004-03-25 Thread Galbreath, Mark A
AM To: Galbreath, Mark A Cc: '[EMAIL PROTECTED]' Subject: RE: [PHP-DB] exporting data to excel Do you set the content-type in the response header like in JSP and servlets? I've been reading the PHP Manual; where do you find stuff like this? ____ take a look at the header fun

RE: [PHP-DB] Tree structure - how to show only current branch ??

2004-03-30 Thread Galbreath, Mark A
/localhost/tests/tree%20structure/test1.php?folderID=12>sub-sub 2 ·· <http://localhost/tests/tree%20structure/test1.php?folderID=8>child 2 of 1 · <http://localhost/tests/tree%20structure/test1.php?folderID=2>parent 2 · <http://localhost/tests/tree%20structure/test1.php?folderID=3>paren

RE: [PHP-DB] Firebird

2004-03-31 Thread Galbreath, Mark A
I don't think sorumor has it IBM is buying MySQL. Mark -Original Message- From: Ignatius Reilly [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 6:38 AM To: DB list PHP; Alireza Balouch Subject: Re: [PHP-DB] Firebird _ - Original Message - F

RE: [PHP-DB] PDFLib

2004-04-06 Thread N . A . Morgan
text -- it's pretty fantastic. Get it. Beckman On Mon, 5 Apr 2004, Nathan Mealey wrote: > Has anyone had any experience extracting text from a fulltext > field/column in a MySQL DB and, using the PDFLib library, converting > it to a PDF on-the-fly? I can create the PDF, but

RE: [PHP-DB] getting one line of info at a time

2004-04-12 Thread Galbreath, Mark A
Find out what the hex is for a carriage return and use strtok() to get an array of words, then use strlen to get the number of chars in each array element, and use array_pop() or array_shift(), iterating over the strlen, or test for NULL for each element in the array.. Mark -Original Message

RE: [PHP-DB] getting one line of info at a time

2004-04-12 Thread Galbreath, Mark A
]) { $char = substr( $array_elelment[ $i ], $j ); printf( $char ); } -Original Message----- From: Galbreath, Mark A Sent: Monday, April 12, 2004 5:06 PM To: 'Hull, Douglas D'; 'Note To php mysql List (E-mail)' Subject: RE: [PHP-DB] getting one

RE: [PHP-DB] New To PHP

2004-04-15 Thread Galbreath, Mark A
P-DB] New To PHP I ma trying to learn PHP and am having difficulty with understanding it. Is there a good PHP creator that will create PHP which will let me specify what all I need to have done so that I can go back and try to figure out just how it all fits together? Thanks, Tom KI8IZ http:

RE: [PHP-DB] New To PHP

2004-04-15 Thread Galbreath, Mark A
at other peoples code. Writing it yourself looking at the hotscript codes also helps you understand the logic of it. Mike On Apr 15, 2004, at 12:53, Tom Cloyes wrote: > I ma trying to learn PHP and am having difficulty with understanding > it. Is there a good PHP creator that will crea

[PHP-DB] Security Issues

2004-05-10 Thread Galbreath, Mark A
Does anybody know if the security issues outlined in http://www.securereality.com.au/archives/studyinscarlet.txt are still salient or not? My boss wants a technical document outlining the security risks of using PHP in an attempt to get it approved for general use by Security. I just bought

RE: [PHP-DB] PHP Training

2004-04-30 Thread Galbreath, Mark A
Yeah...Zandstra, "Teach Yourself PHP in 24 Hours, 3rd ed." (Sams 2004). ;-) -Original Message- From: Rafi Sheikh [mailto:[EMAIL PROTECTED] Sent: Thursday, April 29, 2004 11:50 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP Training Any one know of a good training course for P

Re: [PHP-DB] Connecting to Oracle DB on another server

2004-06-15 Thread roy . a . jones
Beni ... I am using the same setup as you are describing ... Here is my connect information ... OCILogon($username,$password,$tns_alias) The error that you are getting ORA-12154 has the following text on a lookup ... This leads me to believe that php is unable to find your

RE: [PHP-DB] ADOdb db abstraction library moving to sourceforge

2004-06-16 Thread Galbreath, Mark A
Thanks, John - I, for one, would be lost without ADODB. Mark -Original Message- From: John Lim [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 16, 2004 2:04 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] ADOdb db abstraction library moving to sourceforge Hello, ADOdb is a popular database

RE: [PHP-DB] Re: Posting Data to MySQL

2004-06-24 Thread Galbreath, Mark A
Doesn't matter how many fields are on a form; they are returned as an array of strings in the request object. Just iterate through the array and update the corresponding database fields. Mark -Original Message- From: Torsten Roehr [mailto:[EMAIL PROTECTED] Sent: Thursday, June 24,

RE: [PHP-DB] Re: Posting Data to MySQL

2004-06-24 Thread Galbreath, Mark A
agreed - poor design. -Original Message- From: Torsten Roehr [mailto:[EMAIL PROTECTED] Sent: Thursday, June 24, 2004 11:21 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Re: Posting Data to MySQL "Mark A Galbreath" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROT

RE: [PHP-DB] Printing selected characters (strcnt?)

2004-07-15 Thread Galbreath, Mark A
Isn't there a tokenizer method? Mark -Original Message- From: Vincent Jordan [mailto:[EMAIL PROTECTED] Sent: Thursday, July 15, 2004 5:31 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Printing selected characters (strcnt?) I am trying to figure out how to select the first letter of

[PHP-DB] PHP use in Federal Govt

2004-07-16 Thread Galbreath, Mark A
Alls, My division at State is trying to get PHP 5.0 approved for use by developers in the Department, and the Powers That Be are requesting evidence that other Federal agencies/military are using PHP, and the extent of it's use. Anybody have a clue about this? I sure would appreciate some

RE: [PHP-DB] PHP use in Federal Govt

2004-07-16 Thread Galbreath, Mark A
Thanks, David - I'm doing that at this moment :-) -Original Message- From: David Orlovich [mailto:[EMAIL PROTECTED] Sent: Friday, July 16, 2004 4:05 PM To: Galbreath, Mark A Cc: '[EMAIL PROTECTED]' Subject: Re: [PHP-DB] PHP use in Federal Govt Mark, a Google search

RE: [PHP-DB] MySQL '!=' ???

2004-07-20 Thread VANDOORINE A RsrhCppRfaRva
nt of Mexico this is true, so following the OR table, the statement is true, so it is printed. I think you can fix this by using a NOT stament and inverting your WHERE parameters. and changes your request to SELECT country FROM reech_leed_tool WHERE NOT(country = 'Argentina' OR countr

RE: [PHP-DB] LAMP

2004-08-03 Thread Galbreath, Mark A
SuSE 9.1 Pro Mark -Original Message- From: Gavin Amm [mailto:[EMAIL PROTECTED] Sent: Monday, August 02, 2004 8:40 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] LAMP I'd really like to find a Linux distro that is a LAMP system right out of the box. (Linux, Apache, MySQL, PHP) Are ther

[PHP-DB] About PHP 5.0.1

2004-09-04 Thread Daniel A. Betancourt
Hi: So far I´ve read that PHP 5.0.1 has Object Oriented capabilities and it can be used to construct GUI regarding OO programing style, That it has Class, constructors, and alike. I´m new to this, that´s why I wondered for a RAD enviroment on PHP as soon as I installed it. Isn´t there any?. Must

Re: [PHP-DB] PHP Oracle Authentication using UNIX user account

2004-10-04 Thread roy . a . jones
A couple notes / assumptions .. (1) The web server is on a different machine then database (2) The DB is not allowing remote OS authentication and only local OS authentication If these are not true then some of my comments will be invalid (1) The above config will not work as the web-to-db

RE: [PHP-DB] Importing Excel and Access data to MySQL

2004-10-08 Thread Bomgardner, Mark A
The best way I have found is convert the data to a comma separated value file, use phpMyAdmin and insert the data into you database. A couple of things that you have to watch out for is the number of records that you are importing and that all your fields in your DB are of the correct format and

[PHP-DB] Date Question

2004-10-27 Thread Bomgardner, Mark A
I am having trouble converting a date from mm/dd/ to -mm-dd on a user form. I know there was post about this, but I keep getting an error message when I try to search the archives. I have looked at the manual, but I am not finding what I am looking for. Mark A. Bomgardner

[PHP-DB] Time Field

2004-10-28 Thread Bomgardner, Mark A
When creating a time field in MySQL, its purpose is for elapsed time, not time of day. Is it better to use this field or to combine it with the date field when looking at inserting the start date and time of an event? Mark A. Bomgardner Technology Specialist KLETC

[PHP-DB] Insert and Update on same page

2004-11-01 Thread Bomgardner, Mark A
I've got a problem with trying to insert and updating on the same page. Here is my problem: I have a form that the user fills out. Upon submission, I want the information that was just inserted, to be pulled back out and shows to the user with an unique number for that record other tha

Re: [PHP-DB] Apache2+PHP5, Connecting to multiple Oracle servers

2004-12-17 Thread roy . a . jones
I compiled my PHP & Apache with the Oracle 8.1.7 client for Linux. Oracle 10g can only communicate with Oracle 10g & Oracle 9i. The 8.1.7 client can communicate with Oracle 7, 8, 8i, 9i, & 10g. I also have a configuration compiled against the 9.2.0.4 client but it can not comm

[PHP-DB] How to build a dinamic link...

2004-12-27 Thread Daniel A. Betancourt
Hi there!!! This is one of my first postings to this list. I spend most of the time reading the postings, but now I need to ask: How to build a link dinamicly from an output of a query to a web page? Much clearly. I need that certain user can upload a text content into the web site. It doesn´t

Re: [PHP-DB] How to build a dinamic link...

2004-12-29 Thread Daniel A. Betancourt
guess that way I could learn better English. Now, let´s get down to the point. As a matter of fact I haven´t tried your sugestions on the PHP script yet. First there are some details I need to understand much better (is "much" well used here this time?) > Ok, if I understand what

[PHP-DB] Re: How to build a dinamic link...

2004-12-29 Thread Daniel A. Betancourt
Hi Frank: Thank´s for answering. >I assume you can run the query and display the results Yes, I can run the query very well. >- so the only exotic thing here is: > >while ($row = mysql_fetch_array($result)) >{ >print "" . $row["title"] . >"&q

[PHP-DB] No communication between PHP 5.0.3 +MySQL 4.1.9

2005-01-16 Thread J A Brown
Will somebody please help me!!! I'm trying to set up my web server for PHP and MySQL. I've installed PHP 5.0.3 and it works fine. I've installed MySQL 4.1.9 and it works fine. BUT, I can't access MySQL from PHP. I have put the php_mysqli.dll and libmysql.dll in the C:\PHP folder, removed the ';'

Re: [PHP-DB] No communication between PHP 5.0.3 +MySQL 4.1.9

2005-01-16 Thread J A Brown
Thanks Micah, but I've already tried that one. James "Micah Stevens" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > Have you set the extensions_dir properly? It may not be looking in c:\PHP > for > the extension.. > > -Micah > >

[PHP-DB] Double spacing e-mail content..

2002-02-08 Thread Troy A. Delagardelle
I have set up a php form that allows me to fill in the information and then it e-mails the information to the specified e-mail address. On the second step the informatioin is poseted to the screen so I can see exactly what the e-mail is going to look like. The problem I am having is that the

[PHP-DB] Problems with pg_FieldNum

2002-02-13 Thread Brady A. Johnson
Greetings, I am having trouble with the PostgreSQL pg_FieldNum() funciton. When I execute the following: $DB = pg_Connect ( "dbname=lists" ); $Recs = pg_Exec ( $DB, "SELECT 123 AS \"ABC\"" ); $FieldName = pg_FieldName ( $Recs, 0 ); print ( "FieldName: $FieldName" ); $FieldNum = pg_

[PHP-DB] How to make logout from database server (ORACLE for example) when user closes its session

2002-02-18 Thread Vlad A. Chernikhoff
Hi all Is it possible to track such situations when http user closes connection to HTTP server to close opened persistent connections to the database? This connections is still active all the time (if using php not as CGI but as module for Apache) and when user trying to login next time PHP uses p

[PHP-DB] RC4 encryption with PHP

2002-02-23 Thread Troy A. Delagardelle
I am trying to encrypt a credit card number using rc4 and php and then dump it into a mySql database. Does anyone have any sample code that allows me to do this?? I found the Class.RC4Crypt algorithm and would like to use that. When I include the class.rc4crypt.php the page dies... Here is my

RE: [PHP-DB] mysql_fetch_array limit? - more details

2002-07-30 Thread Roedel, Mark A.
rs of > txtSWDesc1 displayed in my table. I am assuming the problem is in > mysql_fetch_array(), that it must have some size limitation that > truncates whatever data it has read to exactly 256 chars. I'm a little curious about this assumption, given that I know I've successful

[PHP-DB] Need Advice on Installing PHP & MySQL on Mac OSX

2002-08-10 Thread Mario A. Salinas
Hi Everyone, My name is Mario Salinas. I'm wondering if anyone on this list has had any experience installing PHP and MySQL on a Apple Laptop running Mac OS-X. If anyone has any advice and is feeling a little generous with their time, I'd love some help. I just can't seem

Re: [PHP-DB] Need Advice on Installing PHP & MySQL on Mac OSX

2002-08-10 Thread Mario A. Salinas
Andrew, Thanks for the heads-up but it doesn't work. I first tried 'foo.php' then I also tried 'info.php' and neither worked. I copied the phpinfo(); function from your email and created your email document but it still didn't work. I then tried to re-

  1   2   >