At 4:29 PM -0400 10/1/09, Robert Cummings wrote:
I'm a superstar... send me a check for $500,000 and I'll fly on over.
Or did you completely misuse the word superstar?
Cheers,
Rob.
Rob:
Well, in my book you are a superstar.
Cheers,
tedd
--
---
http://sperling.com
Hi All,
We require a PHP / MySQL superstar to work in-house at our offices near
Edgware, London for 3 months on a ground breaking new web 2.0 project
which involves a variety of exciting new technologies. You will need at
least 2 years proven experience on commercial projects. Relevant
experience
Hello,
on 10/01/2009 10:09 AM Jerome Botbol said the following:
Hi All,
We require a PHP / MySQL superstar to work in-house at our offices near
Edgware, London for 3 months on a ground breaking new web 2.0 project
which involves a variety of exciting new technologies. You will need
I'm a superstar... send me a check for $500,000 and I'll fly on over.
Or did you completely misuse the word superstar?
Cheers,
Rob.
Jerome Botbol wrote:
Hi All,
We require a PHP / MySQL superstar to work in-house at our offices near
Edgware, London for 3 months on a ground breaking new
all results in an html format from all queries.
Now I could “tee” this to a file and save the results returned if I so choose
to save the result of the display .
Let’s say I want to be lazy and write a php MySQL query to do the same so
that any result I queried for would return the html
I tend to do this robert,
while looking at your example i thought to myself since i am trying to mimick a
shell command why not run one.
Result:
?
$db = 'db';
$host = 'host';
$user = 'user';
$pass = 'pass';
$query = select * from $db.my_table;
$ddvery = shell_exec(mysql -u$user -p$pass --html
ad...@buskirkgraphics.com wrote:
I tend to do this robert,
while looking at your example i thought to myself since i am trying to mimick a
shell command why not run one.
Result:
?
$db = 'db';
$host = 'host';
$user = 'user';
$pass = 'pass';
$query = select * from $db.my_table;
$ddvery =
all results in an html format from all queries.
Now I could “tee” this to a file and save the results returned if I so choose
to save the result of the display .
Let’s say I want to be lazy and write a php MySQL query to do the same so
that any result I queried for would return the html
queries.
Now I could “tee” this to a file and save the results returned if I so choose
to save the result of the display .
Let’s say I want to be lazy and write a php MySQL query to do the same so that
any result I queried for would return the html results in a table without
actually writing
results in an html format from all queries.
Now I could “tee” this to a file and save the results returned if I so choose
to save the result of the display .
Let’s say I want to be lazy and write a php MySQL query to do the same so that
any result I queried for would return the html results
ad...@buskirkgraphics.com wrote:
Would you mind giving me an example of this that i can stick right into a blank
php file and run.
I get what you are saying but i cant seem to make that even echo out the data.
php 5.2 mysql 5.1.3 Apache 2.2
?php
$db = 'db';
$host = 'host';
$user =
-Original Message-
From: Tom Worster [mailto:f...@thefsb.org]
Sent: 09 September 2009 02:29
thanks, Devendra, that's pretty much the same as my handler. (though
i can't
figure Rich Smith's $sess_save_path global. do you know what is
for?)
I think if you look at the comments on
On 9/9/09 4:16 AM, Ford, Mike m.f...@leedsmet.ac.uk wrote:
-Original Message-
From: Tom Worster [mailto:f...@thefsb.org]
Sent: 09 September 2009 02:29
thanks, Devendra, that's pretty much the same as my handler. (though
i can't
figure Rich Smith's $sess_save_path global. do you
good point, gabriel.
i really need to stop procrastinating with the whole memcache project.
perhaps i ought to postpone consideration of the session handler until i've
learned something about memcache, which i need to do anyway.
On 9/8/09 10:06 PM, Gabriel Sosa sosagabr...@gmail.com wrote:
questions for those of you with a user session handler using mysql:
did you write your own handler, write one based off some other you found (if
so, which?), or are you using some available library (if so, which?)?
and how do you feel about your implementation? satisfied? or are there
http://www.devshed.com/c/a/PHP/Storing-PHP-Sessions-in-a-Database/
On Tue, Sep 8, 2009 at 10:53 PM, Tom Worster f...@thefsb.org wrote:
questions for those of you with a user session handler using mysql:
did you write your own handler, write one based off some other you found
(if
so,
thanks, Devendra, that's pretty much the same as my handler. (though i can't
figure Rich Smith's $sess_save_path global. do you know what is for?)
but what i'm really interested in is people's experience in switching over
to and using this kind of handler: pitfalls, gotchas, etc. or is it really
I'm our case we opt for memcache to store the sessions
Mmc its soo much faster and you will have less net overhead because
the simple protocol
Also the configuration its easier. If you see in the php manual you
only need to touch two lines in the php.ini
On 9/8/09, Tom Worster f...@thefsb.org
At 12:47 AM +0200 8/10/09, Ralph Deffke wrote:
I would like to have a KNOWN status of my database after a NEW installation
of the application, because the further installation relais on information
stored in record 1 of each table.
Sounds like a problem waiting to happen.
Cheers,
tedd
--
Hi all,
I'm facing the fact that it seems that auto_increment fields in a table not
start at 1 like it was in earlier versions even if I install mySQL brand new
creating all tables new. it seems to me that auto_increments handling has
changed to older version. is somebody out there who can give
ALTER TABLE T1 AUTO_INCREMENT=1;
It's likely that you dropped every record and expected the auto_increment to
reset.
Jerry Wilborn
jerrywilb...@gmail.com
On Sun, Aug 9, 2009 at 1:17 PM, Ralph Deffke ralph_def...@yahoo.de wrote:
Hi all,
I'm facing the fact that it seems that auto_increment
no this is not the point ! if I do this, the next auto_increment is still
10720
i can do what I want however the is defined long unsigned unique
auto_increment, what happens is in t1 the value is set to 10720 in t2 the
next value ist set to 10721 while the next record in t1 gets 10721.
it seems
no this is not the point ! if I do this, the next auto_increment is still
10720
i can do what I want however the field is defined long unsigned unique
auto_increment, what happens is in t1 the value is set to 10720 in t2 the
next value ist set to 10721 while the next record in t1 gets 10722.
At 8:17 PM +0200 8/9/09, Ralph Deffke wrote:
Hi all,
I'm facing the fact that it seems that auto_increment fields in a table not
start at 1 like it was in earlier versions even if I install mySQL brand new
creating all tables new. it seems to me that auto_increments handling has
changed to
I would like to have a KNOWN status of my database after a NEW installation
of the application, because the further installation relais on information
stored in record 1 of each table.
tedd tedd.sperl...@gmail.com wrote in message
news:p06240801c6a4fe331...@[192.168.1.100]...
At 8:17 PM +0200
On Jul 13, 2009, at 10:03 AM, Govinda wrote:
I have this code:
$db_billing=mysqli_connect(localhost,metheuser,mypass,billing);
if (mysqli_connect_error()) { die(Can't connect: .
mysqli_connect_error()); }
mysqli
//$dbname = 'billing';
$sql = SHOW TABLES;
Better late then never! :)
I played around with your code tonight and got this working on a
test server:
?PHP
$db_billing = mysql_connect($DBHOST, $DBUSER, $DBPASS) or die(Could
not connect: .mysql_error());
$db_selected = mysql_select_db($DB, $db_billing);
if(!$db_selected)
Things I have used prepared statements for:
1. SELECT
2. UPDATE
3. INSERT
4. DELETE
5. Stored procedures
Things I am aware of that prepared statements are not capable of doing:
What have you read that prepared statements can't do? I've not heard
of anything, nor have I encountered anything,
Hi List,
Just wanted to pick your brains please?
I'm trying to standardise on the way I query databases and move away from
the Dreamweaver built-in functions (which I know you all hate!) ;)
I've been on this list for about 5 years now and I don't think I've ever
heard anyone mention the Pear
On Tue, Jul 14, 2009 at 2:29 AM, Tom Chubbtomch...@gmail.com wrote:
Hi List,
Just wanted to pick your brains please?
I'm trying to standardise on the way I query databases and move away from
the Dreamweaver built-in functions (which I know you all hate!) ;)
I've been on this list for about 5
On Tue, 2009-07-14 at 01:52 -0400, Andrew Ballard wrote:
On Mon, Jul 13, 2009 at 4:18 PM, Haig Dedeyanhdede...@videotron.ca wrote:
for the phone #'s, I'm using int as the data type storing each part of the
phone # in its own cell,
When it gets displayed, I add a dash in between each part
2009/7/14 Eddie Drapkin oorza...@gmail.com
On Tue, Jul 14, 2009 at 2:29 AM, Tom Chubbtomch...@gmail.com wrote:
Hi List,
Just wanted to pick your brains please?
I'm trying to standardise on the way I query databases and move away from
the Dreamweaver built-in functions (which I know you
Eddie Drapkin wrote:
Things I have used prepared statements for:
1. SELECT
2. UPDATE
3. INSERT
4. DELETE
5. Stored procedures
Things I am aware of that prepared statements are not capable of doing:
What have you read that prepared statements can't do? I've not heard
of anything, nor have I
2009/7/14 Tom Chubb tomch...@gmail.com
2009/7/14 Eddie Drapkin oorza...@gmail.com
On Tue, Jul 14, 2009 at 2:29 AM, Tom Chubbtomch...@gmail.com wrote:
Hi List,
Just wanted to pick your brains please?
I'm trying to standardise on the way I query databases and move away
from
the
On July 12, 2009 03:34:49 pm Haig Dedeyan wrote:
On Sat, 11 Jul 2009 21:26:36 -0400, Haig Dedeyan wrote:
On Sun, Jul 12, 2009 at 4:09 AM, Haig Dedeyan hdede...@videotron.ca
wrote:
mysql_query(INSERT INTO phonedir
(fname, lname) VALUES('$new_fname','$new_lname'))
or die(mysql_error());
On July 12, 2009 08:52:56 am Haig Dedeyan wrote:
At 6:39 PM -0400 7/11/09, Haig Dedeyan wrote:
[1]
mysql_query(INSERT INTO phonedir
(fname, lname) VALUES('$new_fname','$new_lname'))
or die(mysql_error());
or
[2]
mysql_query(INSERT INTO phonedir
(fname, lname)
At 8:50 PM +0530 7/12/09, Zareef Ahmed wrote:
On Sun, Jul 12, 2009 at 8:42 PM, tedd
mailto:tedd.sperl...@gmail.comtedd.sperl...@gmail.com wrote:
As with all communication, it's better to be clear than obtuse.
Agree, but I believe obtuse word meaning is contextual and depends :)
The word
At 3:53 PM -0400 7/12/09, Paul M Foster wrote:
On Sun, Jul 12, 2009 at 09:07:45AM -0400, tedd wrote:
snip
As for prepared statements, I'm no authority on them, but from what
I've read they are not going to be something I'll be practicing
anytime soon.
Aside from Stuart's comments about
On Monday 13 July 2009 14:31:09 tedd wrote:
At 3:53 PM -0400 7/12/09, Paul M Foster wrote:
On Sun, Jul 12, 2009 at 09:07:45AM -0400, tedd wrote:
snip
As for prepared statements, I'm no authority on them, but from what
I've read they are not going to be something I'll be practicing
I have this code:
$db_billing=mysqli_connect(localhost,metheuser,mypass,billing);
if (mysqli_connect_error()) { die(Can't connect: .
mysqli_connect_error()); }
mysqli
//$dbname = 'billing';
$sql = SHOW TABLES;
$result = mysql_query($sql); // line 53
On July 13, 2009 09:48:54 am Haig Dedeyan wrote:
On Monday 13 July 2009 14:31:09 tedd wrote:
At 3:53 PM -0400 7/12/09, Paul M Foster wrote:
On Sun, Jul 12, 2009 at 09:07:45AM -0400, tedd wrote:
snip
As for prepared statements, I'm no authority on them, but from what
I've read
On Mon, Jul 13, 2009 at 4:18 PM, Haig Dedeyanhdede...@videotron.ca wrote:
On July 13, 2009 09:48:54 am Haig Dedeyan wrote:
On Monday 13 July 2009 14:31:09 tedd wrote:
At 3:53 PM -0400 7/12/09, Paul M Foster wrote:
On Sun, Jul 12, 2009 at 09:07:45AM -0400, tedd wrote:
snip
As for
On Mon, 2009-07-13 at 16:30 -0400, Bastien Koert wrote:
On Mon, Jul 13, 2009 at 4:18 PM, Haig Dedeyanhdede...@videotron.ca wrote:
On July 13, 2009 09:48:54 am Haig Dedeyan wrote:
On Monday 13 July 2009 14:31:09 tedd wrote:
At 3:53 PM -0400 7/12/09, Paul M Foster wrote:
On Sun, Jul 12,
On Mon, Jul 13, 2009 at 5:52 PM, Ashley
Sheridana...@ashleysheridan.co.uk wrote:
On Mon, 2009-07-13 at 16:30 -0400, Bastien Koert wrote:
On Mon, Jul 13, 2009 at 4:18 PM, Haig Dedeyanhdede...@videotron.ca wrote:
On July 13, 2009 09:48:54 am Haig Dedeyan wrote:
On Monday 13 July 2009 14:31:09
tedd wrote:
At 3:53 PM -0400 7/12/09, Paul M Foster wrote:
On Sun, Jul 12, 2009 at 09:07:45AM -0400, tedd wrote:
snip
As for prepared statements, I'm no authority on them, but from what
I've read they are not going to be something I'll be practicing
anytime soon.
Aside from Stuart's
On Mon, Jul 13, 2009 at 4:18 PM, Haig Dedeyanhdede...@videotron.ca wrote:
for the phone #'s, I'm using int as the data type storing each part of the
phone # in its own cell,
When it gets displayed, I add a dash in between each part of the phone #'s
(country code-area code-1st set of
2009/7/12 Haig Dedeyan hdede...@videotron.ca
On July 11, 2009 08:21:34 pm Haig Dedeyan wrote:
On Sun, Jul 12, 2009 at 4:09 AM, Haig Dedeyan hdede...@videotron.ca
wrote:
On July 11, 2009 10:57:14 am Haig Dedeyan wrote:
At 10:12 PM -0400 7/10/09, Haig Dedeyan wrote:
[1]
At 6:39 PM -0400 7/11/09, Haig Dedeyan wrote:
[1]
mysql_query(INSERT INTO phonedir
(fname, lname) VALUES('$new_fname','$new_lname'))
or die(mysql_error());
or
[2]
mysql_query(INSERT INTO phonedir
(fname, lname)
Hi gang:
I am top posting only to show that the following post makes no sense
as to who said what.
At what point here Zareef, did you think you were helping anyone? Or
is this more of your I'm going to do whatever I want attitude?
I would hate to review code with such lack of forethought
At 9:26 PM -0400 7/11/09, Haig Dedeyan wrote:
@Tedd - I will be looking into prepared statements eventually but I
still want to understand escaping.
Haig:
I'm not the one pushing the prepared statements, that's someone else.
However, I can see how you might think that considering how
On Sun, Jul 12, 2009 at 6:32 PM, tedd tedd.sperl...@gmail.com wrote:
Hi gang:
I am top posting only to show that the following post makes no sense as to
who said what.
At what point here Zareef, did you think you were helping anyone? Or is
this more of your I'm going to do whatever I want
At 8:24 PM +0530 7/12/09, Zareef Ahmed wrote:
On Sun, Jul 12, 2009 at 6:32 PM, tedd
mailto:tedd.sperl...@gmail.comtedd.sperl...@gmail.com wrote:
Hi gang:
I am top posting only to show that the following post makes no sense
as to who said what.
At what point here Zareef, did you think you
On Sun, Jul 12, 2009 at 8:42 PM, tedd tedd.sperl...@gmail.com wrote:
At 8:24 PM +0530 7/12/09, Zareef Ahmed wrote:
On Sun, Jul 12, 2009 at 6:32 PM, tedd mailto:tedd.sperl...@gmail.com
tedd.sperl...@gmail.com wrote:
Hi gang:
I am top posting only to show that the following post makes no
On Sat, 11 Jul 2009 21:26:36 -0400, Haig Dedeyan wrote:
On Sun, Jul 12, 2009 at 4:09 AM, Haig Dedeyan hdede...@videotron.ca wrote:
mysql_query(INSERT INTO phonedir
(fname, lname) VALUES('$new_fname','$new_lname'))
or die(mysql_error());
I won;t be using 2x escapes but I just need to know
On Sun, Jul 12, 2009 at 09:07:45AM -0400, tedd wrote:
snip
As for prepared statements, I'm no authority on them, but from what
I've read they are not going to be something I'll be practicing
anytime soon.
Aside from Stuart's comments about slowness, what else have you read
that makes you
On Sat, Jul 11, 2009 at 19:57, Govindagovinda.webdnat...@gmail.com
wrote:
I have been using PEAR's tableInfo() to remind myself about the
columns in
the table.. but now I want to see as much data as possible about
the table
and its contents *without* using PEAR. (I.e. just using built in
Top-posting.
This would be an excellent question for Prune (CC'd) to field,
based on the error message.
Prune?
On Sun, Jul 12, 2009 at 17:49, Govindagovinda.webdnat...@gmail.com wrote:
On Sat, Jul 11, 2009 at 19:57, Govindagovinda.webdnat...@gmail.com
wrote:
I have been using
On Mon, Jul 13, 2009 at 3:19 AM, Govinda govinda.webdnat...@gmail.comwrote:
On Sat, Jul 11, 2009 at 19:57, Govindagovinda.webdnat...@gmail.com
wrote:
I have been using PEAR's tableInfo() to remind myself about the columns
in
the table.. but now I want to see as much data as possible about
On Jul 10, 2009, at 10:12 PM, Haig Dedeyan hdede...@videotron.ca
wrote:
Hi everyone,
I'm starting to experiment with an edit form and I am seeing the
following
behaviour:
$fname = mysql_real_escape_string($fname);
$lname = mysql_real_escape_string($lname);
$sql = UPDATE phonedir
At 10:12 PM -0400 7/10/09, Haig Dedeyan wrote:
[1]
$fname = mysql_real_escape_string($fname);
$lname = mysql_real_escape_string($lname);
$sql = UPDATE phonedir SET fname = '$fname',lname = '$lname' WHERE id=$id;
$result = mysql_query($sql);
echo mysql_error() . \n;
This will result in the
On July 11, 2009 10:57:14 am Haig Dedeyan wrote:
At 10:12 PM -0400 7/10/09, Haig Dedeyan wrote:
[1]
$fname = mysql_real_escape_string($fname);
$lname = mysql_real_escape_string($lname);
$sql = UPDATE phonedir SET fname = '$fname',lname = '$lname' WHERE
id=$id; $result =
On Sat, Jul 11, 2009 at 6:39 PM, Haig Dedeyanhdede...@videotron.ca wrote:
On July 11, 2009 10:57:14 am Haig Dedeyan wrote:
At 10:12 PM -0400 7/10/09, Haig Dedeyan wrote:
[1]
$fname = mysql_real_escape_string($fname);
$lname = mysql_real_escape_string($lname);
$sql = UPDATE phonedir SET
2009/7/12 Eddie Drapkin oorza...@gmail.com:
No offense or anything, but all of this work you've done is
immediately mode obsolete the second you switch to prepared
statements. They're easier to use and more secure, as well as making
code more readable. I don't understand why it's so hard for
I have been using PEAR's tableInfo() to remind myself about the
columns in the table.. but now I want to see as much data as possible
about the table and its contents *without* using PEAR. (I.e. just
using built in stuff for mysqli.)
I have been looking through the manuals, even tried
On Sat, Jul 11, 2009 at 19:57, Govindagovinda.webdnat...@gmail.com wrote:
I have been using PEAR's tableInfo() to remind myself about the columns in
the table.. but now I want to see as much data as possible about the table
and its contents *without* using PEAR. (I.e. just using built in
On Sun, Jul 12, 2009 at 4:09 AM, Haig Dedeyan hdede...@videotron.ca wrote:
On July 11, 2009 10:57:14 am Haig Dedeyan wrote:
At 10:12 PM -0400 7/10/09, Haig Dedeyan wrote:
[1]
$fname = mysql_real_escape_string($fname);
$lname = mysql_real_escape_string($lname);
$sql = UPDATE
On July 11, 2009 08:21:34 pm Haig Dedeyan wrote:
On Sun, Jul 12, 2009 at 4:09 AM, Haig Dedeyan hdede...@videotron.ca wrote:
On July 11, 2009 10:57:14 am Haig Dedeyan wrote:
At 10:12 PM -0400 7/10/09, Haig Dedeyan wrote:
[1]
$fname = mysql_real_escape_string($fname);
$lname =
hi guys, i need some help by optimize the performance.
my problem is that i need a lot of rows the whole site (don't ask i need
the rows really :-) )
this is about ~4000 rows it will be loaded from mysql database in 0.3
seconds
my idea was to cache this rows in a xml file like for example:
Chris;
From my understanding of your question, your message (included
below in its entirety) is better sent to the MySQL General list, which
I've CC'd on this reply. If you haven't yet, please subscribe there
at mysql-subscr...@lists.mysql.com to follow the thread for responses.
If
On Fri, Jul 10, 2009 at 12:36 PM, Daniel Browndanbr...@php.net wrote:
Chris;
From my understanding of your question, your message (included
below in its entirety) is better sent to the MySQL General list, which
I've CC'd on this reply. If you haven't yet, please subscribe there
at
hi andrew i think you understand my problem a little,
but if 100 user load this query at the same time, the two mysql server
had a lot to do!
so i think to cache this query as xml to the application server local
make thinks faster,
but, i would like to have the same performance to read this xml
On Fri, Jul 10, 2009 at 12:59, Andrew Ballardaball...@gmail.com wrote:
I understood the question to be how to improve performance by caching
MySQL results into an XML document (which, given that it was posted
here) within a PHP script. Perhaps this is not the correct
interpretation, but if so
On Fri, Jul 10, 2009 at 13:07,
workerho...@studysite.euworkerho...@studysite.eu wrote:
hi andrew i think you understand my problem a little,
but if 100 user load this query at the same time, the two mysql server had a
lot to do!
so i think to cache this query as xml to the application server
hmm, the infrastructure ist good, this is just this query
so to solve my problem i could run mysql on the application server and
store just this table
and read the query from them, it could solve my problem litte, i hope so!
Daniel Brown schrieb:
On Fri, Jul 10, 2009 at 13:07,
On Fri, Jul 10, 2009 at 13:23,
workerho...@studysite.euworkerho...@studysite.eu wrote:
hmm, the infrastructure ist good, this is just this query
so to solve my problem i could run mysql on the application server and store
just this table
and read the query from them, it could solve my
On Fri, Jul 10, 2009 at 1:23 PM,
workerho...@studysite.euworkerho...@studysite.eu wrote:
hmm, the infrastructure ist good, this is just this query
so to solve my problem i could run mysql on the application server and store
just this table
and read the query from them, it could solve my
yes i think i should do this
Daniel Brown schrieb:
On Fri, Jul 10, 2009 at 13:23,
workerho...@studysite.euworkerho...@studysite.eu wrote:
hmm, the infrastructure ist good, this is just this query
so to solve my problem i could run mysql on the application server and store
just this
On Fri, 10 Jul 2009 13:29:31 -0400
Bastien Koert phps...@gmail.com wrote:
On Fri, Jul 10, 2009 at 1:23 PM,
workerho...@studysite.euworkerho...@studysite.eu wrote:
hmm, the infrastructure ist good, this is just this query
so to solve my problem i could run mysql on the application server
workerho...@studysite.eu wrote:
hi andrew i think you understand my problem a little,
but if 100 user load this query at the same time, the two mysql server
had a lot to do!
so i think to cache this query as xml to the application server local
make thinks faster,
but, i would like to have the
first thanks to all who have read ;-)
your solution looks like the method how i done it actually,
i have tested the last hours the solution with sql lite on application
server
the Solution:
3 Mysql Server ( 1 more to handle the big load ) (1 Master, 2 Slaves)
mysql replication
10
On Jul 10, 2009, at 5:25 PM, workerho...@studysite.eu workerho...@studysite.eu
wrote:
first thanks to all who have read ;-)
your solution looks like the method how i done it actually,
i have tested the last hours the solution with sql lite on
application server
the Solution:
3
Hi everyone,
I'm starting to experiment with an edit form and I am seeing the following
behaviour:
$fname = mysql_real_escape_string($fname);
$lname = mysql_real_escape_string($lname);
$sql = UPDATE phonedir SET fname = '$fname',lname = '$lname' WHERE id=$id;
$result = mysql_query($sql);
Haig Dedeyan wrote:
Hi everyone,
I'm starting to experiment with an edit form and I am seeing the following
behaviour:
$fname = mysql_real_escape_string($fname);
$lname = mysql_real_escape_string($lname);
$sql = UPDATE phonedir SET fname = '$fname',lname = '$lname' WHERE id=$id;
$result =
On July 10, 2009 11:26:04 pm Haig Dedeyan wrote:
Haig Dedeyan wrote:
Hi everyone,
I'm starting to experiment with an edit form and I am seeing the
following behaviour:
$fname = mysql_real_escape_string($fname);
$lname = mysql_real_escape_string($lname);
$sql = UPDATE phonedir
Greetings Gurus!
I am attempting to use PHP+MYSQL+APACHE and I have downloaded all the latest
verions and installed them on a fresh windows XP install. Got the Apache
server up and running, got MySQL up and running and installed PHP. Tested
PHP with a script containing phpinfo
On Thu, 2009-06-18 at 22:10 -0400, Shawn Simmons wrote:
Wrote a small script to connect to the MySql database. Tried to run the
script (http://localhost/dbscript.php) and I get a 500 Internal Server
error. I have been up and down the web for two days looking for a solution
and I am
Yarlei.
Programmer PHP, CSS, Java, PostregreSQL;
Today PHP, tomorrow Java, after the world.
Kyou wa PHP, ashita wa Java, sono ato sekai desu.
To: php-general@lists.php.net
From: elcid...@gmail.com
Date: Thu, 18 Jun 2009 22:10:44 -0400
Subject: [PHP] PHP MySQL 500 Internal Error
Greetings
On Thu, Jun 18, 2009 at 22:10, Shawn Simmonselcid...@gmail.com wrote:
Greetings Gurus!
Also, please keep new threads on the list limited to one at a
time, except in extenuating circumstances. And as a developer, there
certainly are and will be more of those circumstances. ;-P
--
/Daniel
Sorry about thatI wasn't sure if it went the first time when I didn't
see the post sfter a refresh8-)
Daniel Brown danbr...@php.net wrote in message
news:ab5568160906190558u1a585cedpf73eb5690330d...@mail.gmail.com...
On Thu, Jun 18, 2009 at 22:10, Shawn Simmonselcid...@gmail.com
I've built a certain system where every time new user enters it creates a
guest row on guests table. he also gets an identifying cookie.
The table contains several fields, one of them is ID which is auto increment
and unique
When he does a certain action it gets recorded in the done_action
Just use SERIAL id and you will be good ;) (that's an alias for something
like BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY)
It shouldn't bother you as long as it works.
On Sat, Jun 13, 2009 at 9:16 PM, דניאל דנון danondan...@gmail.com wrote:
I've built a certain system where every
2009/6/13 דניאל דנון danondan...@gmail.com:
I've built a certain system where every time new user enters it creates a
guest row on guests table. he also gets an identifying cookie.
The table contains several fields, one of them is ID which is auto increment
and unique
When he does a
On Tuesday 02 June 2009 11:36:28 pm optoma...@rogers.com wrote:
Everybody has given Angus really great advice in this previous thread
and I have learned a lot too. I hope no one mines the fork but I am in
the exact same situation as Angus. If anyone could spare a bit of time
regarding
From: Sancar Saran
And if you so much thinking about future DB change. Just wrote
compatible sql
and use multi drive layer (phpADO db).
And you are problem free
I have some questions about this suggestion. We currently have
production systems using Postgres, Sybase ASA, Oracle and MS SQL
Sadly, Mr. Saran wasted a lot of time writing a pluggable backend db layer,
as one is built into PHP now, PDO: http://us2.php.net/pdo
Sybase / MsSQL: http://www.php.net/manual/en/ref.pdo-dblib.php
Postgres: http://us2.php.net/manual/en/ref.pdo-pgsql.php
Oracle:
Everybody has given Angus really great advice in this previous thread
and I have learned a lot too. I hope no one mines the fork but I am in
the exact same situation as Angus. If anyone could spare a bit of time
regarding application infrastructure I would really appreciate it.
I know there
On Tue, Jun 02, 2009 at 04:36:28PM -0400, optoma...@rogers.com wrote:
Everybody has given Angus really great advice in this previous thread
and I have learned a lot too. I hope no one mines the fork but I am in
the exact same situation as Angus. If anyone could spare a bit of time
regarding
High-performance builds of mysql are still faster. And with 5.4 integrating
a lot of performance boosts, I'd expect MySQL to retain that lead for a lot
longer. There's also a lot more guides / support for MySQL around, as well
as having a more robust choosing of UDF's, if you were to need them.
how do I make a permanent connection to mysql database and what is
difference between mysql_connect() and permanent one?
If I make connections in one file and redirect it to another file do
I keep connection (permanent / standard)?
Do I lose connection only when I type mysql_close (permanent/
Hi All
I know this is not strictly a PHP question, but i have a problem whenever i
insert a record using PHP. Basically the auto increment field does not work
at all. Here's the structure of the table that i'm using:
CREATE TABLE `children` (
`cid` int(4) NOT NULL auto_increment,
`cname`
201 - 300 of 3625 matches
Mail list logo