So, if you want to use MySQL, create yourself a database and some tables with the fields you like in phpMyAdmin, then connect PHP to the database.
If you download a PHP script that requires MySQL support, you'll likely have to tell it what host, user and password MySQL requires. Depending on the size of the script (i.e. one file or 200... etc) it will be in the file or (most likely) an include file. As for installing the calendar (two messages down...), just open up the install.php file in a web browser (i.e. if you put the calendar in htdocs\calendar, you'll call up http://localhost/calendar/install.php). That should do the trick. Glad you're learning stuff. Just don't let that brain explode... -Dash Time flies like an arrow Fruit flies like a banana On Thu, 21 Nov 2002, Joe Finlinson wrote: > 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 > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
