RE: [PHP-DB] Transfering post data to a series of pages.

2005-05-05 Thread Perry, Matthew (Fire Marshal's Office)
After looking at what I wanted to do I see no good reason I can't do most of
what we needed with function calls.  The others can be handled with plugging
more data into my session array.  Somehow I thought this was a poor way of
coding (I don't know why). 
Thank you everyone for your advice!
- Matthew 

-Original Message-
From: Brad Webb [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, May 04, 2005 12:21 PM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Transfering post data to a series of pages.

You may also consider using sessions to store form data.. this allows 
for actual user interaction with the data, back/forward etc... as well 
as tracking and other stuff.. you really should only have "Page1.php", 
and use a logic object to parse the data from there.. IMHO, of course. :)

[EMAIL PROTECTED] wrote:

>Perry, Matthew (Fire Marshal's Office) wrote:
>  
>
>>Is there a way to transfer post data to a series of PHP pages?
>>
>>For example, lets say I have the following 4 pages:
>>Page1.php - this page has my original post form
>>Page2.php - this page does one thing with the post data
>>Page3.php - this page does another thing with the post data
>>Page4.php - this page shows the results of everything I have done
>>
>>Right now I am using the header: 
>>
>>The problem is, the following works:
>>Page1.php - this page has my original post form
>>Page2.php - this page does one thing with the post data
>>Page3.php - this page shows the results of everything I have done
>>
>>But when I try to add the second transfer the data is lost:
>>Page1.php - this page has my original post form
>>Page2.php - this page does one thing with the post data
>>Page3.php - this page does another thing with the post data
>>Page4.php - Only the results from Page2.php are shown
>>
>>ASP does this with <%Server.Transfer ("transferpage1.asp")%>
>>Is there a counterpart with PHP?
>>
>>- Matthew
>>
>>
>
>Martin Norland wrote:
>  
>
>>>include() :P
>>>  
>>>
>
>  
>
>>>seriously though, Page1.php and Page4.php are the only two pages that 
>>>should exist, if any.  Page2 and Page3 should pretty much guaranteed be 
>>>  
>>>
>
>  
>
>>>turned into function calls or classes and called from Page4.php.  You 
>>>don't need to separate logic and display in separate scripts that you 
>>>push everything at, just separate your logic out into function calls.
>>>  
>>>
>
>
>What Martin suggests makes a lot of sense. Can you say something about why 
>you have the site design the way that you do?
>
>David
>  
>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] Transfering post data to a series of pages

2005-05-04 Thread Perry, Matthew (Fire Marshal&#x27;s Office)

Is there a way to transfer post data to a series of PHP pages?

For example, lets say I have the following 4 pages:
Page1.php - this page has my original post form
Page2.php - this page does one thing with the post data
Page3.php - this page does another thing with the post data
Page4.php - this page shows the results of everything I have done

Right now I am using the header: 

The problem is, the following works:
Page1.php - this page has my original post form
Page2.php - this page does one thing with the post data
Page3.php - this page shows the results of everything I have done

But when I try to add the second transfer the data is lost:
Page1.php - this page has my original post form
Page2.php - this page does one thing with the post data
Page3.php - this page does another thing with the post data
Page4.php - Only the results from Page2.php are shown

ASP does this with <%Server.Transfer ("transferpage1.asp")%>
Is there a counterpart with PHP?

- Matthew


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] Exporting pictures to Excel

2005-04-05 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
I am having some difficulties exporting images to excel.

 

I am using the following header:



 

Then I just create a table with my data.  This works beautifully and
generates the file correctly with one exception.

When I include the following HTML in one of the columns:



It only saves the PATH to the image and not the image itself.  When I am
inside the correct directory the image displays.  As soon as I move it
outside this directory it does not display.

 

This makes sense because that is how HTML works.  But what I want to do is
have PHP export the image to excel and insert this image into the file I am
attempting to generate.

Is there a means to insert the actual image into the generated file instead
of the path?

 

Thank you for your time,

Matthew Perry

 



RE: [PHP-DB] grabbing data from other peoples sites

2005-03-17 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
I guess my real question is how to parse the output from someone else's
site.  Setting up the lookup procedure from data in my database and filling
their form with the address is the easy part.  How do I make their form
"submit", parse the output, store it, and then reuse it in another function?
I have never tried something like this before.
- Matthew

-Original Message-
From: Martin Norland [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, March 16, 2005 10:09 AM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] grabbing data from other peoples sites

Perry, Matthew (Fire Marshal's Office) wrote:
[snip]
> What this has to do with PHP
> 
> Is there a way to write some sort of PHP script that accesses to the
county
> auditors website, automatically enters the info into their form, grabs
> whatever information is outputted, imports the data into our SQL Server,
and
> repeats the process for all addresses in our database?
> 
> I will of course research the legality of this before we implement the
> script.  I just wanted to know if this was even feasible before we meet
> about this.  I don't even know where we should start.

Sure, you're just issuing POST requests with data from your database, 
and parsing the output - and entering that extracted data back into your 
database again.  A better question, however, would be how are you 
planning to handle this once you are ready to run it - are you just 
storing the address at each corner of your 'covered regions'?  You'll 
need some kind of fuzzy lookup to be able to do all this.

Maybe a better solution would be to just link directly to the county 
auditors website with instructions, allowing the users to do their 
queries as they're needed?  Even if you have every current covered 
address on file, people may mistype things - new buildings are created - 
roads are renamed, etc.

Someone should contact maps.google.com and see about adding this sort of 
information to that :)

Cheers,
-- 
- Martin Norland, Sys Admin / Database / Web Developer, International 
Outreach x3257
The opinion(s) contained within this email do not necessarily represent 
those of St. Jude Children's Research Hospital.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] grabbing data from other peoples sites

2005-03-16 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
I have searched the archives as it this question has almost assuredly been
asked countless times.

Unfortunately I have no idea what sort of keyword or parameter is applicable
for this topic.

 

History

Here is a brief history of the problem we are trying to solve.  Feel free to
skip this section if you only want to see what this has to do with PHP.

  We need to correlate residents of our county to their local fire
departments.  We receive about 10 calls a day asking this very question and
someone in our office has to literally pick up a map and see find where the
little lines for the fire department end.  The process takes about 10
minutes where it should only take seconds.  We want citizens of Harris
County to enter this information into our web forms instead of calling us.

Our county tax auditors have already done this through a project that costed
millions of taxpayers dollars.  The information is protected and available
under the Open Records Act of 2000.  Unfortunately the Open Records Act does
NOT require any government agency to provide their information in electronic
form or some sort of database dump.  We have requested ALL data about
EVERYTHING they have concerning ANY fire department at ANY location (which
is our right and privilege).  The handed us a huge stack of paper (not
something we can import) with a big invoice (both of which we happily
declined).

  The county auditor's website uses ASP and MS SQL Server to allow people to
enter their address and find out this information.  Unfortunately the
information only makes sense to people who understand the coding scheme!

 

What this has to do with PHP

Is there a way to write some sort of PHP script that accesses to the county
auditors website, automatically enters the info into their form, grabs
whatever information is outputted, imports the data into our SQL Server, and
repeats the process for all addresses in our database?

I will of course research the legality of this before we implement the
script.  I just wanted to know if this was even feasible before we meet
about this.  I don't even know where we should start.

 

- Matthew

 

 

 

 



[PHP-DB] GD with IIS and MS SQL Server

2005-03-07 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
I work with a county office in Houston, Texas and have been forced to use
Windows IIS (on Windows 2000 Server) with MS SQL Server.

They have permitted me to use PHP (instead of ASP) when I showed them
problems on every county ASP site.  

Most applications on IIS are running well including database connections and
all my PHP functions but I am having problems getting GD applets to work.

 

The GD application that I am most interested in outputs a bar code image.
On the Windows Server this image does not appear and there are no error
messages outputted even when the display error messages option is enabled
(at least this is what our IT department claims!)

 

This application works perfectly on my local Apache Server (which runs on my
Windows XP machine).

 

Has anyone attempted to get PHP / MS SQL Server / Windows IIS to work?

If so, have you had similar difficulties when you tried to enable GD?

 

- Matthew



RE: [PHP-DB] Excel headers not working anymore

2005-02-11 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
Wow!
Removing the file that controlled the session array fixed the problem
(suggestion 2).

I was using ssl and session data and would never have guessed it would trip
things up.  I would have stared at this problem for weeks and probably not
have solved the problem.

Also I will change my code to include mailto:[EMAIL PROTECTED] 
Sent: Friday, February 11, 2005 10:47 AM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Excel headers not working anymore

Perry, Matthew (Fire Marshal's Office) wrote:
> Good morning,
> 
> I have been using PHP4.1, Apache, and MySQL for a few years now and have
> never had a problem with my Excel headers.  When I want to output html to
> Excel I place the following on the top of the page:
> 
>  header ("Content-Disposition: attachment" );
> 
> After moving to PHP 4.3, MS SQL Server, Windows 2000 Server I am having
> problems with this header.  I get the message:
> "Internet Explorer cannot download myfile.php from myintranet.net"

1) is your server still configured to recognize "http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] Excel headers not working anymore

2005-02-11 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
Good morning,

I have been using PHP4.1, Apache, and MySQL for a few years now and have
never had a problem with my Excel headers.  When I want to output html to
Excel I place the following on the top of the page:

http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] javascript and php

2005-02-08 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
Hello all,

 

I am having difficulties working with a JavaScript menu that should load on
each page of my intranet site.

 

Here is a brief background of the problem:

1)   I am using PHP and SQL Server and it is running on Windows 2000
Server (yes I know this stinks but I have no choice in my office).

