View Full Version : What are some programs i can use to create a database?
Mario123
03-04-2007, 02:44 PM
Hello,
What are some programs i can use to create a database
Mario123
Demonicman
03-04-2007, 02:48 PM
mysql? phpmyadmin
Mario123
03-04-2007, 03:01 PM
I have tried to download phpmyadmin but some dreamweaver files open up there is no exe or other installation file.
Mario123
Demonicman
03-04-2007, 03:08 PM
i suggest downloading wamp
www.wampserver.com i believe, then you can put your test files in the www folder and access phpmyadmin easier
Mario123
03-04-2007, 03:09 PM
Thanks
boxxertrumps
03-04-2007, 03:12 PM
phpmyadmin is only a php module that manages mysql...(Meaning, its only a set of php files.)
i rarely use an SQL DB.
I prefer flat file DB myself..
Ive found there's less code involved and they only en=mploy php or whatever other server side language you want.
For example, my comment system.
"Submit.php"(includes directory)
<hr /><?php
if ($_POST['opt'] == "sub") {
$bad = array("#","|");
$gtlt = array("<",">");
$ampcode = array("<",">");
$name = $_POST['name'];
$mail = $_POST['mail'];
$text = $_POST['text'];
if ($name == "") {echo "Name Required.";}
else {
$name = str_replace($bad , " " , $name);
$mail = str_replace($bad , " " , $mail);
$text = str_replace($bad , " " , $text);
$all = $name ."|". $mail ."|". $text ."\r\n";
$fin = stripslashes(str_replace($gtlt , $ampcode , $all));
$prev = file_get_contents("comment.txt");
if ($prev == "") {
$combined = $fin;
} else {
$exploded = explode("#", $prev);
$done = array_merge(array($fin), $exploded);
$combined = implode("#", $done);
};
$handle = fopen("comment.txt","w+");
fwrite($handle , $combined);
fclose($handle);
echo "Comment Posted.";
};
} elseif (($_POST['opt'] == "del") && ($_POST['pass'] == "mod password")) {
if ($_POST['num'] == "wipe") {
$handle = fopen("comment.txt","w");
fclose($handle);
echo "Deleted.";
} else {
$delnum = $_POST['num'];
$contents = file_get_contents("comment.txt");
$contents = explode("#" , $contents);
unset($contents[$delnum]);
$towrite = implode("#" , $contents);
$handle = fopen("comment.txt","w+");
fwrite($handle , $towrite);
fclose($handle);
echo "Comment ". $delnum ." Deleted.";
};
} else {echo "Invalid Option.";};
?><hr />
"Veiw.php"(base directory)
<div style="width:400px;margin:0 auto;">
<a href="URL To Forms...">Post A Comment</a>
<?php
$full = file_get_contents("includes/comment.txt");
$ready = explode("#", $full);
$count = "0";
while (($count >= "0") && ($count <= count($ready)-1)) {
echo "<hr />";
$set = explode("|", $ready[$count]);
echo $count ." - ". $set['1'] ." <b>". $set['0'] ."</b>\r\n";
echo "<div>". $set['2'] ."</div>\r\n";
$count++; };
?></div>
Forms:(base directory)
<h4>Add A Comment</h4>
<form action="includes/submit.php" method="post">
<div><input type="hidden" name="opt" value="sub" />
Name:<input type="text" name="name" /><br />
Title:<input type="text" name="mail" /><br />
Entry:<textarea name="text" rows="10" cols="40"></textarea>
<br />
<input type="submit" value="submit" /></div></form>
<hr />
<h4>Delete A Comment</h4>(Disregard This, Moderates Comments)
<form action="includes/submit.php" method="post">
<div><input type="hidden" name="opt" value="del" />
Number:<input type="text" name="num" />
Password:<input type="text" name="pass" />
<input type="submit" value="submit" /></div></form>
Demonicman
03-04-2007, 03:22 PM
your welcome :)
boxer that would work as well but who has the time to code all that when you can just use phpmyadmin :P
boxxertrumps
03-04-2007, 03:52 PM
...
for making a web application, a flat file DB is easier to code...
You cant use phpmyadmin to create webapps... only the SQL code that the apps use.
And that took me less than an hour to code, test, and implement.
mburt
03-04-2007, 04:03 PM
Also, if you want to manage your own database with your own program, you don't have to mess with any kind of manager, or program download. I find that writing my own scripts for viewing/editing/updating databases are much easier.
for making a web application, a flat file DB is easier to code...Until you have to do something remotely complex. Then you find yourself essentially implementing a SQL server. Let's not forget the performance hit, too. All in all, you're much better off with a real SQL server (or even just with sqlite).
All SQL implementations of which I know come with a client that allows one to enter queries directly. These are quite sufficient for creating databases.
boxxertrumps
03-04-2007, 04:51 PM
I was only refering to small scale apps, creating a forum that uses not but a text file is...
idiotic, At best...
mburt
03-04-2007, 04:59 PM
I was only refering to small scale apps, creating a forum that uses not but a text file is...
idiotic, At best...
Definitely. If you want your users to be able to update/change their posts or whatever, doing so with a flat file would be nearly impossible.
Powered by vBulletin® Version 4.2.2 Copyright © 2021 vBulletin Solutions, Inc. All rights reserved.