[PHP-DB] Call Oracle procedure
Hi every one! Does sombody know how to call an Oracle procedure and that get its result returned as out variable? Thanks, Alexey. Email: [EMAIL PROTECTED] ICQ# 101975252 -- 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] Computer Exploded!!!
SELECT name FROM sites WHERE description LIKE '%best%' AND description LIKE '%net%' should do what you want i think :) % = wildcard for any character, any number of tiems _ = wildcard for any character, once only HTH Beau // -Original Message- // From: Selvin Sakal [mailto:[EMAIL PROTECTED]] // Sent: Tuesday, 1 May 2001 2:18 PM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] Computer Exploded!!! // // // My computer didn't explode i just wrote that to get attention. // My question // is this - I have a table which looks like this - // // CREATE TABLE sites // ( // ID INT NOT NULL AUTO_INCREMENT, // name VARCHAR(30) NOT NULL, // keywords VARCHAR(200) NOT NULL DEFAULT 0, // description VARCHAR(200) NOT NULL DEFAULT 0, // url VARCHAR(50) NOT NULL, // rank blob NOT NULL, // PRIMARY KEY (ID) // ); // // there is a index on keywords and description // // what i would like to know is how to search description to see if // it contains // a word like 'web'. // // i would also like to know how to search description and keyword // for specific // words like this - // // say description has 'the best search engine on the net' // // i want to search for all the descriptions that contain 'best' and 'net'. // // If i don't get help soon my computer might explode. // _ // Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. // // // -- // 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 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] Computer Exploded!!!
My computer didn't explode i just wrote that to get attention. My question is this - I have a table which looks like this - CREATE TABLE sites ( ID INT NOT NULL AUTO_INCREMENT, name VARCHAR(30) NOT NULL, keywords VARCHAR(200) NOT NULL DEFAULT 0, description VARCHAR(200) NOT NULL DEFAULT 0, url VARCHAR(50) NOT NULL, rank blob NOT NULL, PRIMARY KEY (ID) ); there is a index on keywords and description what i would like to know is how to search description to see if it contains a word like 'web'. i would also like to know how to search description and keyword for specific words like this - say description has 'the best search engine on the net' i want to search for all the descriptions that contain 'best' and 'net'. If i don't get help soon my computer might explode. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- 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 and Access to DB2.
Check www.p2p.wrox.com...more later on this Phil J. Nicolas Machado wrote: > Hy, somebody knows if exist a driver for database access to DB2/400, running > on AS/400. > Something like a module. > > Thanks. > > --- > Este Mail NO contiene Virus. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.250 / Virus Database: 123 - Release Date: 18/04/01 > > -- > 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 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] linking images
And store the file type - it does make a difference when you go to display it..i.e. *.gif or *.jpg.. Phil J. olinux o wrote: > Best way to do it is to store the filename in the db, > faster and really simple. > > What I have done at my site is write a script that > uploads the file. Uploading generates something like > three variables [filesize, filetype, and filename] the > only one I am concerned with is filename. The > variables are named the same as the file upload > fieldname plus an extension like this: > > say my upload field is NAME="upload_image" when i > upload the filename can be referenced by > upload_image_name - size by upload_image_size at least > from what i can remember quickly. > > so i insert this filename [upload_image_name] into a > table that references the associated ID. something > like this: > > IMG_TABLE > > apartment_id filename > > k, so this will store the filename, now you just need > to grab the filename from this table and echo the > filename into the or like > this: > > HTH, > probably a bit confusing, lemme know if you would like > my script. > > olinux > > --- Sharmad Naik <[EMAIL PROTECTED]> wrote: > > I m using postgresql-7.0.2 with php,My problem is > > that this database > > doesn't allow more than 4k images to be stored . > > I wanted to know how to store images in a > > directory and keep its link in the dbase or if > > anyone can tell me how to split > > the image so that it can be kept in the dbase > > -Thanks > > -- > > The secret of the universe is @*&í!'ñ^#+ NO CARRIER > > ___ _ _ _ > > |_|_||_||_||\/||_|| \ > > _|| || || \| || ||_/ > > > > -- > > 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] > > > > __ > Do You Yahoo!? > Yahoo! Auctions - buy the things you want at great prices > http://auctions.yahoo.com/ > > -- > 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 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] Keeping authentication
Here's the way I do it . I started using a cookie, but switched to session
as I wanted the authentication to expire when the user closed the browser.
The UserLogin function is in User_login.php. FetchUsrData checks the names
and password against the database and returns either 1 (true) or 0 (failure).
function UsrLogin( $first_name, $last_name, $pass )
{
/***
Seek username and Password in subscriber table
If found, set cookie AllNS & redisplay page,
with swtiches to show bidding section.
If not display "Sorry couldn't find you ..." and return
/
global $cMsgNotFound, $member_id ;
$nFetchResult = FetchUsrData( $first_name, $last_name, $pass, $member_id );
if( $nFetchResult == 1 )
{
//setcookie ("AllNS", $member_id, time()+3600,'/' );
session_start();
session_register( "member_id" );
$ReaderOK = 1;
}
else
{
$ReaderOK = 0;
}
return $ReaderOK;
}
Each page then has the following code at its head:
At the VERY TOP, with NOT A SPACE before it. Obviously if there's no
session with member_id, the user is directed to the login page, user_logon.php.
This scheme was used because the client wanted a custom login page. Rasmus
Lerdorf wrote up a scheme that uses Apache's built in authentication
dialog, although still authenticating against a database. Can't remember if
it's in the webmonkey or devshed archives.
Hope this helps,
Miles Thompson
At 05:10 PM 4/30/01 -0600, James McLaughlin wrote:
>Hello,
>
>I am attempting to build a series of pages that are only visible to people
>logged in through the auth script I wrote using a MySQL db to hold the auth
>users.
>
>login.php--Login script that takes username and password from user.
>myhome.php--If username and password check out myhome.php displays
>information that is authed by thier account.
>other.php-- *concept* if username and password still check out then this
>page will display blah blah and blah3.
>
>I can login just fine and myhome.php displays correctly. But when I go to
>look at other.php it kicks me back to the login.php screen asking for my
>username and password again.
>
>In the other.php page what and how do I ask the database if someone is still
>logged in or not logged in so that the authorized information will show?
>
>
>
>Any help would be appreciated
>
>Thanks
>
>Kat
>
>
>--
>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 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] More information about PHP & Oracle 8i
Hi, I would like to know if there is any other information about PHP & Oracle 8i, websites etc Sean -- 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] Keeping authentication
you need to use sessions and register the user's session name, and save it to the db against their account, then you can check that the session still exists and that will say they are logged in still. have a look at the session management functions in the manual (only in php4+) HTH Beau // -Original Message- // From: James McLaughlin [mailto:[EMAIL PROTECTED]] // Sent: Tuesday, 1 May 2001 7:11 AM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] Keeping authentication // // // Hello, // // I am attempting to build a series of pages that are only visible // to people // logged in through the auth script I wrote using a MySQL db to // hold the auth // users. // // login.php--Login script that takes username and password from user. // myhome.php--If username and password check out myhome.php displays // information that is authed by thier account. // other.php-- *concept* if username and password still check out then this // page will display blah blah and blah3. // // I can login just fine and myhome.php displays correctly. But // when I go to // look at other.php it kicks me back to the login.php screen asking for my // username and password again. // // In the other.php page what and how do I ask the database if // someone is still // logged in or not logged in so that the authorized information will show? // // // // Any help would be appreciated // // Thanks // // Kat // // // -- // 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 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] Updating Mysql database from a remote computer
if the computer where the writable copy of the database is stored is
permanently connected to the other one, then you could just create a new
user for that database using mysqls security features which only has access
to read information, no change or delete.
and yes you can connect using an ip, to any database which allows external
connections (firewalls etc notwithstanding)
// -Original Message-
// From: Marko Lesnik [mailto:[EMAIL PROTECTED]]
// Sent: Monday, 30 April 2001 10:40 PM
// To: [EMAIL PROTECTED]
// Subject: [PHP-DB] Updating Mysql database from a remote computer
//
//
// The database will be created on a local computer and it only
// needs to be
// transferred to the server (it's a read-only database when it's
// on the net).
// The problem is that the database itself isn't located in
// directory, where we
// could access it with Ftp client and simply owerwrite it with the new
// version.
// Is it possible to connect via a IP number instead
// 'localhost' like this:
// mysql_connect("100.10.20.30","username","password")
// and then update record by record. It should be slower but our
// main interest
// is to get the data to server. Are there any free servers where
// this can be
// tested?
//
// Thanks,
// Marko.
//
//
//
// --
// 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 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] undefined index
hi to all
I try to get data listed out of my database with the statement
...
while ($row = mysql_fetch_array($sql)) {
$image = $row["imageurl"];
$id = $row["productID"];
$name = $row["cdescription"];
...
If i havent got anything in that field in my database I get the error
message in my browser
Undefined index: imageurl in ...
How can I overcome that problem? Is there a way to define a index if that
occurs and make it to not produce that error message?
Hope I have explained it understandable enough. If you need to know more
details let me know, I would appreciate any help I could get. Thanx
P.
Re: [PHP-DB] Executing a PL/SQL Function
Does the database user your logging in as have execute permissions for that
procedure?
"Marcelo Dias de Toledo" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Here is the code:
>
> $stmt = OCIParse($conn,"BEGIN prontolog.pc_int.pedido(:p_cgc_lweb,
> :p_id_cliente, :p_id_pedido, :p_id_transp, :p_contrato, :p_dt_emissao,
> :p_dt_chegada, :p_dt_entrega, :p_vl_frete, :c_nome, :c_fone1, :c_fone2,
> :c_fax, :c_email, :c_endereco_f, :c_bairro_f, :c_cep_f, :c_cidade_f,
> :c_estado_f, :c_nome_e, :c_endereco_e, :c_bairro_e, :c_cep_e,
> :c_cidade_e, :c_estado_e, :p_id_conpag, :v_observa); END;");
>
> OCIBindByName($stmt, ":p_cgc_lweb", &$p_cgc_lweb, 150);
> OCIBindByName($stmt, ":p_id_cliente", &$p_id_cliente, 150);
> OCIBindByName($stmt, ":p_id_pedido", &$p_id_pedido, 150);
> .
> .
> .
>
> $p_cgc_lweb = "04284227000167";
> $p_id_cliente = "29334988800";
> $p_id_pedido = "0001";
> $p_id_transp = "00926551000180";
> $p_contrato = "numero do contrato da transportadora";
> $p_dt_emissao = date("Y-m-d H:i:s");
> $p_dt_chegada = date("Y-m-d H:i:s");
> .
> .
> .
>
> OCIExecute($stmt);
>
> print "(($v_observa))";
>
> prontolog is the schema
> pc_int is the package
> pedido is the function
>
> And this is the exacly output
> ---//---
> Warning: OCIStmtExecute: ORA-06550: line 1, column 7: PLS-00221:
> 'PEDIDO' is not a procedure or is undefined ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored in /www/htdocs/mariamercado/teste.phtml on
> line 64
> (())
> ---//---
>
> Can I execute functions ? If yes, what may be wrong ?
>
> Thank you very much,
> --
> Marcelo Dias de Toledo
> N-Web E-Commerce - http://www.nweb.com.br
> mailto:[EMAIL PROTECTED]
> Phone: 55 71 341-8474 - Fax: 55 71 341-8480
>
> --
> 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 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] Keeping authentication
Hello, I am attempting to build a series of pages that are only visible to people logged in through the auth script I wrote using a MySQL db to hold the auth users. login.php--Login script that takes username and password from user. myhome.php--If username and password check out myhome.php displays information that is authed by thier account. other.php-- *concept* if username and password still check out then this page will display blah blah and blah3. I can login just fine and myhome.php displays correctly. But when I go to look at other.php it kicks me back to the login.php screen asking for my username and password again. In the other.php page what and how do I ask the database if someone is still logged in or not logged in so that the authorized information will show? Any help would be appreciated Thanks Kat -- 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] Executing a PL/SQL Function
Here is the code:
$stmt = OCIParse($conn,"BEGIN prontolog.pc_int.pedido(:p_cgc_lweb,
:p_id_cliente, :p_id_pedido, :p_id_transp, :p_contrato, :p_dt_emissao,
:p_dt_chegada, :p_dt_entrega, :p_vl_frete, :c_nome, :c_fone1, :c_fone2,
:c_fax, :c_email, :c_endereco_f, :c_bairro_f, :c_cep_f, :c_cidade_f,
:c_estado_f, :c_nome_e, :c_endereco_e, :c_bairro_e, :c_cep_e,
:c_cidade_e, :c_estado_e, :p_id_conpag, :v_observa); END;");
OCIBindByName($stmt, ":p_cgc_lweb", &$p_cgc_lweb, 150);
OCIBindByName($stmt, ":p_id_cliente", &$p_id_cliente, 150);
OCIBindByName($stmt, ":p_id_pedido", &$p_id_pedido, 150);
.
.
.
$p_cgc_lweb = "04284227000167";
$p_id_cliente = "29334988800";
$p_id_pedido = "0001";
$p_id_transp = "00926551000180";
$p_contrato = "numero do contrato da transportadora";
$p_dt_emissao = date("Y-m-d H:i:s");
$p_dt_chegada = date("Y-m-d H:i:s");
.
.
.
OCIExecute($stmt);
print "(($v_observa))";
prontolog is the schema
pc_int is the package
pedido is the function
And this is the exacly output
---//---
Warning: OCIStmtExecute: ORA-06550: line 1, column 7: PLS-00221:
'PEDIDO' is not a procedure or is undefined ORA-06550: line 1, column 7:
PL/SQL: Statement ignored in /www/htdocs/mariamercado/teste.phtml on
line 64
(())
---//---
Can I execute functions ? If yes, what may be wrong ?
Thank you very much,
--
Marcelo Dias de Toledo
N-Web E-Commerce - http://www.nweb.com.br
mailto:[EMAIL PROTECTED]
Phone: 55 71 341-8474 - Fax: 55 71 341-8480
--
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 with mysql or interbase?
I prefer Interbase just because I don't like the way mySQL handles user authentication. It's rock solid and runs plenty fast. I use IBConsole or QuickDesk to do simple table definition and ERwin for complex projects. Some complex stuff requires generating a script and then running the script from isql.exe. Regards, John Thompson <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Thanks, but instead of sifting through all the individual messages I wanted > to see if there were any > comments that summarize the whole thing. > > If there are not my conclusion is that there is more free documentation and > support for mysql than interbase. > I even found a new book at Barnes and Noble titled: MySQL/PHP Database > Applications. > > The documentation for interbase is not so well supported probably because > it is more new to open source. > > Joel > > At 03:18 PM 4/17/01 -0400, you wrote: > >[In a deadpan voice...] Oh, what a fascinating twist. > > > >http://marc.theaimsgroup.com/?l=php-db is where this particular list is > >archived. > > > >That's where you can learn a lot about the individual programs, and you may > >find out little bits of wisdom like: each database has strengths and > >weaknesses, you really should pick the platform based upon your needs, even > >the best database will not help you if you start with a poorly designed > >schema. > > > >Doug > > > >At 02:33 PM 4/17/01 -0400, [EMAIL PROTECTED] wrote: > > >I'm trying to decide whether to use interbase or mysql with php. > > >Both are free and both have a php api. > > > > > >So which is better to use with php? > > >Or does it matter? > > > > > >[EMAIL PROTECTED] > > > > > > > >-- > >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 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 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] linking images
Binary Large Objects permit storage of any operating system file, including
images or large files directly into the database, Use lo_import() to load an
object into the database and lo_export() to retrieve.
CREATE TABLE picture(name char(20), photo OID); -- as an example.
The lo_import() stores a path, i.e., /../...jpg and so on, into the
database. The function call returns an OID that is used to refer to the
imported large object. It is stored in picture.photo thus:
INSERT INTO picture VALUES ('blabla', lo_import('/directory path/..jpg'));
To retrieve it do:
SELECT lo_export(picture.photo, '/export path, i.e., /tmp/outimage.jpg')
FROM picture WHERE name = 'blabla';
Robert B. Barrington
GetMart Commercial Ecom: Web Administrator
http://weddinginlasvegas.com/
http://getmart.com/
[EMAIL PROTECTED]
Vegas Vista Productions
3172 North Rainbow Boulevard
Suite 326
Las Vegas, Nevada 89108-4534
Telephone: (702)656-1027
Facsimile: (702)656-1608
-Original Message-
From: Sharmad Naik [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 30, 2001 7:06 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] linking images
I m using postgresql-7.0.2 with php,My problem is that this database
doesn't allow more than 4k images to be stored .
I wanted to know how to store images in a
directory and keep its link in the dbase or if anyone can tell me how to
split
the image so that it can be kept in the dbase
-Thanks
--
The secret of the universe is @*&í!'ñ^#+ NO CARRIER
___ _ _ _
|_|_||_||_||\/||_|| \
_|| || || \| || ||_/
--
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 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] linking images
Best way to do it is to store the filename in the db, faster and really simple. What I have done at my site is write a script that uploads the file. Uploading generates something like three variables [filesize, filetype, and filename] the only one I am concerned with is filename. The variables are named the same as the file upload fieldname plus an extension like this: say my upload field is NAME="upload_image" when i upload the filename can be referenced by upload_image_name - size by upload_image_size at least from what i can remember quickly. so i insert this filename [upload_image_name] into a table that references the associated ID. something like this: IMG_TABLE apartment_id filename k, so this will store the filename, now you just need to grab the filename from this table and echo the filename into the or like this: HTH, probably a bit confusing, lemme know if you would like my script. olinux --- Sharmad Naik <[EMAIL PROTECTED]> wrote: > I m using postgresql-7.0.2 with php,My problem is > that this database > doesn't allow more than 4k images to be stored . > I wanted to know how to store images in a > directory and keep its link in the dbase or if > anyone can tell me how to split > the image so that it can be kept in the dbase > -Thanks > -- > The secret of the universe is @*&í!'ñ^#+ NO CARRIER > ___ _ _ _ > |_|_||_||_||\/||_|| \ > _|| || || \| || ||_/ > > -- > 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] > __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- 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] PHP and Access to DB2.
Hy, somebody knows if exist a driver for database access to DB2/400, running on AS/400. Something like a module. Thanks. --- Este Mail NO contiene Virus. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.250 / Virus Database: 123 - Release Date: 18/04/01 -- 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] Checking query suceeded
Hi, If I'm doing more than one query on a page what is the best way to check if they all succeeded with out using transactions? TIA, Jord -- 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] Oracle 8i and php4
Hello, I'm trying to compile PHP 4.0.4pl1 for apache with oracle support. It is asking for some .h libraries... oci.h and others. We've found some of them in a samples directory on the oracle server, but when we use them we get segmentation faults! So, anybody has installed php with oracle 8i support? where did you find the .h files? Thanks! -- 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] Updating Mysql database from a remote computer
The database will be created on a local computer and it only needs to be
transferred to the server (it's a read-only database when it's on the net).
The problem is that the database itself isn't located in directory, where we
could access it with Ftp client and simply owerwrite it with the new
version.
Is it possible to connect via a IP number instead 'localhost' like this:
mysql_connect("100.10.20.30","username","password")
and then update record by record. It should be slower but our main interest
is to get the data to server. Are there any free servers where this can be
tested?
Thanks,
Marko.
--
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: nobody header
> the script below gives me a from header = "Nobody"; and the > $from which is supposed to be the header has been included in the > body of the email. How can i make the $from to be placed in the header? hi Jennifer, you have to specify the From email address in the following way: $from = "From: [EMAIL PROTECTED]"; the last parameter passed to PHP is not by default the from address, but any additional paremeters, so you've gotta tell PHP it's the from address (in the way above). Look here for more info: http://www.php.net/manual/en/function.mail.php the "nobody" user will be the webserver, and since your original script did not specify a sender then this is what the server usually defaults to. best wishes, Simon --- Studio 24 Ltd | tel. 01223 501 892 PO Box 88 | fax. 0870 063 1216 Cambridge | mob. 07974 074 547 CB4 1XH | www.studio24.net -- 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] Intialize PHP Module on Windows98
Looks like you've got different versions for php and your modules. Since php is the oldest, make sure you have the newer php4isapi.dll and php4ts.dll in the system directory, or wherever you installed them. ""Benny"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I have a problem on intializing PHP module. > I've installed PHP on my windows 98 system. I used PWS. > I placed php on c:/Php. > My home directory is c:/Inetpub/myfolder. > This is the php.ini, Paths and Directories section : > doc_root = "c:/Inetpub/myfolder" > extension_dir = "c:/Php/extensions" > This is the registry : > > [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\w3svc\parameters\Scrip > t Map] > ".php"="c:\\Php\\sapi\\php4isapi.dll" > When I try phpinfo(), I received message like this : > dbase: Unable to initialize module > Module compiled with debug=0, thread-safety=1 module API=20001214 > PHP compiled with debug=0, thread-safety=1, module API=2609 > These options need to match > That's for dbase module, and for the others module it gave the same result. > > Anyone could help me to solve this problem ? > > Regards; > > Benny. > > > > -- > 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 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] save data to file problem...
Hi I want to save data from mysql to a text file when i search...a popup window should come up that says save as How can i do that? Thanks Nils -- 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] linking images
I m using postgresql-7.0.2 with php,My problem is that this database doesn't allow more than 4k images to be stored . I wanted to know how to store images in a directory and keep its link in the dbase or if anyone can tell me how to split the image so that it can be kept in the dbase -Thanks -- The secret of the universe is @*&í!'ñ^#+ NO CARRIER ___ _ _ _ |_|_||_||_||\/||_|| \ _|| || || \| || ||_/ -- 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] modules dir
Can Anybody tell me the purpose of modules dir ,that is observed in the dir of php-**version** after unzip or installing -Thanks -- The secret of the universe is @*&í!'ñ^#+ NO CARRIER ___ _ _ _ |_|_||_||_||\/||_|| \ _|| || || \| || ||_/ -- 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] Select statements - A Quest !!!
i worked at a particularly PC bank once ... Kaizen was the management philosophy and means 'never ending horizon' or words to that effect ... maybe their get Kaizen points per department ... sounds lovely, :-) Steve > -Original Message- > From: Bob Hall [mailto:[EMAIL PROTECTED]] > Sent: 28 April 2001 23:53 > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] Select statements - A Quest !!! > > > >I have two tables namely, > >1. cpkaizen : The following is the desc > > > >Field | Type | Null | Key | Default | Extra | > >++--+--+-+-+- > ---+ > >| kno | int(10) | | PRI | NULL | auto_increment | > >| loginid | varchar(20) | YES | | NULL | | > >| period | varchar(6) | YES | | NULL | | > >| peryear | int(5) | YES | | NULL | | > >| star | char(1) | YES | | N | | > >| name1 | varchar(30) | YES | | NULL | | > >| name2 | varchar(30) | YES | | NULL | | > >| name3 | varchar(30) | YES | | NULL | | > >| name4 | varchar(30) | YES | | NULL | | > >| date | date | YES | | NULL | | > >| problem | varchar(255) | YES | | NULL | | > >| action | varchar(255) | YES | | NULL | | > >| result | varchar(255) | YES | | NULL | | > >| benefit | varchar(255) | YES | | NULL | | > >| evalution_para | varchar(100) | YES | | NULL | | > >| dept | varchar(20) | YES | | NULL | | > >| name0 | varchar(30) | YES | | NULL | | > > > >(* the records in this table are KAIZENS. dept is of that employee > >i.e either \'ms\' or fin,com,log,epcm,po,ms,hr . *) > > > >2. employee : following is the desc > > > >Field | Type | Null | Key | Default | Extra | > >+---+-+--+-+-+---+ > >| edpno | int(10) | YES | | NULL | | > >| name | varchar(40) | | | | | > >| loginid | varchar(20) | YES | | NULL | | > >| superuser | char(1) | YES | | N | | > >| groupno | int(4) | YES | | NULL | | > >| dept | varchar(30) | YES | | NULL | | > >| sub_dept | varchar(30) | YES | | NULL | | > > > >(* dept is common for employees i.e \'cp\' but sub_depts are > >fin,com,log,epcm,po,ms,hr . So there are more than one employee in > >each sub_dept *) > > > >Now actually, I want to generate the report : > > > >the output should be : > > > >Department | Total no of employee | Total KAizen | Average > > Average what? > > > > >(* here under departments should come the above seven mentioned. > >then total no of employees in eeach sub_dept. > >Then total no of KAIZENS for that sub_dept from table cpkaizen > >and > >Average which is Total no of kaizen divide by total no of > employees *) > > > >How can I go ahead to get that output table generated. > > > >Thank you, > >Pranot > > Sir, from looking at your tables, I can't tell which contains the > parent records and which contains the child records. I might be able > to figure it out if know what a kaizen is. You haven't declared any > primary keys on the employee table, and you didn't say which DBMS > you're using. > > In general, pattern is > > SELECT dept, Count(p.something), Count(c.something_else), > Avg(some_column) > FROM parent_table AS p INNER JOIN child_table AS c ON > p.id = c.p_id > GROUP BY dept; > > The actual syntax depends on your DBMS. > > Bob Hall > > Know thyself? Absurd direction! > Bubbles bear no introspection. -Khushhal Khan Khatak > MySQL list magic words: sql query database > > -- > 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 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] How to randomly select data in a field. Please help newbie.
Hi, you could do the random selection in MysSQL if you use it using a query like this. SELECT FieldWithURL FROM YourTable ORDER BY RAND() LIMIT 0,1; This will give you a random field. If you want more fields you have to set different values for the limit. Like LIMIT 0,5 for the first 5 row. Just if you don't know the syntax of LIMIT: limit 'StartingPoint', 'NumberOfRows' hope it helps Johannes ""Greg K"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag 9cfe9n$ggd$[EMAIL PROTECTED]">news:9cfe9n$ggd$[EMAIL PROTECTED]... > Can someone explain to me the best way to randomly select data from field > that consist of urls. The fields consist urls that are images of people. I > believe I have to setup that field as a array and turn it into a interger. > But I have no experience doing this can someone sort of give me a example on > how I would do this . > > Thank you .. > > Your Help would be well appreciate it .. > > > > > > -- > 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 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] nobody header
Hi,
Are you using header to redirect a URL? If yes, you just add it as query
string in the URL like;
header ("http://www.url.com?[EMAIL PROTECTED]";);
I don't know if you have to urlencode the email address.
Lester
At 04:26 PM 4/30/01 +0800, Jennifer Arcino Demeterio wrote:
>hello,
>
> i hope you could help me with this,
>
> the script below gives me a from header = "Nobody"; and the $from
> which is supposed to be the header has been included in the body of the
> email. How can i make the $from to be placed in the header?
>
> $from = "[EMAIL PROTECTED]";
> $subject = "Changes on employee's personal data\n\n";
> $message = $message."Changes on Employee's Personal Data since
> the last evaluation\n\n";
> $message = $message."Employee's Name: $emplname, $empfname,
> $empmname\n";
> $message = $message."Address: $address\n";
> $message = $message."Telephone Number: $telno\n";
> $message = $message."Civll Status: $civilstatus\n\n";
> $message = $message."Name/s and Birthday/s of children born
> within the last 6 months\n";
> $message = $message."Name: $name1 $name2 $name3\n";
> $message = $message."Birthday: $bday1 $bday2 $bday3\n";
> mail("[EMAIL PROTECTED]", "$subject", "$message","$from");
>
>thanx :)
-
Lester June Cabrera
Chief Web Programmer
I-Quest Corporation
Tel: (632) 867 8150 local 301 or 302
Fax: (63 2) 867 8077
E-mail: [EMAIL PROTECTED]
Visit the most comprehensive on-line business travel resource at
http://www.worldroom.com
Successful events start here. Visit http://www.worldroomevents.com .
The one-stop online exchange for event planners and suppliers to the MICE
industry.
--
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 problem
user something like this:
the thing you're looking for is the SELECTED bit of the select drop down ...
echo '';
$months = Array("January", "February", "March", "April", "May", "June",
"July", "August", "September", "October", "November", "December");
for ($x=1; $x <= count($months); $x++)
{
print "\t".$months[$x-1]."\n";
}
echo ' ';
get the form to submit itself using action=
Steve
> -Original Message-
> From: Johan [mailto:[EMAIL PROTECTED]]
> Sent: 29 April 2001 16:02
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] PHP problem
>
>
> Dear Sir/Madam,
>
> I have a mysql database available with user information. I want that
> visitors have the change to change their personel
> information. Now the form
> works with two different types of fields. edit-fields and
> selectie/option-lists.
>
> How do I get the value of a user from a selectionlists selected in the
> form-field. All options must be availabele, but the value of
> the user must
> be selected in the form field.
>
> If anyone can help me please mail me at [EMAIL PROTECTED]
>
> Thanks
>
> Johan.
>
>
>
> --
> 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 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] MySql aund PHP
Hello,
I have pictures stored in a database, when I will see them I get only
placeholder of pictures but not the picture self. What is wrong in my code?
Please help me.
Code section:
1) PHP-HTML for storing:
http://localhost/php/insert_file.html";);
exit;
}
$db = mysql_connect() or die("Can't connect to server.");
mysql_select_db("media", $db) or die("Can't select database.");
$binary_junk = addslashes(fread(fopen($img1, "r"), filesize($img1)));
$insert_data = "INSERT INTO images(img_id, binary_junk, filename, filesize,
filetype) VALUES ('4', '$binary_junk', '$img1_name', '$img1_size',
'$img1_type')";
mysql_query($insert_data) or die("Couldn't insert data.");
?>
Successful File Insertion!
Success!
You have inserted the following into your database:
, a byte file with a mime
type of .
2) Html for viewing:
My Image
Look at this:
3) PHP for viewing:
";
for($i=0; $i<$num; $i++)
{
$id = mysql_result($res, $i, "img_id");
$fn = mysql_result($res, $i, "filename");
$ft = mysql_result($res, $i, "filetype");
$bj = mysql_result($res, $i, "binary_junk");
header("Content-type: $ft");
echo "$bj" . "";
}
mysql_close($db);
?>
Thanks for your help.
Damian
--
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] PHP4, APACHE, SCO & INFORMIX
Hi Everyone, Firstly, apologies for cross posting but I wanted to make sure this got to the relevant people. I am continually getting people asking me off list for information regarding building the above combination. I don't mind as it's encouraging to see PHP spreading to this type of platform. All I ask is that if anyone requires help then please direct it to the PHP-Install list so others may benefit from the replies given. I will try to compile a complete install guide when I get time and perhaps one of the PHP associated sites would be able to host it. It maybe an idea for others to contribute with their particular build so that a centrally managed install guide could be set up and perhaps free up some of the traffic on the lists? Best regards, - Paul - -- 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] nobody header
hello,
i hope you could help me with this,
the script below gives me a from header = "Nobody"; and the $from which is
supposed to be the header has been included in the body of the email. How can i make
the $from to be placed in the header?
$from = "[EMAIL PROTECTED]";
$subject = "Changes on employee's personal data\n\n";
$message = $message."Changes on Employee's Personal Data since the last
evaluation\n\n";
$message = $message."Employee's Name: $emplname, $empfname, $empmname\n";
$message = $message."Address: $address\n";
$message = $message."Telephone Number: $telno\n";
$message = $message."Civll Status: $civilstatus\n\n";
$message = $message."Name/s and Birthday/s of children born within the last 6
months\n";
$message = $message."Name: $name1 $name2 $name3\n";
$message = $message."Birthday: $bday1 $bday2 $bday3\n";
mail("[EMAIL PROTECTED]", "$subject", "$message","$from");
thanx :)
AW: [PHP-DB] Fatal error: undefined function mysql_connect()
*gmpf* I even can't copy&paste today, maybe I should go to bed again! Of course it should be: '--with-mysql=shared,/usr' |Shouldn't it be "--with-mysql=..." ? | | |At 09:17 AM 4/30/01 +0200, Newsletter wrote: |>Hi there, |> |>we have the same problem on our Debian. |> |>In the top of the output of phpinfo() says "-with-mysql=share", but |>there is no section with mysql and the settings further down. |> |>Maybe someone knows the answer! |> |>Greetings |>Andi |> |>|-Ursprüngliche Nachricht- |>|Von: winescout [mailto:[EMAIL PROTECTED]] |>|Gesendet: Sonntag, 29. April 2001 20:44 |>|An: [EMAIL PROTECTED] |>|Betreff: Re: [PHP-DB] Fatal error: undefined function |mysql_connect() |>| |>| |>|I am having the same problem. I followed the advice of the |>|message below(|phpinfo()?>), and can only find any mention of mySQL in my |>|Configure area. |>|It shows that I configured it with "-with-mysql=share". |>|What is the next |>|step to solving this? |>| |>|Here is some more information that may be usefull. |>|RedHat 7.0 |>|Apache 1.3.x |>|PHP 4.04 compiled with Apache, not as a dynamic module |>| |>|time and suggestions much appreciated |>|Matt |> |> |>-- |>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] | | | |- |Lester June Cabrera |Chief Web Programmer |I-Quest Corporation | |Tel: (632) 867 8150 local 301 or 302 |Fax: (63 2) 867 8077 |E-mail: [EMAIL PROTECTED] | |Visit the most comprehensive on-line business travel resource at |http://www.worldroom.com | |Successful events start here. Visit http://www.worldroomevents.com . |The one-stop online exchange for event planners and |suppliers to the MICE |industry. | -- 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] Fatal error: undefined function mysql_connect()
Shouldn't it be "--with-mysql=..." ? At 09:17 AM 4/30/01 +0200, Newsletter wrote: >Hi there, > >we have the same problem on our Debian. > >In the top of the output of phpinfo() says "-with-mysql=share", but >there is no section with mysql and the settings further down. > >Maybe someone knows the answer! > >Greetings >Andi > >|-Ursprüngliche Nachricht- >|Von: winescout [mailto:[EMAIL PROTECTED]] >|Gesendet: Sonntag, 29. April 2001 20:44 >|An: [EMAIL PROTECTED] >|Betreff: Re: [PHP-DB] Fatal error: undefined function mysql_connect() >| >| >|I am having the same problem. I followed the advice of the >|message below(|phpinfo()?>), and can only find any mention of mySQL in my >|Configure area. >|It shows that I configured it with "-with-mysql=share". >|What is the next >|step to solving this? >| >|Here is some more information that may be usefull. >|RedHat 7.0 >|Apache 1.3.x >|PHP 4.04 compiled with Apache, not as a dynamic module >| >|time and suggestions much appreciated >|Matt > > >-- >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] - Lester June Cabrera Chief Web Programmer I-Quest Corporation Tel: (632) 867 8150 local 301 or 302 Fax: (63 2) 867 8077 E-mail: [EMAIL PROTECTED] Visit the most comprehensive on-line business travel resource at http://www.worldroom.com Successful events start here. Visit http://www.worldroomevents.com . The one-stop online exchange for event planners and suppliers to the MICE industry. -- 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]
