Ok. The categories are coming from checkboxes, e.g.:
Accountant
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 with the $cgi object, but
when I print_r($_SESSION['cate
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 ques
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 a
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 sess
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
glob
Well, can't say I see the same problem:
"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 assign categories?
Maybe the var
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
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 < (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 tag, then follow 2.
4.
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
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
news:20021030002059.9083.qmai
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 login
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:
please fill in the required
fields.
';
}
// authenticate.
if(!get_magic_quotes_gp
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
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. T
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" <[E
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 L
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 th
First off, cookie documentation:
http://www.php.net/manual/en/function.setcookie.php
Second, since you store your info in the DB, it might be easier and more
scalable to use a "$user" object which contains everything about the user:
userID, username, email, etc. for quick reference:
$user = m
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, Po
This should be useful, mysql-wise:
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Optimisation.html#Data_size
Declare columns to be NOT NULL if possible. It makes everything faster
and you save one bit per column. Note that if you really need NULL in
your application
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 datab
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 be
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 Defu
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
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, O
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 url
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:
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: Tuesd
Oops... my mistake. I gave the wrong link. Here's the correct link:
http://www.devhood.com/Tools/tool_details.aspx?tool_id=758
--Matthew
-Original Message-
From: 1LT John W. Holmes [mailto:holmes072000@;charter.net]
Sent: Tuesday, October 29, 2002 8:44 AM
To: Matthew Hildebrand
Subject:
Hello,
i am creating script which will make select and desc to table and
then based on results it will make xml file...all is okay, but on my
IE it takes it as xml file (it is okay) BUT on my screen I dont see
any of tags...how can i override that?
script is here:
header("Content-type
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, $var_datablob);
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 PROTEC
> 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=en&ie=UTF-8&oe=UTF-8&q=Converting+database+f
rom+MS+Access+to+MySQL+on+Linux
---John Holmes...
--
PHP Database Mailing List (http://www.php.net/)
To u
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 (http://www.p
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 (http://www.php
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, ATT
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,
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
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 s
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 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
agencies...
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 hav
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 IP).
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,
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, from
45 matches
Mail list logo