2)   My users first log in.  Login information is saved in the PHP
session array.  This information dynamically adjusts what the users will see
from that point on.  The higher the access level the more "stuff" they can
see.  This should be pretty common.

3)   All of my PHP functions display information correctly based on the
data stored in the session array.  For example, if the user has an
administrative login, SSN and rate of pay are displayed while this data is
not displayed for other employees.

4)   I am using a JavaScript application for my navigation menu.  I
chose this because I need collapsing menus.  There are lots of functions
under each category; if I were to use HTML for the menu, my users would have
to scroll way down to get to where they want to go - especially the ones
still using 800X600 monitor resolution.  A php function calls the JavaScript
menu and changes what is displayed based on the session array data.  

 

Here is the problem:

 My JavaScript menu DOES NOT always display.  It displays about 95% of the
time.  When it displays, it displays correctly (based on the session data).
When it doesn't display, I hit reload and it usually reappears.  What's
worse, it seems to happen randomly!  I could click the same link 10 times
and it will work perfectly.  The 11th time it might not show up.

 

Here is the small amount of information I know about the problem:

I have read through the list server achieves and think the problem may lie
with the fact that Javascript has to run at the Web Browser end and PHP has
to run at Server Side.  This probably explains how it is possible that the
two are not in sync but it does not explain WHY this happens about 5% of the
time.  It also does not explain why it happens only to the JavaScript while
always displaying the results of my php functions.

 

