Re: [PHP-DB] functions via event handlers

the closest you could come is to make javascript functions call php pages basically redirects that would call the php functions. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] Zip Code Fields

i use varchar(10) for mine that way the starting 0 is not knocked off but it also allows for 0- format zips -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] PHP 5 Error Handling

the line of the file where the throw statement is. Is there a way to make it show the actual line number of the line that is the error? the $this->command("NoSuchCommand\n"); line. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account conta

Re: [PHP-DB] PHP 5 Error Handling

> gets thrown, the $line_no is captured, and I can use the info to print > to the logs or the screen or ... > > G. > > Gary Every > Sr. UNIX Administrator > Ingram Entertainment Inc. > 2 Ingram Blvd, La Vergne, TN 37089 > "Pay It Forward!" > > >

[PHP-DB] Socket Errors

not be completed immediately. ) in D:\htdocs\WebReader\System\NET\Sockets\Socket.php on line 25 -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

[PHP-DB] Re: [nyphp-talk] Socket Errors

nt be able to connect to the account. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: [nyphp-talk] Socket Errors

nt be able to connect to the account. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: [nyphp-talk] Socket Errors

nt be able to connect to the account. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] unsubscribe me

question. > > ---John Holmes... > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST --

Re: [PHP-DB] Question on Registration Method

users). > > > > > > > > Just make a usergroup for accounts that haven't been > > > > activated yet. > > > > Also, a separate table holding information on how to > > > > activate (something > > > > along the lines of userid, touse

Re: [PHP-DB] Question on Registration Method

gt; users, users). > > > > > > > > Just make a usergroup for accounts that haven't > > been > > > > activated yet. > > > > Also, a separate table holding information on > > how to > > > > activate (something > > > > along the lines of userid, tousergroup, > > > > activationcode). > > > > > > > > / rylin > > > > > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, visit: > > http://www.php.net/unsub.php > > > > > > > > > > > > > > -- > > M.Saleh.E.G > > 97150-4779817 > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Question on Registration Method

ut not sure how to > flip the switch on the activate column 0->1 > Is that done through an update mechanism ? > > Stuart > > > > --- Joseph Crawford <[EMAIL PROTECTED]> wrote: > > > what i did is i used php to create a random string > > of n

Re: [PHP-DB] Question on Registration Method

s that in order to compare the code to the one > in the database, don't I need the userid or something? > > or just that it exists in the database? > > Thank you, > > > Stuart > --- Joseph Crawford <[EMAIL PROTECTED]> wrote: > > > what i did is i us

Re: [PHP-DB] Question on Registration Method

ountryman between two lawyers is like a fish between two cats. > -- Ben Franklin > > > */ > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Capturing a sql query

and then submitting the form, i guess you could add a check to make sure that the refering page is yourdomain.com but if i am correct this could open up a world of trouble. If however i am wrong someone please respond and correct me :) -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED

Re: [PHP-DB] Capturing a sql query

results and form the email. Let me take a look at one of these sites to see what exactly you want and can give a better explanation. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] I have a query

{ // returned a row, display it or whatever } $result = null; $data = null; this would return a row containing everything you want and would allow you to loop through the rows so you can display them or whatever -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail a

Re: [PHP-DB] Capturing a sql query

e keywords searched for it will basically save these into a database record and use a cron job to pull the latest matches and send the emails. also it just uses those keywords when you use that agent on thier site. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247

Re: [PHP-DB] Capturing a sql query

users email and thier saved agent keywords. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] String handling

$string = '10001'; if((int)$string) > 1) { echo 'Yep it is'; } -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Capturing a sql query

Not so much that it is bad but you might be storing data you dont need to, all you really need to store are the keywords the person has searched for. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database Mailing List

Re: [PHP-DB] Capturing a sql query

why do you need more than a varchar? the persons keywords shouldnt be that much text for each agent maybe PHP+Programming+Vermont -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] which DB to use?

i am not a fan of microsoft go with mysql :) -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] 802-558-5247 For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Session Objects, Dynamic Parameters

b->connect(); it seems to take this, (which is the actual call in the getObject function Mysql('localhost', 'database', 'user', '**') it seems that 'localhost', 'database', 'user', '**' is being taken as on

Re: [PHP-DB] Re: [users@httpd] November 2, 2004

> Do we care? Realy? Unlikely. Maybe you should send your 'useful' info on > a national mailinglist only. i am sorry but i do care, if you do not care about voting you dont care if the war comes to the US. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] For

Re: [PHP-DB] Currency and number types...

how about good old number_format() -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] php v jsp

organized way to use PHP when working in a team environment. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Optimize Query Output

the display really has nothing to do with SQL but rather your php output format. you would use php to display the data however you want it formatted. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http

Fwd: [PHP-DB] Data from a pull down menu

-- Forwarded message -- From: Joseph Crawford <[EMAIL PROTECTED]> Date: Fri, 10 Dec 2004 16:00:33 -0500 Subject: Re: [PHP-DB] Data from a pull down menu To: [EMAIL PROTECTED] well are you looking for an automatic page refresh when a name is selected? If so you need to loo

Re: [PHP-DB] Re: sessions

e sender. Views expressed in this message are > > those of the individual sender and are not necessarily the views of the > > Mid Western Area Health Service. > > - > > <<<>>> > > -- > -- ShenKong (shenkong(at)php.net) > -- http://www.openphp.cn > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] For a GMail account contact me OFF-LIST -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Pagination

than one pager per page let me know as i said it's simple to remove the singleton pattern. http://www.weberdev.com/get_example-4005.html -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.ph

Re: [PHP-DB] to many addresses

one thought might be to check thier data for Str, St etc... and have it automatically replace with Street. Another would be to reload the page and give them suggestions on what to use, if they do Rd, have a drop down with Road, Street, Avenue etc.. so they can choose the correct one. -- Joseph

Re: [PHP-DB] Site optimization

i was wondering this as well :D are there any tools out there to simulate high traffic on your web server say where you specify how many users hit the site at one time and the tool actually hits your server that many times? -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] -- PHP

Re: [PHP-DB] Getting total results

this is a good method, however i created a paging class in php 5 and i believe i still have it here locally in php 4 i will get the link soon :D -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] Getting total results

one per page. the php 4 version i will need to zip up locally here and will post it @ http://codebowl.dontexist.org/pager_php4.zip -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Getting total results

php 4 version is posted, let me know if you like it or not. Please keep in mind it is a very basic class, you could extend this in many ways, especially to make the nav bar do something like << 1 2 3 4 25 26 27 28 >> -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECT

Re: [PHP-DB] Getting total results

No problem :D Actually i thought keeping all the data in one query stored in a class was more efficient than a database connection with each page change, however if i am wrong please explain why more database connections is less efficient... -- Joseph Crawford Jr. Codebowl Solutions [EMAIL

Re: [PHP-DB] Getting total results

actually, i was not doing anything with it because it was just the class. The way i use it is that i would store the object in a session variable for use accross pages :D -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] SQL statement syntaxis

isting = "SELECT CompanyID, CompanyName, CompanyOrDepartment, BillingAddress, City, PostalCode, PhoneNumber FROM company WHERE company.CompanyName= ORDER BY CompanyName ASC"; Let me know if this is your problem or not :D -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] --

Re: [PHP-DB] mysql - image storing

Jason, can you explain why stripslashes should not be used on data taken from the db? when you store data in the db i thought it was good practice to addslashes, when you retrieve from the db, you will need to use stripslashes to remove the extra \ -- Joseph Crawford Jr. Codebowl Solutions

Re: [PHP-DB] most popular places

get into the details you could do seperate queries for the members, pictures, reports and store them as such $citites[$city]['members'] etc... -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://w

Re: [PHP-DB] How to programmatically finding freetds.conf location?

you could execute the exec command in php and run a locate freetds.conf or whereis freetds.conf or find freetds.conf, i believe whereis only locates binary files not sure though. read up on exec here http://us2.php.net/manual/en/function.exec.php -- Joseph Crawford Jr. Codebowl Solutions

Re: [PHP-DB] Test

se Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Getting information on ICQ

i am sorry but what does this have to do with PHP? -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED]

Re: [PHP-DB] addslashes + stripslashes + mysql question

you might want to check to see if magic quotes GPC is turned on, if it is then you are adding slashes twice. You can either turn it off or do not use addslashes ;) -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED]

Re: [PHP-DB] Limiting Results

You could always try the LIMIT keyword :) select a.college, a.state, a.cd <http://a.cd/>, b.rep from a, b where a.state = "al" and a.cd <http://a.cd/> = "3" or a.state = "az" and a.cd <http://a.cd/> = "1" and a.state = b.state and a.cd

Re: [PHP-DB] registration form with activation code sent to user

the user as confirmed. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED]

Re: [PHP-DB] registration form with activation code sent to user

;] and $_GET['email'] then check the database for the users email and make sure the code matches the one in the database. If it does mark them as confirmed and let them proceed, if not well do nothing. -- Joseph Crawford Jr. Codebowl Solutions [EMAIL PROTECTED]

Re: [PHP-DB] Delivery reports about your e-mail

