http://cakephp.org/
On Jan 16, 2011, at 6:02 AM, Miriam Natanzon wrote:
Hi,
I want to choose an open-source ORM platform to use as a base for many
different applications as a standard environment in my organization. ( we
used DBI for PERL in the past).
I saw and read about Doctrine -
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
On Jan 7, 2010, at 2:36 PM, Vinay Kannan wrote:
Hello,
Theres this project that I am working on, and a specific module does take
few secs to process, I am thinking it would be cool to be showing a progress
bar(some kind on a .gif image) while the script runs, does any one have an
idea how
On Dec 15, 2009, at 6:02 PM, David McGlone wrote:
On Monday 14 December 2009 21:44:24 Chris wrote:
Chris wrote:
David McGlone wrote:
On Monday 14 December 2009 21:02:37 Chris wrote:
David McGlone wrote:
Hi everyone,
I've been lurking in the shadows on the list for quite some time and
Hi.
In a mysql query, it is recommended that GROUP BY fields be indexed? Using
EXPLAIN on one of my queries, I noticed no change between having indexed by
GROUP BY field and not indexing it. Any thoughts would be appreciated.
In this example, should `history_field` be indexed...?
SELECT
On Dec 9, 2009, at 12:58 PM, h...@deweywilliams.com wrote:
The only SELECT is on MAX('timestamp'). There is really nothing to Group BY
in this query.
Dewey
Philip Thompson wrote:
Hi.
In a mysql query, it is recommended that GROUP BY fields be indexed? Using
EXPLAIN on one of my
Hi all.
We are wanting to create an app that contains multiple clients. Each clients
has anywhere from 1 user to more than a hundred. We had the idea of separating
each client into its own database schema. This reduces the single point of
failure - if 1 client db dies, it doesn't kill the
On Nov 4, 2009, at 4:00 PM, Chris wrote:
Chris wrote:
Rafael Costa Pimenta wrote:
But the link http://doc2pdf.sourceforge.net/overview.html seems to
use e-mail, i did not understand, I just want to extract a
word .doc file from the mssql database, save in a temp directory,
convert to the
On May 2, 2009, at 6:43 PM, Emiliano Boragina wrote:
Hello.
I am using this:
$sql = SELECT * FROM table WHERE ID LIKE '%$_GET[id]%' AND title LIKE
'%$_GET[word]%';
But I want exactlu ID, not one part of many possibles Ids in the DB.
How can I do that?
PLEASE tell me your cleaning that
On Sep 15, 2008, at 10:03 AM, Jason Pruim wrote:
On Sep 15, 2008, at 10:59 AM, Micah Gersten wrote:
Use 2 tables. You never know what the app might grow into and you
should do it right the first time.
That's what I was thinking too... Just wanted to hear it from
someone else... NOW I get
Developer
http://www.onshore.com
Yes, I agree with that. That was just a quick example that I whipped
up (and obviously didn't think enough about). ;) So, follow Micah's
advice, people. =D
~Philip
Philip Thompson wrote:
I'll throw this out there though. When dealing with foreign keys
On Jul 8, 2008, at 11:55 AM, TK wrote:
I'd like to use a PDO prepared statement to perform a MySQL query
that uses the IN function.
I.e.:
$stmt = $pdo-prepare('
select *
from mytable
where myfield IN (:contents)
);
$stmt-bindValue(':contents', $contents);
$stmt-execute();
Here's the
Hi all.
Which is more efficient in order to use SELECT FOR UPDATE?
% SELECT * FROM `table` WHERE (`table_id` = 32) LIMIT 1 FOR UPDATE;
% UPDATE `table` SET `field_name` = 'Pizza' WHERE (`table_id` = 32)
LIMIT 1;
OR
% SELECT `field_name` FROM `table` WHERE (`table_id` = 32) LIMIT 1
FOR
On May 2, 2008, at 8:00 AM, Jason Pruim wrote:
On May 1, 2008, at 8:31 PM, Chris wrote:
PS... Was it you, Jason, or someone else who asked about the
security
of the community knowing their database structure and I
encouraged the
use of `backticks` around all field and table names?
Yeah
On May 1, 2008, at 7:56 AM, Jason Pruim wrote:
On Apr 30, 2008, at 5:03 PM, Philip Thompson wrote:
On Apr 30, 2008, at 10:54 AM, Jason Pruim wrote:
Hi Yves,
Thanks for the tip, that worked, I think I'll use that from now on..
Just out of curiosity though, any idea why it wasn't working
On Apr 30, 2008, at 10:54 AM, Jason Pruim wrote:
Hi Yves,
Thanks for the tip, that worked, I think I'll use that from now on..
Just out of curiosity though, any idea why it wasn't working as I
was writing it :)
Did you try putting the query that PHP is generating in phpMyAdmin or
MySQL
On Apr 28, 2008, at 12:49 AM, Chris wrote:
Philip Thompson wrote:
On Apr 27, 2008, at 9:15 AM, Ron wrote:
Hi,
How can i retrieve via php a media stored in a mysql database as
longblob?
I'd like to be able to retrieve the media and stream it.
TIA
regards,
ron
Just like any other field
On Apr 28, 2008, at 9:22 AM, Ron wrote:
hi yves,
not sure how large the file is, but i'm assuming a caller would not
leave a voicemail longer than a minute. max maybe 30 secs. is there
a query to get the size of a data in a certain row/column?
thank you
regards
ron
Assuming you're
On Apr 27, 2008, at 9:15 AM, Ron wrote:
Hi,
How can i retrieve via php a media stored in a mysql database as
longblob?
I'd like to be able to retrieve the media and stream it.
TIA
regards,
ron
Just like any other field type. Doesn't matter to PHP what the field
type is...
?php
$sql
Hi all.
Here's my disclaimer: this question is solely MySQL-related - I just
happen to be programming in PHP.
I have found some functionality which *appears* to be a bug, but I
didn't want to report it before asking some intelligent people. I have
this simple query:
SELECT UPPER('just
Hi all.
I have worked with a MySQL database a whole lot, but never really an MS
SQL database before. Here's the problem I'm having. I call this
function and then nothing else happens. No other information shows up
on the page.
$link = mssql_connect(myServer, me, pw);
Of course, I replace the
Hi again all!
Right after I sent the email... I think I figured out what it was! I do
not have it `uncommented` in my php.ini file! Therefore, none of the
mssql_* functions would work.
Sorry for that last email.
~Philip
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
Hi all.
I am having a problem obtaining the specific information I need. I have
a table of people that can have multiple rows - ie, Director,
Manager, etc. However, in the projects table, each project has a
director AND manager, but not necessarily the same person.
I have the query to pull the
On Oct 12, 2004, at 7:15 AM, [EMAIL PROTECTED] wrote:
hello,
I have a begining question.
I've got simple html form and php script, but insert doesn' t work.
What is
wrong in my insert mysql_query?
mysql_query( insert into obiskovalci (ime, priimek, ulica, hstevilka,
pstevilka, posta)
Hi all.
This may be a bit elementary, however, I am confused on the
functionality of it. I am wanting to create a session that logs out
after a certain amount of time, no matter if the user is doing
something or not. I have used the function `set_time_limit()`, but I
don't know if I'm using it
['REMOTE_ADDR'] it is giving ip address of server which
is hosting the webpage not the user's ip address. pls. suggest how can IP
address of an user can be obtained.
with best wishes
balwant
-Original Message-
From: Philip Thompson [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 30, 2004 3:45
Ramil,
On Sep 30, 2004, at 1:17 AM, Ramil Sagum wrote:
On Thu, 30 Sep 2004 11:00:35 +0530, balwantsingh
[EMAIL PROTECTED] wrote:
i tried the $_SERVER['REMOTE_ADDR'] it is giving ip address of server
which
is hosting the webpage not the user's ip address. pls. suggest how
can IP
address of an
Hi all.
I am needing to obtain the IP address of a user who logs into the
system. I tried to use `getenv(REMOTE_ADDR)`, however, this function
does not work in ISAPI mode, which is what I am running.
Is there an alternative to obtaining the IP address? I have looked
around, but I cannot seem
Oh, before I get a slew of emails about this one, I think I figured it
out: $_SERVER['REMOTE_ADDR']
I knew it couldn't have been that difficult... brain fart! Sorry for
wasting your time.
~Philip
On Sep 29, 2004, at 5:02 PM, Philip Thompson wrote:
Hi all.
I am needing to obtain the IP address
Hi.
On Sep 15, 2004, at 6:55 AM, Vincent Jordan wrote:
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
Aaron,
I agree with what Mark said. But I just want to say what I noticed off
hand...
On Sep 10, 2004, at 11:13 AM, Aaron Todd wrote:
I'm trying to run an INSERT query on my mysql database and it isnt
working.
Here is the query:
$updatequery = UPDATE `users`
SET
Blackwater,
On Sep 10, 2004, at 12:39 PM, blackwater dev wrote:
Hello,
I need to grab the max value of all of the data in a table grabbing
the max total for each client. Example.
T1
idtotal clientid
1 100 111
2 200 111
3 100
I think everyone knows that $sql is a statement. But what people are
asking is: what is that statement?! Because if there are incorrect
characters or 's in that statement, then that can break your
code/statement.
~Philip
On Sep 9, 2004, at 5:49 PM, Stuart Felenstein wrote:
Just getting back to
Yemi,
On Sep 6, 2004, at 7:14 AM, Yemi Obembe wrote:
i'd just luv to ask if it is possibble to call a function in PHP by
using event handlers (like onmouseover, onload) as done in javascript?
if its possible, i'd appreciate someone to tutor me on it.
As far as I know, this is not possible.
Hi all.
This might be a simple answer, but I'm still not sure what the case is.
Okay, so I have a form in my html that has some inputs. These each
have a `name` and a `value` attribute to them, of course.
I cannot seem to access the name/value pair in my php without using the
$_POST
/
--
Philip Thompson [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi all.
This might be a simple answer, but I'm still not sure what the case
is.
Okay, so I have a form in my html that has some inputs. These each
have a `name
an array over a lot of variables? I can use
either or - there was no particular reason why I chose a single
variable.
Thanks,
~Philip
On Mon, 2004-08-30 at 11:02 -0500, Philip Thompson wrote:
Peter,
On Aug 29, 2004, at 6:26 PM, Peter Lovatt wrote:
Hi
you need to check for $_POST[user1], $_POST[user2
Hi all.
I have a list of users in a database that I would like to show on a
dynamic webpage. With each of these users that shows up on the page,
there is going to be a checkbox next to their name so that I can
perform multiple tasks, such as 'Remove User' or 'Modify Information'.
I have all of
Hi again all.
Sorry to bug you again. But I thought I would throw this out here again
and see if anyone has any input. It would be greatly appreciated.
I am running PHP on a Windows 2000 Server, and I need to enable LDAP
support. So I have viewed the
http://us3.php.net/manual/en/ref.ldap.php
Aaron,
On Aug 2, 2004, at 1:31 PM, Aaron Todd wrote:
So far, I have been doing ok with PHP. I feel that I have picked it up
rather easily. But now I need some help. I am trying to use the
sendmail
functions to send data entered in a form to my email address.
Currently its
not working at all.
Hi all.
I am running PHP on a Windows 2000 Server, and I need to enable LDAP
support. So I have viewed the
http://us3.php.net/manual/en/ref.ldap.php page on how to get LDAP
running. However, I have run into a snag.
I have copied the two required .dlls (libeay32 ssleay32) into the
system
Hi all.
I am querying a database of single information multiple times using a
simple 'select' statement. However, whenever the data in the DB is
empty or is 0 (zero), then it throws an error. However, I don't want it
to throw an error, I just want it to move on to the next query.
This is being
Pablo,
Hello Philip,
pse.. can you paste the error information?
There is no known empty set problem.
Here's my function:
function getMysqlSelectResultForUsername($identifier, $userName, $link)
{
$queryResult = mysql_query(select $identifier from theTable where
username = '$userName',
Thanks all! I will try some of the suggestions that you guys gave. I
appreciate it.
~Philip
On Jul 26, 2004, at 12:52 PM, Pablo M. Rivas wrote:
Hello Philip,
read:
http://www.php.net/manual/en/function.mysql-result.php
when you do $queryResult = mysql_result($queryResult,0) you
Hi. You left out the 'php' after the '?'. So it should read:
?php
print $action;
print $Name;
?
See if that helps any.
~Philip
body
form name=frmname
input type=text name=Name value=Rinku
input type=submit name=action value=Login
?
print $action;
print $Name;
?
/form
/body
/html
--
PHP Database
Yeah, you should have a single apostrophe around the $id. So it should
read:
mysql_query(DELETE FROM open_trades WHERE id='$id');
That should do it.
~Philip
On Jun 16, 2004, at 12:04 AM, Justin wrote:
Hello, I have a simple script to retrieve and then delete a selected
script, but it does not
Have you tried with a insted of A for am/pm indication?
Yes, I have tried both 'a' and 'A'. Still gives an incorrect time.
~Philip
Hope can help
Bye
Franciccio
Philip Thompson [EMAIL PROTECTED] ha scritto nel messaggio
news:[EMAIL PROTECTED]
Hi all.
Maybe there's something I'm doing incorrectly
I agree about the semi-colon: not allowed. But also, specify '$link' in
your mysql_error(). This tells it explicitly what the error is
referring to, even though it should be able to figure it out on it's
own.
echo 'MySQL Error: ' . mysql_error($link);
Hope this helps - seems to work for me.
Hi all.
Maybe there's something I'm doing incorrectly, but I cannot get the
date() function to return the appropriate time. It's always 12 hours
off. I've tried using 24-hour time and 12-hour time (with AM/PM), but
they both give the wrong time. I even emailed the server admin to make
sure
Hi all!
I am using a select statement to obtain all the dates whenever someone
submitted a problem in a database. Well, I want to get the result
(which could be multiple dates) and then print that in a table format
with some other information on a webpage. So I want to use a FOR loops
and go
Yes, thanks to all that assisted. I got it working like a charm!
~Philip
On Jun 11, 2004, at 9:30 AM, Torsten Roehr wrote:
Philip Thompson [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi all!
I am using a select statement to obtain all the dates whenever someone
submitted a problem
Hi all.
I am running a website to where a user needs to login to authenticate
themselves to perform certain tasks. So a user logs in, and I start a
session (in PHP, of course). Well, the catch is, I am doing this all
from one page, 'viewer.php', and I just tack on the specific view/page
that I
On Jun 10, 2004, at 9:44 AM, Torsten Roehr wrote:
Philip Thompson [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi all.
I am running a website to where a user needs to login to authenticate
themselves to perform certain tasks. So a user logs in, and I start a
session (in PHP, of course
53 matches
Mail list logo
