I am writing a content management section for a site that will use as part
of the front page three small sub-sections from another site's home page
(with their permission, of course).
They are worried about giving us the password to their database, where the
information is stored, because we
Which DB? MySQL supports encrypted connections.
On Mon, 25 Nov 2002, Lisi wrote:
I am writing a content management section for a site that will use as part
of the front page three small sub-sections from another site's home page
(with their permission, of course).
They are worried about
I didn't realize that, is this discussed in Paul DuBois' book? Or, can you
point me to the function(s) on the mysql website I need to look at?
Thanks,
-Lisi
At 12:09 AM 11/25/02 -0800, Rasmus Lerdorf wrote:
Which DB? MySQL supports encrypted connections.
On Mon, 25 Nov 2002, Lisi wrote:
I
See php.net/mysql_connect
The client_flags argument is the one you want, so you will need PHP 4.3
for it and MySQL 4.0.x.
-Rasmus
On Mon, 25 Nov 2002, Lisi wrote:
I didn't realize that, is this discussed in Paul DuBois' book? Or, can you
point me to the function(s) on the mysql website I
I checked with phpinfo() and this is what I got:
PHP Version 4.2.2
mysql - Client API version 3.23.51
Is there any secure way to connect using these versions? I am on a virtual
host so there's not much I can do about upgrading. Also, does it matter
which versions the server I am connecting to
On Sun, 24 Nov 2002, Peter Beckman wrote:
Don't forget that you can use the DB to store PHP Sessions as well, which
is faster than storing the sessions in /tmp on the file system. If you
have well written SQL, you can have 5-30 queries per page, most of which
should return the data in under
Quick hack for those who think that the MM handler is not stable
is to use the standard handler and the directory where the session files
will be to be mounted as tmpfs (even /tmp). This will give almost of the
MM's speed
without worrying whether MM is stable or not.
Andrey
- Original
Yup, only MySQL 4.0.x has SSL support. I suppose you could try to set up
some sort of tunnel, but it might not be the most reliable thing in the
world.
On Mon, 25 Nov 2002, Lisi wrote:
I checked with phpinfo() and this is what I got:
PHP Version 4.2.2
mysql - Client API version 3.23.51
Is
OK, then I'll throw this back to the list - any other ideas how I can get
to their data without compromising their DB? I thought maybe about asking
them to set up a separate DB with just the table I need, and sync it to
those table in their main db, but it has to be a solution that involves the
Hi,
why don't you write a script which simply gets all the data you need out of their
database and puts it into some arrays. then include the page on your website and
then you can work with the arrays as if they were on your server
HTH,
Bastian
--
PHP Database Mailing List
I'm using the contents of a table to print an option list in another form to
allow me to cross reference the tables in my data.
? $result = mysql_query(SELECT * FROM category,$db);
printf(select name=\catcode\\n);
while ($myrow = mysql_fetch_array($result)) {
printf(option value=\%s\%s/option\n,
On Monday 25 November 2002 18:03, Lisi wrote:
OK, then I'll throw this back to the list - any other ideas how I can get
to their data without compromising their DB? I thought maybe about asking
them to set up a separate DB with just the table I need, and sync it to
those table in their main
I didn't realize that, is this discussed in Paul DuBois' book? Or, can you
=not book, but books!
=MySQL (New Riders) discusses network access/security in Chap 12, but
Jason's solution is also discussed in Chap 11. Unfortunately this book is
getting a bit old when it comes to these more advanced
Hope it helps a bit
Mike Karthauser wrote:
I'm using the contents of a table to print an option list in another form to
allow me to cross reference the tables in my data.
? $result = mysql_query(SELECT * FROM category,$db);
printf(select name=\catcode\\n);
while ($myrow =
mike karthauser wrote:
Once i have selected from the drop box the variable is submitted back
to my
table and saved.
When re-edit the data - the record already has a value for catcode which i
want to reflect within the drop box - in html it would be the addition of
selected=selected within the
Is it possible to post a message about looking for someone developing php
software?
Thanks
Antonio Bernabei
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hello everybody
Does evrybody know if there is a free version of PDFlib
Thanx
Nikos
Web Monkey lists a few alternatives here:
http://hotwired.lycos.com/webmonkey/02/20/index3a.html?tw=programming
- Original Message -
From: nikos [EMAIL PROTECTED]
To: PHP-mailist [EMAIL PROTECTED]
Sent: Monday, November 25, 2002 7:19 AM
Subject: [PHP-DB] PDFlib
Hello everybody
Does
Hi people,
I dont know why but am stuck trying to debug this problem. I keep
getting error number 1100 (Table 'jobs' was not locked with LOCK TABLES)
from PHP when i try querying a mysql database. It has me stumped because
I am using the LOCK TABLES statement when locking the tables...but maybe
On Monday 25 November 2002 23:19, nikos wrote:
Hello everybody
Does evrybody know if there is a free version of PDFlib
Thanx
Nikos
You have started a new thread by taking an existing posting and replying to
it while you changed the subject.
That is bad, because it breaks threading.
Is this for real? I never knew this either. I almost always send emails to the list by
replying to old ones and changing the subject for new threads. I will remember this in
the future if I create a thread.
I don't imagine Nikos and I are the only two who did not know this. Though I'm sure
the
We do mention it at http://www.php.net/mailing-lists.php
I'll post the mailing list guidelines here as well, as it is good to
remind people every now and then:
* Use a valid email adress. Every new poster's email address is
checked for validity through confirmation.
* Send plain
$SQL = SELECT AU,ST,BT,AT,id FROM ccl.ccl_main
WHERE MATCH (AU)
AGAINST ('\Margaret Atwood\' IN BOOLEAN MODE)
ORDER BY id desc;
When I enclose Margaret Atwood in double quotes, it's like having no quotes at all.
Therefore, it searches for all occurences of Margaret and Atwood.
Any inspiration?
Here is a simple, yet very useful shell script that will automate MySQL
output to open into Excel where you can view it with more control, save it
to a spreadsheet for other coworkers, etc.
I played with this a bit and it's really cool. Bound to save me a lot of
time so I thought I'd share. While
Dear All,
I have question about syntax to make http request and send email
through CLI command
I have script while the sender [Mobile Phone] send sms to my gateway and then if
their request have right result, the gateway will reply back to their
mobile phone, but if the result is
I am having difficulty with the implode function. What I am doing is
building a string for an UPDATE SQL command. At the end of the building
portion of the code, I want to insert a comma between the various fields
that will be updated. However, it is not working. Here is a portion of my
implode accepts an *array* as input, not a string.
you would need to change your $sqlUpdate to be an array, and each statement
look something like;
if($textfield12 != '') { $sqlUpdate[] = textfield12='$textfield12'; }
of course it would probably be easier to just do something like this;
27 matches
Mail list logo