Here are my questions:

1) How can make this menu display 100% of the time?  I realize this may be
hard to answer without looking at all of my code.

2) Should I stop using JavaScript?  If so, what should I use instead that
allows collapsing menus?

 

Thank you for your time,

 

- Matthew Perry

 



RE: [PHP-DB] IIS, PHP, and session data

2005-01-26 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
It turns out that the real problem was problem 1) I am not personally in
control of our web server.
I forwarded some of the posted messages to our IT department and they
decided to change what they were telling me.  They actually had register
globals turned off not on.  I changed my code to use the session array and
it works beautifully now.
Thank you all for your advice!
- Matthew

-Original Message-
From: Simon Rees [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 25, 2005 4:25 PM
To: php-db@lists.php.net
Cc: Perry, Matthew (Fire Marshal's Office)
Subject: Re: [PHP-DB] IIS, PHP, and session data

On Tuesday 25 January 2005 20:20, Perry, Matthew (Fire Marshal's Office) 
wrote:
> I am having trouble with my session data on Microsoft IIS.
>
> Here is a little background of the problem:
>
> 1)   I am not personally in control of our web server.  Our IT
> department manages it.  

oh dear! ;-) 

> They have IIS running on their sever and use MS 
> SQL Server, but they have allowed me to use PHP instead of ASP.
>
> 2)   I have Apache running on a local web server in our office (not
> the IT department).  It accesses the SQL Server database remotely.  I

I can't comment on the use of register_globals or session_register as I 
always use the $_SESSION array but I do use PHP on IIS...
Something that you might like to check is that the directory specified by:

session.save_path

in the IIS server's php.ini is a directory writable by the user that IIS 
masquerades. The default value for this is:

c:\php\sessiondata

which if your sysadmin installed php as Administrator will not be writable 
by the IIS user (normally IUSR_).

Either get the sysadmin to specify (& create) another dir that is writable 
by IIS or change the permissions on c:\php\sessiondata

Assuming you're running Apache on a Linux (and probably other un*x) 
distribution you will find that the session.save_path variable is set 
to /tmp which is usually world writable.

I think if you posted the exact error message it would tell me if this was 
happening to you or not...

hth, Simon

-- 
~~
Simon Rees  | [EMAIL PROTECTED]  |
ORA-03113: end-of-file on communication channel
~~

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] IIS, PHP, and session data

