mga pare, can you help me... suggest naman kayo kung ano ok na gamitin na language,
i want to make an enrollment system plus a database ng mga students at the same time database na rin ng mga grades nila then gusto ko din i print yung report ng grades nile
anong mgandang gamitin na database and coding language para dito. mejo iwan talaga ako pag dating sa application and database coz im more of a web design person pero kelangan kasi sa work.
thanks a lot.
ASP.NET/C# and SQL SERVER 2005!
hmmm.. any language that you are comfortable would do.
i suggest you start small but dream big. what i would do in this case is think about how i envision that application to be used. if you are thinking of exposing this application on the web then use asp.net. if you are thinking of using this app as an internal only application then you can use asp.net, winforms or wpf. i suggest that you pick asp.net so you can open your application for extensibility.
once you've decided on what to use the next step is to build some basic facilities of your application like membership and roles for user authentication. then once that is done, start prioritizing which modules you want to build first.
hth
DJ_Mikey: mga pare, can you help me... suggest naman kayo kung ano ok na gamitin na language, i want to make an enrollment system plus a database ng mga students at the same time database na rin ng mga grades nila then gusto ko din i print yung report ng grades nile anong mgandang gamitin na database and coding language para dito. mejo iwan talaga ako pag dating sa application and database coz im more of a web design person pero kelangan kasi sa work. thanks a lot.
If you're time constrained, choose the language that you're most comfortable with just like Keith said. It seems to me that you're doing freelancing? If so, learn PHP and MySQL.
Convert limitations to great expectations... You are the creative force of your life...
given that you're a web design person...easiest is to slide into PHP. of course other languages and platforms are OK (some can even be better, albeit more difficult to learn...YMMV!)
lamia:If you're time constrained, choose the language that you're most comfortable with just like Keith said. It seems to me that you're doing freelancing? If so, learn PHP and MySQL.
is it really that flexible to use php and mysql? ano options ko dun for printing? kasi ciempre kelangan automated na yung pag print ng grades or print ng subject list per student.
at the simplest level you can print the HTML output (similar to web sites' "Printer-Friendly" pages), or you can completely control the print layout by dynamically creating a PDF file and having it printed by a browser with a PDF reader (Adobe Acrobat, or Foxit Reader). yakang-yaka ng PHP yan...
cruizer: at the simplest level you can print the HTML output (similar to web sites' "Printer-Friendly" pages), or you can completely control the print layout by dynamically creating a PDF file and having it printed by a browser with a PDF reader (Adobe Acrobat, or Foxit Reader). yakang-yaka ng PHP yan...
echo "Korek!";
nope not really doing a freelance job. my boss asked me if i could do it for the school im working in right now. can u believe that they don't have any system working here??? anyway, im not really fluent with php in terms of programming is concern. i kinda need help in connecting to my database. im thinking of using a local host. im using easyphp as a virtual server, i think it will do the trick. can you help me lamia. a script to connect me to my database. thanks
DJ_Mikey: lamia:If you're time constrained, choose the language that you're most comfortable with just like Keith said. It seems to me that you're doing freelancing? If so, learn PHP and MySQL. nope not really doing a freelance job. my boss asked me if i could do it for the school im working in right now. can u believe that they don't have any system working here??? anyway, im not really fluent with php in terms of programming is concern. i kinda need help in connecting to my database. im thinking of using a local host. im using easyphp as a virtual server, i think it will do the trick. can you help me lamia. a script to connect me to my database. thanks
I see. I would've recommended using xampp instead, it's pretty good for development. Here's a snippet of how you could connect to your database
<?phpmysql_connect("localhost", "admin", "1admin") or die(mysql_error());echo "Connected to MySQL<br />";?>Where "localhost" is the location of your MySQL server, "admin" is the username and "1admin" is the password. Did you happen to specify a password for your MySQLdatabase?
lamia:I see. I would've recommended using xampp instead, it's pretty good for development. Here's a snippet of how you could connect to your database
Dude, im done connecting to my database. im currently studying some tutorials on php/mysql. can you recommend a site? and gulo kasi nung iba eh. hindi ko masakyan. and one more thing, code na rin bro para makapag insert sa database. thanks sensei.
DJ, marunong ka na ba mag SQL? If not, I highly suggest you read about it. Here's a nice tutorial though pang Oracle sya pero applicable naman sa SQL in general, it helped me learn SQL years back: http://www.dbbm.fiocruz.br/class/Lecture/d17/sql/jhoffman/sqltut.html
Then, may basic knowledge ka na ng SQL SELECT, INSERT, UPDATE at DELETE, basahin mo na lang yun MySQL section ng PHP manual sa www.php.net/docs.php. Masusundan mo na yan.
chong, ok na ko sa sql... nakaka pag basic na ko ng select insert update and delete. my prob is, paano ko lalagay na variable yung user input na galing sa html form? meron na kong front end... simple na name and student number muna na ittype sa textbox. kaya lang hindi ko sya ma incorporate sa basic sql statement ko... any help or tuts na pwede basahin? thanks. or pakitype na lang. ok yung site ng tutorial na binigay mo bout sa basic sql... thanks again.
with PHP, form data is put in the $_GET or $_POST hash/array. It depends on the form submission method. For example you may have markup like this:
<form action="myscript.php" method="POST"> Your Name: <input type="text" name="myname" size="50" maxlength="100" /> <input type="submit" value="Go!" /></form>
when that markup gets rendered, it'll show a text box with a button labeled "Go!" beside it. Whatever you type in the text box will get sent to the myscript.php script when you press the "Go!" button. Inside the processing logic for myscript.php, the name typed in the text box will be placed in the $_POST['myname'] variable, since 'myname' is the name of the HTML text box control.
dude paano mag lagay ng multiple items sa isang variable. im thinking of doing an if statement checking the string length of the input my user will put in. dapat kasi hindi blanko yung isang 3 field. heres my line:
$number = $_POST["number"]; $len = strlen($number); if ($len > 0)
{
}
gusto ko sana hindi lang number yung ichcheck nya