[PHP-DB] approaching a relational database
I'm about to embark on a project where I have to enter many, many fields into a MySQL database, and I don't know how to approach the database structure. The data is statistics for a golf course. There are 18 holes, and each hole has a Red Tee Par, White Tee Par, and Blue Tee Par, which is 54 inputs already (18 x 3). Then, there are about 5 more statistics I have to keep for each hole, making the total amount of inputs 144 (18 x 8). There's about 7 more fields pertaining to the Course name, location, etc. How the heck do I approach this? I've successfully done relational databases before, but not to this scale. Does anyone have any suggestions as to how I should approach this? I attached a .jpg of the form I'm using to input, just to clarify things. Any suggestions would be greatly appreciated... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] newbee in PHP-MySQL- help in relational tables
I would say, that MYSQL is a relational database, thus implying that tables would eb relational and this is a DB forum, so just shot, what's the problem? Phanivas Vemuri wrote: > hi, > I need to knwo if anyone had worked on a php interface for relational tables > in MySql. I have a problem , would be explaning the problem after anyone > responds. > Thankyou, > Phani. > > _ > The new MSN 8: advanced junk mail protection and 2 months FREE* > http://join.msn.com/?page=features/junkmail > > -- > 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] newbee in PHP-MySQL- help in relational tables
hi, I need to knwo if anyone had worked on a php interface for relational tables in MySql. I have a problem , would be explaning the problem after anyone responds. Thankyou, Phani. _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Linux+php+remote MS SQL
John, Thank you so much for your response to my post. As I mentioned before, a few things in this project are new to me: remote access, MS SQL and SSL. Your experience gives me more confidence although I still have a lot to learn. I am sure I will need people's help here later on. Thanks again. Thank php-db list too. Ruth - Original Message - From: "John Krewson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, December 14, 2002 3:06 AM Subject: Re: [PHP-DB] Linux+php+remote MS SQL > We are currently running two report generation applications where PHP is > running on Linux machines and queries data from Windows NT servers > running MSSQL 7.0 > > We have reports that deal with millions of records, and whether they run > for 4 minutes or 20, I have only seen robust results from the PHP/MSSQL > combination. (I know, 20 minutes is a long time...I didn't say that all > of my SQL statements were robust (-: ) > > Regarding remote access to SQL server 7, as far as I know the only way > to access SQL Server remotely is from another machine also running SQL > server. From SQL Server Enterprise Manager you can add databases to > access, setting the login properties to either use Windows > authentication or SQL server authentication. SQL Server has great > documentation, their Books Online, and is, I believe, a pretty easy app > to figure out. Remotely you can add databases, change users, run > queries, etc...again the only downside is that you need to be on windows > running SQL Server on the client. I've looked for a remote SQL Server > tool that could run on OSX or Linux, but have not yet found one that > meets all my needs...anyone? > > You asked if your setup will slow down the application. I have to ask, > is the DB server going to be behind a firewall? I'm no networking guru, > but we had some speed issues initially when our DB server was behine the > firewall and the apache server was not. It seemed to me that there was > time spent moving data back and forth, as now that we have both machines > behind the firewall things have speeded up considerably. The real lesson > I learned, however, was to make every connection count, as in get as > much data as possible per query and lean on the Linux box to process, > sort, count, etc if I could rather than getting a small chunk of data, > going back to the DB, etc etc. Considering how easy it is to remotely > administer a Linux machine, it's too bad you can't have it with the DB > machine. > > I'm not quite sure what you mean by your last question regarding PHP's > mssql functions vs. ODBC. I do not and have never used ODBC to connect > PHP to SQL Server, although in our situation I think it would add a > layer of complexity and possibly slow things down a bit, but that's just > a guess. I'm assuming you were asking if using connecting via ODBC is > slower. > > See: > http://www.php.net/manual/en/function.mssql-connect.php > http://www.phpbuilder.net/columns/alberto2919.php3 > > for more specific info regarding setup and mssql libraries. > > Hope this was helpful. Once you get started you should be able to find > plenty of info in the php-db mailing list archive regarding how to make > this setup work. > > > > Ruth Zhai wrote: > > >Hi Everyone, > >I have spent a few hours searching on the internet, but still can not get the information I need. So I turn to you for help. > > > >I will be doing a web site which has a lot of data from a remote mssql server. The scripts will be in php and run on Linux. As requirements, the mssql will stay at the client's internal network, and linux server will be right here with me. For your information, we are considering using broad band connection for the web server although this has not been finalized. The web site will initially have 3000 clients, and the db will be updated on daily basis. For me, this is challenge because this is the first time for me to use remote db server, first time to use mssql server and first time to use combination of open source and MS products. Forgive me if I don't ask proper questions. The followings are my questions: > > > >1. Will this combination cause a lot of problems? Will it be stable enough? > >2. Because the db server is not connected to the internet, I am not sure what options I have in terms of connection to the db. Would some one point me a direction or tutorial about this? > >3. Will remote access slow down the application a lot? > >3. PHP has functions for mssql. Does any one know how those compare with ODBC? > > > >I would appreciate if you could share your experience with me or give me your opinion on the above issues. > > > >Thank you very much in advance. > > > >Ruth > > > > > > > > > -- > 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] RE: copying data
There is a utility called MyAcess it is like MyODBC and I have used it to do
this exact thing. It works very well. I believe you can find it on
Freshmeat.
Thomas G. Knight
[EMAIL PROTECTED]
http://www.slaponline.com
-Original Message-
From: David Eisenhart [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 15, 2002 4:51 AM
To: [EMAIL PROTECTED]
Subject: Re: copying data
If its a 'one off' kind of transfer then i'd recommend that you consider
doing what I did - export the data from Access to text file(s) and then
import from the text file(s) into MySQL (phpMyAdmin is v handy for this lind
of task) {Of course if you want a more automated solution then this is not
the way to go)
David Eisenhart
>
> If I have a microsoft access file .mdb on my server, can I use a php page
> to move the data from the file to a mysql db?
>
> Thanks,
> Eddie
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] OpenSSL, PHP and MySQL
What you need to do is get a merchant account and use a service like authorize.net or something similar to charge credit cards. You send the data over SSL to their servers which charge the account and credit your account and you receive a response back. You don't store the credit card number anywhere and you don't jeopardize your customers accounts. ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ > -Original Message- > From: Joshua Minnie [mailto:[EMAIL PROTECTED]] > Sent: Sunday, December 15, 2002 1:46 PM > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] OpenSSL, PHP and MySQL > > The MySQL db is on the same machine as the website. It has the following > set up on it: > -- > Server Information: > + PHP v. 4.2.3 > + Apache 1.3.26 > + MySQL 3.23.53 > + SSL > -- > Because I don't know much about SSL what would be the best way to get the > client the CC information, since you don't recommend storing it in a db? > So > I know which way to pursue more research on this topic. Thanks for the > help > and direction so far. > > -Josh > > > "John W. Holmes" <[EMAIL PROTECTED]> wrote: > > > My client has a website in which a customer will be purchasing gift > > > certificates online. They don't need a comprehensive e-commerce > > package, > > > just simple information passed across a secure connection, such as: > > user > > > names, passwords, credit cards and mailing addresses. We already have > > a > > > MySQL db set up with the gift certificate "package" information. I > > just > > > need to be able to store the customer information for retrieval later > > by > > > the > > > owners of the site. > > > > So is the MySQL database on a different machine? If it is, and you're > > talking about sending data securely to it, then using MySQL4/PHP4.3 or > > an SSH tunnel like Marco said are your options. If it's on the same > > machine, then you don't have to worry about this. Or are you talking > > about storing it securely, i.e. encrypting it within the database? > > > > Don't take this the wrong way, but unless you really, really know what > > you're doing, please don't store credit card numbers anywhere in your > > system. > > > > ---John W. Holmes... > > > > PHP Architect - A monthly magazine for PHP Professionals. Get your copy > > today. http://www.phparch.com/ > > > > -- > 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
Re: [PHP-DB] OpenSSL, PHP and MySQL
The MySQL db is on the same machine as the website. It has the following set up on it: -- Server Information: + PHP v. 4.2.3 + Apache 1.3.26 + MySQL 3.23.53 + SSL -- Because I don't know much about SSL what would be the best way to get the client the CC information, since you don't recommend storing it in a db? So I know which way to pursue more research on this topic. Thanks for the help and direction so far. -Josh "John W. Holmes" <[EMAIL PROTECTED]> wrote: > > My client has a website in which a customer will be purchasing gift > > certificates online. They don't need a comprehensive e-commerce > package, > > just simple information passed across a secure connection, such as: > user > > names, passwords, credit cards and mailing addresses. We already have > a > > MySQL db set up with the gift certificate "package" information. I > just > > need to be able to store the customer information for retrieval later > by > > the > > owners of the site. > > So is the MySQL database on a different machine? If it is, and you're > talking about sending data securely to it, then using MySQL4/PHP4.3 or > an SSH tunnel like Marco said are your options. If it's on the same > machine, then you don't have to worry about this. Or are you talking > about storing it securely, i.e. encrypting it within the database? > > Don't take this the wrong way, but unless you really, really know what > you're doing, please don't store credit card numbers anywhere in your > system. > > ---John W. Holmes... > > PHP Architect - A monthly magazine for PHP Professionals. Get your copy > today. http://www.phparch.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Beginner problem: let the user select 1 element
Check out: http://www.phpbeginner.com/columns/joel/mysql There are other tutorials there as well for other databases. Also, phpbuilder.com and devshed.net have good tutorials to check out. HTH -Brad [EMAIL PROTECTED] wrote: > Hi, > I have this problem. > I have a db and I want to let the user modify already inputted data: can > any one show me a way to handle this, I think common, problem, maybe by > showing me a tutorial? > Thanks > ANtonio > > -- > 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] From a beginner, how to modify the contents of a table
Sorry for the duplication of this message Hi, does anypne know a tutorial where is described how to let the user update the contents of a table? I thought of 1. the user selects with the help of a form some records (done) 2. these records are shown to the user (done) 3. the user selects the one he wants (??? how can I do it?) Thanks Antonio -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Beginner problem: let the user select 1 element
Hi, I have this problem. I have a db and I want to let the user modify already inputted data: can any one show me a way to handle this, I think common, problem, maybe by showing me a tutorial? Thanks ANtonio -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: copying data
If its a 'one off' kind of transfer then i'd recommend that you consider
doing what I did - export the data from Access to text file(s) and then
import from the text file(s) into MySQL (phpMyAdmin is v handy for this lind
of task) {Of course if you want a more automated solution then this is not
the way to go)
David Eisenhart
>
> If I have a microsoft access file .mdb on my server, can I use a php page
> to move the data from the file to a mysql db?
>
> Thanks,
> Eddie
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: copying data
If its a 'one off' kind of transfer then i'd recommend that you consider
doing what I did - export the data from Access to text file(s) and then
import from the text file(s) into MySQL (phpMyAdmin is v handy for this lind
of task) {Of course if you want a more automated solution then this is not
the way to go)
David Eisenhart
>
> If I have a microsoft access file .mdb on my server, can I use a php page
> to move the data from the file to a mysql db?
>
> Thanks,
> Eddie
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
