2. PHPRunner General questions
  3. What did you use to learn the program
This topic is locked

What did you use to learn the program

 		2/26/2008 10:11:33 PM
PHPRunner General questions
B
 bullet author

I am a newbie and I am trying to learn the program. I have viewed all the video and read the manual. It is not detail. It shows how to do things, but the results or not very clear. I don't explain the action it just shows the actions for the page that it is building. I am having problems with the Lookup Wizard. I think I know what goes in the information area and I test and it is not good.<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=7702&image=1&table=forumtopics' class='bbc_emoticon' alt=':(' /> Is there a place that explains it better? A place in the forum I didn't see. I know it can do what I want to do, but I am to dumb to figure it out.

I am making a listing of businesses that make knives in the USA. I am trying to do this with one table. I was told php can do this in one table, but in this program it may not be able to. What I am trying to do is very easy. I want to have a drop down list of all 50 states. The visitor can pick the state from there. The states are retrieved from a database.

Then I want a list of cities that have knife businesses in them to make a drop down list. This is in the database also.

An example is like this from the drop down list of states the visitor would pick Texas.

Then another drop down list would get all the cities in Texas that have knife businesses and they would be in a drop down list.

From there they choose a city of their choice say Houston. Now in the table that shows on my webpage all the knife businesses in that city will come up and have all the information about the business. Name, address, e-mail,phone, decription, and a picture and all this is coming out of a database with all information in it for each business. That is one part.

I would like vistors to upload pictures of knifes or etc. and they would be added to the database to be shown.

Also if you have a decription or story they can upload one and it would be put in a database to be presented on the website. I have a few other things, but this is the major part of what I want to do. Will I be able to do this with this program. I am in the try phase at the time. If I am able to do this I will purchase the software. I don't what to purchase it and then have to go and learn php out the books.

Any help you can give me would be great. Mainly if I will be able to do this and if there is some more manuals to help me learn this program. I am purchasing it due to not knowing php. I know I will learn as time goes on.

Again Thanks Ron <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=7702&image=2&table=forumtopics' class='bbc_emoticon' alt=':huh:' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=7702&image=3&table=forumtopics' class='bbc_emoticon' alt=':blink:' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=7702&image=4&table=forumtopics' class='bbc_emoticon' alt=':(' />
J
 		Jane 2/27/2008

Ron,
you can do the following:

  1. create dependent dropdown boxes for the states and cities. Create table or view with state and city fields and use add or edit page of this table.

    I recommend you to have a look at the "How to setup dependent dropdown boxes on Edit/Add pages" tutorial:

    http://www.xlinesoft.com/phprunner/php-database.htm
  2. then redirect to the list page after choosing correct state and sity. Use Before record added or Before record updated event on the Events tab.

    Here is a sample:
    if ($values["state"] && $values["city"])

    {

    header("Location: TableName_list.php?state=".$values["state"]."&city=".$values["city"]);

    exit();

    }

    return false;



where state and city are your actual field names.
3. you can add where clause for your main table using URL parameters in the List page: Before SQL query tab event.

Here is a sample:

if ($_REQUEST["state"] && $_REQUEST["city"])

{

$strWhereClause = whereAdd($strWhereClause,"state='".$_REQUEST["state"]."' and city='".$_REQUEST["city"]."'");

}
B
 		bullet author 2/27/2008

How do I need to set up my tables. I was told I can use one table for this. Also. In the demo it shows a it shows catagory catagoryID and catagory name. Do I need all this columns to make it work. I don't know if I have my table setup right. In the demo it shows the lookup wizard and the program and I understand, but it don't show the table or database and I think this is my problems. To the the information I need that is in my first post how do I set up my table or tables.

Thanks
J
 		Jane 2/28/2008

Hi,
you can download and run all PHPRunner live demos on your box:

http://www.xlinesoft.com/phprunner/livedemo4.htm
Also find table structure for all tables used in demos in the livedemo zip.
In regards to this specific issue - you can use one field as link and display field on the "Edit as " settings dialog on the Visual Editor tab.