Hello,
maybe this is not to be posted here but I am working on this
using PHP and MySQL (one application for travel agencies)
Does someone know how to synchronize automatically two
databasesi have one database running on my server with
static IP and another,
Hi
Take a look at replication
http://www.mysql.com/doc/en/Replication.html
HTH
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
tel. 0121-242-1473
Hello Peter,
nice readinglooks like i need to get binary log with queries that
modified some data...okayand use queries from this log on our
slave databaseokay
mysqlbinlog log-file | mysql -h server_name
i suppose server_name is hostname but what if this hostname
changes (or
Hi
Replication works continuously when the two databases are in contact with
each other, unless you specify otherwise. Likewise, if you connect
periodically, MySql will synchronise the two databases itself.
With replication, MySql logs everything the master does. When a slave logs
in (you can
Hei!
Ühel ilusal päeval [29-10-2002 12:14] kirjutas Martin Hudec:
Hello Peter,
I'm not Peter and i don't know, if i can help, but here is one idea.
I have server of travel agencies records (we need to update this, so
it is slave) with stable IPand then bunch of other computers (from
Hello Juhan,
JK So you can't determine database servers' ip addresses, since they may or
JK may not be dynamic. So don't use the ip address, use hostname and
JK update this hostname every time ip-address changes. You can do it with
JK your own scripts and local host file or you can use public
Hello Peter,
okay :)))so far I understand...buthmmm let me explain
I have server of travel agencies records (we need to update this, so
it is slave) with stable IPand then bunch of other computers (from
these we are updating...so they are all masters) in various travel
Hi
If the records are all independant - ie travel agent (TA) A has their own
records and so does TA B then REPLACE INTO MainDB SELECT * FROM
Travel_agent_A_DB so the main database is just receiveing updated records
from the TAs.
Travel agent logs in to master php driven site .
master php driven
Hello,
see below...
--
Best regards,
Martinmailto:corwin;corwin.sk
Tuesday, October 29, 2002, 10:51:17 AM, you wrote:
PL Hi
PL If the records are all independant - ie travel agent (TA) A has their own
PL records and so does TA B then REPLACE INTO MainDB SELECT *
Hi all,
I have a file I need to insert into a blob in a interbase table. Code as
follows:
$filehandle = fopen($file, r);
$blob_id = ibase_blob_import($filehandle);
$qry = INSERT INTO BPFATTACHMENTS ;
$qry = $qry . (BPFATTACHMENTNO, BPF, ATTACHMENTTYPE, FILENAME,
FILESIZE,
Sir,
Can u pls help in Converting database from MS Access
to MySQL on Linux. Pls send the code for converting.
Bye
Som
__
Do you Yahoo!?
HotJobs - Search new jobs daily now
http://hotjobs.yahoo.com/
--
PHP Database Mailing List
Sir,
Can u pls help in Converting database from MS Access
to MySQL on Linux. Pls send the code for converting.
Bye
Som
__
Do you Yahoo!?
HotJobs - Search new jobs daily now
http://hotjobs.yahoo.com/
--
PHP Database Mailing List
Can u pls help in Converting database from MS Access
to MySQL on Linux. Pls send the code for converting.
http://www.google.com/search?hl=enie=UTF-8oe=UTF-8q=Converting+database+f
rom+MS+Access+to+MySQL+on+Linux
---John Holmes...
--
PHP Database Mailing List (http://www.php.net/)
To
http://www.devhood.com/Tools/tool_details.aspx?tool_id=759
I've been very happy with this tool, and it is well worth the cost.
--Matthew
-Original Message-
From: Soma Shekhar K [mailto:somashekhark;yahoo.com]
Sent: Tuesday, October 29, 2002 6:11 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL
Your SQL query doesn't need that semicolon at the end of the query -- lose
it.
I never used ibase, so here's what I found from the PHP Manual page for
ibase_query:
Using BLOB
Insert BLOB:
/* create blob */
$blob_id = ibase_blob_create();
/* fill blob */
ibase_blob_add($blob_id,
I use this, it has a nag screen but doesn't require any money.
http://www.accessmysql.com/
works as an access plugin, just select an access table, point it to your
mysql db and click a button. easy to use.
-Original Message-
From: Matthew Hildebrand [mailto:gosherm;byu.edu]
Sent:
Hi everyone,
I created a login on my page that handles with a session. I also would like
to add a cookie so that people don't have to sign in every time they visit
my page, but I have no clue how to create it. Is there anyone out there
willing to help?
my login script:
?php
hi there,
i would like to get an image from an web-url and store it into
mysql-db.
inserting local images or images i upload to the server is no
problem, but handling urls as images seems quite difficult..
now, for fopen() i need the filesize() of the image, but that command
does not work on
You don't need filesize().
$fp = fopen('address_to_image','r');
while(!feof($fp))
{ $image .= fread($fp,1); }
Something like that will work...
---John Holmes...
- Original Message -
From: Marcus Fleige [EMAIL PROTECTED]
To: PHP-Mailinglist [EMAIL PROTECTED]
Sent: Tuesday, October
Is defaulting a column to NULL considered as a waste of space??
I have a table that has 2 columns (so far) that defualt to NULL, and
potentially,
there can be good amount of rows with NULL. Just wondering...
--
Gerard Samuel
http://www.trini0.org:81/
http://dev.trini0.org:81/
--
PHP Database
No, I believe all databases have an isnull bit flag to go with any column stored. So
whether you set it or not the bit is being used.
Ryan
-Original Message-
From: Gerard Samuel [mailto:gsam;trini0.org]
Sent: Tuesday, October 29, 2002 9:47 AM
To: php-db
Subject: [PHP-DB] Column
Also note that many databases calculate the maximum allowable rowsize and allocate
that much space whether it's populated or not. This is especially evident when you use
char types verses varchar types. It's actually a good thing in most cases that they
do, since it allows query algorithms to
With MySQL you save a bit by declaring a column not null. If it is null,
you are using a bit. For performance on high volume and high transaction
servers, declaring your columns not null will help, if only slightly.
Peter
On Tue, 29 Oct 2002, Ryan Jameson (USA) wrote:
No, I believe all
I have developed a PHP application that accesses a Microsoft Access database
through ODBC. The application works well using PHP version 4.1. I have
recently installed the newest version of PHP (4.2.3) on another machine
running NT4, and IIS 4.
Again, I am using an ODBC connection, and have given
Matthew Hildebrand [EMAIL PROTECTED] wrote:
http://www.devhood.com/Tools/tool_details.aspx?tool_id=759
I've been very happy with this tool, and it is well worth the cost.
If you are the author of the tool, you want perhaps add a note that the
tool can convert _from_ Access _to_ MySQL on Linux
I think you would have to go a long way to beat DBTools which i might add
is free
and will convert most all db formats msaccess/foxpro/excell/dbf/csv/txt etc
etc to mysql
and also now supports PostgreSQL
http://www.dbtools.com.br
Steven
- Original Message -
From: Michael Mauch
I'm having a problem with session variables and arrays.
I'm building a multi step sign up form and I need to store all the
variable until the final step, when they are inputed to a database. I
thought the best way to do this would be to store the contents for
$HTTP_POST_VARS in session variables.
Hello all,
Platform:
Apache/1.3.20 (Unix)
Redhat 7.2
PHP/4.2.3
Postgres 7.2.1
Summary: periodically, something spazzes out and causes connections to the
database to stop closing at script termination; after a few seconds, the
number of connections to the database exceeds the connection limit for
Hi everyone,
I use a login-script, but for some reason I keep losing my $_SESSION
variables. Can Anyone tell me why?
Here's my login script:
?php
if(isset($_POST['submit'])) { // if form has been submitted
/* check they filled in what they were supposed to and authenticate */
You only need to add session_start() in your script before storing your data
into the $_SESSION array.
Without session_start(), no session is started by php...
Regards,
P.E. Baroiller
Seabird [EMAIL PROTECTED] a écrit dans le message de news:
[EMAIL PROTECTED]
Hi everyone,
I use a
where do I place a session start in a script? before the form? after?
inside?
Jacco
--
http://seabird.jmtech.ca
Attitude is Everything!
But Remember, Attitudes are Contagious!
Is Yours worth Catching
Baroiller Pierre-Emmanuel [EMAIL PROTECTED] wrote in message
turns out, I already have a session_start(). I have some seperate files and
use them as includes. The thing is... my login form is located on my
index.php and if I do a login, only this file will recognize my session
variables.
I load pages external into a layer, but none of them get the session
you don't see them because they are interpreted as HTML tags, they are
unknown, so they are ignored.
options;
1. View - Source
2. Encode all as lt; (HTML version) and it will display it all
as text, then you can copy-paste it to somewhere else
3. Wrap it all in a pre tag, then follow 2.
Does anyone know of speedy methods of periodically archiving and
retrieving a database table? I've got a table I'm using to log
statistical data, and it's getting 10k+ entries per day. Entries are
only logged in the database if the user is authenticated for access, and
only once per access session
Well, can't say I see the same problem:
?php
$_SESSION['foo'] = array(hi=bye);
print_r($_SESSION['foo']);
echo \n\n;
print is_array($_SESSION['foo']);
Outputs:
X-Powered-By: PHP/4.2.2
Content-type: text/html
Array
(
[hi] = bye
)
1
Which is what I'd expect it to show.
Now how did you
Put session_start() somewhere in your code.
$_SESSION isn't set until you start your session.
And don't set session variables by $_SESSION[foo] = bar;
DO this:
$foo = bar;
session_register(foo);
Much better.
However, if anyone can correct me, go for it. I just believe that setting
global
prepend.php gets called before running any page on a site. Put the
session_start() in the prepend.php and you won't have to worry where you
put it.
Learn more about it on the php web site (don't have the url handy).
Peter
On Tue, 29 Oct 2002, Seabird wrote:
turns out, I already have a
Hay guys,
I have two variables ( integers ) that are being minused one from the other
and i am printing the result to the screen but i am getting unwanted
decimals.
print ($eall - $sall) / 1000;
My question is what is the easiest way to strip decimals off the above
result. The only way i know
printf(%d,($eall - $sall) / 1000);
On Wed, 30 Oct 2002, Andrew Wilson wrote:
Hay guys,
I have two variables ( integers ) that are being minused one from the other
and i am printing the result to the screen but i am getting unwanted
decimals.
print ($eall - $sall) / 1000;
My question is
Ok. The categories are coming from checkboxes, e.g.:
input type=checkbox name=categories[] value=1 /Accountantbr /
Which then are handled by a $cgi class dealy and handed to the
$_SESSION['categories'] variable before being forwarded to the next
step. I was thinking that the problem might be
Univates, October, 22, 2002
I've just published the version 3 of Agata Report
=
http://agata.codigolivre.org.br
::: Agata Report is a Report Generator writen in PHP-GTK using Pear:DB.
::: further information at the end of message.
* Currently, Agata has support to English,
41 matches
Mail list logo
