RE: [PHP-DB] Database management

It appears to be. I've downloaded the free/trial version, I haven't had time to play with it. : Ashay -Original Message- From: Karl DeSaulniers [mailto:k...@designdrumm.com] Sent: Thursday, August 26, 2010 12:03 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] Database

Re: [PHP-DB] Database management

[mailto:k...@designdrumm.com] Sent: Thursday, August 26, 2010 12:03 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] Database management That is interesting cause they are an asp based server. I'll have to take a look at that. Might be something I can build into the server. Is it web based like ph

Re: [PHP-DB] Database management

net Subject: Re: [PHP-DB] Database management Thank you all for your comments and suggestions. It was a "real" task to find something open source, so I gave up on that. I decided to go with RazorSQL. Its just what I needed and I already have most of the changes done on the database alr

Re: [PHP-DB] Database management

Thank you all for your comments and suggestions. It was a "real" task to find something open source, so I gave up on that. I decided to go with RazorSQL. Its just what I needed and I already have most of the changes done on the database already. and I am only using the trial version ATM. I pl

RE: [PHP-DB] Database management

If open source is a must, then there is only one choice showing up on search: SQL Web Data Administrator (sqlwebadmin.codeplex.com) That said, the best choice is SQL Server Management Studio. It's not open source and it is a Win32 app (meaning you'll have to run it in VirtualBox or something si

Re: [PHP-DB] Database management

On Aug 25, 2010, at 19:27, Karl DeSaulniers wrote: > Hello fellow PHPers, > Question, > 1. Does anyone know of a good Open source MS SQLServer management software > for MAC? > I have been charged with updating a companies Microsoft SQLServer and I > usually work in MySQL. > Need a freeware if

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

To: Vinay Kannan > Cc: PHP DB > Subject: Re: [PHP-DB] finding out if a user left our website ? > > Have a look at this: > https://developer.mozilla.org/en/DOM/window.onunload > > <https://developer.mozilla.org/en/DOM/window.onunload>But, as someone > pointed out a f

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

Have a look at this: https://developer.mozilla.org/en/DOM/window.onunload But, as someone pointed out a few days ago, please do not post stuff that is not related to PHP DB. On Thu, Aug 26, 2010 at 6:32 AM, Vinay Kannan wrote: > Hello Guys,

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

I think you can do that with window.focus in javascript. Karl On Aug 25, 2010, at 3:32 PM, Vinay Kannan wrote: Hello Guys, 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 )

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

> -Original Message- > From: Vinay Kannan [mailto:viny...@gmail.com] > > 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

In the case that your comparing a field to a field in the database (the field name) do you escape that or because it is hardcoded you dont need to? My thoughts are that you need to escape all data going in. Correct. A field name is not data though. You've already validated it (somehow, either

Re: [PHP-DB] Slashes or no slashes

