You are all helping me SOOO much! I did manage to download myphpadmin... and by some miracle got through the installation process. It is a pretty slick program although I have no idea what I am looking at. I have learned more in the last 10 hours than I ever thought possible, although I haven't written a line of code besides a simple test to make sure that the PHP server was configured correctly. This stuff looks like it could really turn out to be a ton of fun.
Anyway, So what is the story about mysql... supposing I download a script that requires a mysql database, would I want to configure that on my own machine or configure it on the host computer... this is where things begin to get confusing. I am guessing that I can configure a mysql database from the myphpadmin... and then I just add the fields that I want etc..??? I think I will be hitting Barnes and Noble today so that I can buy that book that Dash recommended... then maybe I will stop pestering all of you. However in the meantime, I am ever so grateful for your kindness in helping me step into this new world. "Cam Dunstan" <[EMAIL PROTECTED]> wrote in message 003801c29179$29737ce0$7866a8c0@camhome">news:003801c29179$29737ce0$7866a8c0@camhome... > hey Joe, > > You ought to try some of those tools for MySQL Dash recommends, there`s some > beauties amongst them, especially phpmyadmin. In the meantime, here is a > little script, quick and dirty that will let you look at a database and > generate some basic queries and forms for you. > Just copy and paste this into a script file, change the $dbase value near > the top of the script to your database name and "run" it, it does nothing to > your database except read it and knock up some php code for you. > > Use it for two things.... > > 1. an object lesson in how NOT to program, avoid the sloppy lazy style, > total lack of comments and abysmal presentation of results. > > 2. Takes a little of the tedium out of keying up a long query or form when > you can`t remember fieldnames etc > > > But remember! you`re a newbie! you mustn`t produce sloppy code with no > comments, no error checking, no indentation and no proper presentation of > results until you`re an expert! > > good luck! > > > > > <?php > > $dbase = "beadace"; > > $db = mysql_connect("localhost", "root"); > > > function friendly_date($mydate){ > // unix or mysql string type datetime to friendly dd/mm/yyyy type date > string > return date("d/m/Y", strtotime($mydate)); > } > > > > > mysql_select_db($dbase,$db); > > $underline = "-"; > for ($m = 0; $m < 60; $m++){ > $underline = $underline."-"; > } > $underline = $underline."<br>\n"; > > $result = mysql_list_tables($dbase); > $rowcount = mysql_num_rows($result); > > > for ($j = 0; $j < $rowcount; $j++){ > $tablenam = mysql_tablename($result, $j); > echo $underline; > echo $tablenam.";"; > > $fieldresult = mysql_list_fields($dbase, $tablenam); > $fieldcount = mysql_num_fields($fieldresult); > echo $fieldcount."<br>\n"; > //echo "<br>"; > > $updatestatement = "\"UPDATE ".$tablenam." SET "; > $insertprefix = "\"INSERT INTO ".$tablenam." ("; > $insertsuffix = " VALUES ("; > $formstatement = ""; > > > for ($k = 0; $k < $fieldcount; $k++){ > > $fieldnam = mysql_field_name($fieldresult, $k); > > if ((strpos($fieldnam, "hoto") > 0) || (strpos($fieldnam, "humbnail") > 0)){ > $fieldnaminsert = $fieldnam."_name"; > } else { > $fieldnaminsert = $fieldnam; > } > > echo " ".$fieldnam.";"; > $fieldtyp = mysql_field_type($fieldresult, $k); > echo $fieldtyp.";"; > $fieldsiz = mysql_field_len($fieldresult, $k); > echo $fieldsiz.";<br>\n"; > > $sep = "\\\""; > if (((strcmp($fieldtyp, "int") ==0)) || ((strcmp($fieldtyp, "real") > ==0))){$sep = ""; } > > $fieldlabel = ucwords(str_replace("_", " ", $fieldnam)); > > if (strcmp($fieldtyp, "datetime") == 0){ > $scriptstatement = "<"."?"."php if ("."$"."addrec == 0){echo > friendly_date($"."myrow[\"".$fieldnam."\"])"."; }"." ?".">"; > } else { > $scriptstatement = "<"."?"."php if ("."$"."addrec == 0){echo > $"."myrow[\"".$fieldnam."\"]"."; }"." ?".">"; > } > > if ($fieldsiz > 64){ > $formstatement = $formstatement.$fieldlabel."<br><textarea cols=\"40\" > rows=\"8\" > name=\"".$fieldnam."\">".$scriptstatement."</textarea><br><br>\n"; > } else { > $formstatement = $formstatement.$fieldlabel." <input type=\"text\" > size=\"".$fieldsiz."\" name=\"".$fieldnam."\" > value=\"".$scriptstatement."\"><br>\n"; > } > > $updatestatement = > $updatestatement.$fieldnam."=".$sep."\".$".$fieldnaminsert.".\"".$sep; > > $insertprefix = $insertprefix.$fieldnam; > $insertsuffix = $insertsuffix.$sep."\".$".$fieldnaminsert.".\"".$sep; > > if ($k < ($fieldcount - 1)){ > $updatestatement = $updatestatement.", "; > $insertprefix = $insertprefix.", "; > $insertsuffix = $insertsuffix.", "; > } > > } > $updatestatement = $updatestatement." WHERE > pin=\\\""."\".$"."pin.\""."\\\"\";"; > echo $updatestatement."<br>\n"; > > $insertstatement = $insertprefix.")".$insertsuffix.")\";"; > echo $insertstatement."<br>\n\n"; > > $formstatement = $formstatement."</form>\n"; > > echo "<p>View Source to inspect FORMS design code.</p>\n"; > > echo "<!--\n"; > echo "<form ENCTYPE=\"multipart/form-data\" name=\"someform\" > action=\"somescript.php\" method=\"POST\">\n"; > echo "<INPUT TYPE=\"hidden\" name=\"MAX_FILE_SIZE\" value=\"1000000\">\n"; > echo $formstatement."<br>\n\n"; > echo "-->\n"; > > } > > ?> > > > > > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
