[PHP] cxml
Does anyone have examples or know of documentation in order to receive and respond to cxml punchout requests. I'm attempting to integrate my cart with a catalog however have not done much coding with cxml or xml. Thanks in advance.
[PHP] Re: [users@httpd] Favorite Linux Distribution
The Disguised Jedi wrote: Hello all - I've been a list member for a while, helped out some people, and asked some questions. But, today I have a completely off topic, but somewhat relevant question for y'all. What is your favorite Linux distribution? What would you recommend for my situation? Not sure what your situation is, but I'll answer anyways. I'm brand new to Linux. I'm just trying to learn how it works, but I think I'll catch on quick. I'm looking for the one with the most capability, and also one to run my development instance of Apache 2.0 on. I've been looking at either RedHat or Fedora. Is this a good choice? I'm truly drawing a blank, and I've searched Google, but never really found anything extremely useful. Please help me, an old Windows veteran, escape the Microsoft box! First off, do NOT go RedHat or Fedora. Both are abominations of Linuxdom and are as bloated as Windows. My recommendation for a good binary install distro is Slackware. Minimal set of tools installed for a base system so there is no bloat right off the bat. Gentoo is another good one, but rather more advanced the Slack although the tools are very well documented and once you learn them you'll never consider going to another distro. I really think Gentoo is that good. I use it myself for all my workstation and server needs. Good luck on finding one that suits you, though. Thanks a ton!! signature.asc Description: OpenPGP digital signature
[PHP] First day of the month
I'm trying to make a custom calendar script for my school district, and I'm hitting a little obstacle. I know how I can accomplish what I'm after, but it's a lot of extra coding. I'm wondering if there's a simple way to figure out what day of the week the first day of the month lands on. I can take the info pulled with date() and use several switch() and if statements, but that's ugly. Anyone have any suggestions? Thanks! ~ David -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] First day of the month
On Tue, 2004-08-03 at 11:09, Matthew Sims wrote: I'm trying to make a custom calendar script for my school district, and I'm hitting a little obstacle. I know how I can accomplish what I'm after, but it's a lot of extra coding. I'm wondering if there's a simple way to figure out what day of the week the first day of the month lands on. I can take the info pulled with date() and use several switch() and if statements, but that's ugly. Anyone have any suggestions? Thanks! ~ David You mean like: $firstWkDay = date(l, mktime(0,0,0,7,1,2004)); That's much simpler that what I had in my head. Thanks so much! ~ David -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Apache directive to expand unqualified host names?
Matt wrote: Hello, I am looking for an Apache directive to automatically expand an unqualified host name in a web browser client. Here's an example of what I mean by this: User, in web browser, enters (these are all hypothetical examples): http://automobiles/trucks/ automobiles actually fully qualifies to automobiles.transportation.com. I want the Apache server to convert the text entered above to the following once the browser loads the web page: http://automobiles.transportation.com/trucks/ I understand that one can configure an Apache server to do this, probably with an Apache directive? If so, which one? Is this on an Intranet where you would resolve 'automobiles' to an IP address? Thanks for any help, -Matt -- Remove the obvious text (including the dash) to email me. -- Phil Frisbie, Jr. Hawk Software http://www.hawksoft.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Can't Get PHP Configured Properly To Use SQLite
Hello All, I am having a devil of a time getting PHP configured to work properly with SQLite. I am running PHP 4.3.3 on Redhat ES 2.1. My configure statement for PHP is below. I have run: pear download http://pecl.php.net/get/SQLite-1.0.tgz, no problem here. Then I run: pear install SQLite-1.0.tgz and get a make error of: /tmp/tmpACnhIu/SQLite-1.0/sqlite.c:29:17: php.h: No such file or directory /tmp/tmpACnhIu/SQLite-1.0/sqlite.c:30:21: php_ini.h: No such file or directory /tmp/tmpACnhIu/SQLite-1.0/sqlite.c:31:31: ext/standard/info.h: No such file or directory make: *** [sqlite.lo] Error 1 `make' failed The entire output is below. Any advice would be appreciated. Thanks! JR [EMAIL PROTECTED] html]# pear install SQLite-1.0.tgz 48 source files, building running: phpize You should update your `aclocal.m4' by running aclocal. Configuring for: PHP Api Version: 20020918 Zend Module Api No: 20020429 Zend Extension Api No: 20021010 building in /var/tmp/pear-build-root/SQLite-1.0 running: /tmp/tmpACnhIu/SQLite-1.0/configure creating cache ./config.cache checking host system type... i686-pc-linux-gnu checking for gcc... gcc checking whether the C compiler (gcc ) works... yes checking whether the C compiler (gcc ) is a cross-compiler... no checking whether we are using GNU C... yes checking whether gcc accepts -g... yes checking whether gcc and cc understand -c and -o together... yes checking if compiler supports -R... no checking if compiler supports -Wl,-rpath,... yes checking for PHP prefix... /usr checking for PHP includes... -Idir=/usr/include/php -Idir=/usr/include/php/main -Idir=/usr/include/php/Zend -Idir=/usr/include/php/TSRM checking for PHP extension directory... /usr/lib/20020429 checking how to run the C preprocessor... gcc -E checking for gawk... gawk checking for sqlite support... yes, shared checking size of char *... 4 checking for lemon... no checking for usleep... yes checking for nanosleep... yes checking for time.h... yes checking for Cygwin environment... no checking for mingw32 environment... no checking build system type... i686-pc-linux-gnu checking for ld used by GCC... /usr/bin/ld checking if the linker (/usr/bin/ld) is GNU ld... yes checking for /usr/bin/ld option to reload object files... -r checking for BSD-compatible nm... /usr/bin/nm -B checking whether ln -s works... yes checking how to recognise dependant libraries... pass_all checking for object suffix... o checking for executable suffix... no checking command to parse /usr/bin/nm -B output... ok checking for dlfcn.h... yes checking for ranlib... ranlib checking for strip... strip checking for objdir... .libs checking for gcc option to produce PIC... -fPIC checking if gcc PIC flag -fPIC works... yes checking if gcc static flag -static works... yes checking if gcc supports -c -o file.o... yes checking if gcc supports -c -o file.lo... yes checking if gcc supports -fno-rtti -fno-exceptions... yes checking whether the linker (/usr/bin/ld) supports shared libraries... yes checking how to hardcode library paths into programs... immediate checking whether stripping libraries is possible... yes checking dynamic linker characteristics... GNU/Linux ld.so checking if libtool supports shared libraries... yes checking whether -lc should be explicitly linked in... no creating libtool updating cache ./config.cache creating ./config.status creating config.h running: make sed -e s/--VERS--/2.8.3/ -e s/--ENCODING--/ISO8859/ /tmp/tmpACnhIu/SQLite-1.0/libsqlite/src/sqlite.h.in /tmp/tmpACnhIu/SQLite-1.0/libsqlite/src/sqlite.h /bin/sh /var/tmp/pear-build-root/SQLite-1.0/libtool --mode=compile gcc -I/tmp/tmpACnhIu/SQLite-1.0/libsqlite/src -I. -I/tmp/tmpACnhIu/SQLite-1.0 -DPHP_ATOM_INC -I/var/tmp/pear-build-root/SQLite-1.0/include -I/var/tmp/pear-build-root/SQLite-1.0/main -I/tmp/tmpACnhIu/SQLite-1.0 -Idir=/usr/include/php -Idir=/usr/include/php/main -Idir=/usr/include/php/Zend -Idir=/usr/include/php/TSRM -DHAVE_CONFIG_H -g -O2 -prefer-pic -c /tmp/tmpACnhIu/SQLite-1.0/sqlite.c -o sqlite.lo gcc -I/tmp/tmpACnhIu/SQLite-1.0/libsqlite/src -I. -I/tmp/tmpACnhIu/SQLite-1.0 -DPHP_ATOM_INC -I/var/tmp/pear-build-root/SQLite-1.0/include -I/var/tmp/pear-build-root/SQLite-1.0/main -I/tmp/tmpACnhIu/SQLite-1.0 -Idir=/usr/include/php -Idir=/usr/include/php/main -Idir=/usr/include/php/Zend -Idir=/usr/include/php/TSRM -DHAVE_CONFIG_H -g -O2 -c /tmp/tmpACnhIu/SQLite-1.0/sqlite.c -fPIC -DPIC -o sqlite.lo /tmp/tmpACnhIu/SQLite-1.0/sqlite.c:29:17: php.h: No such file or directory /tmp/tmpACnhIu/SQLite-1.0/sqlite.c:30:21: php_ini.h: No such file or directory /tmp/tmpACnhIu/SQLite-1.0/sqlite.c:31:31: ext/standard/info.h: No such file or directory make: *** [sqlite.lo] Error 1 `make' failed './configure' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--include' 'dir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr
[PHP] adodb and php5
Does anyone had tested ADODB with php5? I can make a query, print the recordcount but when i try to show the result i got nothing ? require (some\\adodb.inc.php); $conn = ADONewConnection('mysql'); $conn-PConnect('some', 'some', 'some', 'some'); $seleciona = select campo from tabela ; $qry = $conn-Execute($seleciona); if (!$qry) { echo $conn-ErrorMsg(); echo erro; } else { while (!$qry-EOF) { echo $qry-fields['campo'] . br; $qry-MoveNext(); } } ? any help? thanks
Re: [PHP] adodb and php5
I use adodb cause I need an abstraction layer for database cause the application can run under mysql, mssql, oracle and pgsql. so i have one config file that has the parameters for the conection. this is the reason for me use adodb layer. now, about ADONewConnection(), this function is from adodb layer. php.weblogs.com/adodb - Original Message - From: Jay Blanchard [EMAIL PROTECTED] To: Gilberto Garcia Jr. [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, September 08, 2003 5:45 PM Subject: RE: [PHP] adodb and php5 [snip] Does anyone had tested ADODB with php5? I can make a query, print the recordcount but when i try to show the result i got nothing ? require (some\\adodb.inc.php); $conn = ADONewConnection('mysql'); $conn-PConnect('some', 'some', 'some', 'some'); [/snip] You do not need the ADODB connection if you are using MySQL. Are you connecting to Access or MS SQL? If you are using MySQL look at http://www.php.net/mysql_connect . For instance, the function you use above ADONewConnection() does not exist as a PHP function. Do you declare the function in adodb.inc.php? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Use of php_value in .htaccess is not working
Hello Everyone, I am running Red Hat Enterprise Linux ES release 2.1 (Panama). Originally I was using the Red Hat PHP package. This package was not the most current version so I removed it and compiled PHP 4.3.3. Since doing this I am unable to set things like path using php_value in a .htaccess file. The apache config is the same Red Hat default that is in use on other boxes that are not having this problem. The only difference between this box and boxes without the issue is the fact that I compiled the 4.3.3 rather than going with the Red hat package. The configure options I used are below. I can do non-PHP things with the .htacess file like setup basic authentication from a password file, so I know the .htaccess files are being parsed. Also Apache is unchanged from when this was not an issue. The only thing changed is the removal of the old PHP install and re-install with 4.3.3. Any help would be greatly appreciated. Thanks, JR - John Rudnick RHCE #808003122507415 MySQL Certification #206067847 SallyJo, Inc., provides Top Notch Web Hosting Programming! Ask me about Dedicated Hosting starting at just $89 per month. ./configure --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --include dir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --prefix=/usr --with-config-file-path=/etc --enable-force-cgi-redirect --disable-debug --enable-pic --disable-rpath --enable-inline-optimization --with-bz2 --with-db3 --with-exec-dir=/usr/bin --with-freetype-dir=/usr --with-png-dir=/usr --with-gd --enable-gd-native-ttf --with-ttf --with-gdbm --with-gettext --with-ncurses --with-gmp --with-iconv --with-jpeg-dir=/usr --with-mm --with-openssl --with-png --with-regex=system --with-xml --with-expat-dir=/usr --with-zlib --with-layout=GNU --enable-bcmath --enable-debugger --enable-exif --enable-ftp --with-pear=/usr/share/pear --enable-magic-quotes --enable-safe-mode --enable-sockets --enable-sysvsem --enable-sysvshm --enable-discard-path --enable-track-vars --enable-trans-sid --enable-yp --enable-wddx --without-oci8 --with-mysql --enable-memory-limit --enable-bcmath --enable-shmop --enable-versioning --enable-calendar --enable-dbx --enable-dio --enable-mbstring --enable-mbstr-enc-trans --with-apxs=/usr/sbin/apxs -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] php conditional loop question
I am running php as a client and I have the script running 24/7 to download the data from the connection. Is there a function to see if the connection drops. ?? is there a way to keep restart the function in the script. perhaps use a while and exit the function with a number exit(3) and use that value as the condition in the while? Randy * Thus wrote Randy L Johnson Jr ([EMAIL PROTECTED]): I have done this but it does not seem to ever get to the end of file, I have it inserting the values into the database, it goes for awhile around 12 to 24 hours and then stops inserting the values into the database and I have to restart the script... ah.. so it sound like the connection is dropping at some point thus your socket becomes not usuable. From my previous post you can use http://php.net/stream_set_timeout btw, any reason why your using pfsocketopen vs. just fsocketopen? the pfsocketopen would be only needed if you plan on using that socket on a different page request. Come to think of it the pfsocketopen might even give you problems even if you use the stream_set_timeout function. HTH, Curt -- "I used to think I was indecisive, but now I'm not so sure." -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php . IncrediMail - Email has finally evolved - Click Here
Re: [PHP] error problem
there is something in the php.ini file that turnsthe display errors in browser on and off... Randy ---Original Message--- From: Kris Reid Date: Wednesday, August 13, 2003 10:36:59 PM To: PHP List Subject: Re: [PHP] error problem Sorry the second "echo "Hello world";" was meant to have no semi colon - Original Message - From: "Kris Reid" [EMAIL PROTECTED] To: "PHP List" [EMAIL PROTECTED] Sent: Thursday, August 14, 2003 12:37 PM Subject: [PHP] error problem When I have an error in my code nothing gets written to the screen. If I have ? echo "Hello world"; ? It will works normal. but if I have ? echo "Hello world"; ? Nothing gets written to the browser. Not even the error message. When I run php on the command line I get error messages just not when running through a browser. Where should I start looking for the problem? Thanks Kris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php . IncrediMail - Email has finally evolved - Click Here
Re: [PHP] php conditional loop question
I have done this but it does not seem to ever get to the end offile, I have it inserting the values into the database, it goes for awhile around 12 to 24 hours and then stops inserting the values into the database and I have to restart the script... Randy ---Original Message--- From: Analysis Solutions Date: Wednesday, August 13, 2003 10:02:15 PM To: PHP List Subject: Re: [PHP] php conditional loop question On Wed, Aug 13, 2003 at 09:51:39PM -0400, Randy L Johnson Jr wrote: I have a function that makes a connection to a live datafeed website and downloads data via a pfsockopen() statement. After awhile the data stops feeding but the connection stays open. when the data stops I want to exit out of the function and have the function run again Pseudo code... while (1) { pfsockopen(... blah blah ...); while (not end of file) { get the line and do what you want with it... } } --Dan -- FREE scripts that make web and database programming easier http://www.analysisandsolutions.com/software/ T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y 4015 7th Ave #4AJ, Brooklyn NY v: 718-854-0335 f: 718-854-0409 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php . IncrediMail - Email has finally evolved - Click Here
[PHP] php conditional loop question
ok. This is probably simple but I am not thinking straight. Here is what I want to do I have a function that makes a connection to a live datafeed website and downloads data via a pfsockopen() statement. After awhile the data stops feeding but the connection stays open. when the data stops I want to exit out of the function and have the function run again basically i don't know how to exit out of the function and have the program run the function again I have the program downloading the data and all that so I don't need help with that. I just want to be able to reun the function if the data stops or in more general a certain condition is met. any ideas and comments would be greatly appreciated. Randy -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Trouble connection to Postgres DB
Hi, I have PHP 4.3.1 and PostgreSQL 7.3 running in a Mandrake 9.1 workstation. When trying to connect to the DB, the PHP execution just blocks in pg_connect() call, and it remain blocked for several minutes - until I cancel the request. Sometimes the call completes, but I am not sure it connected sucessfully (did not execute any query). Postmaster is running with -i option and acess permitions are OK. There is no error message at all. Any help? Nelson -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] function is_executable
Hey guys, I made a class to work with file upload. I used the php function is_executable. and in php 4.2.x it works ok, on linux and on windows. Last week I update my php to 4.3.x and this function stop work. In fact I got this error. undefinied function. Does anyone can help? thanks
[PHP] php and mcrypt on windows
How I can use php and mcrypt on windows? I mean. What I have to do to turn php able to use mcrypt function on windows. Thanks
[PHP] php with mcrypt
Hey guys, How can I enable php to work with mcrypt functions? I´m using debian woody linux. I´ve had installed libmcrypt already, from debian cds. But I dont know how to make php understands this lib. thanks --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.465 / Virus Database: 263 - Release Date: 25/03/03 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] fast template class
I´m a newbie on this class. But i´m getting this error. if I define a constant using define('',''); I get template as just if doesnt has parsed anithing. all constants name´s are showed without changing the name per values. So, when i define the constant as a variable $x = ''; it works fine. anyone can help? thanks --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/03 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] login problem
Hi guys. I´m having a problem with a login system. I enter with the correct password and I press the submit button. But, nothing happens. It´s not a typinh mistake, cause when i enter the wrong pass. it returns me an error. What this can be??? thanks --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/03 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RES: [PHP] login problem [solved]
It was a cookie problem. between php and windows. thanks -Mensagem original- De: Chris Hewitt [mailto:[EMAIL PROTECTED] Enviada em: segunda-feira, 17 de maro de 2003 11:45 Para: Gilberto Garcia Jr. Cc: PHP Assunto: Re: [PHP] login problem Gilberto Garcia Jr. wrote: Hi guys. Im having a problem with a login system. I enter with the correct password and I press the submit button. But, nothing happens. Its not a typinh mistake, cause when i enter the wrong pass. it returns me an error. What this can be??? You would need to tell us a lot more about it. The most I can say at the moment is that you have a bug in your code. I suggest you put in some debug code to try to narrow it down a bit more or post the relevant part of the code here and tell us what error you are getting. HTH Chris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/03 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/03 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] adodb + oracle 8i
Somebody here use adodb with oracle? I´m triyng to use that, but I´m noting realize how to estabilish a conection with oracle. I´m getting the folowing error: Fatal error: Call to undefined function: ora_plogon() in e:\inetpub\wwwroot\hosted\EnsinoNet\php\adodb\drivers\adodb-oracle.inc.php on line 105 I´m triyng to conect with oracle with the folowing command: $conn = ADONewConnection('oracle'); $conn-PConnect(false, 'user', 'pass', 'bata_base_name'); can some one help? thanks --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/03 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Avoiding several windows with the same session
If you are using cookies the new window will pick it up. Have the original page change a variable to say that it has loaded then when the new window loads have it check that variable first. -Original Message- From: Roman Sanchez [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 1:57 PM To: [EMAIL PROTECTED] Subject: [PHP] Avoiding several windows with the same session I place session_start(); if (!session_is_registered('somevar')) { header('location: login.php'); exit(); } at the top of all my pages to prevent people to view pages before they log in. However, once thay have logged in succesfully, they can ctrl-U in IE to open a new window. This new window 'inherits' the session id and hence it does not redirects to the login page. Is there any way to avoid this situation so that people cannot have several windows with the same session open? Thanks! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] mail() and sendmail path
You can find this here - http://www.php.net/manual/en/ref.mail.php -Original Message- From: micah lamb [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 5:29 PM To: [EMAIL PROTECTED] Subject: [PHP] mail() and sendmail path Is there any way to declare the path to sendmail locally (on the page that has the mail() function) ? I need to use mail() but do not have access to the php.ini file. Micah -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] getting javascript string values
Hey Guys, How can I get the value of an javascript string and pass it to a php variable? i.e. script var x = test; /script ? $x = // need to get the value of x ? thanks Iced Sun
[PHP] handling files error
Hey guys, I have a red hat 7.3 server running apache and php4. It all seems working fine, but when I try to upload a file through a form I got nothing. I mean, I can ouput the temp name of the file, the final name, size and other stuff. but some functions don´t work. Like If (!is_executable($userfile_temp)) - this don´t block executables files. if I change to If (!is_executable($userfile_name)) - it´s point me that all files is executable. and when i try to move the file from /tmp directory to another directory with move_upload_file function. This func. doesn´t do anything, and doesn´t move the file to the specified directory any help are welcome []´s Iced Sun
Re: [PHP] handling files error
Thanks, but just a little part of the problem was solved. the other part is: why php doesn´t move the upload file to the specified directory, with move_uploaded_file? - Original Message - From: Marek Kilimajer [EMAIL PROTECTED] To: Gilberto Garcia Jr. [EMAIL PROTECTED] Cc: PHP [EMAIL PROTECTED] Sent: Thursday, January 23, 2003 10:36 AM Subject: Re: [PHP] handling files error None of the uploaded files is executable, even if it is some .exe or shell script, simply it does not have the permission to execute. $userfile_name is only the name of the file as it was on the client's machine, there is no such file on your filesystem (unless you create it) Gilberto Garcia Jr. wrote: Hey guys, I have a red hat 7.3 server running apache and php4. It all seems working fine, but when I try to upload a file through a form I got nothing. I mean, I can ouput the temp name of the file, the final name, size and other stuff. but some functions don´t work. Like If (!is_executable($userfile_temp)) - this don´t block executables files. if I change to If (!is_executable($userfile_name)) - it´s point me that all files is executable. and when i try to move the file from /tmp directory to another directory with move_upload_file function. This func. doesn´t do anything, and doesn´t move the file to the specified directory any help are welcome []´s Iced Sun -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Page Rendering
Hi all. I am having some problems with a script which reads information from a database and creates a table. It works in IE but not Netscape. I call myself going through the tags to make sure all that were open were closed because Netscape doesn't like unfinished business. What I have is a script that outputs the previous page, 1, 2, ..., next page link (if there are more than x table items per page). It has worked in both browsers but now I have broke something. :o) Any ideas are appreciated. The code is like this ... ?php function pagelinks($prev_page, $num_pages, $next_page, $page) { // This displays the Previous link if ($prev_page) { echo a href=\$PHP_SELF?page=$prev_page\lt;nbsp;Prev/anbsp;|nbsp;; } // No need to output the page number if there is only one page if ($num_pages1) { for ($i = 1; $i = $num_pages; $i++) { if ($i != $page) { echo a href=$PHP_SELF?page=$i$i/a; } else { echo $i ; } } } // Display the Next link. if ($page != $num_pages) { echo nbsp;|nbsp;a href=\$PHP_SELF?page=$next_page\nbsp;Nextnbsp;gt;/a ; } } ? This code is at the top of an include file which is included in pics.php. It seems that $PHP_SELF is interpreted differently in *some* instances between the two browsers. I can't figure it out because PHP_SELF is a server side evaluation. The links are output correctly in IE ... http://www.xyz.com/pics.php?page=2 ... but in Netscape I get ... http://www.xyz.com/?page=2 I had this problem once before and inadvertently fixed it with something else that I was doing. Any hints are appreciated. TIA, Bill
RE: [PHP] Page Rendering
This worked ... thanks! But I am confused. It has worked with PHP_SELF in the past. Why would it not evaluate the variable on the server. Or more specifically, why would the page render fine in both Netscape and IE with the links (from PHP_SELF) being the only thing wrong with the page? Just trying to understand. :o) Bill -Original Message- From: Jason Wong [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 21, 2003 8:56 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] Page Rendering On Tuesday 21 January 2003 22:26, Bill Arbuckle, Jr. wrote: This code is at the top of an include file which is included in pics.php. It seems that $PHP_SELF is interpreted differently in *some* instances between the two browsers. I can't figure it out because PHP_SELF is a server side evaluation. The links are output correctly in IE ... http://www.xyz.com/pics.php?page=2 ... but in Netscape I get ... http://www.xyz.com/?page=2 I had this problem once before and inadvertently fixed it with something else that I was doing. Any hints are appreciated. Most likely $PHP_SELF is in fact blank. If you're using a relatively new version of PHP use $_SERVER['PHP_SELF'] instead. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* On the road, ZIPPY is a pinhead without a purpose, but never without a POINT. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] How Do I Return Values Across Servers
This may be a no-brainer for everyone but me but ... I have several php scripts residing on a web site on Server A. In a library file on Server A are misc. functions, some of which query an underlying database and return a text string as the result. On another web site on Server B I would like to call these functions to get the result without reinventing the wheel so to speak. So my question is ... How can I call a function that returns a text string from Server A in a script requiring that text during the processing of a web page on Server B ... all in php? Thanks in advance. Bill
RE: [PHP] read javascript variable php?????
location.href=?= $destination ? should work ... hth ... Bill -Original Message- From: Ysrael Guzmán [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 4:30 PM To: [EMAIL PROTECTED] Subject: [PHP] read javascript variable php? example: location.href=$destination; or location.href=?php $destination; ; or echo location.href=', $destino, ';; PLEASE GIVE A IDEA Ysrael Guzmán Meza -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] How Do I Return Values Across Servers
Yes, I want to get a value from a script on Server A that runs against a database on Server A, returning that value to a script variable on Server B. I read the manual but must have missed something. This is what *seemed* as if it should work: Server A (containing functions and database) qotd.php ?php requireonce('miscfuncs.php'); $qotd= qotd(); ? ** qotd()is a f(x) in miscfuncs.php = Server B test.php ... HTML stuff ?php include 'http://www.servera.com/qotd.php'; echo $qotd . \nbr\n; ? ... More HTML stuff With this setup I get the following error: Warning: Failed opening 'http://www.servera.com/qotd.php' for inclusion (include_path='.;c:\php4\pear') in c:\webdev\kids\homebody.inc on line 27 Any ideas? I know that I am missing something here. Thanks, Bill -Original Message- From: Timothy Hitchens (HiTCHO) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 4:45 PM To: 'Bill Arbuckle, Jr.'; [EMAIL PROTECTED] Subject: RE: [PHP] How Do I Return Values Across Servers If I understand you want to be able to get a value from a script on another server. Well I would suggest a really each way would be to do have the calling server call a script on the supplying server using include(); which is supported but please see this page regarding URL fopen wrappers: http://www.php.net/manual/en/function.include.php Requests for includes and on the supplying server simply output the value like: ?php $answer = 'no'; ? If you do it this way it will be simply included and be available as a variable instantly. (**subject to security issues and speed) Timothy Hitchens (HiTCHO) Open Platform Consulting e-mail: [EMAIL PROTECTED] -Original Message- From: Bill Arbuckle, Jr. [mailto:[EMAIL PROTECTED]] Sent: Thursday, 9 January 2003 8:17 AM To: [EMAIL PROTECTED] Subject: [PHP] How Do I Return Values Across Servers This may be a no-brainer for everyone but me but ... I have several php scripts residing on a web site on Server A. In a library file on Server A are misc. functions, some of which query an underlying database and return a text string as the result. On another web site on Server B I would like to call these functions to get the result without reinventing the wheel so to speak. So my question is ... How can I call a function that returns a text string from Server A in a script requiring that text during the processing of a web page on Server B ... all in php? Thanks in advance. Bill -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Securing areas of a web site with PHP
You might consider using cookies that keep track of the user's login name and a bitwise status to control AAA (Authentication, Authorization, and Access0 controls instead of using session variables. -mel On Wed, 1 Jan 2003, Jean-Christian Imbeault wrote: On my web site there are some areas that I want to make accessible only after a user has logged in (for example when placing an order, etc ...) I have been able to achieve this however I have the following problem: 1- user logs in 2- user goes to restricted area 3- user views pages, orders an item, changes his account settings, etc ... 4- user logs out 5- user is sent to log out page 6- user hits back button ... And here my problems start ... even though the user has logged out, all the restricted pages he saw are still cached by his browser and accessible ... I have tried using a script that checks a session variable that indicates if a user is logged in or not and take appropriate action at the start of all restricted pages, but that doesn't work since when the user hits the back button, the PHP script is not re-executed, the page is simply loaded from the browser cache. What are some PHP techniques I could use so that a user can no longer access/use pages once he has logged out? Basically I would like to have sort of state machine so I that I can simply check where a user is coming from and his login state to decide if a certain page should be presented or not (i.e. you can't get here form there or you can't view that page with your current login status). But it seemed that creating a state machine is not the right way to go about it since hitting the back button pretty much allows a user to circumvent this ... Eventually the web site I will build will actually have many areas, each needing a separate/different login, (and you can be logged in to multiple areas at once) so I would like to be able to generalize this problem and understand how I can use PHP to implement the needed functionality. Just as a simple example, once a user has placed an order, he should not be able to go back to the order placing/processing pages ... Any tips, hints, or pointers to tutorials are appreciated! Thanks, Jc -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: \Z characters
This field contains ONLY the \Z. Thanks for the suggestion but it generates the following error message: Parse error: parse error, unexpected '\' in On Sun, 2002-12-22 at 04:49, Mattia wrote: Dave J. Hala Jr. [EMAIL PROTECTED] ha scritto nel messaggio 1040500684.942.130.camel@badboy">news:1040500684.942.130.camel@badboy... I've got a bunch of fields in a mysql database that have a \Z character in them. I want to search a field for \Z and if it contains that character, make the field blank. In running php 4.x on RH 8.0 Here is the code: $connection = db_connect(Could not connect DB); $SQL=SELECT id,PVLN from lhpl_side WHERE PVLN =\\\Z\ ; $result= mysql_query($SQL,$connection) or die (mysql_error()); $num = mysql_numrows($result); You are looking for a field that is a string and consist of a \Z character! not more not less. I don't understand if this is what you want or you want to find all fields that CONTAIN a \Z in any position. In this case the correct query would be select id,PVLN from lhpl_side WHERE PVLN LIKE \%\\Z\% mATTIA cAZZOLA -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- ...Unix, MS-DOS and Windows NT (also known as the Good, the Bad, and the Ugly) OSIS Dave J. Hala Jr. 641.485.1606 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] \Z characters
I've got a bunch of fields in a mysql database that have a \Z character in them. I want to search a field for \Z and if it contains that character, make the field blank. In running php 4.x on RH 8.0 Here is the code: $connection = db_connect(Could not connect DB); $SQL=SELECT id,PVLN from lhpl_side WHERE PVLN =\\\Z\ ; $result= mysql_query($SQL,$connection) or die (mysql_error()); $num = mysql_numrows($result); This query returns 0 rows. (no error messages either) But when I execute the query: SELECT id,PVLN from lhpl_side WHERE PVLN =\Z; from the mysql command prompt it works properly. (returns a 172 rows) I realize that I need to do an update to change the value in field. However, right now I just need to get a query that works to the db. Anyone got any ideas? :) Dave -- ...Unix, MS-DOS and Windows NT (also known as the Good, the Bad, and the Ugly) OSIS Dave J. Hala Jr. 641.485.1606 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Post Problem
I'm running php-4.2.2-8.0.5 on Redhat 8.0 Lately I've noticed that when doing a form, listbox variables have funky values in certain situations. Unfortunately, I haven't been to determined what the certain situation is. Here's an example. Here is the listbox in the form: select NAME=SQN option VALUE=44/option option VALUE=66/option option VALUE=/option /select After clicking submit, when I echo the variable in the post script,I get the following results: SQN=4 I should get the value 4 Doing an echo $_POST[SQN] BR; yields the same results. I didn't start seeing this until this week. I don't know what changed, but it only happens with certain variables on certain posts. Anyone else seen this type of behavior? :) Dave -- ...Unix, MS-DOS and Windows NT (also known as the Good, the Bad, and the Ugly) OSIS Dave J. Hala Jr. 641.485.1606 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Post Problem
I selected the option that would have the value 4, what I get is 4SQN=4 I should get just the value 4 On Mon, 2002-11-18 at 04:33, BigDog wrote: That is what you should be getting right? When you have a select statement that has a value as the first one then that is what you will get when you post or get the form. if you want a blank one then do option/option and that should not pass anything in the post or get... On Mon, 2002-11-18 at 17:30, Dave J. Hala Jr. wrote: I'm running php-4.2.2-8.0.5 on Redhat 8.0 Lately I've noticed that when doing a form, listbox variables have funky values in certain situations. Unfortunately, I haven't been to determined what the certain situation is. Here's an example. Here is the listbox in the form: select NAME=SQN option VALUE=44/option option VALUE=66/option option VALUE=/option /select After clicking submit, when I echo the variable in the post script,I get the following results: SQN=4 I should get the value 4 Doing an echo $_POST[SQN] BR; yields the same results. I didn't start seeing this until this week. I don't know what changed, but it only happens with certain variables on certain posts. Anyone else seen this type of behavior? :) Dave -- ...Unix, MS-DOS and Windows NT (also known as the Good, the Bad, and the Ugly) OSIS Dave J. Hala Jr. 641.485.1606 -- .: B i g D o g :. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- ...Unix, MS-DOS and Windows NT (also known as the Good, the Bad, and the Ugly) OSIS Dave J. Hala Jr. 641.485.1606 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Post Problem
SQN: 4SQN=4 brSQN: 4SQN=4br html head title Nifcap - Export Checks/title table WIDTH=100% tr td WIDTH=5% bgcolor=#CCfont face= arial size =3 Export Checks/font/td /tr /table br body bgcolor=f0 text=00 font face= font_type size =3 a HREF=https://122.192.204.199/payment/tmp/checks_4SQN=4.zip;checks_4SQN=4.zip/abrbrtable WIDTH= 100% tr td WIDTH=11% bgcolor=66 font face= arial size =3a HREF=https://122.192.204.199/payment/pay_menu.php;Liheap Processing Menu/a/td/font td WIDTH=11% bgcolor=66 font face= arial size =3a HREF=https://122.192.204.199/main.php;Main Menu/a/td/font td WIDTH=11% bgcolor=66 font face= arial size =3a HREF=https://122.192.204.199/logout.php;Logout/a/td/font /tr /table br /font /body /html On Mon, 2002-11-18 at 04:44, BigDog wrote: What does the entire form look like? On Mon, 2002-11-18 at 17:43, Dave J. Hala Jr. wrote: I selected the option that would have the value 4, what I get is 4SQN=4 I should get just the value 4 On Mon, 2002-11-18 at 04:33, BigDog wrote: That is what you should be getting right? When you have a select statement that has a value as the first one then that is what you will get when you post or get the form. if you want a blank one then do option/option and that should not pass anything in the post or get... On Mon, 2002-11-18 at 17:30, Dave J. Hala Jr. wrote: I'm running php-4.2.2-8.0.5 on Redhat 8.0 Lately I've noticed that when doing a form, listbox variables have funky values in certain situations. Unfortunately, I haven't been to determined what the certain situation is. Here's an example. Here is the listbox in the form: select NAME=SQN option VALUE=44/option option VALUE=66/option option VALUE=/option /select After clicking submit, when I echo the variable in the post script,I get the following results: SQN=4 I should get the value 4 Doing an echo $_POST[SQN] BR; yields the same results. I didn't start seeing this until this week. I don't know what changed, but it only happens with certain variables on certain posts. Anyone else seen this type of behavior? :) Dave -- ...Unix, MS-DOS and Windows NT (also known as the Good, the Bad, and the Ugly) OSIS Dave J. Hala Jr. 641.485.1606 -- .: B i g D o g :. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- ...Unix, MS-DOS and Windows NT (also known as the Good, the Bad, and the Ugly) OSIS Dave J. Hala Jr. 641.485.1606 -- .: B i g D o g :. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- ...Unix, MS-DOS and Windows NT (also known as the Good, the Bad, and the Ugly) OSIS Dave J. Hala Jr. 641.485.1606 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Post Problem
I'd be willing to post the entire page, but it's 154 lines of embedded php. Here's the FORM block portion of the page. The $sqn_list_box variable contains the listbox. $export_form .=FONT face= \$font_type\ size =\$font_size\FORM METHOD=\post\ ACTION=\/payment/export_checks.php\ Export Check file: $sqn_list_box INPUT TYPE=SUBMIT VALUE= Submit/FORM ; On Mon, 2002-11-18 at 04:55, BigDog wrote: but where is the form that you created... That was i can see what you have set up inside of the form tag... On Mon, 2002-11-18 at 17:51, Dave J. Hala Jr. wrote: SQN: 4SQN=4 brSQN: 4SQN=4br html head title Nifcap - Export Checks/title table WIDTH=100% tr td WIDTH=5% bgcolor=#CCfont face= arial size =3 Export Checks/font/td /tr /table br body bgcolor=f0 text=00 font face= font_type size =3 a HREF=https://122.192.204.199/payment/tmp/checks_4SQN=4.zip;checks_4SQN=4.zip/abrbrtable WIDTH= 100% tr td WIDTH=11% bgcolor=66 font face= arial size =3a HREF=https://122.192.204.199/payment/pay_menu.php;Liheap Processing Menu/a/td/font td WIDTH=11% bgcolor=66 font face= arial size =3a HREF=https://122.192.204.199/main.php;Main Menu/a/td/font td WIDTH=11% bgcolor=66 font face= arial size =3a HREF=https://122.192.204.199/logout.php;Logout/a/td/font /tr /table br /font /body /html On Mon, 2002-11-18 at 04:44, BigDog wrote: What does the entire form look like? On Mon, 2002-11-18 at 17:43, Dave J. Hala Jr. wrote: I selected the option that would have the value 4, what I get is 4SQN=4 I should get just the value 4 On Mon, 2002-11-18 at 04:33, BigDog wrote: That is what you should be getting right? When you have a select statement that has a value as the first one then that is what you will get when you post or get the form. if you want a blank one then do option/option and that should not pass anything in the post or get... On Mon, 2002-11-18 at 17:30, Dave J. Hala Jr. wrote: I'm running php-4.2.2-8.0.5 on Redhat 8.0 Lately I've noticed that when doing a form, listbox variables have funky values in certain situations. Unfortunately, I haven't been to determined what the certain situation is. Here's an example. Here is the listbox in the form: select NAME=SQN option VALUE=44/option option VALUE=66/option option VALUE=/option /select After clicking submit, when I echo the variable in the post script,I get the following results: SQN=4 I should get the value 4 Doing an echo $_POST[SQN] BR; yields the same results. I didn't start seeing this until this week. I don't know what changed, but it only happens with certain variables on certain posts. Anyone else seen this type of behavior? :) Dave -- ...Unix, MS-DOS and Windows NT (also known as the Good, the Bad, and the Ugly) OSIS Dave J. Hala Jr. 641.485.1606 -- .: B i g D o g :. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- ...Unix, MS-DOS and Windows NT (also known as the Good, the Bad, and the Ugly) OSIS Dave J. Hala Jr. 641.485.1606 -- .: B i g D o g :. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- ...Unix, MS-DOS and Windows NT (also known as the Good, the Bad, and the Ugly) OSIS Dave J. Hala Jr. 641.485.1606 -- .: B i g D o g :. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- ...Unix, MS-DOS and Windows NT (also known as the Good, the Bad, and the Ugly) OSIS Dave J. Hala Jr. 641.485.1606 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Extracting email addresses
Hello Everyone, Does anyone have an regular expression or other way to extract an email address out of a string. I have been using: if (ereg (^ . [a-z0-9]+([_\\.-][a-z0-9]+)* .//user @ . ([a-z0-9]+([\.-][a-z0-9]+)*)+ . //domain \\.[a-z]{2,} .//sld, tld $ , $body[$line], $regs)) It will match an email address by itself for example; [EMAIL PROTECTED] What it won't do is extract [EMAIL PROTECTED] from; a href=mailto:jr;johnrudnick.com[EMAIL PROTECTED]/a. Any help would be appreciated. Thanks in Advance! JR - SallyJo, Inc., offers Top Notch Dedicated Virtual Hosting. Visit: http://www.SallyJoInc.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP]dtabase problem
there is a problem in mysql database.there r two tables.one table is named as transactions and the other is named as the code.the transactions table has got the 12 fields which r the following 1.clientid int 2.date date 3.isinno text 4.debit int 5.credit int 6.desc text 7.dpid1 text 8.nsdlid int 9. desc1 text 10. desc2 text 11. dpid bigint 12.transno int All these fields r by default NULL the code table has got the 8 fields which r the following 1.rd smallint 2.transno int 3.status tinyint 4.status1 tinyint 5.cdate date 6.clientid int 7. isinno text 8.description text . All these fields r by default NULL I am writing this query but its not giving the recquired results i.e i want it should pick up the all the fields of both the tables without any duplicate enteries. SELECT * from transactions,holdings,code where transactions.clientid=holdings.clientid and transactions.isinno=code.isinno and transactions.isinno=' INE561A01013' and transactions.transno='4509'AND FROM_DAYS(transactions.date) - TO_DAYS(holdings.hdate) group by transactions.credit,code.description Basically the problem with the above query is that its giving the duplicate enteries . plz. solve my problem at the earliest.its very urgent. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Calling info from mySQL inside flash
THANKS A TON!!! --- Brad Bonkoski [EMAIL PROTECTED] wrote: How about giving this page a look over: http://www.macromedia.com/desdev/topics/php.html Here's an article especially for using PHP and MySQL with Flash MX http://www.macromedia.com/desdev/mx/flash/articles/flashmx_php.html HTH -Brad Thomas Edison Jr. wrote: I have a mySQL db, and a bunch of tables in it. What i want to do, is to pick up some data, and display in my Flash Movie. For example. I have a table with a list. Now on my main page, i display the total number of people in the list so far (By counting the rows). Now i want to display the same in my Flash movie. How can we exactly insert PHP Coding inside Flash Movie to make the code work? Any tips... Thanks, T. Edison Jr. __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Calling info from mySQL inside flash
I have a mySQL db, and a bunch of tables in it. What i want to do, is to pick up some data, and display in my Flash Movie. For example. I have a table with a list. Now on my main page, i display the total number of people in the list so far (By counting the rows). Now i want to display the same in my Flash movie. How can we exactly insert PHP Coding inside Flash Movie to make the code work? Any tips... Thanks, T. Edison Jr. __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Need a Web Host for php/mySQl
Glory, I'm looking for a new Web Hosting company, to host my sites. I had been with Aletia, but i'm experiencing some technical flaws with them, so i need a new one. Aletia is very economical, with $7.95 a month for 200 MB, 10 GB Bandwidth, sub-domains, dbs, and a hell a lot of goodies. so i would prefer someone like them or better then them. I'd really appreciate if someone can find me a better Host. Thanks, T. Edison Jr. __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Can't find my font file - Please help
I am trying to use the imagettfbbox function. Am testing the script on my local network running W2K. Have defined : $fontfile = arial.tff; // this file is in the same directory with my script The instruction that fails: $thetextbox = ImageTTFBBox ($fontsize, 0, $fontfile, My Button); The error message is: Warning: Could not find/open font in c:\phpdev\www\public\kazaam\rendertext.php on line 9 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PROBLEM
hi! i have a problem in my project.the problem is that suppose we have the date for the whole of the month and two different files r there. i have to pick one file of the current date that is say today and the other file of the yesterday.but the problem is that if the current date is monday then the in yesterday file i have to pick for saturday and not the sunday.broadly speaking i mean to say that the difference between the today's date and yesterday's is not fixed as there can be a holiday for say 4 days inbetween then in yesterday i need the date 4 days before. so i need some query to handle this as soon as possible as its very urjent.the query should be in MYSQL.that is the query should be such which can pick today's date and the date of the working day before the today's or the current date. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Picking up Data of Previous Date from Table
Glory! I have one Table (Transactions), having a Date Column, with date stored as -MM-DD I have another Table (Holdings), having a Date Column, with date stored as -MM-DD Now i'm joining the two tables, to get data from both the tables and display on the page. The query i'm using is something like this : SELECT * FROM transactions,holdings where transactions.isinno=holdings.isinno AND transactions.clientid='$clientid' AND holdings.clbal!=0 GROUP BY holdings.isinno ORDER BY shares This statement works fine, and for any given date, extracts Data from both the tables and displays in a particular row format. I have to also to do some Calculations as i have Debit, Credit Opening Balance of a day, and have to generate the Closing Balance. Now for this purpose i'm facing a simple problem. The Data being picked up is of the same date from both the Tables. However, what is required is that the Data from the Holdings table needs to be picked up from a Date a day earlier then the Transactions Table Data. For eg:- If i'm displaying Transactions Table Data of 2002-06-22, then the Holdings Data should be picked up of date 2002-06-21 !! The thing is that i have Debit Credit in Transactions Table, and the Closing Balance in Holdings Table. The Closing Balance of 21st is the Opening Balance of 22nd. So when i display the Transactions Table for 22nd, Debit Credit of 22nd is Subtracted Added to the Opening Balance of 21st to get the Closing Balance. So this is what i have to do. I need to pick up the Opening Balance from the Holdings Table of a Date Previous to the Transactions that i'm displaying. How can i do this? Thanks, T. Edison Jr. __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Stopping Multiple Entries in mySQL DB
Hi, Ok i cant actully do this. I have many multiple entries already in the table which i do not wish to delete. And it won't alter table with these multiple entries. So what i need is a PHP Engineered solution, where my PHP code would check for existing entries and deny entry Thanks, T. Edison Jr. --- John Holmes [EMAIL PROTECTED] wrote: I just want my Adding Into Database script to check if the Name/Country already exists, and if it does, it shouldn't be allowed. If some with Name : Jackson Country : USA exists in my DB, no one with same name/country should be able to add his name/country in the DB. Have your database handle that, not PHP. When you create your table, make the combo of Name and Country unique. CREATE TABLE your_table { Name VARCHAR(15), Country VARCHAR(15), UNIQUE Name_Country (Name, Country) } Then you can have Jackson, USA, Jackson, UK, Someone Else, USA, etc...just not the same combination at all. ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Resetting ID
Glory! I have a table, with 4 columns. One of the column is ID, a Primary Key, which has Auto_Increment set on it. Now i have a lot of rows deleted and a lot of duplicate rows that will be deleted, and all sorts of stuff happening in the table.. the result is, that the IDs have become inconsistent. What you get is something like 5,6,9,10,25,32,33 .. and so on. With many IDs missing etc. What i want to do is delete the entire IDs and generate them again so that they are in one single order like 1,2,3,4,5... .like this. And so that any new entry in the table gets the ID accordingly. How can i do this? Thanks, T. Edison Jr. __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Submitting form in new window!
Glory, 2 Problems with this : 1. I have a PHP/MySQL statement within my PHP Code, which is in the Body part of the page. This generates the Form Fields Thier Values.. there are a lot of hidden fields who's values are defined by Database Variables.. If i place the FormSubmit()Function in the head, how will those variables pass? 2. I'm already using Target=_Blank ... problem with that is that you cannot control size of window. And that is exactly what i need to do.. define parameters for the window... Thanks, T. Edison Jr. --- vins [EMAIL PROTECTED] wrote: This is JavaScript you need. one example. FORM NAME=Information INPUT TYPE=text NAME=TextField VALUE=Nothing Here INPUT TYPE=submit NAME=go VALUE= Go! onSubmit=FormSubmit()' /FORM SCRIPT LANGUAGE=JavaScript TYPE=JavaScript/Text function FormSubmit() { var textfield = Information.TextField.value; var url = ./processForm.php?textfield= + textfield; window.open(url); } /SCRIPT OR just add this to your form tag. TARGET=_blank Thomas Edison Jr. [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Glory, Attach a javascript event to the submit button Something like : input type=submit name=go onSubmit=wow(); Wherein wow() defines a the window.open function? and also attach the form values to the url. How do i do this? Because the 3 or 4 form fields i have, which are Hidden Fields, contain values coming in from $myrow[stuff], that is, coming in from a Database Table. How do i define these values up in the Javascript function in the head of the file? Thanks, T. Edison Jr. __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Stopping Multiple Entries in mySQL DB
Glory! I just want my Adding Into Database script to check if the Name/Country already exists, and if it does, it shouldn't be allowed. If some with Name : Jackson Country : USA exists in my DB, no one with same name/country should be able to add his name/country in the DB. Can anyone hint? T. Edison Jr. __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Inserting Processed Data from One Table 2 Another!
Ok ths is great, a lovely Random Code Generator! Thanks a lot. I always wanted one of these. Actually my problem was a little different, but i was able to solve it. I was using $result twice to store to different SQL Queries, i changed the other one to $result2 and it worked. But in fact, i will now change my code to generate the Random Number which of course is much better! Thanks... T. Edison Jr. --- Wouter van Vliet [EMAIL PROTECTED] wrote: I don't see why your code is so wrong but neither do I see what it reall does. YOu are changing the clientID with some simple function into a password? As in everybody can do that trick by himself and login as whoever he wants .. What I'll mostly do for such things, is use this self written function to generate a random string and use this as generated password. it takes an integer as argument, and gives back a random code with only [A-Z][a-z] characters of a length of the given argument. And then, I'd just use the loop to roll through the ID's and insert a random code password. function generateRandomString($length) { srand ((float) microtime() * 100); for ($i=65;$i91;$i++) { $chars[] = chr($i); }; for ($i=97;$i122;$i++) { $chars[] = chr($i); }; $chrs = count($chars) - 1; for ($i=0; $i$length; $i++) { $asc = rand(0, $chrs); $code .= $chars[$asc]; }; return $code; }; $result = mysql_query(SELECT clientid FROM Clientdetails); while ($myrow = mysql_fetch_assoc($result)) { $code = generateRandomString(8); mysql_query(INSERT INTO authentication (id, pass) VALUES ($myrow[clientid], '.$code.'); }; Hope this helped you ! Greetz, Wouter -Oorspronkelijk bericht- Van: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Verzonden: woensdag 24 juli 2002 9:02 Aan: [EMAIL PROTECTED] Onderwerp: [PHP] Inserting Processed Data from One Table 2 Another! Ok i have simple issue, i'm stuck at one point. I have a table Clientdetails which contains ClientID. I have created another table Authentication with 2 fields, ClientID and Password. I want to pick up the ClientID from table Clientdetails and insert ClientID and a Password i have generated using a code, into Authentication. So if there are 13000 ClientID's in Clientdetails, as, many rows with the ClientID it's corresponding password should be Inserted into table Authentication. I'm using the following code which i know is wrong, what would be correct? ? $db = mysql_connect(localhost,user,pwd); mysql_select_db(myDB,$db); $result = mysql_query(SELECT * FROM clientdetails,$db); if ($myrow = mysql_fetch_array($result)) { do { $some = $myrow[clientid] $newid = eregi_replace('100', '', $myrow[clientid]); $date = date(dn); $stuff = $newid.def.$date; $sql = INSERT INTO authentication VALUES('$some','$stuff'); $result = mysql_query($sql); echo All Done!; } while ($myrow = mysql_fetch_array($result)); } ? Thanks, T. Edison Jr. __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Inserting Processed Data from One Table 2 Another!
Ok i have simple issue, i'm stuck at one point. I have a table Clientdetails which contains ClientID. I have created another table Authentication with 2 fields, ClientID and Password. I want to pick up the ClientID from table Clientdetails and insert ClientID and a Password i have generated using a code, into Authentication. So if there are 13000 ClientID's in Clientdetails, as, many rows with the ClientID it's corresponding password should be Inserted into table Authentication. I'm using the following code which i know is wrong, what would be correct? ? $db = mysql_connect(localhost,user,pwd); mysql_select_db(myDB,$db); $result = mysql_query(SELECT * FROM clientdetails,$db); if ($myrow = mysql_fetch_array($result)) { do { $some = $myrow[clientid] $newid = eregi_replace('100', '', $myrow[clientid]); $date = date(dn); $stuff = $newid.def.$date; $sql = INSERT INTO authentication VALUES('$some','$stuff'); $result = mysql_query($sql); echo All Done!; } while ($myrow = mysql_fetch_array($result)); } ? Thanks, T. Edison Jr. __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] why my php can not get values from Form?
Simple.. just edit your php.ini file in your windows directory. Search for register_globals .. it will have Off in front of it.. switch it to On T. Edison jr. --- ram friend [EMAIL PROTECTED] wrote: hello, I have just installed apache+php4, but my php can not get values from form? what's wrong? following is the code in php named file welcome.php ?php echo( Welcome to our Web site, $usernm $passwd! ); ? I called it with http://localhost/welcome?username=passwd=bbb i get nothing, what's wrong? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Importing CSV File : 100000 Rows!
Hi, I have generated a .csv file from a .dat file using a VB program. Now this .csv file needs to be imported into my mySQL Database Table on the internet, using phpMyAdmin. The problem i'm facing is that the file, while uploading, stops somewhere in the middle. The upload just gets stuck. Possible reasons : 1. Number of rows is too large. About 10. Does mySQL Support these many rows? Is yes, is it possible to upload these many rows from a client to a table on the internet using phpMyadmin? 2. Internet connection. Due to the mere size of the file in terms of no. or rows, maybe my internet is not able to send all the data. I dont' know. Now can anyone suggest a possibly solution? Can i break up the file automatically and send or something? Please help.. T. Edison Jr. __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Importing CSV File : 100000 Rows!
Hi, Basically the problem is that i have to connect from my localhost to my MySQL database on the server/internet. I don't have command prompt access to the internet database... --- Pradeep Dsouza [EMAIL PROTECTED] wrote: there is a way to do it from the prompt I use Windows but the command on Linux is close if the file is called mydata.sql mysql \. C:\mydata.sql Hope this works Pradeep - Original Message - From: Thomas Edison Jr. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 18, 2002 10:50 AM Subject: [PHP] Importing CSV File : 10 Rows! Hi, I have generated a .csv file from a .dat file using a VB program. Now this .csv file needs to be imported into my mySQL Database Table on the internet, using phpMyAdmin. The problem i'm facing is that the file, while uploading, stops somewhere in the middle. The upload just gets stuck. Possible reasons : 1. Number of rows is too large. About 10. Does mySQL Support these many rows? Is yes, is it possible to upload these many rows from a client to a table on the internet using phpMyadmin? 2. Internet connection. Due to the mere size of the file in terms of no. or rows, maybe my internet is not able to send all the data. I dont' know. Now can anyone suggest a possibly solution? Can i break up the file automatically and send or something? Please help.. T. Edison Jr. __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Connecting LocalHost Remote mySQL DB
Glory! Let's say i got a bunch of Data in my mySQL Table on my localhost. I need all this Data uploaded on my mySQL on the Server/Internet. Now one way is to use phpMyAdmin, Export the original data on LocalHost to a .CSV file, then use the Server phpMyAdmin to upload the same .CSV file to the table on the server. What could be an alternate, in case we dont' want to use this lengthy procedure. Can i make one page which will do both these things? .OR. Can my PHP page on my server, directly pick up data from my localHost mySQL, and feed it in the mySQL Table on the server? Help needed! Thanks, T. Edison Jr. __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Connecting LocalHost Remote mySQL DB
Glory! Exactly.. that IS the problem. You see, my mySQL DB on the Server/Internet, on my website.. it DOES NOT allow Remote Host Connection. That's why i need to use a PHP page, that too based on the server. Because i need to move tabel data on my Client/My Computer to the Tables on my Website mySQL. Thanks, T. Edison Jr. --- Jason Wong [EMAIL PROTECTED] wrote: On Saturday 13 July 2002 13:45, Thomas Edison Jr. wrote: Glory! Let's say i got a bunch of Data in my mySQL Table on my localhost. I need all this Data uploaded on my mySQL on the Server/Internet. Now one way is to use phpMyAdmin, Export the original data on LocalHost to a .CSV file, then use the Server phpMyAdmin to upload the same .CSV file to the table on the server. What could be an alternate, in case we dont' want to use this lengthy procedure. Can i make one page which will do both these things? .OR. Can my PHP page on my server, directly pick up data from my localHost mySQL, and feed it in the mySQL Table on the server? If all you want is to copy data from ServerA/Database/Table to ServerB/Database/Table you don't even need PHP. Providing that at least one of the server allows remote access then the easiest way is to use mysqldump. For details consult mysql manual. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Love is in the offing. -- The Homicidal Maniac */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Submitting form in new window!
Hi, When i press the Submit button, i would like it to open in a new Javascript Windows with well-defined characteristics like size, width etc. I create a window.open function and gave the name of my PHP page .. but the Form Variables are not passing into it.. Thanks, T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Sending data in table, multiple rows, via mail()
Hi, Ok i have a bunch of rows in my table, with some data. I want my mail() function to be able to pick up the data from the rows and send to a specified email. Basicall let's say there are 3 fields, and 3 rows, the data sent in email should be something like : row1field1 : dkjhdkj row1field2 : dsjdkj row1field3 : skljskj row2field1 : dkjhdkj row2field2 : dsjdkj row2field3 : skljskj And so on, apart from the other mail info. Can anyone help me out with this... Thanks, T. Edison Jr. __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Sending data in table, multiple rows, via mail()
Thank you for your *extreme* kindness... I do not know where to begin to make this happen. I created a variable and ran the entire do while loop to read contents of the table and tried storing them in the variable, which could be used as Content of the mail. However, i just get the Last Row in my DB Table sent in mail.. not all the rows. Following is part of the code i'm using, and it could be absolutely wrong, but that's all i know.. ? $db = mysql_connect(localhost,user, pwd); mysql_select_db(tbl,$db); $result = mysql_query(SELECT * FROM cart where sid='$s',$db); $realcontent= if ($myrow = mysql_fetch_array($result)) { do { $myrow[pid]br $myrow[nm]br $myrow[q]br } while ($myrow = mysql_fetch_array($result)); } ; $to = [EMAIL PROTECTED]; $subject = Purchase order Website; $from = Purchase Order; $stuff = Name : $name\n Phone : $phone\n Fax : $fax\n Email : $email\n Address : $address\n Country : $country\n Order:\n\n $realcontent\n\n; mail($to,$subject,$stuff,$from); ? __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Submitting form in new window!
Hi, Ok, let me show some code : form name=\drama\ action=\add2cart.php\ method=post target=\blank\ input type=hidden name=sessid value= $PHPSESSID input type=hidden name=proid value= $result[vProID] input type=hidden name=proname value= $result[vProName] font color=#00 face=verdana size=2Quantity input type=\text\ size=3 name=\qty\ input type=\submit\ value=\Add To Cart\/font This is the SUBMIT button that submits the form alongwith the Form Variables to a file called Add2Cart.php !! But this file simply opens in an unadministered new window. i would like to use the window.open function, or whatever can accomplish this, to restrict parameters of the window in which add2cart.php opens, at the same time the variables of my form should get submitted into the add2cart.php T. Edison Jr. __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Sending data in table, multiple rows, via mail()
Hi, WOW... THANKS A LOT!! This actually did it .. i was on a slight wrong track.. $realcontent = ; while ($myrow = mysql_fetch_array($result)) { $realcontent .= $myrow['pid']br; $realcontent .= $myrow['nm']br; $realcontent .= $myrow['q']br; } Thanks, T. Edison Jr. __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Commit/Roll Back Transaction in PHP/mySQL
Glory! Im creating a .php file that will be uploading putting in data from a .csv file into mySQL Tables on the server. However, my problem is that if there is any kind of a problem during the transaction, i.e, system shut down, electricity problem, or any reason why the transaction is interrupted, i would like the transaction to roll back.. that is, all the records entered before the interruption SHOULD NOT remain in the database, they should get deleted or something, so that the transaction can begin Fresh from next time. How can i make such a function that will see this happens, in my PHP/mySQL. Thanks, T. Edison Jr. __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Exporting mySQL Table Data to .csv
Glory, I use phpMyAdmin which enables me to take dump of mySQL Table Data into Comma Seperated Values file (.csv) Now, i have to create such a program that accomplishes this, without using phpMyAdmin. Can someone guide me to this procedure.. Thanks, T. Edison Jr. __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Submitting form in new window!
Glory, Attach a javascript event to the submit button Something like : input type=submit name=go onSubmit=wow(); Wherein wow() defines a the window.open function? and also attach the form values to the url. How do i do this? Because the 3 or 4 form fields i have, which are Hidden Fields, contain values coming in from $myrow[stuff], that is, coming in from a Database Table. How do i define these values up in the Javascript function in the head of the file? Thanks, T. Edison Jr. __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Software on web Accessing mySQL/PHP
Hi, Basically we have created a Software in Visual Basic. Now the software uses mySQL on the internet as Backend. However, our server does not allow Remote Host Connection, which means we cannot access our mySQL Database on the Internet by our Software on a local client. We need the mySQL Database on the Internet because basically everything will be available on a website later through PHP Pages. Now, my problem is how to connect to my mySQL DB on the Internet, via my Software, when my Server Company doesn't allow Remote Host Connection to mySQL. What is suggested to me is to place the Software on the Internet. I have no clue how to do that. Because if i place an .exe file on the net, it will just start downloading instead of running. How then can i accomplish this? The software feeds in Data in the mySQL DB on the internet, and then the PHP pages access the mySQL DB to show data to users on the Website. It's something like that. The software involves a lot of processing, decryption, conversion etc. to convert a .dat data into usable mySQL Tables Data. Hope somebody can help. Thanks, T. Edison Jr. __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP not working on Apache at XP Pro.
Glory! I've got Windows XP Pro OS. I installed and am running mySQL on that. However, PHP is not getting configured with Apache on it. I got the latest Apache, 1.3.24 or something, not the Version 2. Anyway, Apache runs perfectly on it. However, when i put in the required PHP lines in httpd.conf and install PHP otherwise on the system. What happens is that i get an error stating that : mod_c.php already exists, skipping Now when i remove that line, PHP does not work with Apache. If i insert that line, APACHE itself doesn't work at all. What is wrong with it? Well thanks, T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Apache 2.0 or 1.3 for php on windows XP ?
Glory! I have Windows XP Home Edition.. and i downloaded the latest PHP mySQL. I have Apache 1.3.19 earlier, which for some reason gives Service Apache Not Installed now even when everything is installed, on my windows XP. So i decided to get a new Apache Web Server. They have 2 versions available.. 2.0 1.3 .. i just want to know which one i should use, and if PHP is compatible with both.. and that if i do use 2.0, the Install Doc in PHP has given no instructions on how to install php on Apache 2.0, so how will i install it.. Any suggestions most welcome.. T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Apache 2.0 or 1.3 for php on windows XP ?
Ok... i'll go for 1.3.24 Thanks, T. Edison Jr. --- R'twick Niceorgaw [EMAIL PROTECTED] wrote: use apache 1.3.24.. php has experimental support for apache 2.0.x.. so don't trust it much - Original Message - From: Thomas Edison Jr. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 10, 2002 2:49 PM Subject: [PHP] Apache 2.0 or 1.3 for php on windows XP ? Glory! I have Windows XP Home Edition.. and i downloaded the latest PHP mySQL. I have Apache 1.3.19 earlier, which for some reason gives Service Apache Not Installed now even when everything is installed, on my windows XP. So i decided to get a new Apache Web Server. They have 2 versions available.. 2.0 1.3 .. i just want to know which one i should use, and if PHP is compatible with both.. and that if i do use 2.0, the Install Doc in PHP has given no instructions on how to install php on Apache 2.0, so how will i install it.. Any suggestions most welcome.. T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Uploaded File OverWriting Old File
Hi, If i have a filename room.jpg in my Upload Directory, and someone else comes and uploads a file by the same name, the previous room.jpg is overwritten by the new one. Any suggestions? This is the code i'm using : ?php $db = mysql_connect(localhost,user,pwd); mysql_select_db(dbname,$db); if ($img1_name != ) { $pic = yes; } else { $pic = no; } $date = date(l dS of F Y h:i:s A); // if $img_name isn't empty, try to copy the file if (($img1_name != ) and ($img1_size = 256000) and ($img1_type == image/pjpeg) or ($img1_type == image/jpeg)) { $sql = INSERT INTO tablename (name,age,gender,country,email,date,profile,looking,pic_name,pic) VALUES ('$name','$age','$gender','$country','$email','$date','$profile','$looking','$img1_name','$pic'); $result = mysql_query($sql) or die(You made a mistake, please go back and try again); copy($img1, mjpalpics/$img1_name) or Die (Could not do); } ? Thank you for adding you details. The following has been added to the Database :brbr big ?php $profile = stripslashes($profile); $looking = stripslashes($looking); echo ( Name : $namebr Age : $agebr Gender : $genderbr Country : $countrybr Email : $emailbr Your Profile : $profilebr You are looking for : $lookingbr ); if (($img1_size = 256000) and ($img1_type == image/pjpeg) or ($img1_type == image/jpeg)) { echo Your Photo : iName - $img1_name | Size - $img1_size | MIME Type - $img1_type/i br ; } else { echo No photograph uploaded, or wrong Type/Size photograph; } ? Thanks a LOT! T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] File Type not working in Uploaded File
Hi, Ok there were a lot of mistakes in that code. IN fact i rubbed it off completely and am using a new code.. Everything works fine now, except that if the filename exists, any new file with the same name overwrites the old file.. What do i do about it? Here is the code i'm using : ?php $db = mysql_connect(localhost,user,pwd); mysql_select_db(dbname,$db); if ($img1_name != ) { $pic = yes; } else { $pic = no; } $date = date(l dS of F Y h:i:s A); // if $img_name isn't empty, try to copy the file if (($img1_name != ) and ($img1_size = 256000) and ($img1_type == image/pjpeg) or ($img1_type == image/jpeg)) { $sql = INSERT INTO mjpals (name,age,gender,country,email,date,profile,looking,pic_name,pic) VALUES ('$name','$age','$gender','$country','$email','$date','$profile','$looking','$img1_name','$pic'); $result = mysql_query($sql) or die(You made a mistake, please go back and try again); copy($img1, mjpalpics/$img1_name) or Die (Could not do); } ? Thank you for adding you details. The following has been added to the Database :brbr big ?php $profile = stripslashes($profile); $looking = stripslashes($looking); echo ( Name : $namebr Age : $agebr Gender : $genderbr Country : $countrybr Email : $emailbr Your Profile : $profilebr You are looking for : $lookingbr ); if (($img1_size = 256000) and ($img1_type == image/pjpeg) or ($img1_type == image/jpeg)) { echo Your Photo : iName - $img1_name | Size - $img1_size | MIME Type - $img1_type/i br ; } else { echo No photograph uploaded, or wrong Type/Size photograph; } ? = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Uploaded File OverWriting Old File
Hmm... Tried it, and this doesn't sound too good : Fatal error: Call to undefined function: file_exist() in d:\apache group\apache\htdocs\mjimm\mjpals_added.php on line 37 Basically this is what i added in the appropriate place : if(file_exist($img1_name)) { $img1_name = $img1_name+n; } And thanks a lot.. Thus Spake T. Edison Jr. !! --- Nick Wilson [EMAIL PROTECTED] wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Thomas Edison Jr. declared Hi, If i have a filename room.jpg in my Upload Directory, and someone else comes and uploads a file by the same name, the previous room.jpg is overwritten by the new one. Any suggestions? Well, I presume that you would like for this *not* to happen right? if so, just add a if(file_exist($img)) { change name of img. I expect you could add an 1 to the end or better still, have the user choose another name? - -- Nick Wilson // www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE83PEnHpvrrTa6L5oRApJlAJ9n3/jsPvej8U1DwjDQnED7wwp4FQCgjjGh SO2IqQydOwy9zA0Q7TCd9no= =xxgQ -END PGP SIGNATURE- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Uploaded File OverWriting Old File
Glory Power! I'm using the following code now... the Error is gone, but it's still overwriting the old file. It's not changing the name.. not doing anything, just uploading this new file and replacing the old one.. ?php $db = mysql_connect(localhost,use,pwd); mysql_select_db(dbname,$db); if ($img1_name != ) { $pic = yes; } else { $pic = no; } $date = date(l dS of F Y h:i:s A); // if $img_name isn't empty, try to copy the file if (($img1_name != ) and ($img1_size = 256000) and ($img1_type == image/pjpeg) or ($img1_type == image/jpeg)) { if(file_exists($img1_name)) { $img1_name = n+$img1_name; } $sql = INSERT INTO mjpals (name,age,gender,country,email,date,profile,looking,pic_name,pic) VALUES ('$name','$age','$gender','$country','$email','$date','$profile','$looking','$img1_name','$pic'); $result = mysql_query($sql) or die(You made a mistake, please go back and try again); copy($img1, mjpalpics/$img1_name) or Die (Could not do); } elseif (($img1_name == ) and ($img1_size 256000) and ($img1_type != image/pjpeg) or ($img1_type != image/jpeg)) { $sql = INSERT INTO mjpals (name,age,gender,country,email,date,profile,looking,pic_name,pic) VALUES ('$name','$age','$gender','$country','$email','$date','$profile','$looking','','no'); $result = mysql_query($sql) or die(You made a mistake, please go back and try again); } ? Thank you for adding you details. The following has been added to the Database :brbr big ?php $profile = stripslashes($profile); $looking = stripslashes($looking); echo ( Name : $namebr Age : $agebr Gender : $genderbr Country : $countrybr Email : $emailbr Your Profile : $profilebr You are looking for : $lookingbr ); if (($img1_size = 256000) and ($img1_type == image/pjpeg) or ($img1_type == image/jpeg)) { echo Your Photo : iName - $img1_name | Size - $img1_size | MIME Type - $img1_type/i br ; } else { echo No photograph uploaded, or wrong Type/Size photograph; } ? = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Uploaded File OverWriting Old File
Glory! Well, I don't see any thing in your code that denotes the directory the images are going in? What about this : copy($img1, mjpalpics/$img1_name) or Die (Could not do); Sends the images to the mjpalpics Directory! 'path/to/img/img.jpg' exists and if so, name the upload img to something else. Hmm... possibly when i say if(file_exists($img1_name)), he's looking for the file name in the Directory where the Images initially go.. but then since i copy them elsewhere, they won't be in the initial place.. and so he overwrites while copying..Possibly! Don't know for sure. T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Uploaded File OverWriting Old File
Well thanks a bunch! --- Nick Wilson [EMAIL PROTECTED] wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Thomas Edison Jr. declared Hmm... possibly when i say if(file_exists($img1_name)), he's looking for the file name in the Directory where the Images initially go.. but then since i copy them elsewhere, they won't be in the initial place.. and so he overwrites while copying..Possibly! Don't know for sure. Well, check out the manual, you'll find good stuff there. and dot your code with print($whatevers) to see whats going on. - -- Nick Wilson // www.tioka.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE83Pz7HpvrrTa6L5oRAi87AJ0aqEBYw/ii3CiBjZ6h/oFlRseWuQCeKkTG NA6OVtmTrVU841aLkqnZwFI= =k4Rg -END PGP SIGNATURE- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Uploaded File OverWriting Old File
WOOO.. i did not know this was possible : file_exists(mjpalpics/$img1_name) And this might actually solve the whole issue!! Let me try this.. Thanks a BUNCH! T. Edison Jr. --- John Holmes [EMAIL PROTECTED] wrote: copy($img1, mjpalpics/$img1_name) or Die (Could not do); Sends the images to the mjpalpics Directory! Possibly. But one thing that is definitely a problem is: if(file_exists($img1_name)) { $img1_name = n+$img1_name; } should be: if(file_exists($img1_name)) { $img1_name = n . $img1_name; } Umm...wouldn't you want to use file_exists(mjpalpics/$img1_name) instead? Otherwise you're not checking for it existing in the same place you are copying it to... ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Uploaded File OverWriting Old File
Hmm.. You gave me a lot to think about, and a whole lot of work to do. I definately love your idea and logic, and yes, it would make everyone happy. well i guess by the time i figure the coding and process out, i'll keep in mind to arrange for your British Airways Gift Certificate too. Glory! T. Edison jr. --- Miguel Cruz [EMAIL PROTECTED] wrote: On Sat, 11 May 2002, Thomas Edison Jr. wrote: If i have a filename room.jpg in my Upload Directory, and someone else comes and uploads a file by the same name, the previous room.jpg is overwritten by the new one. Any suggestions? In the long run, I think the best plan is to name your files after the unique database ID. Store the names ('room.jpg') in the database. If you expect getting more than a thousand files or so, split them into directories. If you use a numeric key, just take the last digit or two and use that for the directory (for instance, '4745' would go in '5/4745'). Then write a simple readfile script to process downloads (see today's thread about protecting downloads). You can look in the database and construct URLs like: img src=image.php/4745/room.jpg and your download script can look at the number to figure out which directory it's in, and look at the file name to figure out the mime type to send. The browser's happy because it thinks it's getting a file called room.jpg no matter how many of them you have, the server is happy because the files are spread nicely across a few directories, you're happy because you got your work done, and I'm happy because you sent me a British Airways gift certificate out in gratitude. miguel -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] File Type not working in Uploaded File
Hi, This is my upload form : form action=upload.php method=POST enctype=multipart/form-data p align=centerfont size=2 face=VerdanastrongPlease upload your file below:/p input type=file name=file size=30 pinput type=button name=submit type=submit Upload /form And this is part of my PHP coding, that handles the Upload. Basically the problem is, that my code is not recognising the File Type! I have specified image/jpeg as the file type, but even then it does not upload ANY file at all. In fact it gives the specific error which i have associated when the file type is wrong. * $allow_type = image/jpeg; $allow_file_type = 1; $not_correct_file = bfont face=\$font\ size=\$font_size\ color=\$font_color\Sorry, but the file you tried to upload is not valid file to upload!; if ($allow_file_type == 1) { if ($allow_type != $type) { die($not_correct_file); } } * Why is it that it is NOT recognising ANY file type. I tried removing the Cheking of FILE type, and the program was working fine, where it was Uploading ANY file. However, as soon as i put in this particular code to check for File Type, it does NOT upload any file. Help! T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Shopping - Mother's Day is May 12th! http://shopping.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Help With postgresql
Hello, I need help with a website that I had design as a E-commerce tool. There's a credit card option in the shopping cart, That I would like to remove. The guy that design the site said that It would need to be turned off in the database. Any help would be great. I know the database is postgresql. Thanks for any help. Jr -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] importing .dat SQL Data into mySQL
Hi, I have a .dat file.. with some data like this : 02001IN00100213200207120020412200204122002041710002002041720020417 02002IN00100213200207220020415200204152002041810002002041820020418 02003IN00100213200207320020416200204162002041910002002041920020419 This data was exported via SQL Server.. using Oracle. I need to use this data in my mySQL Database and work on it through PHP. Can i use phpMyAdmin for this.. or some other method? Thanks, T. Edison Jr. __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Search Results, Per Page, Total Results!
Hi, I have a mySQL table on which i'm performing a search.. something like this : $sql_text = (SELECT * FROM searchtb where vCategory='$q' || vSubCategory='$q'); Now i want the Search Results to appear per page.. that is, maybe 15 Records per page should appear.. with something like this on top to navigate through search results : Page : [] 1|2|3|4|5 [] And i would also like to display total results found on results page. Lastly, suppose i have a column vProName in my mySQL Database, which contains a record like this : Millenium basket ball Now if someone searches for basket or ball .. i want this record to show up in search results. How can i make that possible? Can anyone guide me towards this.. Thanks, T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Search Results, Per Page, Total Results...
Hi, I'm working on a search program that searches on a mySQL DB and gives back results.. something like this : $sql_text = (SELECT * FROM searchtb where vCategory='$q' || vSubCategory='$q'); What i want is that the results should be displayed PageWise.. that is, maybe 15 results per page. Something like this : Page : [] 1|2|3|4|5 [] And also i would like to display the Total Results on the resulst page. Secondly, i have a table with a column vProName, which let's say, contain Basket Ball Game. Now what i want is that if someone searches for Game or Ball, even then this record should appear. Could someone guide me for the same Thanks, T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Searching a mySQL DB
I'm working on a search program that searches on a mySQL DB and gives back results. I have a table with a column vProName, which let's say, contains a record Basket Ball Game. Now what i want is that if someone searches for Game or Ball, even then this record should appear. Could someone guide me for the same Thanks, T. Edison Jr. __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Adding a in try.jpg!
I have a new very intriguing problem at hand. I have the name of my Images stored in my mySQL database in one column. Now when i pick the images, they are displayed as it as. However, they are the big images, and the thumbnails of those images are stored with an a at the end of thier names. That is, If the image is try.jpg , the thumbnail of the image is trya.jpg !! Now i want to display the thumbnail and not the large image. And unfortunately, my whole database contains the name of Large images and NOt the Thumbnails. How can i : 1. Insert a at the end of the name of the image, before the .extension through PHP. The problems are that the names are stored in the database WITH the extesion. And the extensions also vary, some are JPG and some are GIF. So in my datase i have images as try.jpg or something.gif! How can i insert an a at the end of the name before the . ? 2. OR.. can i insert the a before the . in the image name in my mySQL database itself. Either of the two solutions can work for me. Thanks, T. Edison Jr. __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Adding a in try.jpg! Problems!
Hi, Thanks for your relies. There are a couple of problems. Firstly, i'm picking the filename from the database, so my code is something like this : if ($myrow = mysql_fetch_array($result)) { do { echo( img src=\images\\$myrow[ilmage]\ ); } while ($myrow = mysql_fetch_array($result)); } Now the filename is actually stored in $myrow[ilmage] How do i perform the spliting adding functions on $myrow[ilmage] ?? Secondly, all images are not .JPG, some are jpg others are gif !!! Thank you.. T. Edison Jr. --- Miguel Cruz [EMAIL PROTECTED] wrote: (untested) $newname = eregi_replace('\.jpg$', 'a.jpg', $oldname); No point messing up your database; just use something like the above when you're outputting the image tags for the thumbnails. miguel On Mon, 8 Apr 2002, Thomas Edison Jr. wrote: I have a new very intriguing problem at hand. I have the name of my Images stored in my mySQL database in one column. Now when i pick the images, they are displayed as it as. However, they are the big images, and the thumbnails of those images are stored with an a at the end of thier names. That is, If the image is try.jpg , the thumbnail of the image is trya.jpg !! Now i want to display the thumbnail and not the large image. And unfortunately, my whole database contains the name of Large images and NOt the Thumbnails. How can i : 1. Insert a at the end of the name of the image, before the .extension through PHP. The problems are that the names are stored in the database WITH the extesion. And the extensions also vary, some are JPG and some are GIF. So in my datase i have images as try.jpg or something.gif! How can i insert an a at the end of the name before the . ? 2. OR.. can i insert the a before the . in the image name in my mySQL database itself. Either of the two solutions can work for me. Thanks, T. Edison Jr. __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Adding a in try.jpg! SOLVED!!
Hi, Thanks.. actually that problem is solved, this is what i used : $myrow[ilmage] = eregi_replace('\.jpg$', 'a.jpg', $myrow[ilmage]); $myrow[ilmage] = eregi_replace('\.gif$', 'a.gif', $myrow[ilmage]); and it's now showing the small images with the a!! Thanks AGAIN! T. Edison Jr. --- Miguel Cruz [EMAIL PROTECTED] wrote: (untested) $newname = eregi_replace('\.jpg$', 'a.jpg', $oldname); No point messing up your database; just use something like the above when you're outputting the image tags for the thumbnails. miguel On Mon, 8 Apr 2002, Thomas Edison Jr. wrote: I have a new very intriguing problem at hand. I have the name of my Images stored in my mySQL database in one column. Now when i pick the images, they are displayed as it as. However, they are the big images, and the thumbnails of those images are stored with an a at the end of thier names. That is, If the image is try.jpg , the thumbnail of the image is trya.jpg !! Now i want to display the thumbnail and not the large image. And unfortunately, my whole database contains the name of Large images and NOt the Thumbnails. How can i : 1. Insert a at the end of the name of the image, before the .extension through PHP. The problems are that the names are stored in the database WITH the extesion. And the extensions also vary, some are JPG and some are GIF. So in my datase i have images as try.jpg or something.gif! How can i insert an a at the end of the name before the . ? 2. OR.. can i insert the a before the . in the image name in my mySQL database itself. Either of the two solutions can work for me. Thanks, T. Edison Jr. __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MS Access data = mySQL database
Hi, I did actually download DBTools and i think its' an excellent software. It's running perfect on my system too. Just a couple of things i'd like to ask you, since you have already used this and i'm fairly new to this... You see, my MySQL server/database is on a web server, for a online website. Now how do i connect the DBTools on my system to the Web Server on the Internet, and then to the database on the website?? Once i'm able to connect to that, then i think it should not be a problem to import the Data from the MS Access table into the MySQL table on the internet. Really appreciate your help... Thanks! T. Edison jr. --- Steven Dowd [EMAIL PROTECTED] wrote: you should try this program , DBTools http://www.dbtools.com.br/ a.. Import Structure and Data from others Databases (MS Access, MS FoxPro, Clipper, Dbase, Paradox, Text Files and ODBC Data sources) a.. Export the database/table contents to SQL, Text, HTML or XML documents. You can dump it directly by using the Dump Data or you can export your results (this includes other formats) a.. You don't need to have MySQL server installed in a WIN32 platform. DBTools can connect to MySQL wherever you have your server installed, using TCP/IP and MySQL C API. I use this constantly to transfer direct from access / excell into mysql. its isnt the answer for you if you want to do it completly with php, but it gets you to the basic area, and transfers the data.. there is at www.hotscripts.com a php accessmysql converter, i tried it last year, but found it very buggy. cannot remember what it was called steven dowd - Original Message - From: Thomas Edison Jr. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 25, 2002 11:31 AM Subject: [PHP] MS Access data = mySQL database Can anyone tell me how to convert/send data stored in an MS Access database to a mySQL table through PHP?? T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MS Access data = mySQL database
Thanks... actually the software DBTools from www.dbtools.com.br is excellent for the same purpose, as suggested by someone here. It does the needful pretty efficiently. Cheers! T. Edison Jr. --- Jon Farmer [EMAIL PROTECTED] wrote: Can anyone tell me how to convert/send data stored in an MS Access database to a mySQL table through PHP?? 3 Ways of doing this come to mind. Only one uses PHP though. 1. From PHP use ODBC to extract from access and send to MySQL through PHP functions. 2. Export to csv from Access and use mysqlimport to import into MySQL. 3. Use the MySQL ODBC driver to link the MySQL tables into Access and run a query to copy the records over. Regards Jon -- Jon Farmer Systems Programmer, Entanet www.enta.net Tel 01952 428969 PGP Key available, send email with subject: Send PGP Key = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Personal web server that runs PHP
Hi, Of course. The Personal Web Server that is available with Windows 98 as an Add-On totally supports PHP4. I have it configured on my system. I'm not sure if i know of a place where you can download it from.. But it's available as an Add-On with Windows 98 CD. If you look on the net, i'm sure you'll find the PWS. Regards, T. Edison jr. --- Don [EMAIL PROTECTED] wrote: Hi, Does anyone know of a personal web server that I can installon my Win 98 machine that supports PHP 4.x? Thanks, Don = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Personal web server that runs PHP
In fact, using Apache Win32 Module on a Windows 98 PC is a much better choice option rather then PWS. Apache server gives greater flexibility support. I don't see any reason why you should choose PWS over Apache Win32 for your Win 98 PC? T. Edison Jr. --- R'twick Niceorgaw [EMAIL PROTECTED] wrote: u can use Apache on win 98 I believe ? - Original Message - From: Don [EMAIL PROTECTED] To: php list [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 12:56 PM Subject: [PHP] Personal web server that runs PHP Hi, Does anyone know of a personal web server that I can installon my Win 98 machine that supports PHP 4.x? Thanks, Don -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] MS Access data = mySQL database
Can anyone tell me how to convert/send data stored in an MS Access database to a mySQL table through PHP?? T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Error Handling!
I want errors reported on a page when the mail() function for any reason fails to send emails. FOr example, if there is a malformed email address or anything, and the mail is not sent, how can i catch the Error and Display it on the page? Thanks, T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] 5 Records per line
Hi, I would like to display 5 records per line on the Results page. Not seperated by a comma, but just seperated by Space. How can i do that? Thanks, T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] 5 Records per line
Hi, Thanks for writing back. Basically what i want is, that on a results page, i want that the records should be placed only 5 on one line. For example, let's say i have 100 usernames in a table in my database. Now on one page, i want to display all these usernames. But i want that in one line, there should be only 5 usernames, seperates by spaces. Like this : user1 user2 user3 user4 user5 user6 user7 user8 user9 user10 Can you help? Thanks, T. Edison jr. --- RIVES Sergio [EMAIL PROTECTED] wrote: may you give me more explanations ? thanx SR Thomas Edison Jr. a écrit : Hi, I would like to display 5 records per line on the Results page. Not seperated by a comma, but just seperated by Space. How can i do that? Thanks, T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] 5 Records per line
Hi, This is the code i'm using so far : ?php $db = mysql_connect(localhost,user,pass); mysql_select_db(mydb,$db); $result = mysql_query(SELECT * FROM sms ORDER BY ID DESC,$db); if ($myrow = mysql_fetch_array($result)) { do { echo(bfont color=#6ed8ff$myrow[num]/b br); } while ($myrow = mysql_fetch_array($result)); } else { echo Sorry, no records matching your criteria were found!; } ? But this displays all records one per line... T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] 5 Records per line
Hey THANKS! It worked.. just the way i wanted! Thank you so much. T. Edison Jr. --- RIVES Sergio [EMAIL PROTECTED] wrote: i don't know if it will work... i am quite a newbie in this stuff. Hope it could help you Thomas Edison Jr. a écrit : Hi, This is the code i'm using so far : ?php $db = mysql_connect(localhost,user,pass); mysql_select_db(mydb,$db); $result = mysql_query(SELECT * FROM sms ORDER BY ID DESC,$db); if ($myrow = mysql_fetch_array($result)) { do { echo(bfont color=#6ed8ff$myrow[num]/b br); if ($counter % 5 == 0) { print br; } $counter++; } while ($myrow = mysql_fetch_array($result)); } else { echo Sorry, no records matching your criteria were found!; } ? But this displays all records one per line... T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Check @ in Record show Error in mail() !!
Hi, I'm using the following code to get Email Address stored in a table in my Database : ?php $db = mysql_connect(localhost,user,pass); mysql_select_db(mydb,$db); $result = mysql_query(SELECT * FROM sms where email!='' ORDER BY ID DESC,$db); if ($myrow = mysql_fetch_array($result)) { do { echo(bfont color=#6ed8ff$myrow[email]/b br); } while ($myrow = mysql_fetch_array($result)); } else { echo Sorry, no records matching your criteria were found!; } ? But there are some records where the user has entered something else.. not the Email Address. I would like to list only those records out of these, who do contain the letter @, so that i'm sure only those records which actually do contain an Email Adress are listed. Also, when sending an email, like this : if($submit) { $headers .= From: Mjimm.com [EMAIL PROTECTED]\n; $headers .= X-Sender: [EMAIL PROTECTED]\n; $headers .= X-Mailer: PHP\n; // mailer $headers .= Reply-To: [EMAIL PROTECTED]\n; // Return path for errors $headers .= bcc:$b\n; // BCCs to mail($to,$subject,$message,$headers); } ? If there are any errors in sending the mail, how can i get those errors, or at least have the alert that an error was there and mail could not be sent, printed on the page? Thanks, T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin
With the phpMyAdmin, you get a Config.inc file. You will have to change the parameters (username, password, database) etc., in order to access your phpMyAdmin. T. Edison Jr. --- Chuck \PUP\ Payne [EMAIL PROTECTED] wrote: I have a client that has install phpMyAdmin but can't get into he gets this error; Error MySQL said: Access denied for user: 'root@localhost' (Using password: NO) Is there a way to get into if he knows the password? Chuck PUP Payne Sr. System Administrator GDI Engineering, Inc. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] 5 Records in a row displayed!
Hi, I'm looking to display 5 records in one rows, from the database. What i mean is, basically, let's take the emails as an example. I have a table with 100s of email addresses. Now i want to display these email addresses on a page, but i want to display only 5 email adresses in one line, then the next 5 in the next line and so on. Also, perhaps if these emails are seperated by space, nothing else or more. Can someone help me with a code. Regards, T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] How-to start a file download?
Hello all, This may be an HTML question, I'm not sure I need to start a file download from within php The file I wish to download is named INSTALLEREXE, and is an InstallShield setup program I know I can use an anchor with an HREF to start a transfer: (A HREF=INSTALLEREXE)Click here(/A), but I don't want the user to have to click on anything to start the download -- when they go to myPagephp I would like the download to start immediately Is this possible? More information: I have some (non-http) client/server software that includes authentication upon connection If someone uses my client to connect to my server, they must have an account established on the server and they must authenticate upon connection, else the server turns them away I'm trying to make the whole process of setting up new users (registering and installing the client) easy My desire is to write a form-based wizard that guides the new user thru a register-download-verify process Step 1 Asks for the desired login id and checks that it is not already in the user database(this works) Step 2 Asks for the password, with verification, and inserts the login id into the user database (this works too) Step 3 Starts the agent download process Step 4 Verifies that the agent has downloaded and installed properly The trouble comes in transitioning from step 2 to step 3 When the user presses NEXT on step 2, I would like the wizard to start the download, and say When the download and installation is complete press NEXT The problem seems to be that the action= for step 2 must do two things: start a file download AND display the next step of the wizard Any advice or examples would be appreciated! ed -- PHP General Mailing List (http://wwwphpnet/) To unsubscribe, visit: http://wwwphpnet/unsubphp