Hi !
The How-To is correct, but there is one screen where there also needs to be added
something. I myself is also a newcomer to PHP, and starting of with FreeTrade was
dificult. But reading the code and altering it is eductional and benefitional. It
shuld not be difficult to add fields to item table.
> Shawn I found this in the archives of the mailing list, hope this helps.
> i didn't write it so I can't answer any questions about it. I didn't add
> it to the FAQ because I wasn't sure if it was finished/correct.
>
> -------------
> Hi!
>
>
> OK, Here is the HOW-TO I made. I do have a feeling there is something I
> have
> forgotten, but I can not remember for sure. I hope this one is correct
> now. Please
> notefy me if there are any errors. It is so nice to have next time I need
> to do this.
> I know for sure that the search results screen is forgotten, but that
> shuld be easy to
> do. You must read all files because I am sure there is a small section
> forgotten
> somewhere in one of the screens or something.
>
> Most of the work is just reading the code, adding new lines to the code
> allready
> there.
> I found the project wery educational :-))
>
>
>
> How to add more fields in item table
>
> These fields had to be altered:
> 1. Build.sql
> 2. From /modules/action/ I had to add to
> A. ADD_ITEM
> B. UPDATE_ITEM
> 3 In /modules/screens these 3
> A. item
> B. add_item
> C. admin_item
>
>
>
> 1. Build.sql
> The filds had to be added.
> CREATE TABLE item (
> ID int(11) NOT NULL AUTO_INCREMENT,
> Name varchar(255),
> FirstName varchar(255),#this
> LastName varchar(255), #this
> Title varchar(255), #this
> ReleaseDate date, #and this was added.
>
> 2. From /modules/action/ I had to add to
> A. ADD_ITEM
> B. UPDATE_ITEM
>
> A. In ADD_ITEM I just inserted new fields in insert statment and dublicate
> lines with
> new names for valiues
>
>
> /*
> ** Add item record.
> */
> if ($continueScript) # Added the new field to insert statement
> {
> $Query = "INSERT INTO item (Name, FirstName, LastName, Title,
> ReleaseDate, " .
> "Description, Keywords, Thumbnail, Graphic, LargeGraphic,
> DisplayPrecedence, " .
> "Active) ";
> $Query .= "VALUES (";
> $Query .= "'" . addslashes($inputName) . "', "; #This- all dublicate
> lines
> $Query .= "'" . addslashes($inputFirstName) . "', ";#This
> $Query .= "'" . addslashes($inputLastName) . "', ";#This
> $Query .= "'" . addslashes($inputTitle) . "', ";
> $Query .= "'" . addslashes($inputReleaseDate) . "', ";
>
> B. In UPPDATE_ITEM
>
> /*
> ** Update the item's main information.
> */
> if ($continueScript)
> {
> $Query = "UPDATE item ";
> $Query .= "SET Name='" . addslashes($inputName) . "', "; #This on has
> SET
> $Query .= "FirstName='" . addslashes($inputFirstName) . "', ";#New
> $Query .= "LastName='" . addslashes($inputLastName) . "', ";#New
> $Query .= "Title='" . addslashes($inputTitle) . "', ";#New
> $Query .= "ReleaseDate='" . addslashes($inputReleaseDate) . "', ";#New
>
>
> And in /modules/include I had to add to
>
> A. item_functions
>
> file://Get main item information# Added the new fields to start of select
> statement
> $Query = "SELECT Name, FirstName, LastName, Title, ReleaseDate,
> Description,
> Keywords, Graphic, LargeGraphic, Thumbnail ";
> $Query .= "FROM item ";
> $Query .= "WHERE ID = $Item_ID ";
> $Query .= "AND Active = 'Y'";
> $DatabaseResult = mysql_query($Query, $DatabaseLink);
>
> if(mysql_num_rows($DatabaseResult))
> {
> file://get the row
> $DatabaseRow = mysql_fetch_object($DatabaseResult);
>
> file://put results into array
> $Item["ID"] = $Item_ID;
> $Item["Name"] = $DatabaseRow->Name;
> $Item["FirstName"] = $DatabaseRow->FirstName;# Added
> $Item["LastName"] = $DatabaseRow->LastName;# Added
> $Item["Title"] = $DatabaseRow->Title;# Added
> $Item["ReleaseDate"] = $DatabaseRow->ReleaseDate;# Added
>
> 3 In /modules/screens these 3
>
> A. item
> B. add_item
> C. admin_item
>
> A. item. This screen is displaying the product with Skus and picture, I
> plainly wanted
> to se if I could have it working, so there is no deisgn. But it works...
> And that is
> all I prensently ask :-))
>
>
> if(isset($Item["ID"]))
> {
> /*
> ** Output the item name and description.
> */
> print("<H3>". prepareText($Item["Name"]) . "</H3>\n");
> print("<H3>". ($Item["Title"]) . "</H3>\n"); #New
> print("<H3>". ($Item["ReleaseDate"]) . "</H3>\n"); #New
> if($Item["Graphic"] != "")
>
> And than we have som code regarding pictures, and then:
>
> print($Item["Title"] . "<br>\n"); #New
> print($Item["FirstName"] . "<br>\n");#New
> print($Item["LastName"] . "<br>\n");#New
> print($Item["Description"]);
> print("<BR CLEAR=\"ALL\"><BR>\n");
> And than I have output of new fields!
>
> But first I need to put data into the database
>
> B. Add_item
>
> Notice the odd L_ADDITEM_NAME in first part of code? That is L_ for
> language. Also
> this expose me as lazy.. Cause I just added norwegian words to my new
> fields. Shuld
> have put it in Language file I guess. Cause L_ADDITEM_NAME makes to
> software get the
> proper title in selected language file and outputs normal words. But it
> works anyway.
> I just copy and past first block and changed field name.
>
>
> /* Start the form, and the table that will be used to organize
> everything. */
> print(StartForm("admin_departments", 'post', 'ADD_ITEM', FALSE,
> array("department"=>$department)));
>
> print("<TABLE>\n");
>
> /* Output all of the html form entities. */
> print("<TR><TD>" . L_ADDITEM_NAME . "</TD>\n");
> print("<TD><INPUT TYPE=\"text\" NAME=\"inputName\" SIZE=\"32\" " .
> "VALUE=\"");
> print( isset($inputName) ? prepareText($inputName) : "" );
> print("\"></TD></TR>\n");
>
> print("<TR><TD>" . Fornavn . "</TD>\n");
> print("<TD><INPUT TYPE=\"text\" NAME=\"inputFirstName\" SIZE=\"32\" " .
> "VALUE=\"");
> print( isset($inputFirstName) ? prepareText($inputFirstName) : "" );
> print("\"></TD></TR>\n");
>
> print("<TR><TD>" . Etternavn . "</TD>\n");
> print("<TD><INPUT TYPE=\"text\" NAME=\"inputLastName\" SIZE=\"32\" " .
> "VALUE=\"");
> print( isset($inputLastName) ? prepareText($inputLastName) : "" );
> print("\"></TD></TR>\n");
>
> print("<TR><TD>" . Tittel . "</TD>\n");
> print("<TD><INPUT TYPE=\"text\" NAME=\"inputTitle\" SIZE=\"32\" " .
> "VALUE=\"");
> print( isset($inputTitle) ? prepareText($inputTitle) : "" );
> print("\"></TD></TR>\n");
>
> print("<TR><TD>" . Releasedato . "</TD>\n");
> print("<TD><INPUT TYPE=\"text\" NAME=\"inputReleaseDate\" SIZE=\"32\" "
> .
> "VALUE=\"");
> print( isset($inputReleaseDate) ? prepareText($inputReleaseDate) : "" );
> print("\"></TD></TR>\n");
>
>
> C. admin_item
>
> OK. so now I can go to admin and add a new record. But I also want a
> chance to modefy
> it.
>
> /*
> ** Get the main information for this item.
> */
> if ($continueScript) # get it into start of SELECT statment
> {
> $item = intval($item);
> $Query = "SELECT Name, FirstName, LastName, Title, ReleaseDate,
> Description, " .
> "Keywords,Thumbnail, Graphic, LargeGraphic, DisplayPrecedence, Active
> ";
>
> and also a litle bit further down
>
> else
> {
> $itemName = $DatabaseRow[0];
> $itemFirstName = $DatabaseRow[1]; #new
> $itemLastName = $DatabaseRow[2]; #new
> $itemTitle = $DatabaseRow[3]; #new
> $itemReleaseDate = $DatabaseRow[4]; #new
>
> Just remember to change the numbers in [ ]
>
>
> Good luck!!
> Bjarne Hansen
>
>
> --
> Christie Walker
>
>
>
>
>
>
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Site: http://www.working-dogs.com/freetrade/
> Problems?: [EMAIL PROTECTED]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
