Help needed in return for crate of beer

[Alex H]

I have some PHP stuff to do for a uni project. Unfortunately i'm crap at it, but then again not likely to use it beyond this re-sit project. If anyone wants to give me a hand with it, can't see it taking too long, I will buy you a crate of beer of your choice.

PM away!

 

[cava83]

cant be arsed to pm,

we need more info,

what's the project and have you started it ?

 

[Alex H]

Basically have to do three things: manipulate some data in a db, dynamically create an xml document and xsl stylesheet and finally create a piechart that uses the data from db.

Apparently pretty easy stuff, load of gobbledegook to me tho

 

[Beef-Mc]

Doesn't seem to bad really.

 

[Alex H]

It wouldn't be if I had any idea how to do it - if anyone wants to have a stab at it, would be very much appreciated and crate of beer would make its way to you (or maybe the pennies then you can pick your own). I have a txt file with the instructions in.

 

[dutch182]

LOL i f**king hate students.

 

[KDF]

Basically have to do three things: manipulate some data in a db, dynamically create an xml document and xsl stylesheet and finally create a piechart that uses the data from db.

Apparently pretty easy stuff, load of gobbledegook to me tho

use mysql db ... piss easy..
xml document dynamically ... piss easy..
piechart from db .. piss easy.. use php and gd library.

 

[KDF]

<?php

# Edit these variables to your settings.
$servername = "your_mysql_server";
$dbuser = "dbuser";
$dbpass =  "dbpass";
$dbname = "databasename";

$link=mysql_connect ("$servername","$dbuser","$dbpass");

if(!$link){die("Could not connect to MySQL");}
mysql_select_db("$dbname",$link) or die ("could not open db".mysql_error());

# now code the stuff to retrieve data from the selected database.

?>

I just wrote this quickly but that should be enough to get you connected to the mysql database, you just need to do the code to retrieve the data depending on the names of your databases/type of data etc.

 

[Alex H]

I've done the database connect thing which I lifted from a book, it's the rest of it I can't do as I've never learnt or been taught it. I thought a crate of beer would have tempted someone, might have to make it two...

 

[KDF]

once you have connected to the database, just issue your mysql statements to modify the data using SELECT, UPDATE and DELETE.

Simple SQL statements will do what you want e.g.

SELECT * FROM table

would select everything.. or

SELECT * FROM table WHERE something='something'

would only select the records where a column (something) has a value of 'something'

there are plenty of examples on the web.

 

[sn00p]

I've done the database connect thing which I lifted from a book, it's the rest of it I can't do as I've never learnt or been taught it. I thought a crate of beer would have tempted someone, might have to make it two...

I think the issue here is that:

1) People can't be arsed to do your homework for you.
2) The people who could do it, won't do it, because you'll not be learning anything!

Post up attempts by all means and I'm sure people will point you in the right direction, it's not difficult what you're trying to do and a few minutes of reading you should be able to make a fair stab at it!

Think of how good it'll feel when you do it for yourself.