Re: [PHP-DB] Trigering PHP Code
Or, you could use XmlHttpRequest, which is what google suggest uses. http://www.google.com/webhp?complete=1 You can use this to dynamically populate a section of the page. I wouldn't delve into it unless you have some xml/javascript experience also though. Try this page for more info: http://www.scss.com.au/family/andrew/webdesign/xmlhttprequest/ -Jeff - Original Message - From: Bastien Koert [EMAIL PROTECTED] To: [EMAIL PROTECTED]; php-db@lists.php.net Sent: Wednesday, December 29, 2004 12:15 PM Subject: RE: [PHP-DB] Trigering PHP Code see interspersed comments bastien From: Nayyar Ahmed [EMAIL PROTECTED] Reply-To: Nayyar Ahmed [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Trigering PHP Code Date: Wed, 29 Dec 2004 19:43:35 +0500 Hello All, I have two problem in my php file i.e. 1. I want to triger some php code, soon after when a selection is done from Drop Down Menu, For Example: When user select country name the State,city menu fill dynamically. 2 ways to do this 1. use javascript and pass all the data down to the client and have js do the manipulation 2. submit the page and draw the next select box at that time filled with a db query 2. I want to use a variable value gathered in one php file to some any other php file use sessions see http://www.php.net/sessions For Example: When user enter his/her name , I will use in later processing in by some other php file. I hope, I have explained my problem: TIA, Regards, -- Nayyar Ahmad Lecturer Faculty Of Computer Science, Institute Of Management Sciences, Hayat Abad Peshawar , Pakistan. Office : 92-091-9217404 , 9217452 Cell : 92-0333-9139461 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] how many databases should I create
Matter of preference really. Do you put all your files in one directory? I do for the most part, but when it comes to security you can divy out access to different databases rather than each table and it makes things simpler, so I use different databases for different projects. Also, I think you can move different databases around onto different partitions if they get too big. -Jeff - Original Message - From: Perry, Matthew (Fire Marshal's Office) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 18, 2004 1:37 PM Subject: [PHP-DB] how many databases should I create I am developing a variety of different web based systems including inventory, payroll, incident reports etc. Should I create a new database for each project category or one huge database with every table I will ever use in it? -Matt -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Checkbox Array Question - Iteration
Well, you should come up with a definitions table.
Create an array out of the definitions table (I'd recommend keeping
everything in one array, for recursive efficiency). Then go over THIS array,
and check for the existence of variables in the form array. That way you can
output all the checkboxes and not just the ones that are checked, and all
your definitions are stored in the database.
Later on you may want to make a simple web based tool to add options (for
non-coders).
-Jeff
- Original Message -
From: Hutchins, Richard [EMAIL PROTECTED]
To: PHP-DB (E-mail) [EMAIL PROTECTED]
Sent: Tuesday, August 17, 2004 11:37 AM
Subject: [PHP-DB] Checkbox Array Question - Iteration
I am developing a page where people check off items for which they would
like to volunteer. For now, this page has around 50 checkboxes on it, but
it
could conceivably change frequently and grow much larger than the current
50
items once it goes live.
I have all of the checkboxes arranged into nice little arrays and named
things like name=kitchen[waitstaff] and name=kitchen[cook],
name=professional[paint]. I take the checked boxes, serialize them, and
store them in columns in MySQL that bear the same name as the array (e.g.,
kitchen, professional). All of this works fine and I'm very happy with it.
Now, when the person revisits the page to update his/her selections, I
query
the database and unserialize the column data. I then search the resulting
array and if the name of the checkbox is found in the array, I echo
checked to select the checkbox. See below:
snip
while($row = mysql_fetch_array($curRecord)){
$vid=$row[vid];
$pID=$row[pID];
$kitchen = unserialize($row[kitchen]);
$kitchenevt = unserialize($row[kitchenevt]);
$profesional = unserialize($row[professional]);
.
.
.
}
//BUNCHA' IRRELEVENT STUFF CUT OUT OF HERE
span class=bodyBoldGeneral Kitchen Help/spanbr
?php
echo input type=\checkbox\ name=\kitchen[waitstaff]\;
if(in_array(waitstaff,$kitchen)){
echo checked;
}
echo nbsp;span
class=\body\Waiter/Waitress/spanbr;
echo input type=\checkbox\ name=\kitchen[cook]\;
if(in_array(cook,$kitchen)){
echo checked;
}
echo nbsp;span class=\body\Cook/spanbr;
.
.
.
//AND SO ON FOR EVERY SINGLE CHECKBOX.
?
/snip
So, having set up a sample section of checkboxes on my page using the
logic
in the snippet above, I am wondering if there is a much more efficient way
to look at the arrays that get returned from the database, check to see if
the given checkbox is contained therein, then, if it is, echo checked.
The
solution snippet above works just fine, but whenever I find myself
contemplating doing the same thing over and over in code, that's obviously
a
flag for investigating an iterative solution.
Right now, though, I'm struggling with trying to noodle out whether
setting
up some sort of iterative function would be more work than simply doing
what
I'm doing now. Obviously, iteration is always great for handling
repetitive
work, but I'm just not having much luck coming up with a solution.
I am aware that this is probably slightly off-topic since it isn't a
direct
php/db question, but I was hoping somebody might be kind enough to offer
up
suggestions as to how I might construct such a solution anyway.
Thanks in advance for you time.
Rich
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] help with mySQL- Fatal error: Call to undefined function mysql_connect()...
Gotta recompile php with the --with-mysql option (or something like that). Try running configure --help You can see what options you compiled with by grepping for CONFIGURE in your Makefile. Here's what I got: [EMAIL PROTECTED] php-5.0.0b4 # grep CONFIGURE Makefile CONFIGURE_COMMAND = './configure' '--with-mysql' '--with-apxs2=/usr/sbin/apxs2' '--with-zlib' '--with-xsl' '--with-imap-ssl' Dude, I need to update! -Jeff - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 17, 2004 12:02 PM Subject: [PHP-DB] help with mySQL- Fatal error: Call to undefined function mysql_connect()... I know this is probably the noobiest of questions but please help. Fatal error: Call to undefined function mysql_connect() in .. on line 112 This occurs when I try to access a MySQL application, specifically Invision Power Boards. I have PHP5 installed on my Apache 1.3.31, and I believe that my MySQL is MySQL4, all this on Windows XP personal. My php.ini file is in my systemroot (C:/windows). Currently I have no loaded extensions for MySQL/php connections stuff (ex: php_mysql.dll, php_mysqli.dll). I tried some stuff I found on help boards but everything just got all messed up, so I thought I'd get more official help. I have all of the php .DLL files that came with the zip file in C:/windows/system32. PHP-mysql.DLL and php_mysqli.dll are in both system32 and just c:/windows. When I run phpinfo() I get no mention of MySQL. MySQL itself connects to the MySQL server just fine. I think that's everything. Thanks in advance. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] help with mySQL- Fatal error: Call to undefined function mysql_connect()...
Oh, you're using windows. To use an extension, set it up as follows. 1.. Open the PHP.INI file and locate the following line. extension_dir = ./ This line indicates the folder where the PHP extension DLL files are located. Edit this line to: extension_dir = C:\php\extensions 2.. Select from the PHP extension choices. Note that some of these files depend on other software to work correctly (such as the Oracle 8 extension). Consult the PHP documentation to see what additional software (if any) is required. 3.. See an example for loading an extension in the following commented out line: ;extension=php_zip.dll Uncomment the line, as follows: extension=php_zip.dll 4.. Save your changes. 5.. Browse the PHP test page in your browser. The following appears: Also make sure phpinfo is showing the right php.ini file that you expect it to be. (http://www.macromedia.com/devnet/mx/dreamweaver/articles/php_iis.html) -Jeff - Original Message - From: Jeffrey Moss [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 17, 2004 12:08 PM Subject: Re: [PHP-DB] help with mySQL- Fatal error: Call to undefined function mysql_connect()... Gotta recompile php with the --with-mysql option (or something like that). Try running configure --help You can see what options you compiled with by grepping for CONFIGURE in your Makefile. Here's what I got: [EMAIL PROTECTED] php-5.0.0b4 # grep CONFIGURE Makefile CONFIGURE_COMMAND = './configure' '--with-mysql' '--with-apxs2=/usr/sbin/apxs2' '--with-zlib' '--with-xsl' '--with-imap-ssl' Dude, I need to update! -Jeff - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 17, 2004 12:02 PM Subject: [PHP-DB] help with mySQL- Fatal error: Call to undefined function mysql_connect()... I know this is probably the noobiest of questions but please help. Fatal error: Call to undefined function mysql_connect() in .. on line 112 This occurs when I try to access a MySQL application, specifically Invision Power Boards. I have PHP5 installed on my Apache 1.3.31, and I believe that my MySQL is MySQL4, all this on Windows XP personal. My php.ini file is in my systemroot (C:/windows). Currently I have no loaded extensions for MySQL/php connections stuff (ex: php_mysql.dll, php_mysqli.dll). I tried some stuff I found on help boards but everything just got all messed up, so I thought I'd get more official help. I have all of the php .DLL files that came with the zip file in C:/windows/system32. PHP-mysql.DLL and php_mysqli.dll are in both system32 and just c:/windows. When I run phpinfo() I get no mention of MySQL. MySQL itself connects to the MySQL server just fine. I think that's everything. Thanks in advance. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] FULLTEXT and LIKE
Well, like will do a full table scan if it starts with a wildcard, so you dont want to do it that way. I'd do full text search. http://dev.mysql.com/doc/mysql/en/MySQL_indexes.html -Jeff - Original Message - From: Monty [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 22, 2004 12:57 PM Subject: [PHP-DB] FULLTEXT and LIKE Hi, My head is swimming with lots of info gleaned from various newsgroups about using fulltext indexes in MySQL, but, I'm still not sure what the best solution would be for what I want to do. I'm concerned about the 3-char minimum and not being able to search on partial words (my version of MySQL doesn't support boolean fulltext searches). I have a simple News table that is structured like this: CREATE TABLE `news` ( `id` int(7) unsigned NOT NULL auto_increment, `author` varchar(50) NOT NULL default '', `headline` varchar(60) NOT NULL default '', `content` text NOT NULL, `url` text NOT NULL, UNIQUE KEY `id` (`id`), ) TYPE=MyISAM; I want searches for News to be on the author, headline and content fields. What is the best way to index and search this? A) Create a combined fulltext index: FULLTEXT (author,headline,content) -- and do searches using MATCH() and AGAINST(). B) Create a fulltext index only for the content field and use this kind of select: SELECT * FROM db WHERE author LIKE %phrase% OR headline LIKE %phrase% OR MATCH(content) AGAINST(phrase); C) None of the above ... is there a better way? Thanks a lot for any input or feedback! I'm completely lost! Monty -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Read a PDF file via PHP
Steve, You must turn the file to postscript before you can read anything out of it, and even then, a lot of the time words are broken up into different show statements. use pdf2ps (part of GNU GhostScript) to convert to PS and then search for patterns like this: (text) show that is the most basic postscript syntax but often it is more complex than that. The Adobe postscript 3 driver for windows creates all in one lines with positioning and formatting parameters. So basically, you look for anything in parenthesis to be text. For indexing you may get by just looking for anything in parenthesis, but I would look for a third party utility to do it if you want it done perfectly. -Jeff Moss - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 25, 2004 1:36 PM Subject: [PHP-DB] Read a PDF file via PHP I'm working on a file upload system that accepts PDF files, reads the text in those files, and enters it into a database, which makes the text from the PDF indexable and searchable. I've got it all down except for the ability to read the text from a PDF file. When the PHP read file function is used, the PDF file is read just fine, but when I return the results to my browser, they're of course nothing but jumble, because the code for the entire file was read. Is there any way to get PHP to simply read the PDF file for text only--just the surface of it, just the words, as if it were a human reading the PDF itself--and not for the internal code of the file? Thanks, Steve -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysql went away
I would start by seeing if the files are there after you create/load the table. It should by default create a file for each table you create. Sounds to me like a problem reading the disk. If you don't find any answers on your own, post your system specs to the MySQL lists. You could also try verbose debugging options, I've never used any debugging, but here's how to do it in mysqladmin. --debug[=debug_options], -# [debug_options] Write a debugging log. The debug_options string often is 'd:t:o,file_name'. The default is 'd:t:o,/tmp/mysqladmin.trace'. -Jeff - Original Message - From: Bill Green [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 12, 2004 4:05 PM Subject: [PHP-DB] mysql went away HI. I've been using mySQL 4.0.13, php4.3.4, and phpMyAdmin2.5.5 on Mac OS 10.3.3 as a learning/testing/development environment for a couple of months now - no problems, works great. I've created more than a few mySQL databases and tables, but yesterday I created a database, a table, and LOAD DATA from within phpMyAdmin. Successfully. I looked at the data and all was fine. Logged out and went away for a while. Came back and phpMyAdmin would not show me my databases in the left frame, and I could not launch a query window. I could see runtime information, system vars, processes, and even privileges. I tried logging in to mySQL through the terminal, and I can run simple commands and connect OK, but any commands to show databases or tables will hang the terminal. Through the command line client I can run simple commands, but no commands to view or affect databases or tables. I can run php scripts - connect to databases, retrieve and even insert/update data, but I cannot view databases or tables. Does anyone have a clue about what the problems may be or where I should start? --- Bill Green 20 Meadowview Drive Asheville, NC 28804 -- [EMAIL PROTECTED] http://www.billgreen.org 828.252.1492 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] search engines
Read up on MySQL full text search. http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html -Jeff - Original Message - From: redhat [EMAIL PROTECTED] To: phplist [EMAIL PROTECTED] Sent: Thursday, April 29, 2004 10:12 AM Subject: [PHP-DB] search engines Anyone out there know of a good tutorial on creating a php/mysql based search engine script? I would like to write one for a small in-house application that I am running. thanks, DF -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] pdf editor
I think someone else asked about a problem where they had text running off
the side of the page, heres everything I've ever learned about PS/PDF.
GNU ghostscript is all you really need for editing pdf's. Usually the text
appears as plain text once you convert the PDF to a PS with pdf2ps, and you
can just delete it and put it back as PDF using ps2pdf. I do quick changes
like this all the time. The adobe postscript 3 driver for windows outputs
clean postscript, I use it a lot for email merge with PDF cause I can't
afford more expensive products. Here's some notes I made a while back on it,
you may need to view my little diagrams with courier fonts:
The first two parameters are the location of the text. Depending on how the
text will function, you have two choices, you can either let the postscript
file handle spacing, or you can use static letter spacing and if there is
too much text for one line it will spill off the page.
You want to use static spacing for fields, where there is no other text to
space, but if you are inserting a name into the middle of a line of text,
you will want to let postscript handle spacing, like this (here what I
know):
-2040 -1827 ( *#address1#*) -2.666595 0 725 5 16 A1`65
^ ^ ^ ^ ^
x coord y coord text string width maximum letter spacing?
If you want to do static text, simply convert this line to this, by adding a
moveto after the coordinates, and chaging all the number parameters to
show.
-2040 -1827 moveto
( *#address1#*) show
When the text runs off the right side of the page, my solution was to change
the original document, and drop it down onto its own line. Its possible to
program postscript to automatically add a line break when the line gets too
big, I don't know postscript so don't ask me how to get this to work:
.
/Helvetica-Bold-SHOWISO exch definefont pop
/Helvetica findfont
dup length dict begin
{1 index /FID ne {def} {pop pop} ifelse} forall
/Encoding showcaseisoencoding def
currentdict
end
...
31 189 M (Comments:) S
/Helvetica-Bold-SHOWISO findfont 24 scalefont setfont
/rule (___) def
/y 189 def /x 141.336 def
y -29 73 { x exch M rule S } for
rule stringwidth pop 29 x y comments BreakIntoLines
grestore
grestore
showpage
This postscript is taken from the default fax coversheet file (faxcover.ps)
from gnu hylafax.
-Jeff
- Original Message -
From: matthew perry [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 07, 2004 9:53 AM
Subject: [PHP-DB] pdf editor
I use Windows XP.
Really all I need to do is remove a single line in a pdf file and I
can't convince myself to spend $749 for Acrobat Pro to do it.
- Matt
On 7 Apr 2004, at 16:34, matthew perry wrote:
Does anyone know a free pdf editor?
what platform do you require it for?
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email [EMAIL PROTECTED]
Web http://www.brightstorm.co.uk
Tel 0117 9426653 (office)
07939 252144 (mobile)
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] password input type
It is possible to md5 encrypt a password before you send it off to the server using javascript onSubmit function. Check this code out: http://pajhome.org.uk/crypt/md5/ -Jeff Moss - Original Message - From: matthew perry [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 05, 2004 12:14 PM Subject: [PHP-DB] password input type Does using a pasword input type input name=password type=password make the transfer more secure from someone sniffing my connection or does it only shield an onlooker from seeing what the user enters? - Matt -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: Re[2]: [PHP-DB] Optimising LIMITs
JM Primary keys aren't any faster than normal keys. They're simply for JM identification. (correct me if I'm wrong, that is my understanding) JM If you don't already have an index on created, I'd do that. I do - here's a question though, what is the best way to have an index? To combine multiple fields into one index - or to have one field per index? I ask because MySQL will appear to select the best possible index for the query and sometimes it's wrong - I read somewhere you can control which index it uses, but if you had a combined index would this make things any more/less effective? Well, it can't use a multi-column index if you are only matching on one column. If you have 3 indexes, (status, boardid), (status), and (boardid), it won't slow you down any on your queries. If one index is needed it is put into memory and stored there until another index bumps it, otherwise it resides on disk. I don't see it has too much of a performance dock, it may slow down inserts a little... I am not sure about this, but I think if you are going to have the 2 column indexes, they have to match up in both tables you're joining. You'll have to experiment with it a bit. you can say select * from thread (index statusBoardCombinedIndex) where to get the index you want. JM If you want to optimize things further, I would run the query at midnight JM each morning, and instead of paging through the entire table, just page JM through that temporary table. Figured someone might suggest that - I will have to look into it. Thanks. -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] sybase support in PHP5
Is Sybase support in PHP5 working? I get: /bin/sh /usr/portage/tmp/php-5.0.0b3/libtool --silent --preserve-dup-deps --mode=compile gcc -Iext/sybase/ -I/usr/portage/tmp/php-5.0.0b3/ext/sybase/ -DPHP_ATOM_INC -I/usr/portage/tmp/php-5.0.0b3/include -I/usr/portage/tmp/php-5.0.0b3/main -I/usr/portage/tmp/php-5.0.0b3 -I/usr/portage/tmp/php-5.0.0b3/Zend -I/usr/include/libxml2 -I/usr/include/mysql -I/opt/sybase-11.9.2/include -I/usr/portage/tmp/php-5.0.0b3/TSRM -g -O2 -prefer-pic -c /usr/portage/tmp/php-5.0.0b3/ext/sybase/php_sybase_db.c -o ext/sybase/php_sybase_db.lo /usr/portage/tmp/php-5.0.0b3/ext/sybase/php_sybase_db.c: In function `zif_sybase_fetch_object': /usr/portage/tmp/php-5.0.0b3/ext/sybase/php_sybase_db.c:1110: invalid lvalue in assignment /usr/portage/tmp/php-5.0.0b3/ext/sybase/php_sybase_db.c:: invalid lvalue in assignment make: *** [ext/sybase/php_sybase_db.lo] Error 1
