RE: [PHP-DB] datetime

hello and thank you... probably again. using datetime, /or something else if applicable, is it possible to have entries to a page and entries to a db automatically delete? i have looked through many docs at php.net and mysql and can't find anything. perhaps i'm using the wrong search key

Re: [PHP-DB] foreach($HTTP_POST_VARS as $key = $value)

Long time ago I built a class for these needs. In fact the half of the code is *stolen* from implemenation of my colleague. I just made it OOP. The class in pi-validate.class.php.txt, the definitions of the checked fields is in pi-validate.defs.php Sample use : $validate_result =

Re: [PHP-DB] Cookies problems

on 1/21/03 10:37 PM, Sabina Alejandr Schneider at [EMAIL PROTECTED] appended the following bits to my mbox: Hello people!!! This time I have a problem with cookies. I tried to send a cookie from one page with the function sendcookie(chat,$mail) to a page in another directory, but when I tried

Re: [PHP-DB] Array problems

on 1/22/03 12:08 AM, Michael Conway at [EMAIL PROTECTED] appended the following bits to my mbox: I find myself stuck in coming up with a way to cycle through this array of db results for porting to a graphing script that I did not write. My latest attempt to get around this problem is below.

[PHP-DB] posting field_DATE variables

Hello dear all, I have a php-application witch use mysql DB; My db have a field (DATE) like timestamp(8) = 20030110, for lay-out problem i call field_DATE with a query : date_format(field_DATE, '%d-%m-%Y'), and it display the field_DATA; 10-01-2003 well.at this point i need to post

[PHP-DB] Re: Using Objects with Databases

Hello, On 01/22/2003 03:26 AM, Philip Zee wrote: I am trying to create a class, say User. Each user has an entry in the database table called user. Each function, including the constructor, will be calling the database to do something. Is it better to initialize the database connection inside

Re: [PHP-DB] posting field_DATE variables

On Wednesday 22 January 2003 23:53, Fabrizio Tivano wrote: I have a php-application witch use mysql DB; My db have a field (DATE) like timestamp(8) = 20030110, for lay-out problem i call field_DATE with a query : date_format(field_DATE, '%d-%m-%Y'), and it display the field_DATA;

Re: [PHP-DB] posting field_DATE variables

On Thu, 23 Jan 2003 00:27:26 +0800 Jason Wong [EMAIL PROTECTED] wrote: On Wednesday 22 January 2003 23:53, Fabrizio Tivano wrote: I have a php-application witch use mysql DB; My db have a field (DATE) like timestamp(8) = 20030110, for lay-out problem i call field_DATE with a query :

[PHP-DB] Re: Problem in the returnvalue of a function

that means the result is not right, it happen when your query is failed,check your query, mysql_error() can help Ruprecht Helms writes: Hi Bayu Susiloadhy, thanks for your answer. function select_price($product_id,$quantity) { --cut-- return True; } --cut-- in the

[PHP-DB] revised: foreach($HTTP_POST_VARS...

hello, i am trying to point all my forms to this .php file to check for errors, and if they are ok, insert the submitted form values into a table in a database. if i use this: ? require(config.php); $error = ; if ($name == ) { $error = $errorLIYou must enter a company name./LI; } if

[PHP-DB] ORA-03106 Error

I have the problem: ORA-03106: fatal two-task communication ... I'm running redhat 7.3 with oracle 9i client connecting to oracle 8.0.5 Server on NT. I put the putEnv to $ORACLE_HOME,$ORACLE_SID,I use OCIDefineByName, but the result is the error. When I'm using the oci functions I can't

[PHP-DB] using Flat File

Hi, I have posted my question to this list before but I did not get a help that I was expected. All I wanted to do is to give access for the users to view a page in which the below code is embedded. The user will enter his/her username and password. But the code is not working. I don't know

RE: [PHP-DB] using Flat File

What do you mean the code doesn't work? How is the code behaving? What kinds of errors are being returned by the interpreter? Is your register_globals set to ON or OFF? Are you certain you have access to the directory in which the file you wish to open is located? -Original Message-

Re: [PHP-DB] using Flat File

Check to see if $PHP_AUTH_USER exists by echoing it to the browser, and make sure you have permissions to the txt file you are trying to read. That's all I can think of given the lack of information such as error messages, where it breaks, etc. web man wrote: Hi, I have posted my question to

[PHP-DB] add.php

hello, i was hoping someone could help me further this? i have multiple form possibilities someone can fill out. each form, on submit would point to say, add.php. it would check for blank fields. if there are no blank fields it would insert the current values into the database accordingly.

Re: [PHP-DB] using Flat File

here is what i use. have your login_form.php post to this and call this login.php. hope it helps. addison ? session_start(); session_register('auth'); session_register('logname'); include(config.php); //this

[PHP-DB] inserting dates

When I insert a date into Mysql it has to be in year/month/day format or else it wont go in right. how do I convert my date variable which is in month /day /year format into year/month/day format? -- Productos de salud: http://www.nvtechnologies.com/hgh -- PHP Database Mailing List

Re: [PHP-DB] inserting dates

check out DATE_FORMAT in the mysql manual. and acually you'll want year-month-day not year/month/day...if you're using the mysql defualt date. DATE_FORMAT(NOW(), '%m/%d/%Y') - would return 01/22/2003 hth jeff

[PHP-DB] Secure variable transport (newbie)

Hi, I have read, that use global variables on php site is not a good idea. I'm newbie in PHP and maybe a stupid question: If I make an array and register it in a session and after I use it all of my pages as $HTTP_SESSION_VARS['variable'] and register_globals is off. In this case is

RE: [PHP-DB] inserting dates

check out DATE_FORMAT in the mysql manual. and acually you'll want year-month-day not year/month/day...if you're using the mysql defualt date. Actually, you can use any delimiter with MySQL, so long as it's in year, month, day order. DATE_FORMAT(NOW(), '%m/%d/%Y') - would return

[PHP-DB] Members area

Hi All, I'm about to start development on a members area for a site. The members area will have 2 levels - Paid Free, with the Paid members having access to more pages. I have not created a members area before am after any advice or links I can get... I think a lot of reading is in order...

[PHP-DB] dump a damn big db with via SSH

Hi all.., I have a problem here... I have a pretty damn big db in my account on host.sk When I failed to dump the file from phpmyadmin.. so I try to dump it via SSH.. The problem is... when I dump the whole database... it failed.. And it said that the file limit exceeded... How can I solve that

Re: [PHP-DB] Members area

Gavin, Download PHP-Nuke and look to see how they handle Non-Users/users/Admins and go from there. It's actually quite easy. They have a table structure that you could utilize and some generic routines for determining if a user is logged in or if they are an Admin. www.phpnuke.org Jim

[PHP-DB] save output to a file instead of displaying in the browser

Hi, I am trying to build a PHP-MySQL application. When users query our database from our web interface, how can I send the output to a file for users to save it to his local disk instead of displaying the output to the browser. Thanks, Qunfeng

RE: [PHP-DB] dump a damn big db with via SSH

Hi all.., I have a problem here... I have a pretty damn big db in my account on host.sk When I failed to dump the file from phpmyadmin.. so I try to dump it via SSH.. The problem is... when I dump the whole database... it failed.. And it said that the file limit exceeded... How can I