2005-01-25 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
I am having trouble with my session data on Microsoft IIS.

Here is a little background of the problem:

 

1)   I am not personally in control of our web server.  Our IT
department manages it.  They have IIS running on their sever and use MS SQL
Server, but they have allowed me to use PHP instead of ASP.

2)   I have Apache running on a local web server in our office (not the
IT department).  It accesses the SQL Server database remotely.  I have
register_global turned OFF and use the following code on each page: 

session_start();

session_register('logged_in');

session_register('username');

etc...

Everything works PERFECTLY on my local system.

3)   I have ported all of my code to the IIS server location.  It
accesses the database correctly but displays an error message when I try to
use the session data.  It does NOT post messages that the session could not
be started (which is the normal sign of session data not being allowed).
The message says the variable does not exist.  It is as if the session is
started but the variables aren't being saved.

 

The question I have is:

What concerns should I have with PHP sessions when I move from Apache to
IIS?

 

I do NOT need to know how to set up IIS to allow session data correctly
(that's the job of our IT department).  If this sounds like something our IT
department has set up wrong, please do not feel compelled to answer this
question.  I just would appreciate some advice on what I may need to change
in my own code so that it works with IIS instead of Apache.

 

Thank you for your time,

Matthew Perry



[PHP-DB] & terminates string?

2005-01-06 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
I am using PHP 4.3.1 and running Apache Server and MySQL.

The following question is probably only related to PHP.

 

Here is the problem:

 

I am passing the following string from one form to another:

"../create.php?dest=Employee/menu_handleemployee.php?action=update&ID=$ID"

 

Here is the actual code:



 

When I view the source it comes out as expected:



 

But after it goes to the next page it turns into this:

"../create.php?dest=Employee/menu_handleemployee.php?action=update"

Everything up to and after the '&' disappears!!

 

The goal of this code is to send the redirect address to the form that
modifies my data. 

I want variable "dest" to be used to dynamically redirect the page.

 

I have tried the following to fix the problem without avail:

1) I tried saving the variable in other ways such as text fields in the form
itself.

2) I tried addslashes() (which works well with similar problems related to
', " etc.).

3) I tried adding \ before &

4) I danced around my computer and threatened to pull the plug.

None of these worked!

 

 

What is it about '&' that throws everything off with PHP variables?  It
doesn't seem to be a problem with HTML.

This is exceedingly difficult to research online because '&' is excluded
from most search engines automatically.

 

-Matthew

 

 

 



RE: [PHP-DB] NULL VALUE

2005-01-03 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
I apologize for my lack of information concerning this problem and I
appreciate the "advice for beginners".
I also did not mean to post it on this list (If you notice my original
message also contained a thank you for a question never asked in this list).
I am terribly sorry about this error.

HOWEVER: The question can regardless be addressed in this list since it is
not appear to be version or database specific.  I am using MySQL 4.1 but
have experienced the same problem with MS SQL Server.

The issue here is NOT whether STATUS is a keyword.  Yes STATUS is a keyword
and indeed it would probably be wise if I did not use keywords as column
names.  The reason I chose to leave this column named "STATUS" is that it is
linked to other databases (ouch!) and such attempts have proven to cause
even more problems.
But in theory this does not matter.  One can use keywords as column names in
all recent versions of MySQL even though this is unadvised (you have to
search the MySQL site for longer than 5 seconds to learn this).  The problem
exists for all column names.  I have experimented with other test tables
with more standard column names and have had the same result.

mysql_error() or mysqli_error() also do not help here.  Even if you enter
the SQL command directly it posts a result that changes 0 rows and the query
completes without any errors.

I believe this problem lies in how SQL handles NULL values.  Let me change
the column name to avoid the question concerning STATUS as a keyword.

UPDATE EMPLOYEE SET STATUS_lsdkrjg='Inactive' where STATUS != 'Active';
UPDATE EMPLOYEE SET STATUS_lsdkrjg ='Inactive' where STATUS <> 'Active';
UPDATE EMPLOYEE SET STATUS_lsdkrjg ='Inactive' where STATUS IS NULL';
UPDATE EMPLOYEE SET STATUS_lsdkrjg ='Inactive' where STATUS = '';
UPDATE EMPLOYEE SET STATUS_lsdkrjg ='Inactive' where STATUS = NULL;

None of these work to update table "Employee".
According to some of my SQL reference manuals they should!

I have tried the following and had success with one of these options:

create table TEST (
testA varchar(30),
testB varchar(30)
);
insert into TEST values ('a', 'a');
insert into TEST values (NULL, 'a');

+++
| testA  | testB  |
+++
| a  | a  |
| [NULL] | a  |
+++

UPDATE TEST set testA='b' where testA='';
UPDATE TEST set testA='b' where testA<>'a';

+++
| testA  | testB  |
+++
| a  | a  |
| [NULL] | a  |
+++

Finally I tried this:
UPDATE TEST set testA='b' where testA IS NULL;

+++
| testA  | testB  |
+++
| a  | a  |
| b  | a  |
+++

But the last example does not work for ANY fields in my EMPLOYEES table.  I
thought at first the problem might have arisen with the fact that this table
is linked to other databases, but even after I removed the links this
problem exists!

I think the problem still lies with my understanding of NULL.

What am I forgetting about the nature of NULL values?
Why won't the following work for NULL values?
UPDATE TEST set testA='b' where testA='';
UPDATE TEST set testA='b' where testA<>'a';

How is it possible that all NULL values equal any string?

If this question does not belong in this list I will make no additional
postings concerning this topic and will continue researching other sources.

Once again I apologize for the original posting.  It was meant to go to one
of my associates (who also does not know the answer!).

- Matthew





-Original Message-
From: Jochem Maas [mailto:[EMAIL PROTECTED] 
Sent: Monday, January 03, 2005 2:16 PM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] NULL VALUE

Norland, Martin wrote:
>>-Original Message-
>>From: Jochem Maas [mailto:[EMAIL PROTECTED] 
>>Sent: Monday, January 03, 2005 12:16 PM
>>Subject: Re: [PHP-DB] NULL VALUE
>>
>>LightBulbMoment (tm): 5 seconds of searching on the MYSQL site tells
> 
> me 
> 
>>STATUS is a keyword. try either renaming your field or using backticks
> 
> 
>>to escape the name e.g.:
> 
> 
> http://dev.mysql.com/doc/mysql/en/Reserved_words.html doesn't list
> status, although I am familiar with its various forms e.g. "show
> status".

I didn't even go as far looking there I made the assumption that 
mysql was crapping out on 'STATUS' because of its use in 'SHOW STATUS' 
query (and the like) - also its hard to determine whats going wrong with 
someones setup when you have no idea what version of stuff they are 
running - bare in mind we assume the chap (Matthew Perry) in question is 
using MySQL but he did not state this so that may be incorrect.

at any rate dumping the output of mysql_error() or mysqli_error() would 
probably have saved him an email to this list. ;-)

> 
> You're probably right, but I don't exactly see this as a 'clearly
> documented'.  Still, backticking all field names is a good idea anyway.

I didn't mean to say it was clearly documented (IMHO reading & 
understanding 

[PHP-DB] NULL VALUE

2005-01-03 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
My "status" column in my Employee table should have two values "Active" and
"Inactive".  Right now all the active employees have the value "Active" and
the rest have a NULL value.

 

Why is it that the following commands do nothing?

UPDATE EMPLOYEE SET STATUS='Inactive' where STATUS != 'Active';

UPDATE EMPLOYEE SET STATUS='Inactive' where STATUS <> 'Active';

UPDATE EMPLOYEE SET STATUS='Inactive' where STATUS IS NULL';

UPDATE EMPLOYEE SET STATUS='Inactive' where STATUS = '';

UPDATE EMPLOYEE SET STATUS='Inactive' where STATUS = NULL;

 

- Matthew

 

 

 

 

 

 

 



[PHP-DB] get primary key

2004-12-30 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
This one should be easy for most of you.

What is the SQL query to select the column name for the primary key of a
table?

-Matthew



[PHP-DB] to many addresses

2004-12-27 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
We have about 20,000 addresses in our database.  

If my users are filling out a form that requires an address already in our
database I have to make sure they enter it in a format already in the db
(such as "West Road" not "West Rd.").  I have to also allow for new
addresses.

Obviously having a dropdown of 20,000 entries and a second field called
"Other Address Not Here" will not work.

It would also be nice if the field auto fills with suggested addresses from
the database.

Does anyone have advice on how I should do this?  

I have been scratching my head over this problem all morning.

-Matthew

 



RE: [PHP-DB] mysql to access

2004-12-17 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
Here is the problem:

I am currently using MySQL and PHP for this application but have realized
recently that the bulk of my work is setting up three forms (add, view,
modify) for each table I create.  It takes hours for each table with MySQL
and PHP but takes only minutes with Access.  Also, other office
administrators have been trained in Access instead of MySQL and will not be
able to update my tables directly or set up new forms if I only use MySQL
and PHP.