On Aug 23, 2010, at 11:38 PM, Karl DeSaulniers wrote: On Aug 23, 2010, at 10:35 PM, Chris wrote: Just to make sure, cause I am ready to get past this. Is this correct? function confirmUP($username, $password){ /* Verify that user is in database */ $q = "SELECT password FROM ".TBL_USERS."

Re: [PHP-DB] Slashes or no slashes

Got it. So only when I am going to diplay the result from the database. I see. Or email (or otherwise present it to the user), yes. But for comparing $dbarray['password'] to $password, don't I have to escape $password and then md5 it? Right. -- Postgresql & php tutorials http://www.design

Re: [PHP-DB] Slashes or no slashes

On Aug 23, 2010, at 10:35 PM, Chris wrote: Just to make sure, cause I am ready to get past this. Is this correct? function confirmUP($username, $password){ /* Verify that user is in database */ $q = "SELECT password FROM ".TBL_USERS." WHERE username = '".mysql_real_escape_string($username)."

Re: [PHP-DB] Slashes or no slashes

Just to make sure, cause I am ready to get past this. Is this correct? function confirmUP($username, $password){ /* Verify that user is in database */ $q = "SELECT password FROM ".TBL_USERS." WHERE username = '".mysql_real_escape_string($username)."'"; Perfect. /* Retrieve password from res

Re: [PHP-DB] Slashes or no slashes

On Aug 23, 2010, at 10:04 PM, Karl DeSaulniers wrote: On Aug 23, 2010, at 9:31 PM, Chris wrote: To be more specific. Is this correct? function confirmUP($username, $password){ $username = mysql_real_escape_string($username); /* Verify that user is in database */ $q = "SELECT password FROM

Re: [PHP-DB] Slashes or no slashes

On Aug 23, 2010, at 9:31 PM, Chris wrote: To be more specific. Is this correct? function confirmUP($username, $password){ $username = mysql_real_escape_string($username); /* Verify that user is in database */ $q = "SELECT password FROM TBL-U WHERE username = '$username'"; I normally do it

Re: [PHP-DB] Slashes or no slashes

To be more specific. Is this correct? function confirmUP($username, $password){ $username = mysql_real_escape_string($username); /* Verify that user is in database */ $q = "SELECT password FROM TBL-U WHERE username = '$username'"; I normally do it in the query in case you use the variable so

Re: [PHP-DB] Slashes or no slashes

On Aug 23, 2010, at 8:35 PM, Chris wrote: You use mysql_real_escape_string for queries on the way in. $query = "select * from table where name='".mysql_real_escape_string($_POST['name'])."'"; You use htmlspecialchars on the way out: $value = htmlspecialchars($row['name']); -- Postgresql

Re: [PHP-DB] Slashes or no slashes

You use mysql_real_escape_string for queries on the way in. $query = "select * from table where name='".mysql_real_escape_string($_POST['name'])."'"; You use htmlspecialchars on the way out: $value = htmlspecialchars($row['name']); -- Postgresql & php tutorials http://www.designmagick.com/

Re: [PHP-DB] Slashes or no slashes

On Aug 22, 2010, at 7:12 PM, Chris wrote: On 20/08/10 08:05, Karl DeSaulniers wrote: On Aug 19, 2010, at 4:44 PM, Karl DeSaulniers wrote: On Aug 19, 2010, at 4:36 PM, Daevid Vincent wrote: You should be using http://us2.php.net/manual/en/function.mysql-escape-string.php You don't need to

Re: [PHP-DB] Slashes or no slashes

On 20/08/10 08:05, Karl DeSaulniers wrote: On Aug 19, 2010, at 4:44 PM, Karl DeSaulniers wrote: On Aug 19, 2010, at 4:36 PM, Daevid Vincent wrote: 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. -

Re: [PHP-DB] Slashes or no slashes

: Subject: Re: [PHP-DB] Slashes or no slashes On Aug 19, 2010, at 4:44 PM, Karl DeSaulniers wrote: On Aug 19, 2010, at 4:36 PM, Daevid Vincent wrote: You should be using http://us2.php.net/manual/en/function.mysql-escape-string.php You don't need to search with extra slashe

Re: [PHP-DB] Slashes or no slashes

I think you should use prepared statements. Kapu -- From: "Karl DeSaulniers" Sent: Friday, August 20, 2010 12:05 AM To: Subject: Re: [PHP-DB] Slashes or no slashes On Aug 19, 2010, at 4:44 PM, Karl DeSaulniers wrote: On Aug 19,

Re: [PHP-DB] Slashes or no slashes

On Aug 19, 2010, at 4:44 PM, Karl DeSaulniers wrote: On Aug 19, 2010, at 4:36 PM, Daevid Vincent wrote: 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 DeSauln

Re: [PHP-DB] Slashes or no slashes

On Aug 19, 2010, at 4:36 PM, Daevid Vincent wrote: 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:k...@designdrumm.com] Sent: Thursday, Augus

Re: [PHP-DB] Slashes or no slashes

On Aug 19, 2010, at 4:36 PM, Daevid Vincent wrote: 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:k...@designdrumm.com] Sent: Thursday, Augu

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:k...@designdrumm.com] > Sent: Thursday, August 19, 2010 2:29 PM > To: php-db@lists.php.net >

Re: [PHP-DB] CURDATE

Hi all, I have a big question - why on this list raised question about MySQL or any other database without any relation to PHP? Is it list for solving SQL and DB problems? When I subscribe to this list I think that this list is about PHP DB problems. At least problems related to PHP - but not about

Re: [PHP-DB] CURDATE

Try: DATE(date_accessed) = CURDATE(). Have a look at this: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_dateto understand what's happening. Regards, Kesavan. On 17/08/2010 6:26 AM, "Ron Piggott" wrote: I am wondering why: SELECT * FROM `bible_concordance_usage`

Re: [PHP-DB] COUNT() query help

On 13 August 2010 13:43, Ron Piggott wrote: > SELECT `bible_concordance_words`.`reference`, > `bible_concordance_words`.`word`, > COUNT(`bible_concordance_word_reference`.`bible_concordance_words_reference`) > AS occurrences FROM `bible_concordance_words` INNER JOIN > `bible_concordance_word_refer

Re: [PHP-DB] how to explain such a regular syntax

On 13 August 2010 08:47, win.a wrote: > Its was picked from drupal source code and i don't know how does it works. > This is the code : > preg_match('/^\[?(?:[a-z0-9-:\]_]+\.?)+$/', $host); This has got nothing to do with php or php-db - your question is on regular expressions. Try consulting htt

Re: [PHP-DB] SELECT with ' in search term

On 13/08/10 13:26, Ron Piggott wrote: If the variable $segment has an ' in it the $query won't work because of having 3 ' 's. Should I be using: $segment = mysql_real_escape_string($segment); before querying the database? Use it in your query. Don't use it anywhere else. Your code may use it

Re: [PHP-DB] Unable to connect to mysql database

I am guessing the message "unable to connect to database" is something you have echoed on a die() or as an error message, could you tell us what is the step before this. Also just check if the database is set correctly, and the user name and the password is correct. Some hosts use the host as loc

RE: [PHP-DB] Unable to connect to mysql database

Hi there, You will have to adjust the configuration file (configuration.php) in your root folder for the new site. var $host = ; var $user = ; var $db = ; they have to reflect the new settings. Hope that helps. Eli Aschkenasy -Original Message- From:

Re: [PHP-DB] PHP application hosted on a dektop ubuntu(localhost) vs A .NET software installed on Windows

Actually there is no customer registrations happening, its just a resturant and there wouldnt be any registrations and stuff, its a valid point of hosting it on a webserver and building it like any web app, but then internet connection might also be a problem in that area, and if the internet doesn

Re: [PHP-DB] PHP application hosted on a dektop ubuntu(localhost) vs A .NET software installed on Windows

Thanks for your reply Maarten, Its a hotel management application for a hotel.. Thanks, Vinay On Fri, Aug 6, 2010 at 1:03 PM, maarten wrote: > Hello, > > without further information, it is not really possible to give any kind > of indication that a web app can replace the original app. We do

Re: [PHP-DB] PHP application hosted on a dektop ubuntu(localhost) vs A .NET software installed on Windows

Hello, without further information, it is not really possible to give any kind of indication that a web app can replace the original app. We do not know what the original app is supposed to do, how it works, ... Having said that, I think most apps would be possible to transform to some web app.

RE: [PHP-DB] Re: Stuck in apostrophe hell

> -Original Message- > From: Simcha Younger [mailto:sim...@syounger.com] > Sent: 04 August 2010 08:19 > > > paul_s_john...@mnb.uscourts.gov wrote: > > > > > > > THE INPUT: > > > > > > $sql_insert_registration = sprintf("INSERT INTO > > > Registrations ( > > > Class_ID, > > > pri

Re: [PHP-DB] Re: Stuck in apostrophe hell

> paul_s_john...@mnb.uscourts.gov wrote: > > > > THE INPUT: > > > > $sql_insert_registration = sprintf("INSERT INTO > > Registrations ( > > Class_ID, > > prid, > > Registrant, > > Company, > > Phone, > > Email > > ) > > VALUES ( > > $_POST[Class_ID], > > $_PO

Re: [PHP-DB] Re: Stuck in apostrophe hell

On Aug 3, 2010, at 5:44 PM, Chris wrote: On 03/08/10 23:04, paul_s_john...@mnb.uscourts.gov wrote: Yes, I may have mixed up the input and output from different iterations of running it. Let me try posting this again although it may not be an issue. Once again if I enter two sequential apost

Re: [PHP-DB] Re: Stuck in apostrophe hell

On Aug 3, 2010, at 8:08 AM, Peter Lind wrote: On 3 August 2010 15:04, wrote: Yes, I may have mixed up the input and output from different iterations of running it. Let me try posting this again although it may not be an issue. Once again if I enter two sequential apostrophes in the name

Re: [PHP-DB] Re: Stuck in apostrophe hell

On 03/08/10 23:04, paul_s_john...@mnb.uscourts.gov wrote: Yes, I may have mixed up the input and output from different iterations of running it. Let me try posting this again although it may not be an issue. Once again if I enter two sequential apostrophes in the name (O''Brien) the INSERT passes

Re: [PHP-DB] Re: Stuck in apostrophe hell

On 3 August 2010 15:04, wrote: > Yes, I may have mixed up the input and output from different iterations of > running it. Let me try posting this again although it may not be an issue. > Once again if I enter two sequential apostrophes in the name (O''Brien) > the INSERT passes right through to M

Re: [PHP-DB] Stuck in apostrophe hell

On Aug 2, 2010, at 4:42 PM, Bret Hughes wrote: > I would turn on query logging and see what exactly is making it to mysql. > > Niel Archer wrote: >>> Before I send the following SQL to MySQL from PHP I print it to screen. PHP >>> chokes on it, but I can paste the exact same query from the screen

Re: [PHP-DB] Stuck in apostrophe hell

I would turn on query logging and see what exactly is making it to mysql. Niel Archer wrote: Before I send the following SQL to MySQL from PHP I print it to screen. PHP chokes on it, but I can paste the exact same query from the screen directly to MySQL and it works just fine. For example: He

Re: [PHP-DB] Stuck in apostrophe hell

> Before I send the following SQL to MySQL from PHP I print it to screen. > PHP chokes on it, but I can paste the exact same query from the screen > directly to MySQL and it works just fine. For example: > > Here's the relevant PHP code: > == > $sql_insert_reg

Re: [PHP-DB] Stuck in apostrophe hell

On 2 August 2010 22:30, wrote: > Before I send the following SQL to MySQL from PHP I print it to screen. > PHP chokes on it, but I can paste the exact same query from the screen > directly to MySQL and it works just fine. For example: > > Here's the relevant PHP code: > ==

Re: [PHP-DB] input statement in php

On 26 July 2010 15:38, Bavithra R wrote: > hi friends.. > > > Is there any equivalent statement in php  for "scanf" or "cin" in c or c++? > That is without using html and creating forms. WOW. Completely surprised by the two responses that were given. STDIN is a predefined resource, so no need

RE: [PHP-DB] input statement in php

> -Original Message- > From: Bavithra R [mailto:bavithr...@gmail.com] > Sent: Monday, July 26, 2010 7:39 AM > To: php-db@lists.php.net > 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

RE: [PHP-DB] input statement in php

>hi friends.. >Is there any equivalent statement in php for "scanf" or "cin" in c or c++? >That is without using html and creating forms. >Thanks in advance >regards >--Bavithra.R No, there are no equivalents in PHP. __ Information from ESET Smart Security, version of virus signat

Re: [PHP-DB] RE: [phpXperts] No Warping in results [1 Attachment]

I guess the html/css is wrong. If you print all links in new TD elements or as nonbreakable test it will look like this. If you just use divs floating left instead then links will fill the space and wrap around. Also getting rid of it all together and simple list of a tags with some space between w

Re: [PHP-DB] Re: LEFT JOIN query help

Thanks. That answer worked. Ron -- -Original Message- From: Kesavan Rengarajan To: ron.pigg...@actsministries.org Cc: ron.pigg...@actsministries.org , php-db@lists.php.net Subject: Re: [PHP-DB] Re: LEFT JOIN query help Date: Mon, 19 Jul 2010 08:21:00 +1000 Change 'NOT

Re: [PHP-DB] Re: LEFT JOIN query help

Change 'NOT LIKE' to 'NOT IN' in the outer query. Sent from my iPhone On 19/07/2010, at 4:15 AM, "Ron Piggott" wrote: > > I am still working on this query and wondering if I should be taking a > different approach --- to use a sub query to figure out which questions > have been answered and th

Re: [PHP-DB] NULL to 0

Thanks, Ron -- -Original Message- From: Andrés G. Montañez To: ron.pigg...@actsministries.org Cc: php-db@lists.php.net Subject: Re: [PHP-DB] NULL to 0 Date: Sat, 17 Jul 2010 23:20:20 -0300 SELECT IFNULL(SUM(`my_Bible_trivia_knowledge_questions_answered`.`score`), 0) AS

Re: [PHP-DB] NULL to 0

SELECT IFNULL(SUM(`my_Bible_trivia_knowledge_questions_answered`.`score`), 0) AS total_score, IFNULL(`my_Bible_trivia_knowledge_profile`.`questions_answered`, 0) AS questions_answered In these cases you must use the IFNULL function, for testing the value. -- Andrés G. Montañez Zend Certified

Re: [PHP-DB] calling a page for each row

On 7/15/2010 8:03 PM, Chris wrote: On 16/07/10 09:51, listread wrote: On 7/15/2010 6:42 PM, Chris wrote: On 16/07/10 09:38, listread wrote: We need to load a page which performs some tasks specific to each record, including writing some results to another table. I have tried to place a page l

Re: [PHP-DB] calling a page for each row

On 16/07/10 09:51, listread wrote: On 7/15/2010 6:42 PM, Chris wrote: On 16/07/10 09:38, listread wrote: We need to load a page which performs some tasks specific to each record, including writing some results to another table. I have tried to place a page loading script within the while loop

Re: [PHP-DB] calling a page for each row

On 16/07/10 09:38, listread wrote: We need to load a page which performs some tasks specific to each record, including writing some results to another table. I have tried to place a page loading script within the while loop that creates the table, but it seems to only load the page on the last r

Re: [PHP-DB] imagettftext

Nevermind. found it on my own. On Jul 9, 2010, at 8:13 PM, Karl DeSaulniers wrote: Is there a way to get the width and height of text created with imagettftext? Karl DeSaulniers Design Drumm http://designdrumm.com Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mai

Re: [PHP-DB] Broken query

> > I am trying to write a query to select a trivia question, but I don't want > the trivia question category to be the same two days in a row so I added a > second "SELECT" syntax to find out what category was used yesterday. This > works when I test it "live", but doesn't work when it is part o

Re: [PHP-DB] Broken query

How is the last mailing date variable set? Have you tried printing out the queries that are run when it is run manually and when it is run as a cron to find any differences? -patrick On Jul 11, 2010 8:23 AM, "Ron Piggott" wrote: I am trying to write a query to select a trivia question, but I d

Re: [PHP-DB] Need help with HTML form errors

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/04/2010 02:55 PM, Jesus wrote: > On 07/04/2010 03:30 AM, nagendra prasad wrote: >> Hi All, > >> I have this php form that I have inserted in the result page. > >> > *

Re: [PHP-DB] Image linking help in PHP

+1 This is the way to do it IMO. Has worked for me. Karl On Jul 4, 2010, at 1:26 PM, Vinay Kannan wrote: So basically you want to be able to associate an image with an Mp3, and the path to the mp3 is stored in the DB, right ? If above is the case, why dont you upload the image to an image

Re: [PHP-DB] Need help with HTML form errors

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/04/2010 03:30 AM, nagendra prasad wrote: > Hi All, > > I have this php form that I have inserted in the result page. > > > > > >    >

Re: [PHP-DB] Image linking help in PHP

So basically you want to be able to associate an image with an Mp3, and the path to the mp3 is stored in the DB, right ? If above is the case, why dont you upload the image to an image folder, and save the path to the image in the DB too along with mp3 path details, I think this should work ! Than

Re: [PHP-DB] Image linking help in PHP

Thanks Jason, However will this work if each time let say a variable called $mp_url will change. I hope you know what I meant. The MP3 link will not be constant, but the image file link could be constant. I already linked the MP3 link with its own name (Text ) and its working but now I want to rep

Re: [PHP-DB] Need help with HTML form errors

Hi, Those are notices not warnings(meaning they can be ignored sometimes, search for error_reporting in the PHP manual). In your example, if you do not wish ignore the notices, then initialize the different variables to some value. Sent from my iPhone On 04/07/2010, at 6:30 PM, nagendra p

Re: [PHP-DB] Need Help in Mysql database

On Wed, Jun 30, 2010 at 10:52 AM, nagendra prasad wrote: > Hi All, > > I have a huge set of MP3 database. My problem is that when I try to search > in my database its getting very slow. I was wondering if I split that > database into 2 or more tables. Will this improve the speed of searching? Is >

Re: [PHP-DB] RE: [PHP-WIN] Re: Need Help in setting up a server

Well, there are two more things to do. 1. If you have a router you will have to forward the ports for the webserver (80, etc) to the correct internal ip. - depending on your security needs consider putting your webserver into the fm 2. There are multiple services out there that offer dynamic d

Re: [PHP-DB] RE: [PHP-WIN] Re: Need Help in setting up a server

u can do one more thing, u need to get a public ip or a static ip from ur ISP, this will make sure that u have a constant ip on ur machine so that it can be accessed from anywhere.. Chaitanya On Wed, Jun 30, 2010 at 2:10 AM, Warren Vail wrote: > The IP you cited Is the IP provided by your rou

Re: [PHP-DB] Email validation

On 28 June 2010 15:42, gmail wrote: > Hello to you all! > > I'm facing a problem with a scrip that can validate a form witch accept only > as input email address. > > I have seen many scripts on the net and  were very interesting but I'm not > able to implement those scripts on my need. > >  I'm e

RE: [PHP-DB] Re: [PHP-WIN] Need Help in setting up a server

The only thing to remember is that the firewall settings on the wamp / xampp machine have to be set to allow incoming connections. Then you can reach the server by IP. I would share the htdocs folder of the server (and map it on the other workstations) , so you can make changes to the working web

Re: [PHP-DB] PHP ERP Applications Need Suggestions????

Hello! You should look at same good & stable ERP's PHP based, and start your new project from one of them. By example: * BlueErp * Dolibarr * GNU Enterprise * WebERP Cheers, Adriano Laranjeira. On Mon, 28 Jun 2010 17:17:26 +0530 Mohamed Hashim wrote: *Hello everyone,* *I just want to dev

RE: [PHP-DB] table html with PHP

ms Cc: php-db@lists.php.net Subject: Re: [PHP-DB] table html with PHP thank youu... work... I understand why the $i = 0 again... thanks thanks thanks 2010/6/15 Systems I assume you're looking for something like: $varible[0]"; $i++; If ($i>1)

Re: [PHP-DB] table html with PHP

thank youu... work... I understand why the $i = 0 again... thanks thanks thanks 2010/6/15 Systems > I assume you're looking for something like: > > >$i = 0; >while(array) >{ >echo "$varible[0]"; > $i++; >If ($i>1) > { >$i=0; >

Re: [PHP-DB] table html with PHP

sorry again... thanks for your answer... 2010/6/15 Emiliano Boragina > sorry... why $i = 0 again? > > 2010/6/15 Systems > > I assume you're looking for something like: >> >> >>>$i = 0; >>while(array) >>{ >>echo "$varible[0]"; >> $i++; >>If ($i>1) >>

Re: [PHP-DB] table html with PHP

sorry... why $i = 0 again? 2010/6/15 Systems > I assume you're looking for something like: > > >$i = 0; >while(array) >{ >echo "$varible[0]"; > $i++; >If ($i>1) > { >$i=0; >echo ''; >} >} > ?> > > > >

RE: [PHP-DB] table html with PHP

I assume you're looking for something like: $varible[0]"; $i++; If ($i>1) { $i=0; echo ''; } } ?> -Original Message- From: Emiliano Boragina [mailto:emiliano.borag...@gmail.com] Sent: Tuesday, June 15, 2010 3:

Re: [PHP-DB] Need Help in error msg

hi.. Try to change the root password by System->administration->users and groups. Unlock the key and double click the root.Change the root password and try downloading again.I hope this works. --Bavithra

Re: [PHP-DB] ie multi tab label share one cookie?

On Wed, Jun 9, 2010 at 10:28 PM, win.a wrote: > It's known  that the IE browser  share on session in the same APP > How about cookie ,the same ?or use its own? > Thanks in advacne! > > All you best > > What we are struggling for ? > The life or the life ? > > -- > PHP Data

Re: [PHP-DB] anyone has experience with pgslq Cybercluster 2 ?

On 02/06/10 04:34, Artur Ejsmont wrote: Hi there i just noticed announcement of cybercluster 2 release for postgres. http://www.cybertec.at/en/postgresql_news they say its open source but did not find downloads on their site ; ) Anyone has experinece with it? i loved postgres and used to work

Re: [PHP-DB] upload images

Good to hear. Karl Sent from losPhone On May 31, 2010, at 2:41 PM, Emiliano Boragina > wrote: Thanks a lot... this last solution is the best for me... thanks a lot to all!!! 2010/5/31 Karl DeSaulniers You are probably right. The use of the $i and say "photo_".$i.".jpg" would work better.

Re: [PHP-DB] upload images

You are probably right. The use of the $i and say "photo_".$i.".jpg" would work better. and change.. :) Karl On May 31, 2010, at 2:27 AM, 3dgtech wrote: It could work, but be careful using timestamp or the php equivalent - microtime since this is reliant on gettimeofday(). If naming conv

Re: [PHP-DB] upload images

It could work, but be careful using timestamp or the php equivalent - microtime since this is reliant on gettimeofday(). If naming conventions don't mandate a sterilized format I woul still recommend using a "confirmed" new variable. Just my two cents :-) Eli On May 30, 2010, at 10:04 PM, K

Re: [PHP-DB] upload images

The problem with time() is that fast servers are too fast! (you will have processed multiple files before time() changes.) Add the $i from the for loop in multiple images to the end of your filename. On May 30, 2010, at 4:33 PM, Karl DeSaulniers wrote: Try this Try assigning time() to

Re: [PHP-DB] upload images

Try this Try assigning time() to a variable then add that to the rename. EG: if ($_FILES['foto']['type'] == "image/jpeg" || $_FILES['foto']['type'] == "image/pjpeg"){ //nombre de la imagen $timestamp = time(); //movemos la i

Re: [PHP-DB] Fatal error: Class 'Mail' not found in

On Sat, May 29, 2010 at 7:23 PM, win.a wrote: > Excuse me to trouble ,in my little application there's a mail function > which i revoked the pear package require 'mail.php' > > when i test the app ,it show me "Fatal error: Class 'Mail' not found > ",i checked the mail.php no Class Mail? > How can

Re: [PHP-DB] File Downloads

can retrieve the file more than once...) Good luck Eli -Original Message- From: Karl DeSaulniers [mailto:k...@designdrumm.com] Sent: Friday, May 28, 2010 7:40 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] File Downloads This is for a small project of limited edition audio or pictures

RE: [PHP-DB] File Downloads

<150 or username Is logged in join table (so the 150 first authenticated users can retrieve the file more than once...) Good luck Eli -Original Message- From: Karl DeSaulniers [mailto:k...@designdrumm.com] Sent: Friday, May 28, 2010 7:40 PM To: php-db@lists.php.net Subject: Re: [PHP

Re: [PHP-DB] File Downloads

which is the IP you're logging) Is there any reason not to log them in by personalized means? (such as email/username) -Original Message- From: Karl DeSaulniers [mailto:k...@designdrumm.com] Sent: Friday, May 28, 2010 6:39 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] File Downloads

Re: [PHP-DB] File Downloads

27;re logging) Is there any reason not to log them in by personalized means? (such as email/username) -Original Message- From: Karl DeSaulniers [mailto:k...@designdrumm.com] Sent: Friday, May 28, 2010 6:39 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] File Downloads On May 28, 2010, at 4:

Re: [PHP-DB] File Downloads

On May 28, 2010, at 4:49 PM, Michael Stowe wrote: For that you would probably need to setup a databased system in which (best scenario) they would need to register prior to downloading or (not so secure) capture their IP address and prevent that IP from downloading it again (example below).

Re: [PHP-DB] Sqlite inserts inside a PDO fetch loop

Can't you do a limit in the extract SQL and mark the records extracted so that you don't end up extraxting the same ones? Bastien Sent from my iPod On May 28, 2010, at 5:49 PM, Brandon wrote: Hello, I have a situation where I am trying to create an index of words contained in a partic

RE: [PHP-DB] File Downloads

come with problems... but depending on the importance of the content -- it should be good. Adam -Original Message- From: Karl DeSaulniers [mailto:k...@designdrumm.com] Sent: Friday, May 28, 2010 2:36 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] File Downloads On May 28, 2010, at

Re: [PHP-DB] File Downloads

On May 28, 2010, at 4:33 PM, Karl DeSaulniers wrote: On May 28, 2010, at 4:18 PM, Adam Schroeder wrote: Hi Karl -- You can store the file contents outside of the web tree and use PHP to "read" the contents. This allows you to place access control restrictions in the PHP script. This

Re: [PHP-DB] File Downloads

On May 28, 2010, at 4:18 PM, Adam Schroeder wrote: Hi Karl -- You can store the file contents outside of the web tree and use PHP to "read" the contents. This allows you to place access control restrictions in the PHP script. This post talks about doing something similar with images.

RE: [PHP-DB] File Downloads

Hi Karl -- You can store the file contents outside of the web tree and use PHP to "read" the contents. This allows you to place access control restrictions in the PHP script. This post talks about doing something similar with images. Obviously, if you have a music track... you'll need to adj

Re: [PHP-DB] PHP / iODBC / PostGreSQL: running into a deadlock

To try to solve this issue, I grabed the sources for PHP (5.3.2) and libiodbc (3.52.7). When ran under GDB, I can observe the following: odbc_exec() [PHP code] calls SQLAllocStmt() [libiodbc code], which calls some internal function that tries to call SQLAllocStmt(), in some indirect recursive w

Re: [PHP-DB] Need Simple PHP mysql search engine script

On 24/05/10 16:01, nagendra prasad wrote: Hi Chaitanya, I have used the below script but its not meeting my requirements. What I need is that I have a database in which their are names which I wanted to use as keywords. I want to search with only one variable called Names. the other stuff will

<    8   9   10   11   12   13   14   15   16   17   >