Hello,
What are some programs i can use to create a database
Mario123
Printable View
Hello,
What are some programs i can use to create a database
Mario123
mysql? phpmyadmin
I have tried to download phpmyadmin but some dreamweaver files open up there is no exe or other installation file.
Mario123
i suggest downloading wamp
www.wampserver.com i believe, then you can put your test files in the www folder and access phpmyadmin easier
Thanks
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)
"Veiw.php"(base directory)PHP Code:<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 />
Forms:(base directory)PHP Code:<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>
HTML Code:<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>
your welcome :)
boxer that would work as well but who has the time to code all that when you can just use phpmyadmin :P
...
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.
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.
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).Quote:
for making a web application, a flat file DB is easier to code...
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.
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.Quote:
I was only refering to small scale apps, creating a forum that uses not but a text file is...
idiotic, At best...