Frequently Asked Questions (FAQ)* on
CS352 - Spring '12 - Programming Assignment #1

- Q1-5 from previous semesters.
- Last updated on 18.04.12

*Ask your questions to ctoraman(at)cs.bilkent.edu.tr

Question#7: So, are we going to insert "quota" into company table?

Answer: Yes. Change the definition of company table to company(cid: CHAR(8), cname: VARCHAR(20), quota: INT)
Question#6: I can't login into dijkstra's FTP.

Answer: Put your php files into public_html folder that is located in ftp://dijkstra.ug.bcc.bilkent.edu.tr (use a ftp connection program like SHH SecureShell or CuteFTP). Then test your files referring Question#2-(i).
Question#5: I can not test my php correctly on dijkstra server under public_html, because it gives an error like...

Answer: If you ensure that your php code works correctly in your pc, then you do not have to test it on dijsktra. But this is not acceptable for Part 1. Just refer to the answer of Question #3.
Question#4: I get "Error 403" although I give permission rights correctly in dijsktra..

Answer: There is a permission problem with some accounts. We are in talk with BCC for solving it. Nevertheless, you do not have to test your php in dijkstra; because we will grade them in our pc. It is enough for you to test them correctly in your pcs. You need to install php, mysql and a web server(e.g Apache) to work locally. WAMP is a quick solution to install all together.

Question#3: Where will you test and grade my homework?

Answer: You can work on your local pcs, which means you can write localhost to your servers etc. But ensure that your submit-ready code obeys the following items:
Part I: Do not send codes with localhost servers. Be sure that your java code connects to your dijkstra server.

Part II: As assignment suggests, do not write relative links because we will test your php on our public_html. Use your dijkstra address or localhost as server address. In both cases, use your dijkstra username and password.
Question#2: How would I test my PHP files?

Answer: Two options:
(i) Testing globally: Files under your public_html folder(e.g public_html/deneme.php) can be tested via "http://dijkstra.ug.bcc.bilkent.edu.tr/~username/deneme.php"
If you see "Error 403", check your file permissions.

(ii) Testing locally: Use your pc and download a tool like WAMP to install necessary things (php, mysql, apache etc.) public_html folder will be your www folder created by the installation of WAMP etc. Suppose you have "www/deneme.php". Test it via "localhost/deneme.php" in your browser.

I suggest you testing globally in any case..
Question#1: I can not connect dijkstra server on Java.

Answer: Two possible solutions:
(i) Try to connect VPN beforehand..

(ii) Students who already have a dijkstra account from previous semesters will use the old account info to login to dijkstra. For such students, the new account info sent by us this term is only valid for connecting to the MySQL server. Other than such students the new account information can be used to login both the dijkstra and MySQL server.