1. Prestashop 1.6 Tutorial
2. Prestashop
3. Banner Manager Prestashop Tutorials

Universal Banner Manager is a powerful banner manager for your websites. It handles unlimited number of banners, allows to sell banner spots directly to advertisers. Il prodotto Hosting d WordPress Banners Tutorial. Adding a banner to the footer is basically the same with one small difference. PrestaShop Hosting; WooCommerce Hosting.

Using the Banner Manager within osCommerce allows an administrator to manage existing banners, add new banners or delete unwanted ones. The managing portion of the interface includes being able to view the banners outside of the store interface, view existing banner statistics and edit the details of the saved banner. The following tutorial describes these sections and how to use or view them in the osCommerce Administrator dashboard.

Viewing and Editing Banners in osCommerce

Editing banners in osCommerce allows you to change organizational information or change HTML text if the banner consists of text entered within the Banner Manager interface. The edit option does not allow you to edit the graphical appearance of a banner. You would need to edit the graphic file in a graphics program to accomplish that type of edit.

Using the Edit Option in the Banner Manager

1. Log into your osCommerce Admin dashboard.
2. Move your mouse pointer to the left side of the screen and then scroll down until you find the TOOLS button. Click on this button and the menu will expand.
3. Click on the BANNER MANAGER to open the interface.
4. When you click on the Banner Manager option in the menu, you will see the table listing any existing any banners. Note that to the right of the table you will see a bar graph indicating the active banner's views and banner clicks. Click on the row for a banner that you wish to view/manage.
5. After you select the row for the banner you wish to edit, look over to the far right of the table and click on the EDIT button.
6. Clicking on EDIT will bring up the same options displayed when you add a new banner. They include the fields for Banner Title, Banner URL, Banner Group, Image, Image Target (Save to), HTMl Text, Schedule At, and Expires On. Each of these options are detailed in the table below:
   

   Option	Description
   Banner Title	Add banner name here - this is a required field
   Banner URL	URL used if the banner is clicked by a website visitor
   Banner Group	Select an existing group, or create banner groups to organize multiple banners
   Image	Click the Browse to use this interface to upload a banner image. You can also use a URL location for the image
   Image Target (Save To)	Define where the banner file will be saved
   HTML Text	You can use text instead of a graphic file for the banner. The banner can also be formatted using HTML. Note that if you have text defined here, it will override an existing image as the text has priority.
   Scheduled At	Schedule when a banner appears by placing a date here.
   Expires On	You can also define when a banner expires by scheduling it in this field.

7. Click on SAVE in the bottom right hand corner if you need to save any changes. Click on this option now in order to return to the main edit view. Note that a green bar will appear in the top of the screen confirming the save. Next we will focus on viewing the banner and the statistics available with the interface.

Viewing the Banner and Banner Statistics

1. Click on the button to the left of the banner name in the table (see screenshot at right). This will display the banner by itself without the storefront interface. Notice that the banner is displayed in a separate window. Additionally, this button displays the line graph and chart for the banner viewing statistics. The options to get to this view of the statistics information are redundant because it can also be accessed in the DETAILS button at the far right as well as the left icon in the ACTION column of the title. Close the window displaying the banner by itself, then click on the back button in your browser to return to the previous menu. Or, go the menu on the left and return to the Banner Manager in the Tools section.
2. Scroll over to the ACTION column in the table listing the banners. Click on the right icon for another banner. This will enable the display of the bar graph for that banner on the far right. If you have only one banner then it will already be showing the banner views and clicks in the bar graph at right. The bar graph will also be titled with your banner name. The triangular icon indicates that the banner is displayed at right (the icon is pointing to the right). The other icon resembles a lower case 'i' inside a circle. Click on DETAILS to go back to the line graph displayed earlier.
3. Note that when you are viewing the daily statistics you can change the type, month and year in the top right corner. The Type includes daily, monthly, and yearly views of the data. The chart below it shows the data per month in terms of views and clicks.
4. Click on the BACK button in the bottom right hand corner to return to the Banner Manager view.

This concludes the tutorial on managing banners using the Banner Manager interface. If you are looking for information on adding a new banner or deleting/disabling banners in osCommerce, please go to the following articles:

Prestashop 1.6 Tutorial

In our previous set of articles, we've created a simple 2 page website that allows users to submit comments about the page they were looking at. In this article, we're going to show you how to use PHP to Connect to and Retrieve Data from MySQL.

Step 1. Create our SQL Query to grab all comments

In order to display comments on a page, we first need to know what comments to show. When we setup our site we created two pages, and each page was assigned a unique id number. This ID number will be used to gather comments for that specific page. For example, when the user is on page 1, we'll select all of the comments in the database assigned to page '1'.

If you're not familiar with SQL, you can use phpMyAdmin to help write your SQL command. To do this:

1. Log into cPanel and click the phpMyAdmin icon
2. In the left menu, first click your database name and then click the table to work with. If you're following our example, we'll first click on '_mysite' and then 'comments'.
3. Click 'Search' in the top menu
4. Enter 1 for the 'Value' of 'articleid' and then click 'Go'
   
5. After running the search, phpMyAdmin will show you all comments that belong to article 1, as well as the SQL syntax you can use to select those comments. The code provided is:
   SELECT * FROM `comments` WHERE `articleid` =1 LIMIT 0 , 30

Step 2. Setting up our PHP code to SELECT our comments

Note that mysqli_fetch_array was deprecated in PHP versions below 7.0. As of 7.0, the code has been removed and replaced with mysqli_fetch-array.

Now that we have our sample SQL query, we can use it to create the php code that will print all comments on a page. Below is the example code that we created. If you're not familiar with php, any line that begins with a // is a comment, and comments are used by developers to document their code. In our example, we have quite a few comments to help explain what the code is doing, but keep in mind that most scripts do not have as many comments.

As stated earlier, we purposely include many comments to help explain what the code was doing. While the example code above looks like a lot of work, if we strip out all of the comments, the code looks more like:

Step 3. Placing our php code into our pages

We now have our php code that will display comments to the screen. In a previous article, we explained how to use php's include function to reuse code, and we will continue to use this method to use our php code.

To incorporate our php code:

1. Create a file named display_comments.php
2. Paste in the sample code above
3. Update both page1.php and page2.php to include display_comments.php by using: towards the bottom of the page where you want to display comments.

Prestashop

After performing the steps above, our page1.php file now looks like this:

Banner Manager Prestashop Tutorials

After testing our two pages, you can see that each page shows only the comments that were added to that particular page: