RE: [PHP-DB] 2nd Pair of eyes please

> -Original Message- > From: Donovan Brooke [mailto:[email protected]] > Sent: Wednesday, January 26, 2011 2:35 PM > To: [email protected] > Subject: [PHP-DB] 2nd Pair of eyes please > > O.K., I give up.. I can't seem to find why this breaks the page to > a point where nothing gets disp

[PHP-DB] PEAR:DB affectedRows() returns wrong value

This took me a while to figure out but I'm fairly confident that http://pear.php.net/manual/en/package.database.db.db-common.affectedrows.ph p Returns the wrong number. I know this package is old and depricated, but I thought I'd throw this out to the ether so that if someone else is searching, t

[PHP-DB] FW: Get The Facts: MySQL Licensing & Pricing

-Original Message- From: Monica Kumar [mailto:[email protected]] Sent: Wednesday, November 10, 2010 11:52 AM To: [email protected] Subject: Get The Facts: MySQL Licensing & Pricing We just posted the following blog entry on Oracle's MySQL Blog: http://blogs.oracle.com/mysq

RE: [PHP-DB] finding out if a user left our website ?

Well look at that. Check out this one too: "window.onbeforeunload" http://www.hunlock.com/blogs/Mastering_The_Back_Button_With_Javascript > -Original Message- > From: kesavan trichy rengarajan [mailto:[email protected]] > Sent: Wednesday, August 25, 2010 2:54 PM > To: Vinay Kannan > Cc: PHP

RE: [PHP-DB] finding out if a user left our website ?

> -Original Message- > From: Vinay Kannan [mailto:[email protected]] > > Wanted to know if there is a way for us to find out, when a > user moves away > from our website( closing the window and entering a different > url in the address bar ) > > closing the window i guess, we could use

RE: [PHP-DB] Slashes or no slashes

You should be using http://us2.php.net/manual/en/function.mysql-escape-string.php You don't need to search with extra slashes for retrieval. > -Original Message- > From: Karl DeSaulniers [mailto:[email protected]] > Sent: Thursday, August 19, 2010 2:29 PM > To: [email protected] >

RE: [PHP-DB] input statement in php

> -Original Message- > From: Bavithra R [mailto:[email protected]] > Sent: Monday, July 26, 2010 7:39 AM > To: [email protected] > Subject: [PHP-DB] input statement in php > > hi friends.. > > > Is there any equivalent statement in php for "scanf" or > "cin" in c or c++? > That

[PHP-DB] FW: semaphores WAS: [PHP-DB] Automatic logoff

> -Original Message- > From: Richard Quadling [mailto:[email protected]] > Sent: Thursday, January 28, 2010 3:48 AM > To: listread > Cc: [email protected] > Subject: Re: [PHP-DB] Automatic logoff > > On 27 January 2010 17:20, listread wrote: > > Richard, > > > > I think I ne

[PHP-DB] FW: Oracle Finalizes Acquisition of Sun

To ensure delivery directly to your inbox please add [email protected] to your address book today. Oracle Corporation We are pleased to announce that Oracle

RE: [PHP-DB] Role Based Access Control and Role Based Security

=> TRUE, 'P_device_add' => TRUE, 'P_device_save' => TRUE, 'P_device_import' => TRUE, 'P_discovery_run' => TRUE, 'P_daterange_delete'

[PHP-DB] FW: Help keep the Internet free -- MySQL petition to EU

-Original Message- From: Michael Widenius [mailto:[email protected]] Sent: Tuesday, December 29, 2009 5:00 AM To: [email protected] Subject: Help keep the Internet free Hi! We have just launched a worldwide, multilingual petition at http://helpmysql.org to get signatures to show th

RE: [PHP-DB] Displaying Password - orale...

> Guess I should have kept that question to myself and dove into the manuals a little more, but > didn't think I would get crucified for asking help. Everyone has to > start somewhere and no one knows everything when they start. Let me apologize. I didn't mean to chastise you specifically. That

RE: [PHP-DB] Displaying Password - oy vey...

> > You can't be serious with that?! LOL. Exactly what I was thinking. W.T.F? http://www.youtube.com/watch?v=pXhKzY0BKwY > > You should try The next code: > > > > $UserPassword = str_repeat("•", strlen($UserPassword)); > > > > Enjoy. (I hope that you are not a programmer) ...and this is why goo

RE: [PHP-DB] UPDATE instead of INSERT INTO

http://dev.mysql.com/doc/refman/5.0/en/replace.html Or as previously mentined: http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html > > -Original Message- > > From: Ron Piggott [mailto:[email protected]] > > Sent: Saturday, September 05, 2009 1:19 PM > > To: php-

RE: [PHP-DB] how to store a heirarchy of resellers and customers WAS: newbie help

Also, you really should use a more descriptive subject line, 'newbie help' is kind of weak. If everyone did that, nobody would be able to search subjects or distinguish one topic from another. I won't even get into the whole 'top/bottom post' B.S. (personally I think top posting is great as you d

RE: [PHP-DB] newbie help

This may be overkill for what you're doing, but based upon your layout, you might consider a nested set. Since you're a newb, it may be too complex to code: http://dev.mysql.com/tech-resources/articles/hierarchical-data.html This is how you setup products and categories for example I think your s

RE: [PHP-DB] Integer in DB becomes string in PHP?

You could use intval($row['number']); to force it, but be careful that you may hit upper bounds around 2 Billion as integers are always signed in PHP (unfortunately), and mysql lets you store unsigned. It'll also depend on your OS. If you're checking the value only, you can use is_numeric($row['nu

RE: [PHP-DB] Are PHP & MySQL acceptable for the website I want to make

Not rain on your parade, but uh... Why would you re-invent the wheel?! A quick Google search for "reminder sites" turns up 4.8million hits, including canned ones for $35 for an entire site to use as you wish! http://www.easyturnkeysites.com/catdisplay.php?category=Reminder%20Websi tes http://ww

RE: [PHP-DB] Creating all key combinations passwords

> -Original Message- > From: Stut [mailto:[EMAIL PROTECTED] > Sent: Sunday, May 20, 2007 8:45 AM > To: Lasitha Alawatta > > Lasitha Alawatta wrote: > > I’m going to create all key combinations; simple-letter > passwords and > > store those in to MySql DB. > > > > Using = a-z (simple le

[PHP-DB] RE: How do I find products when a user types freeform strings like 'Sony 20" TV' or '20" Sony TV'? [SOLVED]

> -Original Message- > From: Daevid Vincent [mailto:[EMAIL PROTECTED] > Sent: Friday, May 04, 2007 1:22 AM > To: [EMAIL PROTECTED] > Subject: How do I find products when a user types freeform > strings like 'Sony 20" TV' or '20" Sony TV'

Re[2]: [PHP-DB] Caching query results in html pages

Bastien wrote: BK> you can write an html page on the fly and save that to the hard drive BK> have a look at fopen/fwrite etc And a more elaborated thing?. Some source development? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Caching query results in html pages

Hi all, I'm trying to improve the performance for visitors, and I want to know if there is some way to store the mySQL results of .php scripts in webpages. So, in example, when requesting http://www.mydomain.com/script.php?id=110 , it can be redirected to his cached version http://www.mydomain.c

RE: [PHP-DB] List menus

g the HTML_Menu. A good point is also the 'renderers' wich let you create new layouts for the very same menu data. this will help you create special menus for your customers... Vincent -Original Message- From: David Skyers [mailto:[EMAIL PROTECTED] Sent: Tue 5/12/2006 14:19 T

RE: [PHP-DB] Special Character

hars, at least as long as you do not enter chinese or foreign chars in your website. vincent -Original Message- From: David Skyers [mailto:[EMAIL PROTECTED] Sent: Thu 23/11/2006 10:29 To: Chris Cc: [email protected] Subject: RE: [PHP-DB] Special Character Hi Chris, Yes, I was using

RE: [PHP-DB] Special Character

h/replace them by their ascii value (use the Oracle function chr() This is specially true when inserting urls. vincent -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: Wed 22/11/2006 22:17 To: David Skyers Cc: [email protected] Subject: Re: [PHP-DB] Special Character Davi

[PHP-DB] What's the PHP equivallent of "mysql mydb < somefile.sql"

Currently I run an 'updater' script to run through a directory of .sql files using something like this in PHP: $COMMAND = "mysql ".$OPTION['db_prefix'].$db." < ".$mydir.$filename; system($COMMAND, $ret); What would be the equivallent way to to this in a PHP mysql_query(""); way?

RE: [PHP-DB] Problem with insert BLOB into Oracle

Hello you can not insert a lob this way. Refer to the php manual pages at http://www.php.net/oci And search for Example 3. Inserting data into a CLOB column Vincent -Original Message- From: Rosen [mailto:[EMAIL PROTECTED] Sent: jeudi 5 octobre 2006 14:43 To: [email protected]

[PHP-DB] [ANNOUNCE] dumpster :: dumps out all related records in a mySQL InnoDB database

Hey all. Well I just finished my first version of a little tool I have affectionately dubbed "dumpster". I do use my own SQL wrapper functions, but they should map fairly cleanly to a search and replace for the stock mysql_*() ones, or your own ones. Mad props to Peter Brawley [EMAIL PROTECTED]

RE: [PHP-DB] Help needed creating a social network

serID={$f['userID']}'>{$f['name']} >\n"; > } > > publish(); > profit($greatly); > do (!$use) { > coldfusion('Cause it sucks'); > } > ?> > > (har har) > > > > > > > > On Monday 06 March 2006 9:4

[PHP-DB] Help needed creating a social network

Anyone have some pointers at a HowTo on creating a social network? Basically I need to show people in your immediate network, and also friends of your friends, etc... Like the whole 'six degrees of separation' thing. Ala: myspace, friendster, etc. ad nauseum. I prefer mySQL and PHP, but I could p

[PHP-DB] RE: [PHP] "Nested Set Model" or "modified preorder tree traversal" [SOLVED]

olean $deleteChildren (false) otherwise move all the subcategories up to the level of the deleted category * @author Daevid Vincent [EMAIL PROTECTED] * @version 1.1 * @date 03/01/06 */ function delete_category($category = null, $deleteChildren = false) { if (is_null($category))

[PHP-DB] RE: [PHP] "Nested Set Model" or "modified preorder tree traversal" [SOLVED]

rks as an attachement. D.Vin > -Original Message- > From: Daevid Vincent [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 22, 2006 12:42 PM > To: 'Curt Zirzow'; [email protected] > Subject: RE: [PHP] "Nested Set Model" or "modified preo

[PHP-DB] Files stored in mysql

I need some advise on how to handle some pfd files. We have sales guys out in the field and generally need to access client reports regularly. I was thinking about making a dir for each rep, subdir for each client and posting the pfd files there. After the reps auth from the login page I call an

RE: [PHP-DB] Getting error with IE [[ SOLVED ]]

Thanks, the problem is solved. I forgot to remove an old ref to some JavaScript I decided not to use. Funny what a fresh set of eyes will do for something one has been staring at for hours :) Thanks again, Vinny -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://ww

RE: [PHP-DB] Getting error with IE

: http://www.cardiactelecom.com"; target="_blank"> Copyright © Cardiac Telecom Corporation -- Vincent Lape Systems Administrator, Cardiac Telecom Corporation. > -Original Message-

[PHP-DB] Getting error with IE

I am getting an error with IE when I load the page https://doctors.cardiactelecom.com Line: 6 Char: 1 Error: Object Expected Code: 0 [CODE] http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] PHP 4.3.10RC2 - Any change in the way rows are fetched ?

aviour ? Or is this a bug ? Is this the right mailing-list to find some information about this ? Vincent -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] RE: [SPAM] Re: [PHP-DB] Using sessions to gather visitor information

John and everyone else, thanks for all the help. Here is what I have for code. Again you help is greatly appreciated. "; echo $_SESSION['user_agent'] . ""; echo $_SESSION['host_name'] . ""; echo $_SESSION['visit_time'] . ""; } // look for db entry $IpSearch = mysql_query("SELECT ip, time FROM

[PHP-DB] Using sessions to gather visitor information

I am trying to track the users that visit one page on a site. I am having a couple of problems. The time seems to be 5 hours off. I do not have any tables as of yet what I would like to do is only count an ip address as one in a 24 hour period, if more than one visit then update visit count.I have

[PHP-DB] php Form Validation help

have a form that I would like to validate before it is submitted to the DB. I am having trouble with a couple of sections. I have a select box with a listing of all the states, the first option is "Choose One" with a value of "0". Would this be the correct way to "validate" this field?

[PHP-DB] RE: [SPAM] [PHP-DB] Global Peace output

You have no html link. Try echo " $company $webaddress" > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Sunday, August 22, 2004 5:33 PM > To: [EMAIL PROTECTED] > Subject: [SPAM] [PHP-DB] Global Peace output > > Dear friends, > > I have pasted table struc

[PHP-DB] RE: [SPAM] Re: [PHP-DB] Intellectual property rights

t be to hard with the M$ people. > > Michael. > > > > > On Mon, 9 Aug 2004 19:03:24 -0400 > "Vincent Jordan" <[EMAIL PROTECTED]> wrote: > > > This is a bit off topic however it may be something people here have or > > will have the unpleasant o

[PHP-DB] RE: [SPAM] RE: [PHP-DB] Intellectual property rights

age- > From: Ed Lazor [mailto:[EMAIL PROTECTED] > Sent: Monday, August 09, 2004 7:23 PM > To: 'Vincent Jordan'; [EMAIL PROTECTED] > Subject: [SPAM] RE: [PHP-DB] Intellectual property rights > > You're asking a legal question and should contact an attor

[PHP-DB] Intellectual property rights

This is a bit off topic however it may be something people here have or will have the unpleasant opportunity to deal with. The company I work for has been having a problem tracking our customers warranty information and have used paper for items sent in for repair. I on my own time had created a we

Re: [PHP-DB] SQL Insert problem (SOLVED), Thanks!

Thank you all for the help. I can't believe I forgot something so simple yet crucial. Thanks again for all the help. Vinny > -Original Message- > From: John W. Holmes [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 05, 2004 11:04 AM > To: Vincent Jordan;

RE: [PHP-DB] SQL Insert problem

that'll > make > the query bomb. > > Rich > > > > -Original Message- > > From: Vincent Jordan [mailto:[EMAIL PROTECTED] > > Sent: Thursday, August 05, 2004 10:25 AM > > To: [EMAIL PROTECTED] > > Subject: [PHP-DB] SQL Insert problem > > > > >

[PHP-DB] SQL Insert problem

Im having a problem inserting data. Ive looked over this again and again and can not find what ive missed. Everything else works besides the db insert. http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> "; $message = "$firstname $lastname $address $address2 $city $state $zip $ph

RE: [PHP-DB] Re: form results to email

>I wrote this, $message is not displaying. What am I doing wrong?? Nevermind. I forgot to add method="post" to the html page. I have gotten it to work however I would like to add some formatting to the email. Sent. I currently have: $message = "$firstname $lastname ."; mail("[EMAIL PROTECT

RE: [PHP-DB] Re: form results to email

I wrote this, $message is not displaying. What am I doing wrong?? > -Original Message- > From: Torsten Roehr [mailto:[EMAIL PROTECTED] > Sent: Friday, July 30, 2004 2:52 PM > To: Vincent Jordan > Subject: RE: [PHP-DB] Re: form results to email > > >

[PHP-DB] form results to email

We have to process almost the same information via email several times a day for customers to get items repaired. I would like to reply to their email with a .htm page containing a fill in form, on form action it will send an email. I have the form and page created, all is almost working. Im ha

[PHP-DB] MySQL software question

Is there a piece of software that will allow my to create MySQL databases and table relations in a graphical format without having to connect to the database? I am looking for something where I can "point and click" the creation of tables and easily create several relationships between tables ( k

[PHP-DB] search form w/ multiple fields

I have a form with firstname, lastname, phone, and email fields. I would like to search the database and return results to the same page in an iframe. I want to be able to search my just one or multiple. For example I can search by "firstname" with value of "john" and it will return all "john" rows

RE: [PHP-DB] Wait Statement... ?

: [PHP-DB] Wait Statement... ? > > Every time someone tries to authenticate, you count the number of > failures in both queues. The larger the number, the longer the sleep > will take. (removing old entries once in a while might speed > up things) Daevid Vince

RE: [PHP-DB] Wait Statement... ?

I'd just DoS it, not waste time locking individual users out one at a time. Daevid Vincent Senior Engineer / Architect two.zero.six.two.eight.five.eight.zero.eight.zero _ _ _ | |___ ___| | | | _ ___ __ | | /

RE: [PHP-DB] Wait Statement... ?

Similarly, I could adjust my brute force attack to sleep() a pre-determined amount of time too ;-) The whole 'sleep()' idea just seems silly. I agree with Jason. Just validate and be done. A better way to stop attacks is to have a tally of failed logins if you really are that worried someone is go

Re: [PHP-DB] howto get PK id after INSERT??

I think I got it correct got the most part. I am having a problem with the urlencode function I believe. On page CustomerAddNew1.php ( page than handles form data ) im using: $last_id = mysql_query("SELECT LAST_INSERT_ID() from customerinfo"); $last_id = urlencode ($last_id); header("Location:

[PHP-DB] howto get PK id after INSERT??

I have a form to insert customer data into a table. The form goes to php page to input data to db hen uses header to go to a final page displaying customer's information. Is there a way to get the ID (custid PK UNIQUE AUTO_INCREMENT) from mysql after INSERT then pass to final page using urlencode

Re: [PHP-DB] DB table creation question

rd month and in stages of about 200 records monthly after that. Thanks for all the help everyone has provided thusfar. -Original Message- From: Matthew McNicol [mailto:[EMAIL PROTECTED] Sent: Monday, July 19, 2004 3:08 AM To: Vincent Jordan Cc: [EMAIL PROTECTED] Subject: [SPAM] Re: [PHP-DB

[PHP-DB] RE: [SPAM] Re: [PHP-DB] DB table creation question

(6) NULL, billable tinyint(1)NULL, billed tinyint (1) NULL, cost varchar (6) NULL, last_modified_by varchar (50) NULL, last_modified_date datetime NULL, ); -Original Message- From: Matthew McNicol [mailto:[EMAIL PROTECTED] Sent: Sunday, July 18,

[PHP-DB] DB table creation question

I am creating a database to keep track of our warranty returns. Currently we do not have anything to track warranty info besides a big excel file. I would like to keep customer data, product info and RMA data in separate tables but still keep them related. If I had table customers: custid Firstn

[PHP-DB] Rewrite value from form data

I have a form with a field for a telephone number. I would like to either apply some kind of formatting to force format of XXX-XXX- or rewrite after submit to insert - in 3 and 5 (or 6). Here is what I have for code: --Form- Home Phone: handler.php $home = $_POST['home_phone' I hav

[PHP-DB] Printing selected characters (strcnt?)

rcnt($last_name), 1 . Datetime(?) // takes the 1st character from $last_name and adds datetime in format of 715041200 Thanks any help appreciated Vincent Jordan Technical Support Smart Parts, Inc. Loyalhanna Business Complex 100 Station Street Loyalhanna, PA 15661 800-992-2147 X 5617 -- PHP Database Ma

[PHP-DB] Re: [SPAM] RE : validate 2 password fields

d, clear password2, allow form to submit > df["password2"].value=""; > return true; > else { > alert("Passwords did not match"); > return false; > } > } > > Cheers -

[PHP-DB] 2 requests: validate 2 password fields as equal and rewrite data

Could someone instruct me or point me in the right direction. I would like to have a when submit it will check to se if password and password2 are = ( i do not want password2 to end up in POST on submit.) also i am trying to rewrite data from a tinyint. the tinyint will return 1 or 0, I have

[PHP-DB] Re: Php form & row delete problems

"could not del user" . mysql_error()); } echo "Done"; ?> - Original Message - From: "Torsten Roehr" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 25, 2004 1:35 PM Subject: [SPAM] [PHP-DB] Re: Php form & row delete problem

[PHP-DB] Php form & row delete problems

box and if the box is checked and delete button is clicked it is passed to userdel.php which would take the user_id and delete row. Any help would be greatly appreciated. Vincent Jordan Technical Support Smart Parts, Inc. Loyalhanna Business Complex 100 Station Street Loyalhanna, PA 15661 80

[PHP-DB] Can I use PHP with SSL to connect to mySQL?

I see that mySQL has SSL support: http://www.mysql.com/doc/en/Secure_connections.html And PHP has some SSL support, but do the mysql() functions work transparently with SSL? It seems there would have to be a flag for this mysql_connect() that turned on SSL. http://us4.php.net/manual/en/function.my

RE: [PHP-DB] Cronjob

One thing I might suggest is to queue up your inserts, then use the extended insert syntax to populate several records at once in a single INSERT instead of 12 separate ones. I believe you can alter the /etc/my.cnf file to play more 'nice' as far as priorities and memory, but I've never touched it

[PHP-DB] Generating UPDATE in loop, how to deal with pesky comma - SOLVED

l loop until sql is built } $SQL = "UPDATE table SET ".implode(',',$upd)." WHERE blah = 3"; //now do it $result = mysql_query($SQL,$db); Daevid Vincent http://daevid.com > -Original Message- > From: Daevid Vincent [mailto:[EMAIL PROTECTED] > S

[PHP-DB] What is the proper way to use mysql db on a multipage site?

to keep making that mysql_connect(). Isn't there a way to store the $db result so I don't have to keep connecting. And how about the mysql_select_db() part too? Since I'm going to stay in the same db most of the time. I thought I read that I can't use a $_SESSION for it, and th

RE: [PHP-DB] Re: MMCache Benchmarks don't show much improvement?

n't show much improvement? > > > Hello, > > On 08/20/2003 09:10 PM, Daevid Vincent wrote: > > Hello, I installed MMCache on one of our boxes here and did > a few timing > > tests. I have to say I'm very unimpressed given the hype > and the benchmark

RE: [PHP-DB] Re: mount command with php in through the web

You could use sudo and add 'apache' as a user who can run 'mount'... Add this to /etc/sudoers: apache ALL=NOPASSWD: /bin/mount Daevid Vincent http://daevid.com > -Original Message- > From: pete M [mailto:[EMAIL PROTECTED] > Sent: Friday,

[PHP-DB] MMCache Benchmarks don't show much improvement?

Hello, I installed MMCache on one of our boxes here and did a few timing tests. I have to say I'm very unimpressed given the hype and the benchmarks on their servers. Am I missing something? (and yes, phpinfo() shows the module is loaded). I was the only person hitting the pages on this test box. F

RE: [PHP-DB] HEAP table

Or instead of creating a table and tying up one more mysql thread, just save the timestamp in a file. This could be as simple as that, you could use XML, you could use INI parser, you could use any number of things. Also, if the HEAP is created per "session", then just store that timestamp in a ses

RE: [PHP-DB] CRiMson live demo and .tgz available

sage- > From: Matthew Moldvan [mailto:[EMAIL PROTECTED] > Sent: Saturday, May 24, 2003 1:01 PM > To: 'Daevid Vincent'; [EMAIL PROTECTED] > Subject: RE: [PHP-DB] CRiMson live demo and .tgz available > > > I've been trying to install this for about 30 minutes

RE: [PHP-DB] DB CODEING HELP!!!!!

Here, this will pull data and make a select box. Adjust as needed. $result = mysql_query("SELECT company_id, company_name FROM company_table ORDER BY company_name", $db); if (mysql_num_rows($result) > 0) { echo "\n\t\n"; while ( $row = mysql_fetch_array($result,MYSQL_ASSOC) )

[PHP-DB] Problem retrieving/updating data from InterBase

base_blob_open($row->Metadata); $content = ibase_blob_get($blob_id); ibase_blob_close($blob_id); ibase_free_result($set); $content returns an empty string. I don't know if it goes wrong updating the data, or retrieving the data. Can anybody help me out here Thanks in advance Vi

RE: [PHP-DB] Re: Get MySQL table schema for a dump

The wrap it in an exec() or one of the other exec type functions ;) $result = exec("mysqldump -uMyUser -pMyPass MyDB > db_dump_file.sql"); > -Original Message- > From: Jonathan Villa [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 26, 2003 3:36 PM > To: [EMAIL PROTECTED] > Subject

RE: [PHP-DB] Unlimited Categories

Well, I'm not sure if you actually truly mean "unlimited", because if you do, be aware that when you define those fields: # BIGINTUNSIGNED = 8 Byte = = 18446744073709551615 # INT UNSIGNED = 4 Byte = = 4294967295 # MEDIUMINT UNSIGNED = 3 Byte = FF = 167

RE: [PHP-DB] How can I use PHP to duplicate a mysql template database? [hack] bug

DAMNIT! This method copies the data, but doesn't copy 'Extra' stuff like "auto_increment". UGH!!! > -Original Message- > From: Daevid Vincent [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, December 17, 2002 2:33 AM > To: [EMAIL PROTECTED] > Su

RE: [PHP-DB] How can I use PHP to duplicate a mysql template database? [hack]

("V2_Template"); while ($row = mysql_fetch_row($tableResult)) { $tsql = "CREATE TABLE ".$V2DB.".".$row[0]." AS SELECT * FROM V2_Template.".$row[0]; echo $tsql."\n"; $tresult = mysql_query($tsql,$linkI); if (!$tresul

[PHP-DB] How can I use PHP to duplicate a mysql template database?

I need to use PHP to duplicate the schema of a database. This seems like it should be a simple task -- taking a 'template' db and cloning it with a new name. I've tried things like: $filename = "myDB.sql"; $fd = fopen ($filename, "r"); $sql = fread

RE: [PHP-DB] query

Ideally, you would have 3 tables like so... Projects(with one record per project) - projectID |ProjectName| etc... 1 my project 2 another project Users(with one record per user) --- userID| userName| etc... 123 Joe Blow 124

RE: [PHP-DB] Single occurance of data

You really need to research join types for this. INNER JOIN, INNER LEFT, OUTER RIGHT etc. There are a plethora of examples and options on the web. Also, the DISTINCT keyword might help, as in "select DISTINCT department"; this would return only those departments in courses that have a correspond

RE: [PHP-DB] Resource id #2

Try this... either... while ($row = mysql_fetch_array($result)) { $title = $row['Books.Title']; $author = $row['Books.Author']; ... print $title; } or... while ($row = mysql_fetch_array($result)) { print $row['Title']; ... } -Original Message--

RE: [PHP-DB] MySQL Problem

Still think we need to see the PHP code before determining that it is an SQL problem. Regards, J -Original Message- From: Jason Wong [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 21, 2002 11:55 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL Problem On Friday 22 November 2

RE: [PHP-DB] Email Encryption?

email address on file) and let then know that someone has changed their account number, and if it wasn't them... blah blah Regards, J -Original Message- From: Aaron Wolski [mailto:aaronjw@;martekbiz.com] Sent: Friday, November 15, 2002 1:18 PM To: 'Peter Beckman' Cc: Vince

RE: [PHP-DB] phpmysqladmin

http://www.phpwizard.net/projects/phpMyAdmin/ yes it is - and it is a great tool J -Original Message- From: Matt Giddings [mailto:cen10761@;centurytel.net] Sent: Friday, November 15, 2002 12:18 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] phpmysqladmin Anybody have the url for phpmysq

RE: [PHP-DB] Email Encryption?

ay no information is ever passed via email. Regards, Jason Vincent Voice Architecture, Nortel Networks (905) 863-7480 (ESN 333) [EMAIL PROTECTED] -Original Message- From: Aaron Wolski [mailto:aaronjw@;martekbiz.com] Sent: Friday, November 15, 2002 11:47 AM To: 'H

RE: [PHP-DB] Email Encryption?

Why email? If the Admin tool uses SSL, that is all you need. Regards, J -Original Message- From: Aaron Wolski [mailto:aaronjw@;martekbiz.com] Sent: Friday, November 15, 2002 11:39 AM To: 'Aaron Wolski'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Email Encryption? Just thinking here..

RE: [PHP-DB] serious help with linking data together...

you haven't really said what the problem is - but this is what I can see... Functions like COUNT, MAX and MIN etc. are group functions (or aggregate functions). For example, select count(*) actually only returns 1 record - the total count. When you mix aggregate functions with regular selects (t

RE: [PHP-DB] Difference between 2 dates.. thoughts?

13, 2002 12:27 PM To: Vincent, Jason [BRAM:1334:EXCH]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Difference between 2 dates.. thoughts? Hi There, Well the first and last record of the results. So if 1000 records were found... then record #1 and then record #1000 - perform data calculation between

RE: [PHP-DB] Difference between 2 dates.. thoughts?

You should be able to do this at the database level - of course you never said what database that is. Regardless, check your database documentation for the max() and min() functions - never used these on date but they might work - do you always want the first record and the last record in the data

[PHP-DB] indexing on existing DB

(I know this is more of a mySQL question than PHP, but allow me this one if you would...) In MySQL, is there any difference between creating an index at table creation time, and creating an index on an existing table? Does an index created on an existing table re-index itself after each insert/up

RE: [PHP-DB] The Ethics and Access of Login

Brooks [mailto:eurleif@;buyer-brokerage.com] > Sent: Monday, October 28, 2002 9:08 PM > To: Daevid Vincent > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] The Ethics and Access of Login > > > That's a HUGE security flaw! Anyone could send that in a GPC > value and > get unau

RE: [PHP-DB] The Ethics and Access of Login

Well, what I would suggest is you log them in once, then set a session variable such that $_SESSION["login"] = true; Then at the top of each page, just check if they're logged in or not. if( !$login ) { Header("Location: ".$LOGINPAGE."\n\n"); exit; } No hit to the db for every page. If you're

RE: [PHP-DB] Pulling apart select list elements

There is another way -- I sometimes do this... you can have both the id and text in the value like so... Product 1 Another product etc... then parse through the value list and split it on "--" foreach ($listOfProducts as $prod){ if (!$prod){break;} list ($productID,$productNam

RE: [PHP-DB] Difference in time

;; }else{ "insert into polls (ipAddress,insertTime) values ('$ipAddress',now())"; } P.S. - "now()" is a database function that will insert the time for you (mySQL is usually -dd-mm hh:mm:ss) -Original Message- From: wade [mailto:[EMAIL PROTECTED]]

RE: [PHP-DB] Difference in time

yeah - the mktime function is returning unix style time (seconds since 1970) which is why only the last few numbers are changing. I would recommend letting the database decide who is able to submit... i.e. select * from database where lastSubmitDate > 'now()- 1 hour' and IP = '$ipaddress' if th

RE: [PHP-DB] Why does this happen??

I would use JOIN syntax - then change your join type based on what you want to see in the results...(INNER JOIN, LEFT JOIN, RIGHT JOIN, LEFT OUTER etc.) SELECT updates.MODELCODE, SETNO, FRPICNO, TOPICNO, CPOSTDATE, MODELNAME, ZIPFILENAME, TOTPICS FROM updates LEFT JOIN models ON updates.MODELCODE

  1   2   >