On the other hand, PHP and ASP are easier and more flexible with user
control options.  Also, directly entering SQL can be much more efficient
than using Access's embedded SQL applications.  

I really would like to exploit the advantages of both databases but do not
know the best means by which to do this.  We are creating a standard that
will be followed by everyone in our department and need the best and most
efficient solution possible.  People move around from different positions
constantly and it seems we are making radical changes to our system every
year.  Here are three questions with which I still need help:

1) Would it really make sense to split the data management between two
linked databases (Access and MySQL) or would this just cause problems?
2) If I must use Access, should I use ASP(grrr) instead of PHP?
3) If I must use Access, should I use MS SQL Server(grrr) instead of MySQL?

Thank you all for your time and patience.

- Matthew


-Original Message-
From: Bastien Koert [mailto:[EMAIL PROTECTED] 
Sent: Friday, December 17, 2004 10:01 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] mysql to access

it would depend on what you need the app to do...if you are looking to use 
access to do reporting and/ or act as a front end, then it may be 
feasible...

more details, if you care to share them, may help in this consideration

bastien

>From: "Perry, Matthew (Fire Marshal's Office)" <[EMAIL PROTECTED]>
>To: "Bastien Koert" <[EMAIL PROTECTED]>
>Subject: RE: [PHP-DB] mysql to access
>Date: Fri, 17 Dec 2004 09:59:25 -0600
>
>You mean link the tables?  I haven't yet considered this.
>- Matthew
>
>-Original Message-
>From: Bastien Koert [mailto:[EMAIL PROTECTED]
>Sent: Friday, December 17, 2004 9:42 AM
>To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
>Subject: RE: [PHP-DB] mysql to access
>
>why not just link the mysql to access?
>
>bastien
>
> >From: "Perry, Matthew (Fire Marshal's Office)" 
><[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >Subject: [PHP-DB] mysql to access
> >Date: Fri, 17 Dec 2004 09:33:39 -0600
> >
> >Does anyone know of a FREE program that exports MySQL to access?  The 
>trial
> >versions of the ones I have downloaded do not export all the records of 
>the
> >database.
> >
> >- Matthew
> >
>
>
>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] mysql to access

2004-12-17 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
Does anyone know of a FREE program that exports MySQL to access?  The trial
versions of the ones I have downloaded do not export all the records of the
database.

- Matthew 



[PHP-DB] Excel - merging cells with PHP

2004-11-29 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
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



[PHP-DB] PHP vs ASP

2004-11-15 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
I need some ammo to convince my boss not to use ASP but use PHP instead. 

Anyone have some info I can give him?

- Matthew



[PHP-DB] passing both an anchor and a variable

2004-11-12 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
How do you append both an anchor and a variable to a URL with PHP?

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] MySQL data harvester

2004-11-02 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
My office purchased 21 fascinating cell phones that have GPS locaters and
bar codes.  

 

When we scan a bar code with one of these cell phones, the data is sent to a
third party company; information about this scan is stored on their
database.  

I have installed a "harvester" on my pc that downloads this data off of the
third party database into my own MySQL database.

I want to link this data with my other tables to modify my inventory
information.

 

What is the best way to continuously update all tables when new transactions
occur?  With MS SQL Server or ORACLE I would write a stored procedure or
trigger that could do this.  

What tools can I use with MySQL instead of procedures or triggers?

 

Matthew



[PHP-DB] MySQL backup software

2004-10-27 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
Does anyone know a free MySQL backup program to schedule regular backups?



RE: [PHP-DB] backing up database with mysqldump

2004-10-25 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
 

How do I provide a password?

I have been trying -p password[mypass] mysqldump sampledb >
./backup/file.txt

-Matt

 

  _  

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Monday, October 25, 2004 11:24 AM
To: Perry, Matthew (Fire Marshal's Office)
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] backing up database with mysqldump

 


MySQLdump is an executable program. 
>From the command line: 

C:\>mysqldump databasename > ./path/to/backup/file.sql (or file.txt ) 

C:\>mysqldump --help 

gives all the options 

dave 




 


"Perry, Matthew (Fire Marshal's Office)" <[EMAIL PROTECTED]> 


 


10/25/2004 11:14 AM 


 


 




To: 

[EMAIL PROTECTED] 


cc: 

 


 

 


 

 


Subject: 

[PHP-DB] backing up database with mysqldump




