Hello,
Does anyone know a good way of locking out access to a record on a MySQL
database when someone has the update page open?
The problem is that we have a local intranet site which is accessed by
members of different departments. Now at the moment when someone loads the
page all of the data is
I know recently the server was update from PHP 4.3.8
to 4.3.9 but that shouldn't have effected anything.
Code:
$query = "INSERT INTO table1 (ProfileID, LurkID,
ProfileName, Edu,..."
VALUES (null,..."
ProfileID is the PrimaryID (autoinc) - I've set the
input v
--- Stuart Felenstein <[EMAIL PROTECTED]> wrote:
> I know recently the server was update from PHP 4.3.8
> to 4.3.9 but that shouldn't have effected anything.
>
> Code:
>
> $query = "INSERT INTO table1 (ProfileID, LurkID,
> ProfileName, Edu,..."
> VALUES (null,..
--- denys <[EMAIL PROTECTED]> wrote:
> hi!
> what if you try to ignore the primary key in fields
> and values list ?
> MySQL should assign a valid primary key. It's what
> I'm doing on 4.0.22
> and it's working If not, try to echo your query
> and write it in
> MySQL( GUI or console).
>
--- Stuart Felenstein <[EMAIL PROTECTED]> wrote:
One last thing to add on this issue. This table was
created using tabletype InnoDB. Now I discovered
earlier that this table and (many others) had switched
over to MyISAM. I'm still trying to trace down the
cause with my ISP.
Anyway, using a mys
Stuart Felenstein a écrit :
--- Stuart Felenstein <[EMAIL PROTECTED]> wrote:
I know recently the server was update from PHP 4.3.8
to 4.3.9 but that shouldn't have effected anything.
Code:
$query = "INSERT INTO table1 (ProfileID, LurkID,
ProfileName, Edu,..."
VALUES (null,..
To view the terms under which this email is distributed, please go to
http://disclaimer.leedsmet.ac.uk/email.htm
On 29 November 2004 13:19, Stuart Felenstein wrote:
> Now the printout of the query is this:
>
> 0: INSERT INTO Table1 (LurkID, ProfileName, Edu,
> WorkAuth, WorkExp, CarLev, Secu,
--- "Ford, Mike" <[EMAIL PROTECTED]> wrote:
> > 0: INSERT INTO Table1 (LurkID, ProfileName, Edu,
> > WorkAuth, WorkExp, CarLev, Secu, Confi, Relo,
> > Telecomu, City1, State1, City2, State2,
> TravelPref,
> > SalaryAnnual, SalaryHourly, Available) VALUES (47,
> > '', 7, 2, 1015, 5, , '',
When you export a table to excel, is there a way to merge cells and create
borders? I want my excel file to look exactly like my html table looks.
Matthew Perry
Hi guys ,
Maybe this question was posted earlier but I could not find it
I have couple of tables
tblCountry
tblCity
tblStreet
tblUser
I have foreign keys
tblUser.street_FK = tblStreet.street_id
tblStreet.city_FK = tblCity.city_id
tblCity.country_FK = tblCountry.country_id
I have PHP Version 4.3.2
> --- "Ford, Mike" <[EMAIL PROTECTED]> wrote:
> > > 0: INSERT INTO Table1 (LurkID, ProfileName, Edu,
> > > WorkAuth, WorkExp, CarLev, Secu, Confi, Relo,
> > > Telecomu, City1, State1, City2, State2,
> > TravelPref,
> > > SalaryAnnual, SalaryHourly, Available) VALUES (47,
> > > '', 7, 2, 10
--- [EMAIL PROTECTED] wrote:
> > --- "Ford, Mike" <[EMAIL PROTECTED]> wrote:
> Don't know about other database engines, but in
> MySQL, it doesn't matter
> if an int is inserted as a string, i.e., with the
> quotes. My recollection
> is that MySQL handles the type conversion
> internally. So,
Its a tough one. My personal fav is to mark the record as locked by changing
a field called 'locked' from 0 to 1. Check for this when extracting the
record and if is present, alert the user this record is locked (if you want
to get fancy you could even track who locked it and the tell the user t
You would need to access the XL sheet via the COM interface (don't know how
are doing currently) and then work out the macros or commands to pass to the
XL sheet to have it do the things you need.
Bastien
From: "Perry, Matthew (Fire Marshal's Office)" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Su
What version of PHP are you using? Did you develop it on one system
then move it to 'production' and now it doesn't work?
PHP 5 has SQLite functions built into it, but PHP 4 doesn't (I think I
got that right). You may need to make sure your extensions are loading
properly and such.
Is it just
http://dev.mysql.com/doc/mysql/en/Replication.html
Check this page, it might be helpful.
-TG
> -Original Message-
> From: Sadeq Naqashzade [mailto:[EMAIL PROTECTED]
> Sent: Saturday, November 27, 2004 11:51 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Is there any replication service
-Original Message-
>Does anyone know a good way of locking out access to a record on a
>MySQL database when someone has the update page open? The problem is
>that we have a local intranet site which is accessed by members of
>different departments. Now at the moment when someone loads t
-Original Message-
>When you export a table to excel, is there a way to merge cells and
>create borders? I want my excel file to look exactly like my html
>table looks.
>
>Matthew Perry
I've not used it personally, but a route you may want to explore is
PEARs Spreadsheet Excel Writer:
Yeah, all good thoughts. Someone else had a similar question that I
answered recently (I think it was in private email) and in addition to
the thoughts below, you might also look into recording WHEN the record
was opened (and locked) so you can expire the lockout. I'd use this in
conjunction with
You can also do a "Click here to download", send it headers identifying
the the page being loaded as something like "application/Excel" or
whatever the mime type is and pass it HTML. Excel will interpret it and
load the data into cells.
That gets around the whole COM thing.
If you do that, then
how can i force the SID variable in urls not to be &SID=, but &SID ?
_ bobo wieland [EMAIL PROTECTED] __
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I've been playing with PHP 5.0.2 on Red Hat Linux, Apache 2 and Oracle 9i.
I've seen some of the emails on problems with OCI. I've experienced problems
with using both Persistent and non-persistent. Most of the time when I do
saves or selects, it works. Occassionally it can no longer find th
well... in xhtml you HAVE to write & in urls... if I can't do that whats
the point in trying to use xhtml, when it won't work with php anyway?
_bobo wieland _ [EMAIL PROTECTED] _
winamp >> kruder dorfmeister | lamb- trans fatty acid
- Original Message -
From: "Bastien Koert" <[EMAIL PRO
Bobo Wieland wrote:
how can i force the SID variable in urls not to be &SID=, but &SID ?
Who is appending SID to your urls?
You or php??
I currently append SID via code (not automatically by php), and its
working well
with XHTML 1.1.
Otherwise, take a look at this php.ini option ->
; The separat
http://www.php.net/htmlentities
On Monday 29 November 2004 01:03 pm, Bobo Wieland wrote:
> how can i force the SID variable in urls not to be &SID=, but &SID ?
>
>
> _bobo wieland _ [EMAIL PROTECTED] _
> winamp >> various artists | green velvet - the stalker (i'm losing my mind)
--
PHP Database
Section 3.3 of that rfc indicates that ; is reserved in URLs - so I'm
guessing there's another solution.
Obviously you can wrap all your URLs up in a nice CDATA structure - but
that seems ridiculous.
A quick googling perusal confirms what I expected:
http://www.biglist.com/lists/xsl-list/archives
you can't, not allowed
read here http://www.faqs.org/rfcs/rfc1738.html
bastien
From: "Bobo Wieland" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: [PHP-DB] & and sessions
Date: Mon, 29 Nov 2004 20:44:43 +0100
how can i force the SID variable in urls not to be &SID=, but &SID ?
_ bobo wieland
Trying to answer a couple of mails here...
How
exactly are you tacking the SID onto the end of these URLs? If it's
done by php automatically then you shouldn't be having problems at all
at the xhtml level, if you're doing it manually - then manually add
&SID=$wherever_sid_is_stored onto the urls.
you can use .htaccess files to modify php.ini values for a particular
directory.
On Monday 29 November 2004 02:16 pm, Bobo Wieland wrote:
> Trying to answer a couple of mails here...
>
> > How
> >exactly are you tacking the SID onto the end of these URLs? If it's
> >done by php automatically
how can i force the SID variable in urls not to be &SID=, but &SID ?
_bobo wieland _ [EMAIL PROTECTED] _
winamp >> various artists | green velvet - the stalker (i'm losing my mind)
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
-Original Message from: Micah Stevens
[mailto:[EMAIL PROTECTED] -
> you can use .htaccess files to modify php.ini values for a particular
directory.
Yeah, try some of these fun settings!
# Run for 10 days!
php_value max_execution_time = 864000
# suck a gig of ram!
php_value memory_limit
Hi there everyone,
I have written a program in PHP with MySQL as the DB backend, It works great
but I need to be able to connect to a remote MySQL DB server for an Updates
system I’ve written, how do I connect to a remote MySQL server with PHP?
I’ve only ever done it with localhost.
Thanks
Chris,
Same as with localhost, replace localhost with DNS name or IP of the remote
DB server. Make sure port 3306 is open on the DB server and that the box you
are connecting from is an allowed host in the users table of the mysql
database on the remote database.
Neal Carmine
Nine Systems Corpora
instead of 'localhost' use the ip address of the server
bastien
From: "Chris Payne" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: [PHP-DB] Connecting to a remote server?
Date: Mon, 29 Nov 2004 18:09:06 -0500
Hi there everyone,
I have written a program in PHP with MySQL as the DB backend, I
Hi there everyone,
Thanks to everyone helping with connecting to a remote server, works
wonderfully now :-)
I do have a final question, had a look online but couldn’t find what I
needed. It’s hard to explain why, but basically individuals have my program
on their HD, the DB is on their HD
35 matches
Mail list logo