Jump to content


Photo

need help i dont really know how to do this


  • Please log in to reply
3 replies to this topic

#1 dean012

dean012
  • Members
  • PipPipPip
  • Advanced Member
  • 87 posts

Posted 10 July 2013 - 02:53 AM

1.      Set up a website to display proverbs for people who might be in need of encouragement or wise words. Think about the colours (representing happiness, prosperity, goodness and love etc). Think about an image (lots of cultures – but don’t spend time creating one at this stage).

2.      Create a log in for your friends only (later on they will be able to add proverbs). If you wish use the same password and whisper it to them. This is to enable your friends (whom you should trust) to add to your proverb database whilst protecting your database from outsiders (whom you should distrust).

3.      Use provided data files (proverbs and countries) to set up a database. There are a few ; errors which should be corrected so it will not insert correctly into the database. NOTE: poor basic design eg Scottish listed many times …  don’t worry about correcting this … 62 000 entries would take forever!

4.      Test that your database is working by creating queries such as: (1) view proverbs from a particular country. (2) randomise the proverbs from a particular country but print a limited number eg 1 or 10.
SELECT proverb FROM proverbs WHERE origin = “Scottish” ORDER BY RAND() LIMIT 10;
(3) proverbs about money, love etc.

5.      Connect the database, re-run the queries to check everything is working.

6.      Add two Maori proverbs and delete a proverb. Test by re-running your queries.

7.      Ask two of your select group to sign in and add a proverb.

8.      Comment your code.1.      Set up a website to display proverbs for people who might be in need of encouragement or wise words. Think about the colours (representing happiness, prosperity, goodness and love etc). Think about an image (lots of cultures – but don’t spend time creating one at this stage).

2.      Create a log in for your friends only (later on they will be able to add proverbs). If you wish use the same password and whisper it to them. This is to enable your friends (whom you should trust) to add to your proverb database whilst protecting your database from outsiders (whom you should distrust).

3.      Use provided data files (proverbs and countries) to set up a database. There are a few ; errors which should be corrected so it will not insert correctly into the database. NOTE: poor basic design eg Scottish listed many times …  don’t worry about correcting this … 62 000 entries would take forever!

4.      Test that your database is working by creating queries such as: (1) view proverbs from a particular country. (2) randomise the proverbs from a particular country but print a limited number eg 1 or 10.
SELECT proverb FROM proverbs WHERE origin = “Scottish” ORDER BY RAND() LIMIT 10;
(3) proverbs about money, love etc.

5.      Connect the database, re-run the queries to check everything is working.

6.      Add two Maori proverbs and delete a proverb. Test by re-running your queries.

7.      Ask two of your select group to sign in and add a proverb.

8.      Comment your code.

im stuck from number 2



#2 KevinM1

KevinM1
  • Moderators
  • Snarkimus Prime
  • 5,248 posts
  • LocationNew Hampshire, USA

Posted 10 July 2013 - 03:37 AM

Yeah... we don't answer homework questions.
Using 'global' is a sign of doing it wrong

#3 Maq

Maq
  • Administrators
  • Advanced Member
  • 9,410 posts
  • LocationPennsylvania, USA

Posted 11 July 2013 - 10:45 PM

Good luck with that.


tjmothy
ini_set ("display_errors", "1");
error_reporting(E_ALL);

#4 jcbones

jcbones
  • Gurus
  • Advanced Member
  • 2,653 posts
  • LocationNorth Carolina

Posted 11 July 2013 - 11:41 PM

I answer homework questions WHEN there has been an effort put forth, and you are stuck on a CODING issue.  I'm not going to do it for you.  If you are stuck at basic if/else statements, you should hit up the instructor. There is an obvious breakdown in your classroom instruction. 






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users