I have attempted to follow the documentation for mysqldump both on mysql.com
and previous emails to this list server.  Unfortunately none of the advice
has helped me successfully backup my database.  I have been spoiled by
phpmyadmin backup procedures and have never had to manually set up a backup
system for a local server.

>From shell> what should I enter tot to backup my database called "sampdb" to
a location "c:/backups"?

Everything I have tried spits out an error message.

-Matt






[PHP-DB] backing up database with mysqldump

2004-10-25 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
I have attempted to follow the documentation for mysqldump both on mysql.com
and previous emails to this list server.  Unfortunately none of the advice
has helped me successfully backup my database.  I have been spoiled by
phpmyadmin backup procedures and have never had to manually set up a backup
system for a local server.

>From shell> what should I enter tot to backup my database called "sampdb" to
a location "c:/backups"?

Everything I have tried spits out an error message.

-Matt



[PHP-DB] imagecreatefromjpeg()

2004-10-22 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
I am using PHP 4.1

 

Why would the php function imagecreatefromjpeg() not be recognized?

 

Fatal error: Call to undefined function: imagecreatefromjpeg() in C:\Program
Files\Apache Group\Apache2\htdocs\Inventory\updateitem.php on line 77

 

-Matthew Perry



RE: [PHP-DB] setting root password

2004-10-19 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
How embarrassing.

Yes I must have accidentally deleted the table.

I reinstalled and it works fine now.

Thank you very much for your help.

 

-Matt

 

  _  

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 19, 2004 11:14 AM
To: Perry, Matthew (Fire Marshal's Office)
Subject: RE: [PHP-DB] setting root password

 


try 

mysql\> use mysql 
  
then 

mysql\>show tables 

is the user table there? 

if not, have you dropped the user table? 

David 




 


"Perry, Matthew (Fire Marshal's Office)" <[EMAIL PROTECTED]> 


 


10/19/2004 11:09 AM 


 


 




To: 

[EMAIL PROTECTED] 


cc: 

 


 

 


 

 


Subject: 

RE: [PHP-DB] setting root password




I entered select user();

It outputs:

---
user()  
[EMAIL PROTECTED]
---

After I enter:
SET PASSWORD FOR [EMAIL PROTECTED]('mypassword');

ERROR 1146: Table mysql.user does not exist.

How is this possible?

- Matt


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 19, 2004 8:37 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] setting root password

Matt,

Is there a space between PASSWORD and the opening parenthesis? There 
shouldn't be, if there is. Otherwise, your statement worked without errors 
for me on MySQL Version 4.0.16.max-nt.

Make sure that you are logged in as root. 

C : \ >select user();

Sometimes MySQL is cryptic about its error messages for security reasons.

dave






"Perry, Matthew (Fire Marshal's Office)" <[EMAIL PROTECTED]>

10/19/2004 08:24 AM





To:
[EMAIL PROTECTED]
cc:





Subject:
RE: [PHP-DB] setting root password





After going to the command prompt I have done exactly this:



c:\>cd C:\mysql\bin

c:\mysql\bin>mysql -uroot -p

mysql>SET PASSWORD FOR [EMAIL PROTECTED]('mypassword');



I get the following familiar message:



You have an error on your SQL syntax.  Check the manual that corresponds 
to
your MySQL server version for the right syntax to use near
'PASSWORD('mypassword')' at line 1



Why does this not set my password correctly?



-Matt

 

 _ 

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Monday, October 18, 2004 1:35 PM
To: [EMAIL PROTECTED]; Perry, Matthew (Fire Marshal's Office)
Subject: Re: [PHP-DB] setting root password




If you haven't yet deleted the localhost root account, you can log onto 
the
mysql client with: 
mysql> mysql -uroot -p 

then press enter again when it prompts you for a password. 

You should now be able to manage all your account info. 

dave 








"Perry, Matthew (Fire Marshal's Office)" <[EMAIL PROTECTED]> 





10/18/2004 01:28 PM 










To: 

[EMAIL PROTECTED] 


cc: 














Subject: 

[PHP-DB] setting root password




I have tried the step-by-step methods listed on mysql.com for setting a 
root
password for my local server but I keep getting the message "you must have
privileges to update tables in the mysql database to be able to change
passwords for others".   What could I be doing incorrectly?

-Matt

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php






RE: [PHP-DB] setting root password

2004-10-19 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
I entered select user();

It outputs:

---
user()  
[EMAIL PROTECTED]
---

After I enter:
SET PASSWORD FOR [EMAIL PROTECTED]('mypassword');

ERROR 1146: Table mysql.user does not exist.

How is this possible?

- Matt


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, October 19, 2004 8:37 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] setting root password

