[PHP-DB] PHP Sessions

2005-04-14 Thread Ian McGhee
Hi All, I have been looking into PHP sessions and I have noticed you can actually use a database for storing the sessions instead of flat files I will be using MS SQL for the database can any one give be a clue as to how I would go about this or point me in the direction of a good tutorial?

Re: [PHP-DB] PHP Sessions

2005-04-14 Thread Maerlyn
Hi, you might consider buying Peter Moulding's PHP Black Book. Among other things it tells much about DBs, sessions and storing sessions in databases. I already used it's codes, and I found it very useful. Maerlyn Ian McGhee wrote: > Hi All, > > > > I have been looking into PHP sessions and I h

Re: [PHP-DB] PHP Sessions

2005-04-14 Thread Balwant Singh
i also want to buy this book. but could not find it in India. If anybody help me out. with best wishes balwant On Thu, 2005-04-14 at 15:10, Maerlyn wrote: > Hi, > > you might consider buying Peter Moulding's PHP Black Book. Among other > things it tells much about DBs, sessions and storing ses

Re: [PHP-DB] PHP Sessions

2005-04-14 Thread Simon Rees
On Thursday 14 April 2005 10:23, Ian McGhee wrote: > I have been looking into PHP sessions and I have noticed you can > actually use a database for storing the sessions instead of flat files I > will be using MS SQL for the database can any one give be a clue as to > how I would go about this or po

[PHP-DB] my dir search

2005-04-14 Thread 'Yemi Obembe
sorry about the volume of this apiece.just thinking it will help you understand my frenzy script better. to start with, it is a simple 'intra' search script that opens include files contained in the dir the visitor wants to searchand match its content with the query. contents of the include file

[PHP-DB] retrieve enum values

2005-04-14 Thread mel list_php
Hi! I have a column type enum in mysql. At the moment the possible values are 1,2 and 3. I make a form for my user to modify that value, something like: 1 2 3 I may need to add a value 4 to the enum, and in that case I would like to avoid modifying the code. I would like to know it it is possib

Re: [PHP-DB] PHP Sessions

2005-04-14 Thread Bastien Koert
article on phpbuilder.com http://www.phpbuilder.com/columns/ying2602.php3?aid=19 bastien From: Maerlyn <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: Re: [PHP-DB] PHP Sessions Date: Thu, 14 Apr 2005 11:40:01 +0200 Hi, you might consider buying Peter Moulding's PHP Black Book. Among other

Re: [PHP-DB] PHP Sessions

2005-04-14 Thread Mignon Hunter
>>> "Ian McGhee" <[EMAIL PROTECTED]> 04/14/05 04:23AM >>> Hi All, I have been looking into PHP sessions and I have noticed you can actually use a database for storing the sessions instead of flat files I will be using MS SQL for the database can any one give be a clue as to how I would go ab

[PHP-DB] SQLite 3.0 extension for PHP

2005-04-14 Thread Hendy Irawan
Hi Is there an SQLite 3.0 extension for PHP? The one that's bundled with PHP 5.0.4 is SQLite 2. Also the same thing with the PECL package at http://pecl.php.net/package/SQLite Thanks a lot! -- Hendy Irawan http://www.gauldong.net http://dev.gauldong.net -- PHP Database Mailing List (http://www

RE: [PHP-DB] retrieve enum values

2005-04-14 Thread Jason
If I understand you correctly.. you want to loop through a select statement and put the enum values in the value of the select box? If that's the case then here is how you would do that... $name"; } ?> Hope that speaks to your question. Jason -Original Message- From: mel list_php [mai

RE: [PHP-DB] retrieve enum values

2005-04-14 Thread Patel, Aman
Melanie, Here's a function that will parse the SHOW COLUMNS query output and will return an array of ENUM values, after you have the array it should be easy to generate the html code you need. The first two parameters are self explanatory (the table name and the column name). Hope this helps, -

Re: [PHP-DB] retrieve enum values

2005-04-14 Thread Aman Patel
A little correction in the code: define(G_ENUM_COLUMN,4); // set this to 4 if you are using "SET" column type, and 4 for "ENUM" column type. /* Return the SET or ENUM set of values. $p_start can be 3 for SET... or 4 for ENUM... */ function get_set_column_values

[PHP-DB] Re: retrieve enum values

2005-04-14 Thread Nadim Attari
$descRS = mysql('describe theTableName theEnumColumn'); list($fld_name, $fld_type, $fld_null, $fld_key, $fld_default, fld_extra) = mysql_fetch_row($descRS); mysql_free_result($descRS); // Values you will be interested: $fld_type (and $fld_default perhaps) // $fld_type will be equal to = enum('1',