[PHP-DB] HELP PLEASE: PHP - Sybase
Hello, I have got a problem, When i try to connect to Sybase from PHP script, I have an error that I am calling undefined function sybase_connect. Does it meen that I have to load some extra module to get this function to work? Or what should I do to resolve this problem ? Thank you. -- 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] Interbase double select
With Interbase functions I have to make 2 select. SELECT count(*).. to count valid record and SELECT * .. to extract the records There is a simple solutions to have unique Select ? I use Pgsql too but here I Have the pg_numrows variable. Someone sau to me: just make the SELECT * .. to extract the records and then get the rownumber by $number_of_rows=count($selected_array); Yes, BUT I use get_object ! -- 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] long or LOBs in oracle ???
Hi everybody, I have a little question. What is the best datatype to put large character data into (more than 5.000-20.000 letters). Maybe a CLOB or a long ? I am quiet new to oracle so I don't know so much about the LOBs and how Oracle handles it. On thing is, that I have to use more than one large field in one table, this means that I cannot use the long type, because only one is allowed, right. OK Then I think there is only a LOB Type (maybe the CLOB is the best for my stuff). I tried it, but I cannot put the data in the normal way into the field, like I am used to with MYSQL longtext type. How can I put LOB data into the DB via PHP or is there an other method to put large character data into the DB, can anybody help me thanx in advance, Andy
[PHP-DB] Interbase Blob
This is my page to extract image (from blob) in a interbase table. I call it with :echo src=\blob2img.php?id_product=.$id_product.\ ; ?php //BLOB2JPG $conn = ibase_connect($host,$user,$pass,$charset,$buffers,$dialect,$rules) $set = ibase_query(SELECT IMAGE from products where (id_product = $id_product)); $row = ibase_fetch_row($set); ibase_blob_echo($row[0]); header(Content-type: image/jpeg); ibase_close($conn); ? My problem is that the images are too slow. Solutions ? -- 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] long or LOBs in oracle ???
Andy: Go with the CLOB. As you stated, you can have more than one CLOB defined in a table. Also, you can pull out data randomly instead of sequentially. Plus, the data can reside inline (for less than 4KB) or out of line for bigger values. The key to making it work is using the DBMS_LOB package. See the Oracle documentation on this to get an idea, then ask a more specific question. If you're a member of technet, you'll be able to read this: http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev. 817/a76936/toc.htm If not, join up ASAP! (It's free). Good luck, Anthony From: Andreas Eckhoff [EMAIL PROTECTED] Date: Tue, 31 Jul 2001 15:09:52 +0200 To: [EMAIL PROTECTED] Subject: [PHP-DB] long or LOBs in oracle ??? Hi everybody, I have a little question. What is the best datatype to put large character data into (more than 5.000-20.000 letters). Maybe a CLOB or a long ? I am quiet new to oracle so I don't know so much about the LOBs and how Oracle handles it. On thing is, that I have to use more than one large field in one table, this means that I cannot use the long type, because only one is allowed, right. OK Then I think there is only a LOB Type (maybe the CLOB is the best for my stuff). I tried it, but I cannot put the data in the normal way into the field, like I am used to with MYSQL longtext type. How can I put LOB data into the DB via PHP or is there an other method to put large character data into the DB, can anybody help me thanx in advance, Andy -- 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] suscribe
Cordialement / Regards Christophe ChassagneuxIngénieur / Développeur ProgressTel: 0144 641 300Fax: 0144 641 301Mail: [EMAIL PROTECTED]
RE: [PHP-DB] ODBC and PHP
The error message is: - Cadastro de Fornecedor Warning: SQL error: [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionTransact (TransactNamedPipe())., SQL state 01000 in SQLExecDirect in c:\inetpub\inventario\cadastro\fornecedor.php on line 364 Warning: Supplied argument is not a valid ODBC result resource in c:\inetpub\inventario\cadastro\fornecedor.php on line 366 Warning: SQL error: [Microsoft][ODBC SQL Server Driver]Communication link failure, SQL state 08S01 in SQLExecDirect in c:\inetpub\inventario\cadastro\fornecedor.php on line 386 - But the trace works fine. To make it work again I have to remove the configuration from the ODBC and create again. []s Ariadne Mensagem original Ariadne, What is the exact error you get? Among other debugging tricks, you can get an ODBC trace from the ODBC Administrator control panel (if using Win32 on client side) and look at where the API calls are failing. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 6:30 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] ODBC and PHP I´m using PHP 4 with ODBC and sometimes I get a response that was unable to connect to the MSSQL database. Then I go to the ODBC configuration to test the connection and I get a response that everything is working fine, but my pages still can´t connect. Is that normal? What can I do? I´m using NT Server 4 with apache 1.3. []s Ariadne -- 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] Re: dba_open
Patrick Callihan [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I don't seem to have the *.so modules available. When I added the line 'extension=php_dba.so' to php.ini, nothing changed. When I tried to use the dl() function, I just got an error message: Warning: Unable to load dynamic library './php_dba.so' - ./php_dba.so: cannot open shared object file: No such file or directory in /home/pat/html I did a 'find / -name php_dba.so' and came up with nothing. Thanks in advance for any help. Hugh Bothwell [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Patrick Callihan [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... HI, I have compiled php4 with the following command: /configure' '--with-mysql' '--with-apache=../apache_1.3.20' '--enable-track-vars' '--enable-tans-sid' '--enable-dba I haven't found any information on where to find/get/make php_dba.so; hopefully someone else can help with that. I would check the directory it's in; should be under php/extensions, I would think. I did find more info on building PHP on *nix; in order to compile dba support in, it looks like you need another switch: http://www.php.net/manual/en/ref.dba.php try adding '--with-gdbm' (for example - it changes depending on exactly which database you are using). -- 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] Problem importing large db to mysql in windows
I'm running a local web server for development on my Win ME machine using apache, mysql 3.23.38, and php4. I've been copying my mysql database that is online to my local one every once in a while. When the database starting getting greater than 1mb I remember the mysql filename.sql wouldn't work anymore and I had to use mysqldump filename.sql to dump the db to a file. I always used phpMyAdmin to run the sql file and import everything to my local db. My problem is that now my database is greater than 2mb and phpMyAdmin no longer wants to run my .sql file. It just skips straight to SQL command executed successfully but says No Tables, so obviously it isn't even trying to run the file. This is almost exactly what was happening on the dump end before I started using mysqldump. So, what's the IMPORT equivalent of mysqldump and how do I run it on windows? - Doug Schasteen
Re: [PHP-DB] Problem importing large db to mysql in windows
It sounds like the problem you are having is the same one I had. There is a variable in the php.ini called upload_max_filesize that the default max size in here is 2Mb, so when importing or exporting a dump file that is over 2Mb, it will not work. Try changing this in your php.ini file and see if that fixes it. You may need to restart the server that PHPMyAdmin is running on to get it to register. Let us know if it still does not work. Thanks. Maureen Biorn Doug Schasteen [EMAIL PROTECTED] said: I'm running a local web server for development on my Win ME machine using apache, mysql 3.23.38, and php4. I've been copying my mysql database that is online to my local one every once in a while. When the database starting getting greater than 1mb I remember the mysql filename.sql wouldn't work anymore and I had to use mysqldump filename.sql to dump the db to a file. I always used phpMyAdmin to run the sql file and import everything to my local db. My problem is that now my database is greater than 2mb and phpMyAdmin no longer wants to run my .sql file. It just skips straight to SQL command executed successfully but says No Tables, so obviously it isn't even trying to run the file. This is almost exactly what was happening on the dump end before I started using mysqldump. So, what's the IMPORT equivalent of mysqldump and how do I run it on windows? - Doug Schasteen -- -- 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] Problem importing large db to mysql in windows
It works great! However, even though my .sql file was only 2.4 mb, it took nearly 15 minutes to import it all. I expect to be working with 20mb files in the not too distant future. Will it really take over two hours? Is this mysql's fault or the fault of my POS 500mhz WinME machine? Anyone know? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 01, 2001 10:41 AM To: Doug Schasteen; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Problem importing large db to mysql in windows It sounds like the problem you are having is the same one I had. There is a variable in the php.ini called upload_max_filesize that the default max size in here is 2Mb, so when importing or exporting a dump file that is over 2Mb, it will not work. Try changing this in your php.ini file and see if that fixes it. You may need to restart the server that PHPMyAdmin is running on to get it to register. Let us know if it still does not work. Thanks. Maureen Biorn Doug Schasteen [EMAIL PROTECTED] said: I'm running a local web server for development on my Win ME machine using apache, mysql 3.23.38, and php4. I've been copying my mysql database that is online to my local one every once in a while. When the database starting getting greater than 1mb I remember the mysql filename.sql wouldn't work anymore and I had to use mysqldump filename.sql to dump the db to a file. I always used phpMyAdmin to run the sql file and import everything to my local db. My problem is that now my database is greater than 2mb and phpMyAdmin no longer wants to run my .sql file. It just skips straight to SQL command executed successfully but says No Tables, so obviously it isn't even trying to run the file. This is almost exactly what was happening on the dump end before I started using mysqldump. So, what's the IMPORT equivalent of mysqldump and how do I run it on windows? - Doug Schasteen -- -- 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] Problem importing large db to mysql in windows
I have several files I import daily using phpMyAdmin, the biggest of which is over 4Mb and it only takes 5-10 seconds, but both machines (my pc-750Mhz Win98 and the server) are on the same network. If you are using dialup to access it, that could be why it is taking longer. Otherwise, I would look somewhere else for the problem. Maureen Biorn Doug Schasteen [EMAIL PROTECTED] said: It works great! However, even though my .sql file was only 2.4 mb, it took nearly 15 minutes to import it all. I expect to be working with 20mb files in the not too distant future. Will it really take over two hours? Is this mysql's fault or the fault of my POS 500mhz WinME machine? Anyone know? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 01, 2001 10:41 AM To: Doug Schasteen; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Problem importing large db to mysql in windows It sounds like the problem you are having is the same one I had. There is a variable in the php.ini called upload_max_filesize that the default max size in here is 2Mb, so when importing or exporting a dump file that is over 2Mb, it will not work. Try changing this in your php.ini file and see if that fixes it. You may need to restart the server that PHPMyAdmin is running on to get it to register. Let us know if it still does not work. Thanks. Maureen Biorn Doug Schasteen [EMAIL PROTECTED] said: I'm running a local web server for development on my Win ME machine using apache, mysql 3.23.38, and php4. I've been copying my mysql database that is online to my local one every once in a while. When the database starting getting greater than 1mb I remember the mysql filename.sql wouldn't work anymore and I had to use mysqldump filename.sql to dump the db to a file. I always used phpMyAdmin to run the sql file and import everything to my local db. My problem is that now my database is greater than 2mb and phpMyAdmin no longer wants to run my .sql file. It just skips straight to SQL command executed successfully but says No Tables, so obviously it isn't even trying to run the file. This is almost exactly what was happening on the dump end before I started using mysqldump. So, what's the IMPORT equivalent of mysqldump and how do I run it on windows? - Doug Schasteen -- -- 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]
[PHP-DB] Multiple Entry
I have some data in a table like this: ++--+ | services | machine_name | ++--+ | MS Exchange Server and BDC | MAIL | | Microsoft Exchange for UA | UAMAIL1 | | Microsoft Exchange for UA | UAMAIL2 | | Microsoft Exchange for UA | UAMAIL3 | ++--+ As you can see, there are same entry for the services column. So If I to display in php : select services from table; then I will get three same entry. Is there any way, I can get only one output.But somehow I have to incorpate it with the other data in that column, which doesn't have multiple entry. Any hint? thanks in advance. -- 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] Multiple Entry
Ya, I understand that. But when I want to view all services then I get three output for Microsoft Exchange. I want only one at that time. And click that service and I can get the machine name. On Wed, 1 Aug 2001, John Pickett wrote: If I understand you correctly you might try a query like: select services from tabl where machine_name=UAMAIL3; That should only return one result based on the data you gave... My 2 ¢ John Pickett http://www.bvstudios.com/ Co-Author: Inside Dreamweaver 4 http://www.amazon.com/exec/obidos/ASIN/0735710848/xtremist - Original Message - From: Sharif Islam [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 01, 2001 10:30 AM Subject: [PHP-DB] Multiple Entry I have some data in a table like this: ++--+ | services | machine_name | ++--+ | MS Exchange Server and BDC | MAIL | | Microsoft Exchange for UA | UAMAIL1 | | Microsoft Exchange for UA | UAMAIL2 | | Microsoft Exchange for UA | UAMAIL3 | ++--+ As you can see, there are same entry for the services column. So If I to display in php : select services from table; then I will get three same entry. Is there any way, I can get only one output.But somehow I have to incorpate it with the other data in that column, which doesn't have multiple entry. Any hint? thanks in advance. -- 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] ODBC and PHP
Ariadne, This appears to be an error in the driver itself, but without a trace I cannot be sure. Best regards, Andrew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 01, 2001 10:52 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] ODBC and PHP The error message is: - Cadastro de Fornecedor Warning: SQL error: [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionTransact (TransactNamedPipe())., SQL state 01000 in SQLExecDirect in c:\inetpub\inventario\cadastro\fornecedor.php on line 364 Warning: Supplied argument is not a valid ODBC result resource in c:\inetpub\inventario\cadastro\fornecedor.php on line 366 Warning: SQL error: [Microsoft][ODBC SQL Server Driver]Communication link failure, SQL state 08S01 in SQLExecDirect in c:\inetpub\inventario\cadastro\fornecedor.php on line 386 - But the trace works fine. To make it work again I have to remove the configuration from the ODBC and create again. []s Ariadne Mensagem original Ariadne, What is the exact error you get? Among other debugging tricks, you can get an ODBC trace from the ODBC Administrator control panel (if using Win32 on client side) and look at where the API calls are failing. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 6:30 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] ODBC and PHP I´m using PHP 4 with ODBC and sometimes I get a response that was unable to connect to the MSSQL database. Then I go to the ODBC configuration to test the connection and I get a response that everything is working fine, but my pages still can´t connect. Is that normal? What can I do? I´m using NT Server 4 with apache 1.3. []s Ariadne -- 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] Re: Linux, Oracle 8.1.5, configure: libclntsh.so: Don't use llseek; slpmprodstab undefined
Installing a current libtools rpm seems to have corrected the situation. Rick Rick Hickerson wrote: I'm at wit's end. ../php-4.0.6/configure gives an error, and debug.log says libclntsh.so: don't use llseek, use lseek64, and slpmprodstab is undefined. I've looked everywhere. All of php.org. All of this newsgroup. The linux forum at Oracle TechNet. The one lead I found was a reference to an Oracle note 68151.1, which apparently no longer exists on their site. I see a gensyslib in $ORACLE_HOME/bin which apparently creates $ORACLE_HOME/lib/sysliblist. This latter contains one line: -ldl -lm -lpthread. I note that -plthread isn't in the command line producing the error in debug.log. Should it be? How do I get it there? TIA for any advice. (I'm not a C programmer, just a DBA trying to get something working) My debug.log is below. Rick -- Rick HickersonT(978)659-4901 _\|/_ Agilent Technologies IT Consulting Engineer (646)452-7668 /|\ Innovating the HP Way 3000 Minuteman Rd, MS 596 (877)868-9829 Andover, MA 01810IT | Information Technology CONFIGURE: './configure' '--with-mysql' '--with-apxs' '--with-pgsql' '--with-oci8' '--prefix=/usr' CC: gcc CFLAGS: -g -O2 CPPFLAGS:-DLINUX=22 -DUSE_HSREGEX -DUSE_EXPAT -DNO_DL_NEEDED -DSUPPORT_UTF8 CXX: CXXFLAGS: INCLUDES:-I/opt/php/php-4.0.6/@includedir@ -I$(top_builddir)/Zend -I/opt/php/php-4.0.6/ext/mysql/libmysql -I/opt/oracle/app/oracle/product/8.1.5/rdbms/demo -I/opt/oracle/app/oracle/product/8.1.5/network/public -I/opt/oracle/app/oracle/product/8.1.5/plsql/public LDFLAGS: -Wl,-rpath,/opt/oracle/app/oracle/product/8.1.5/lib -L/opt/oracle/app/oracle/product/8.1.5/lib -Wl,-rpath,/usr/lib/pgsql -L/usr/lib/pgsql LIBS: -lpq -lm -ldl -lcrypt -lresolv -lm -ldl -lnsl -lresolv -lclntsh DLIBS: SAPI: apache PHP_RPATHS: /opt/oracle/app/oracle/product/8.1.5/lib /usr/lib/pgsql uname -a: Linux tackroom.and.agilent.com 2.4.3-20mdk #1 Sun Apr 15 23:03:10 CEST 2001 i686 unknown gcc -o conftest -g -O2 -DLINUX=22 -DUSE_HSREGEX -DUSE_EXPAT -DNO_DL_NEEDED -DSUPPORT_UTF8 -Wl,-rpath,/opt/oracle/app/oracle/product/8.1.5/lib -L/opt/oracle/app/oracle/product/8.1.5/lib -Wl,-rpath,/usr/lib/pgsql -L/usr/lib/pgsql conftest.c -lpq -lm -ldl -lcrypt -lresolv -lm -ldl -lnsl -lresolv -lclntsh 15 /usr/lib/gcc-lib/i586-mandrake-linux-gnu/2.96/../../../libclntsh.so: the `llseek' function may be dangerous; use `lseek64' instead. /usr/lib/gcc-lib/i586-mandrake-linux-gnu/2.96/../../../libclntsh.so: undefined reference to `slpmprodstab'collect2: ld returned 1 exit status -- Rick HickersonT(978)659-4901 _\|/_ Agilent Technologies IT Consulting Engineer (646)452-7668 /|\ Innovating the HP Way 3000 Minuteman Rd, MS 596 (877)868-9829 Andover, MA 01810IT | Information Technology -- 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: Multiple Entry
Sharif Islam [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Is there any way, I can get only one output.But somehow I have to
incorpate it with the other data in that column, which doesn't have
multiple entry. Any hint? thanks in advance.
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
html
head
titleSample code: Removal of duplicate categories by associative
array/title
style type=text/css
body {
font-family: Verdana, Arial, sans-serif;
}
.service {
font-size: small;
color: #00;
margin-top: 20px;
}
.machine {
font-size: smaller;
color: #743A44;
margin-left: 20px;
margin-top: 5px;
}
/style
/head
body
?php
$conn = mysql_connect(host, user, pwd);
$result = mysql_db_query(db,
SELECT
.services AS svc, // set aliases for brevity
.machine_name AS mach
.FROM table
);// ORDER BY is
unneccessary
// parse
$list = array();
while ($row = mysql_fetch_array($result))
$list[$row[svc]][] = $row[mach];
// print
echo \nul;
foreach($list as $key = $machines) {
echo \n\tli class='service'$keybr\n\t\tspan class='machine';
$first = true;
foreach($machines as $name) {
echo ($first ? : | ).$name;// could easily make this a
hyperlink
$first = false;
}
echo /span\n\t/li;
}
echo \n/ul;
?
/body
/html
--
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] INSERT Won't Insert
This should be a simple insert. I must be missing something because I keep getting: Couldn't execute query. What am I missing? ? error_reporting(15); $db_name = dbname; $table_name=company; $connection = @mysql_connect(servname,username, password)or die (Couldn't connect.); $db = @mysql_select_db($db_name, $connection) or die (Couldn't select database.); $add_co_sql = INSERT INTO $table_name (CompanyID, CompanyName, Address, City, StateorProvince, PostalCode,Region,Country,WebSite) VALUES (\\, \$CompanyName\,\$Address\,\$City\,\$StateorProvince\,\$PostalCode\ ,\$Region\,\$Country\,\$WebSite\ ; $result = @mysql_query($add_co_sql, $connection) or die (Couldn't execute query.); ? -- 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] INSERT Won't Insert
If you simplify the query you'll see your error...all those escaped were
giving me a headache hehe
snip
*modified*
$add_co_sql = INSERT INTO $table_name
(CompanyID, CompanyName, Address, City, StateorProvince,
PostalCode,Region,Country,WebSite)VALUES
('','$CompanyName','$Address','$City','$StateorProvince','$PostalCode','$Reg
ion','$Country','$WebSite';
/snip
If you're still missing it, you're missing a ) after '$WebSite'
Sincerely,
Craig Vincent
--
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] Problem importing large db to mysql in windows
I'm running a local web server for development on my Win ME machine using apache, mysql 3.23.38, and php4. I've been copying my mysql database that is online to my local one every once in a while. When the Since you're using relatively recent version of MySQL might I suggest you setting up the MySQL replication system (chap 11 in the manual if I remember correctly). You don't have to be constantly receiving updates however if setup correctly you can use the LOAD table FROM master command to grab the most recent copy of the table you want in a single command. Sincerely, Craig Vincent -- 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] INSERT Won't Insert
Steve
I believe you're missing the closing bracket ) after $Website.
I think it's clearer if you use single quotes (') rather than double quotes
and then having to escape them.
Something like:
INSERT INTO $table_name
(CompanyID, CompanyName, Address, City, StateorProvince,
PostalCode,Region,Country,WebSite)
VALUES ('',
'$CompanyName',
'$Address',
'$City',
'$StateorProvince',
'$PostalCode',
'$Region',
'$Country',
'$WebSite');
regards
--
Jason Wong
Gremlins Associates
- Original Message -
From: Steve Fitzgerald [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 02, 2001 2:35 AM
Subject: [PHP-DB] INSERT Won't Insert
This should be a simple insert. I must be missing something because I keep
getting: Couldn't execute query.
What am I missing?
?
error_reporting(15);
$db_name = dbname;
$table_name=company;
$connection = @mysql_connect(servname,username, password)or die
(Couldn't connect.);
$db = @mysql_select_db($db_name, $connection) or die (Couldn't select
database.);
$add_co_sql = INSERT INTO $table_name
(CompanyID, CompanyName, Address, City, StateorProvince,
PostalCode,Region,Country,WebSite)
VALUES
(\\,
\$CompanyName\,\$Address\,\$City\,\$StateorProvince\,\$PostalCode\
,\$Region\,\$Country\,\$WebSite\
;
$result = @mysql_query($add_co_sql, $connection) or die (Couldn't execute
query.);
?
--
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] Re: dba_open
Well, I have made it a little further. I could not get it to configure using the --with-db2 switch even after installing the sleepycat software. I did succeed in compiling php using the --with-gdbm switch. After that I had a module called dba.so. I put that in the proper place and changed the line in the php.ini file and it now recognizes the dba_open() function call. Now it gives me this error message: Warning: driver initialization failed in pathdb.php on line 6 and it does not open the database. Any and all help are greatly appreciated. Thanks, Patrick Patrick Callihan [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... HI, I have compiled php4 with the following command: /configure' '--with-mysql' '--with-apache=../apache_1.3.20' '--enable-track-vars' '--enable-tans-sid' '--enable-dba The function dba_open() does not work for me. I get the following error message: Fatal error: Call to undefined function: dba_open() It is not clear to me how I cause these functions to be available to me. I have perused the online documentation and I have tried several different switches on the command line compilation. All help is greatly appreciated. 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] Re: dba_open
With the help of another friend, I now have it working. The problem was I needed to make the directory and file group apache and then give them both group write permission. It works! I thought I would post this in case someone else ran across the same problem. Patrick Patrick Callihan [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Well, I have made it a little further. I could not get it to configure using the --with-db2 switch even after installing the sleepycat software. I did succeed in compiling php using the --with-gdbm switch. After that I had a module called dba.so. I put that in the proper place and changed the line in the php.ini file and it now recognizes the dba_open() function call. Now it gives me this error message: Warning: driver initialization failed in pathdb.php on line 6 and it does not open the database. Any and all help are greatly appreciated. Thanks, Patrick Patrick Callihan [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... HI, I have compiled php4 with the following command: /configure' '--with-mysql' '--with-apache=../apache_1.3.20' '--enable-track-vars' '--enable-tans-sid' '--enable-dba The function dba_open() does not work for me. I get the following error message: Fatal error: Call to undefined function: dba_open() It is not clear to me how I cause these functions to be available to me. I have perused the online documentation and I have tried several different switches on the command line compilation. All help is greatly appreciated. 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] Avoiding Multiple IDs
What is the best method for avoiding multiple ids for the same information. For example: I have a table name company that has unique ids. The CompanyID are tied to a table name contacts which have unique ids (ContactID). The problem seems to be that if I add a contact with an existing CompanyName then I will get multiple ids for the same CompanyName. I've considered using a drop-down menu for CompanyName when adding/modifying contacts, but it seems as if I might run into the same problem of multiple ids. -- 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] UPDATE Not Updating
I belive this UPDATE should work, but it isn't. I get no errors. I have also tried using FieldName= '$Fieldname', but that does not seem to work either. $table_name = contacts; $update_contact_sql = UPDATE $table_name SET FirstName =\$FirstName\, LastName = \$LastName\, Title = \$Title\, WorkPhone = \$WorkPhone\, HomePhone = \$HomePhone\, Mobile = \$Mobile\, EmailName = \$EmailName\, Birthday = \$Birthday\ WHERE ContactID = \$ContactID\ ; $result = @mysql_query($update_contact_sql, $connection) or die (Couldn't execute query.); -- 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] UPDATE Not Updating
Isn't PHP/MySQL case sensitive? Are all the column names the correct case? You could also try changing your die bit to or die (mysql_error()); that will echo the MySQL error message. HTH! Dave -Original Message- From: Steve Fitzgerald [mailto:[EMAIL PROTECTED]] Sent: 01 August 2001 22:25 To: [EMAIL PROTECTED] Subject: [PHP-DB] UPDATE Not Updating I belive this UPDATE should work, but it isn't. I get no errors. I have also tried using FieldName= '$Fieldname', but that does not seem to work either. $table_name = contacts; $update_contact_sql = UPDATE $table_name SET FirstName =\$FirstName\, LastName = \$LastName\, Title = \$Title\, WorkPhone = \$WorkPhone\, HomePhone = \$HomePhone\, Mobile = \$Mobile\, EmailName = \$EmailName\, Birthday = \$Birthday\ WHERE ContactID = \$ContactID\ ; $result = @mysql_query($update_contact_sql, $connection) or die (Couldn't execute query.); -- 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] [Q] PHP on Linux, Oracle on Win32
G'Day All, I need to establish connectivity between a Debain Linux box running PHP 4.06 and Oracle 8i running on a Win32 box. Can someone point me at some FAQ's or other help. At present I have managed to get MS-SQL 2K going using TDS (Tabular Data Stream). Could TDS also be used for Oracle? TIA -- Donovan -- Donovan J. Edye [www.edye.wattle.id.au] Namadgi Systems [www.namsys.com.au] Voice: +61 2 6285-3460 Fax: +61 2 6285-3459 TVisualBasic = Class(None); Heard just before the 'Big Bang': ...Uh Oh -- GXExplorer [http://www.gxexplorer.org] Freeware Windows Explorer replacement. Also includes freeware delphi windows explorer components. --
[PHP-DB] Limit Select Field Characters?
I have a timestamp field that looks like this 0109011754 but I only want to compare 010801 when doing a SELECT. Is there a way I can do this? Thanks. Jeff Oien -- 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] Limit Select Field Characters?
$fulldate = date(dmy); echo $fulldate; -Original Message- From: Jeff Oien [mailto:[EMAIL PROTECTED]] Sent: 01 August 2001 23:34 To: PHP-DB Subject: [PHP-DB] Limit Select Field Characters? I have a timestamp field that looks like this 0109011754 but I only want to compare 010801 when doing a SELECT. Is there a way I can do this? Thanks. Jeff Oien -- 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] InterBase - selecting from a non existing id value?
Hello, is it possible with InterBase to fire a select statement against an empty table witout getting in trouble. if the table X looks like this: id - integer dummy - varchar and if I do now a select like select * from x where id='$id'; I will get the error Warning: InterBase: conversion error from string I have heard that other RDBMs don't run into trouble if you do this? What could I do? Remember $id is an empty value! thx Henning -- 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] Limit Select Field Characters?
left(timestamp,6) - Original Message - From: Jeff Oien [EMAIL PROTECTED] To: PHP-DB [EMAIL PROTECTED] Sent: Wednesday, August 01, 2001 11:33 PM Subject: [PHP-DB] Limit Select Field Characters? I have a timestamp field that looks like this 0109011754 but I only want to compare 010801 when doing a SELECT. Is there a way I can do this? Thanks. Jeff Oien -- 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] REG_EMPTY
What exactly does the error 'REG_EMPTY' mean in PHP? -- -Adam Lundrigan CEO, VPU http://www.vpu-virtual.com/ ICQ # 73617446 [EMAIL PROTECTED]
[PHP-DB] isset() for objects?
Does isset() work for objects? If not, is there a similar function for objects? 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] Re: Limit Select Field Characters?
select * from table where date_format(timestamp, '%y%m%d') = '010801' Jeff Oien [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I have a timestamp field that looks like this 0109011754 but I only want to compare 010801 when doing a SELECT. Is there a way I can do this? Thanks. Jeff Oien -- 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: Avoiding Multiple IDs
Steve Fitzgerald [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... What is the best method for avoiding multiple ids for the same information. For example: I have a table name company that has unique ids. The CompanyID are tied to a table name contacts which have unique ids (ContactID). The problem seems to be that if I add a contact with an existing CompanyName then I will get multiple ids for the same CompanyName. When inserting a new contact, do a search for the company name. If it exists, use the existing id; otherwise, create a new company and get the new id. -- 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: [Q] PHP on Linux, Oracle on Win32
Donovan J. Edye [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... G'Day All, I need to establish connectivity between a Debain Linux box running PHP 4.06 and Oracle 8i running on a Win32 box. Can someone point me at some FAQ's or other help. At present I have managed to get MS-SQL 2K going using TDS (Tabular Data Stream). Could TDS also be used for Oracle? ... I'm not an expert on Oracle by any means, but what is wrong with ora_logon(user@tns, pwd); using the standard PHP Oracle drivers? -- 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 redirect?
I have a form and based off of this form if my user selects option a then I want them to be redirected to another page. If they select option B then I want to continue with my php scrips as it does now. Does any one have any ideas on how I can accomplish this? -- 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 redirect?
Hello!!!
Here try this
if ($DATABASE===Custom)
{
$table=Table1;
}
if ($DATABASE===Return_Log)
{
$table=table=3;
$DATABASE=Return_Log;
echo (HTML);
echo (HEAD);
echo (TITLE $us On Linux Using Apache/TITLE);
echo (/HEAD);
echo (BODY BGCOLOR=#00 LINK=#5A72CC VLINK=#5A72CC ALINK=#ff$
echo (H1BPlease wait while loading RA Database/B/H1\n);
echo (meta http-equiv=refresh
content=2;URL=../show.php?DATABASE=$DATABASEHOSTNAME=$HOSTNAMEtable=$table);
exit();
}
As you can see your using a IF...Statement
I too have this coming from a form.This simple code decides which Database is
selected along with the TableThat way I can use the display code and everything
else for other DatabasesPlus you can use this with usernames and passwordsSO
what if the user can see his or her password
why I have exit ();...I don't remember why!?!?!?! AHAHAHAHAHAHHAit works fine for
me
Also you can pass variables to the sending pagewith
index.php?WHATEVER=$WHATEVER...on the redirectIt doesn't take long at all But I
like to tell the user where the hell there going.
Since the form has passed the Variables over to the next page( or the page after the
form)...these variable will be here to move on to the next page...But you must use
them...or they are lost.
Dan
[EMAIL PROTECTED]
MYSQL ADMIN
Webmaster [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
I have a form and based off of this form if my user selects option a then I
want them to be redirected to another page. If they select option B then I
want to continue with my php scrips as it does now.
Does any one have any ideas on how I can accomplish this?
--
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]
Fw: [PHP-DB] PHP redirect?
OPPS WRONG SENDER HAHAHAHAHA!
I'm a little absent minded
Hello!!!
Here try this
if ($DATABASE===Custom)
{
$table=Table1;
}
if ($DATABASE===Return_Log)
{
$table=table=3;
$DATABASE=Return_Log;
echo (HTML);
echo (HEAD);
echo (TITLE $us On Linux Using Apache/TITLE);
echo (/HEAD);
echo (BODY BGCOLOR=#00 LINK=#5A72CC VLINK=#5A72CC ALINK=#ff$
echo (H1BPlease wait while loading RA Database/B/H1\n);
echo (meta http-equiv=refresh
content=2;URL=../show.php?DATABASE=$DATABASEHOSTNAME=$HOSTNAMEtable=$table);
exit();
}
As you can see your using a IF...Statement
I too have this coming from a form.This simple code decides which Database is
selected along with the TableThat way I can use the display code and everything
else for other DatabasesPlus you can use this with usernames and passwordsSO
what if the user can see his or her password
why I have exit ();...I don't remember why!?!?!?! AHAHAHAHAHAHHAit works fine for
me
Also you can pass variables to the sending pagewith
index.php?WHATEVER=$WHATEVER...on the redirectIt doesn't take long at all But I
like to tell the user where the hell there going.
Since the form has passed the Variables over to the next page( or the page after the
form)...these variable will be here to move on to the next page...But you must use
them...or they are lost.
Dan
[EMAIL PROTECTED]
MYSQL ADMIN
Webmaster [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
I have a form and based off of this form if my user selects option a then I
want them to be redirected to another page. If they select option B then I
want to continue with my php scrips as it does now.
Does any one have any ideas on how I can accomplish this?
--
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 redirect?
?
if $option_button == 1) {
header(Location: some_page_or_other.php);
} else {
header(Location: some_other_page_you_choose.php);
}
?
that's all you need - make sure the form on the previous page has two
radiobuttons, each with the same name of option_button and each has a
value - one is 1 and the other is 2.
HTH :-)
Dave
-Original Message-
From: Webmaster [mailto:[EMAIL PROTECTED]]
Sent: 02 August 2001 04:45
To: [EMAIL PROTECTED]
Subject: [PHP-DB] PHP redirect?
I have a form and based off of this form if my user selects option a
then I
want them to be redirected to another page. If they select option B then
I
want to continue with my php scrips as it does now.
Does any one have any ideas on how I can accomplish this?
--
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]