Matt,

Is there a space between PASSWORD and the opening parenthesis? There 
shouldn't be, if there is. Otherwise, your statement worked without errors 
for me on MySQL Version 4.0.16.max-nt.

Make sure that you are logged in as root. 

C : \ >select user();

Sometimes MySQL is cryptic about its error messages for security reasons.

dave






"Perry, Matthew (Fire Marshal's Office)" <[EMAIL PROTECTED]>

10/19/2004 08:24 AM



 

To:
[EMAIL PROTECTED]
cc:





Subject:
RE: [PHP-DB] setting root password



 

After going to the command prompt I have done exactly this:

 

c:\>cd C:\mysql\bin

c:\mysql\bin>mysql -uroot -p

mysql>SET PASSWORD FOR [EMAIL PROTECTED]('mypassword');

 

I get the following familiar message:

 

You have an error on your SQL syntax.  Check the manual that corresponds 
to
your MySQL server version for the right syntax to use near
'PASSWORD('mypassword')' at line 1

 

Why does this not set my password correctly?

 

-Matt

 

  _ 

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Monday, October 18, 2004 1:35 PM
To: [EMAIL PROTECTED]; Perry, Matthew (Fire Marshal's Office)
Subject: Re: [PHP-DB] setting root password

 


If you haven't yet deleted the localhost root account, you can log onto 
the
mysql client with: 
mysql> mysql -uroot -p 

then press enter again when it prompts you for a password. 

You should now be able to manage all your account info. 

dave 





 


"Perry, Matthew (Fire Marshal's Office)" <[EMAIL PROTECTED]> 


 


10/18/2004 01:28 PM 


 


 

 


To: 

[EMAIL PROTECTED] 


cc: 

 


 

 


 

 


Subject: 

[PHP-DB] setting root password




I have tried the step-by-step methods listed on mysql.com for setting a 
root
password for my local server but I keep getting the message "you must have
privileges to update tables in the mysql database to be able to change
passwords for others".   What could I be doing incorrectly?

-Matt

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP-DB] setting root password

2004-10-19 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
 

After going to the command prompt I have done exactly this:

 

c:\>cd C:\mysql\bin

c:\mysql\bin>mysql -uroot -p

mysql>SET PASSWORD FOR [EMAIL PROTECTED]('mypassword');

 

I get the following familiar message:

 

You have an error on your SQL syntax.  Check the manual that corresponds to
your MySQL server version for the right syntax to use near
'PASSWORD('mypassword')' at line 1

 

Why does this not set my password correctly?

 

-Matt

 

  _  

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Monday, October 18, 2004 1:35 PM
To: [EMAIL PROTECTED]; Perry, Matthew (Fire Marshal's Office)
Subject: Re: [PHP-DB] setting root password

 


If you haven't yet deleted the localhost root account, you can log onto the
mysql client with: 
mysql> mysql -uroot -p 

then press enter again when it prompts you for a password. 

You should now be able to manage all your account info. 

dave 





 


"Perry, Matthew (Fire Marshal's Office)" <[EMAIL PROTECTED]> 


 


10/18/2004 01:28 PM 


 


 




To: 

[EMAIL PROTECTED] 


cc: 

 


 

 


 

 


Subject: 

[PHP-DB] setting root password




I have tried the step-by-step methods listed on mysql.com for setting a root
password for my local server but I keep getting the message "you must have
privileges to update tables in the mysql database to be able to change
passwords for others".   What could I be doing incorrectly?

-Matt






[PHP-DB] how many databases should I create

2004-10-18 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
I am developing a variety of different web based systems including
inventory, payroll, incident reports etc.  Should I create a new database
for each project category or one huge database with every table I will ever
use in it?

-Matt



[PHP-DB] setting root password

2004-10-18 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
I have tried the step-by-step methods listed on mysql.com for setting a root
password for my local server but I keep getting the message "you must have
privileges to update tables in the mysql database to be able to change
passwords for others".   What could I be doing incorrectly?

-Matt



[PHP-DB] moving from MS Access

2004-10-15 Thread Perry, Matthew (Fire Marshal&#x27;s Office)
I have finally convinced my office manager to move from Access to MySQL.
Unfortunately the office users are used to Access forms instead of web
forms.  
I have attempted to make my web forms look as much like the Access forms
they are used to but I am not a web designer.  Does anyone know a good
application that can help me with this so I can get away from UI development
back to my DB management?  
I realize this is not a web design list server.

Matthew Perry

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php