i am getting those too, seems i talked to gmail and users are spoofing other gmail accounts ;( not sure how we stop this or if we even can. -- Joseph Crawford Jr. Codebowl Solutions, Inc. 1-802-671-2021 [EMAIL PROTECTED]

[PHP-DB] Fwd: Code Optimization Help

;Release(); } private function CreateDocument($template) { $this->obj = new COM("word.application"); if(!is_object($this->obj)) throw new Exception('Unable to instanciate Word!'); $this->obj->Documents->Open($this->mm_data_dir.'/'.$template.'.do

Re: [PHP-DB] URL Forwarding in PHP...

header("Location: http://www.php.net/";); note that this cannot be set once any output has been sent to the browser. atleast not without using output buffering. -- Joseph Crawford Jr. Zend Certified Engineer Codebowl Solutions, Inc. 1-802-671-2021 [EMAIL PROTECTED]

Re: [PHP-DB] Searching remote web sites for content

button in the admin area that you push to check and return the results in a nice table. You would not want this check to run with every page load as curl could be time consuming depending on the speed of the site you are checking. -- Joseph Crawford Jr. Zend Certified Engineer Codebowl Solutions,

Re: [PHP-DB] Re: Subject: Searching remote web sites for content

why do all that, if you know the address of the page that the link will reside on just curl that page for the results and preg_match that. -- Joseph Crawford Jr. Zend Certified Engineer Codebowl Solutions, Inc. 1-802-671-2021 [EMAIL PROTECTED]

Re: [PHP-DB] Suggestions please!

} } Understand that this code will not work out of the box and no security measures were implemented, i did this just to show an example ;) In my system i have user permissions and group permissions, i load the group permissions then override with the user permissions. -- Joseph Crawford J

Re: [PHP-DB] Debugging

zend studio client/server work hand in hand and are the best debugging tools i have found ;) install zend studio server on the web server and use the zend studio client locally to debug. -- Joseph Crawford Jr. Zend Certified Engineer Codebowl Solutions, Inc. 1-802-671-2021 [EMAIL PROTECTED]

Re: [PHP-DB] getting rows by an ID field or by another field in a table

CT id, date, subject FROM journal LIMIT 20"); echo ''; echo 'SubjectDate'; while($entry=mysql_fetch_array($res)) { echo ''.$entry['subject'].''.$entry['date'].''; } echo ''; -- Joseph Crawford Jr. Zend Certified Engineer Codebowl Solutions, Inc. 1-802-671-2021 [EMAIL PROTECTED]

Re: [PHP-DB] Google Style Search Results

why not use substr? $preview = substr($string, 0, 50) .'...'; it will probably cut off in the middle of a word, but you can use strpos and check to see if the char is a space to get to the point you want. -- Joseph Crawford Jr. Zend Certified Engineer Codebowl Solutions, Inc. 1-80

Re: [PHP-DB] Restricting What's Retreived

you can try this select SUBSTRING(field,0,100) from table -- Joseph Crawford Jr. Zend Certified Engineer Codebowl Solutions, Inc. 1-802-671-2021 [EMAIL PROTECTED]

Re: [PHP-DB] Quick question

ini_set('max_execution_time', 9600); that's how you set the max_execution_time, i would assume the rest follow the same format. notice the time is in seconds. -- Joseph Crawford Jr. Zend Certified Engineer Codebowl Solutions, Inc. 1-802-671-2021 [EMAIL PROTECTED]

[PHP-DB] Emails Bouncing

The e-mail account does not exist at the organization this message was sent to. Check the e-mail address, or contact the recipient directly to find out the correct address. Thanks, -- Joseph Crawford Jr. Zend Certified Engineer Codebowl Solutions, Inc. 1-802-671-2021 [EMAIL PROTECTED]

Re: [PHP-DB] Classes and Includes

include_once('database.php'); -- Joseph Crawford Jr. Zend Certified Engineer Codebowl Solutions, Inc. 1-802-671-2021 [EMAIL PROTECTED]

Re: [PHP-DB] PHP4 and Constructor

nual didn't make me understood. Does this mean the very > > first `function` in class is always the constructor for the Class? > > > > Tek > > > > > -- Joseph Crawford Jr. Zend Certified Engineer http://www.josephcrawford.com/ 1-315-820-4244 [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Recommended web developers

The cost factor was why I did not speak up myself. On Jun 24, 2008, at 3:45 PM, Ken Keefe wrote: I'm a little surprised no one else has commented on this, but for a website that complicated, 10k is way too low. I've done work on websites that do almost all of those things separately, but not co

Re: [PHP-DB] Im new to this but...

ll also suggest that you read articles, blog entries, etc about SQL Injection and how to cleanse your data before throwing a user submitted value at your database. Thanks, Joseph Crawford On Sep 2, 2008, at 3:05 PM, Chris Hale wrote: I have: Apache 2.0.59 MySQL 5.0.41 PHP 4.4.7 &

Re: [PHP-DB] how is this line a security risk?

read up on register_globals. It is a security risk because if i do http://domain.com/file.php?plugins_directory=/directory/ it can reset your variable. the best way to do that is to make PLUGINS_DIR a constant define('PLUGINS_DIR', '/directory/'); Joseph Crawford On Se