Anyone here familiar with PHP+MySQL?

Community forum for discussions completely unrelated to MediaMonkey.

Moderator: Gurus

Mizery_Made
Posts: 2283
Joined: Tue Aug 29, 2006 1:09 pm
Location: Kansas City, Missouri, United States

Anyone here familiar with PHP+MySQL?

Post by Mizery_Made »

Perhaps not the best place to be asking, as this isn't a Web Development forum, but I figured there may be someone around these parts that has a clue what they're doing when it comes to web pages and databases. I've been attempting to read up on the both of them for some time now, but am honestly not making much progress. I believe I've made more headway on the PHP front however, as I've been able to incorporate it into a couple projects of mine to solve a few simple problems.

I've been working on a project for some time now, a "Discography" (or perhaps "Songography" would be more appropriate) that started with one artist that has now expanded to a few others on the same label. I've been using XML files to store the information (a file for each artist), and given the artists often work together or appear on others' songs together, it has resulted in a lot of duplicated information as well as some inconsistencies in artist names and whatnot. That's why I've begun looking toward PHP+MySQL as an alternative to XML+XSL, hoping to cut down on the amount of duplicated information (seeing as the same song could be linked to one... or all of the artists, and still only need one entry) and spelling inconsistencies and such (since each artist would only need one entry, and not have to be typed for each song, etc).

Though as I previously indicated, I have yet to fully grasp the knowledge needed to make such a move. Especially when it comes to trying to sit down and design the database to hold the information. I have some general ideas as to how it should look, but every time I sit down to try and hammer out the details... I end up just sitting there scratching my head. Even if I were to manage to get that all set up, I imagine I would still have a little trouble on the PHP side, when it comes to interacting with said database.

That's why I'm seeking someone who actually knows what they're doing when it comes to messing with both of these. Hoping they may be able to provide some tips, point me in the right direction, or may be willing to take a more hands-on approach to trying to help me on this project.

If you're someone that knows a thing or two and may be able to help, or are just curious as to the project I'm working on, you can see the current XML+XSL solution here: StrangeMusicHQ, there you can get a sense of the needed layout of the page, as well as the current storage structure (via View Source to see the XML information). If anyone can and is willing to offer help (in whatever form), it would be greatly appreciated. If not, then I still appreciate you taking the time to give this a read through. :)

Thanks,
Mizery_Made
trixmoto
Posts: 10023
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Re: Anyone here familiar with PHP+MySQL?

Post by trixmoto »

My website is written in PHP+MySQL so I've probably got the skills you need. I don't really have any spare time at the moment, but I may be able to give you a few pointers.
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
Peke
Posts: 18773
Joined: Tue Jun 10, 2003 7:21 pm
Location: Earth
Contact:

Re: Anyone here familiar with PHP+MySQL?

Post by Peke »

My suggestions would be:
http://www.blumentals.net/webuilder/order.php
http://www.navicat.com/en/buynow/store.html Non-commercial (Individual) If you only want MySQL than go with that version
and free http://www.apachefriends.org/en/xampp.html

That is all you will ever need for you and your work with PHP, MySQL, CSS
Best regards,
Peke
MediaMonkey Team lead QA/Tech Support guru
Admin of Free MediaMonkey addon Site HappyMonkeying
Image
Image
Image
How to attach PICTURE/SCREENSHOTS to forum posts
Lowlander
Posts: 59914
Joined: Sat Sep 06, 2003 5:53 pm

Re: Anyone here familiar with PHP+MySQL?

Post by Lowlander »

You might also like this as reference: http://w3schools.com/
oldtimer
Posts: 146
Joined: Wed May 02, 2007 5:49 pm

Re: Anyone here familiar with PHP+MySQL?

Post by oldtimer »

php/mySQL is a good way to go. I took a course at a local community college. That will get you up to enough speed to do what you want. Here you are taking a one column text file and uploading it to a 1 column table Cancer_types.

<body>
<?php
$lines = file($_SERVER['DOCUMENT_ROOT'].'/Mard/cancers.txt');
$count=0;
connect();
foreach ($lines as $lineNum => $data) {
$sql='INSERT INTO Cancer_types(Cancer_name) VALUES ("'.$data.'")';
//echo $sql.'<BR>';
$result = mysql_query($sql); //add this line after you know the sql is correct!
$count++;
}//each name in file
echo $count.' records read
';
?>
</body>
Post Reply