Joomla Hosting BLOG

Blog about Joomla, Technologies and Hosting Service

Joomla Hosting - ASPHostPortal.com :: Move away from These 3 Joomla Plugin

clock October 27, 2016 10:31 by author ben

According to Anjelina Sharma (web developer) article, Joomla, to put it simply, is a great fit for ecommerce stores. It is an easy-to-use ecommerce store. This is perhaps the main reason why it has succeeded in the ecommerce front. You know that internet users have very little patience. Ecommerce buyers, on the other hand, have no patience at all when it comes to accessing whatever they want to access. An ecommerce business is a lucrative career choice, but only if you're able to steer it in the right direction. Convenience is key. Convenience is at the heart of initial success tasted by you. Convenience is what your consumers want. Your products might be terrific but don't expect too many buyers if you don't have equally convenient payment options as well. Your customers would want to pay right through your site and not their e-mail and wait till you receive it after which they can send the order back. The whole exercise is time-consuming and your customers cannot really wait for so much to happen. They want everything fast.

So, as an ecommerce entrepreneur, irrespective of whatever you are selling (food, clothes, books, shoes, accessories etc) you need to ensure that your services are backed by an effective shopping cart. Today, we are going to zero in on the best Joomla shopping cart extensions for entrepreneurs. Selecting the right extension is equally important as choosing the right Joomla website template. So, here we go.

Eshop: Ease of use wins again

One of the primary reasons why this particular extension has succeeded is because of its ease of use. It is extremely easy to use and adjust. Troubleshooting (whenever needed) is easy. You can access their customer support service and they will definitely help you with your needs. The core features of this cart extension are meant to make your site work to its optimal potential:

  • More than ten shipping methods
  • Single page checkout
  • Automatic image resizing
  • More than 20 payment gateways
  • The presence of standard Joomla toolbars, groups, layouts (all very easy to access)
  • Wish list products
  • Different tax rates based on geo zones

J2Store: Bolsters functionality in more ways than what you can imagine

The greatest attribute of this particular feature is that even its free versions offer you great functionality. You can showcase or organize your products beautifully with its help.

There is scope to put unlimited products to the fore. The items can be showcased with the right zoom effect. Don't miss out on the pro-support documentation as well. Both physical and downloadable goods can be sold.

JooCmmerce: What you need to find out about this one

The feature set offered by this one is quite powerful. Once again, it is very easy to use and is backed by the following remarkable attributes:

  • GPL License
  • Paypal integrated
  • Stripe Integrated
  • Country Filtering
  • Great internalization
  • Shipping
  • Great tax management console

It is extremely important for ecommerce entrepreneurs to find out about these plugins so as to shore up user experience.

Best Joomla Hosting Recommendation

ASPHostPortal.com provides our customers with Plesk Panel, one of the most popular and stable control panels for Windows hosting, as free. You could also see the latest .NET framework, a crazy amount of functionality as well as Large disk space, bandwidth, MSSQL databases and more. All those give people the convenience to build up a powerful site in Windows server. We offer Joomla hosting starts from $5/month only. We also guarantee 30 days’ money back and guarantee 99.9% uptime. If you need a reliable affordable Joomla Hosting, we should be your best choice



Joomla Hosting - ASPHostPortal.com :: Joomla installation on Plesk server, getting permissions

clock October 26, 2016 08:05 by author Armend

In this post I will explain about joomla installation, Installing Joomla on a Plesk server has it's problems with permissions. I think this gives a nice solution The steps are:

  • Add the ‘apache’ user to the ‘psacln’ group by editing /etc/group

    i.e. psacln:x:_hidden(dont actually change this field!)_:apache

  • Change the current directory permissions with:

    cd /home/httpd/vhosts/[domain.com]
    chown -R [username]:psacln httpdocs
    chmod -R g+w httpdocs

  • Find httpdocs -type d -exec chmod g+s {} \;
  • This set the setuid bit on each of the directories
  • Reload the apache settings with /etc/init.d/httpd reload
  • If you are using proftp to upload files or the new joomla 1.5 ftp layer then change the umask for proftpd by editing ‘/etc/proftpd.conf’ to read Umask 002
  • Otherwise change the umask that php uses. The easiest, but I guess least elegant way is to add the line <?php umask (0002); ?> to the top of the administrator template index.php file. In Joomla 1.5 this is "administrator/templates/khepri/index.php"

Joomla also complains about some PHP settings, sometimes including not being able to write to ‘/var/lib/php/session’. To fix the issues, make some adjustments to the vhost.conf for the domain:

<Directory /home/httpd/vhosts/[domain]/httpdocs>
php_admin_flag magic_quotes_gpc on
php_admin_flag display_errors on
php_admin_value session.save_path /tmp
</Directory>

If the vhost.conf is brand new, then run:

/usr/local/psa/admin/bin/websrvmng -av

Make sure Apache runs with your new configuration:

# httpd -t (check your work)
# /etc/init.d/httpd reload

Best Joomla Hosting Recommendation

ASPHostPortal.com provides our customers with Plesk Panel, one of the most popular and stable control panels for Windows hosting, as free. You could also see the latest .NET framework, a crazy amount of functionality as well as Large disk space, bandwidth, MSSQL databases and more. All those give people the convenience to build up a powerful site in Windows server. We offer Joomla hosting starts from $5/month only. We also guarantee 30 days’ money back and guarantee 99.9% uptime. If you need a reliable affordable Joomla Hosting, we should be your best choice



ASPHostPortal.com Announces Docker Hosting Solution

clock October 25, 2016 09:16 by author ben

ASPHostPortal.com is a web hosting provider dedicated to providing high quality Docker hosting at an affordable price. We care for the clients, ensuring each and every client is more than just satisfied day in and day out. We only use the best hardware, super fast network, covered by 24/7 Support Team. We have 12 world class data centers, located on 12 different countries. Each of locations will provide with amazing performance. Today, we offer high quality Docker hosting at cheap rate.

Docker is the world’s leading software containerization platform. Docker enables developers and IT admins to build, ship and run any application, anywhere. Docker's commercial solutions provide an out of the box CaaS environment that gives IT Ops teams security and control over their environment, while enabling developers to build applications in a self service way. With a clear separation of concerns and robust tooling, organizations are able to innovate faster, reduce costs and ensure security.

Docker gives teams the choice to leverage any infrastructure whether in the cloud, on VMs or baremetal servers allowing companies to make the best business decision for them. Docker containers spin up and down in seconds, making it easy to scale application services to satisfy peak customer demand, and then reduce running containers when demand ebbs.

ASPHostPortal.com offers Docker Hosting with expert team support. We offer Docker hosting with affordable price, a lot of features, 99.99% uptime guarantee, 24/7 support, and 30 days money back guarantee. We strive to make sure that all customers have the finest web-hosting experience as possible. To learn more about our Docker Hosting, please visit http://asphostportal.com/Docker-Hosting.aspx

About ASPHostPortal.com:
ASPHostPortal.com is The Best, Cheap and Recommended ASP.NET & Linux Hosting. ASPHostPortal.com has ability to support the latest Microsoft, ASP.NET, and Linux technology, such as: such as: WebMatrix, Web Deploy, Visual Studio, Latest ASP.NET Version, Latest ASP.NET MVC Version, Silverlight and Visual Studio Light Switch, Latest MySql version, Latest PHPMyAdmin, Support PHP, etc. Their service includes shared hosting, reseller hosting, and Sharepoint hosting, with speciality in ASP.NET, SQL Server, and Linux solutions. Protection, trustworthiness, and performance are at the core of hosting operations to make certain every website and software hosted is so secured and performs at the best possible level.



Joomla Hosting - ASPHostPortal.com :: 4 Functional Web Designed Tools in Joomla

clock October 20, 2016 11:44 by author ben

According to Jason Roiz (Joomla Programmer) article, A content management system is software that acts like a library keeping track of all the content on a website. It includes simple text, photos, music videos, or documents. CMS does not need any special technical skill and any one can use it. Joomla is a CMS used for creating online applications and websites.

Joomla is known to be easy to use and extensible; that is the reason which makes it the most popular website available. Joomla also happens to be an open source which makes it available to all. Joomla uses PHP language and has My SQL as its database.

Uses

Joomla Customization has a huge scope as a Content Management System. It is used to enhance websites all over the world including: Corporate Websites or portals,Corporate Intranets and extranets, online magazines, newspapers, and publications, e-commerce and online reservations, government applications, small business web sites, non-profit and organizational websites, community-based portals, school and church portals and personal homepage.

Advantages to look forward

Joomla Customization powers up portal from corporate websites to homepages. It is used in applications dealing with e-commerce storefronts, community portals, e-magazines and Image galleries. Joomla gives an affordable alternative to website designing. The features of Content Management System, page caching, RSS feed, Printable versions are developed by Joomla. It keeps all the data in centralized database. Joomla becomes interactive and powerful due to the third party plug ins. Joomla creates search engine friendly URLs and site structure. Joomla has a text editor akin to a Word Pad that makes it easy for a layman to edit the web content.

Easy to build a website


It is easy to create a website if you use Joomla. Joomla is easy to install or set up even by a new user. There is plenty of Webs hosting services you can use to click 'install' and get Joomla activated. Joomla offers the simplicity and speed of setting up websites for clients. The clients can then be given instructions by Joomla programmers on how to manage their own sites. Clients can even apply for specialized functionality as several extensible are available in the Joomla Extensions Directory.

The reason to use Joomla

Joomla is easy to use and pick up by those who do not have technical expertise. With Joomla you can design an attractive website within no time. Joomla's easy usability makes it convenient to produce a functional website. Follow a few steps that will get Joomla activated: You need to log on to the administrator section and then add the content - text, photos or files. Click on Administrator and enter your username and password and work with the backend of the site.

Joomla programmers find the functionality factor of this CMS very useful. There is no end to the functions that you can add to Joomla and expand its functionality. For Joomla users there are plenty of forums offering support. Avail of programmers at affordable rates if you would like to outsource your web designing to professionals.

Best Joomla Hosting Recommendation

ASPHostPortal.com provides our customers with Plesk Panel, one of the most popular and stable control panels for Windows hosting, as free. You could also see the latest .NET framework, a crazy amount of functionality as well as Large disk space, bandwidth, MSSQL databases and more. All those give people the convenience to build up a powerful site in Windows server. We offer Joomla hosting starts from $5/month only. We also guarantee 30 days’ money back and guarantee 99.9% uptime. If you need a reliable affordable Joomla Hosting, we should be your best choice.



ASPHostPortal.com Announces Drupal 8.2 Hosting Solution

clock October 11, 2016 19:49 by author ben

ASPHostPortal.com was established on the goal to provide high quality hosting services for everyone. We care for the clients, ensuring each and every client is more than just satisfied day in and day out. Our company is passionate about hosting and strive to deliver an excellent level of service to each customer. Now, we offer reliable Drupal 8.2 hosting with good server performance.

Drupal 8.2 is a minor version (feature release) of Drupal 8 and is ready for use on production sites. This minor release provides new improvements and functionality without breaking backward compatibility (BC) for public APIs. Note that there may be changes in internal APIs and experimental modules that require updates to contributed and custom modules and themes per Drupal core's backwards compatibility and experimental module policies.

Place Block is the new Drupal 8.2.x feature allows the user to place a block on any page and see the region where it will be displayed, without having to navigate to a backend administration form.

ASPHostPortal.com is set up with an aim to serve customers in an excellent manner by providing them quality service. We offer Drupal 8.2 hosting with affordable price, a lot of features, 99.99% uptime guarantee, 24/7 support, and 30 days money back guarantee. We strive to make sure that all customers have the finest web-hosting experience as possible. To learn more about our Drupal 8.2 Hosting, please visit http://asphostportal.com/Drupal-Hosting.aspx

About ASPHostPortal.com:
ASPHostPortal.com is The Best, Cheap and Recommended ASP.NET & Linux Hosting. ASPHostPortal.com has ability to support the latest Microsoft, ASP.NET, and Linux technology, such as: such as: WebMatrix, Web Deploy, Visual Studio, Latest ASP.NET Version, Latest ASP.NET MVC Version, Silverlight and Visual Studio Light Switch, Latest MySql version, Latest PHPMyAdmin, Support PHP, etc. Their service includes shared hosting, reseller hosting, and Sharepoint hosting, with speciality in ASP.NET, SQL Server, and Linux solutions. Protection, trustworthiness, and performance are at the core of hosting operations to make certain every website and software hosted is so secured and performs at the best possible level.



Joomla Hosting - ASPHostPortal.com :: Boost Your site's SEO score with sh404SEF

clock October 7, 2016 00:45 by author ben

If you think, that is enough to build a nice site with a great content to have lots of visitors flowing to your site you're wrong. There are millions of webmasters trying to do the same. And Google and other search engines simply can't find, index and sort all of these sites, and show them to your potential visitors. So you need to do a little more to help these search engines - and to help yourself!

You have chosen Joomla - and that's great, you have one of most search engine friendly CMS-es under your fingertips. But you need to do some more small steps to reach the search engines first 3 result pages for your potential clients. One of most important things you should do is to unleash the SEO capabilities of Joomla, then add the best SEF component written for it, the sh404SEF, and tweak it to become a preferred target of search engines.

You already can see a big improvement - and also some weak points of the native Joomla SEO engine:

  • No Title Tag Support – You cannot customize your title (in Joomla 1.5) or you have very limited tools to do it (in Joomla 1.7+).
  • You cannot customize the Meta Description per page, or you can do it on Joomla 1.7 only per menu item level.
  • Joomla, as any other CMS-es is plagued by multiple URL's problem - the different URL parameters used to control the site's behavior and look are ending up on multiple URL's pointing to the same content. And you cannot point these duplicate URL's to one URL
  • URL’s cannot be customized
  • Sitemaps are not built in
  • NON Existent built in 404 pages on pre-Joomla 1.7 versions, and on newer Joomla sites these 404 error pages aren't customizable, and are offering as little as a link back to your home and another one to let users contact you.

And this is only the tip of the iceberg. Even with spectacular advances in Joomla native SEO, you still need a pro-level tool to address the above issues and do even more tweaks. and here enters in the scene sh404SEF, our preferred Joomla SEO component. BTW, it's not the ONLY one. It's just simply the best ;). Let's see how we can maximize the benefits of using it!

Steps to be done

Enabling Joomla SEO

  • In Joomla backend go to “Global configuration”
  • On the right hand side in SEO Settings options you will see three options, you will need to change 2 of them
    • Select yes for “search engine friendly URLs”
    • Select yes for “use Apache mod_rewrite”
  • Leave “add suffix to URLs” at no
  • Grab your preferred FTP client, log in to the site, locate in WEBROOT the file named htaccess.txt, rename it to .htaccess

with these simple steps you have enabled the built in Joomla SEO engine.
Adding the sh404SEF component to the mix

I know, it's a commercial component. But, believe me, worth every penny you will spending on it. Purchase it, download it, and install it as any other Joomla component. There are no special tricks there.

Configuring the sh404SEF component it's a bit trickier, we highly recommend doing only one setting at time, then check the result, see if the outcome is what you expected, roll back or fine-tune if needed. The component is terrific, you have an arsenal of high impact SEO tools. Fortunately most of them are unleashed out of the box.

  • Go to the menu item labeled “components” and click on the SH404sef component
  • On the right, on the Quick Start pane you have couple of options. Change these to YES:
    • Enable URL optimization
    • Enable remote configuration
  • From the dropdown below select the value "with .htaccess (mod_rewrite)
  • Hit the Save button below

You just launched your missiles: the sh404SEF engine is up and running. Clear your cache, and go to the frontpage to see the results. If everything is OK, the go back to the sh404SEF's main interface, the fun just begins.

Configuration tab

  • On the left, select the tab Configuration, then from the icons you will see click on “sh404sef configuration”
  • ON this page you will see quite a few options and we are going to cover a basic Joomla install SEO setup
  • Choose yes on the radio button labeled “Enabled”
  • Next scroll down and make sure file suffix is “.html”
  • below that choose “index.html” as your default index file
  • Choose a 404 page on the next row. On install sh404SEF probably created and preselected his default 404 error page, and you are ready to go with. But later you might want to go back and create your own, customized error page in your articles manager. Something like this. Can be very useful - and fun - when someone lands on your website and the page is no longer available

The rest of settings can be leaved out for now, the defaults are generally the recommendable ones. But let's note couple of interesting things.

Advanced Tab

  • Activate Url Cache should be set to yes and will help with page load times. But it's highly recommended to change this setting to YES only when you finished your tweaks, and you are ready to launch your site with new settings. Otherwhise you might see some misleading results.
  • If you are using Linux and you did the basic out of the box Joomla seo setup, then you should stick with the above settings, and keep the drop down selected at “with .htaccess (mod_rewrite)". If you are on a windows platform then you will need to choose one of the other two. Test either one out until it works right. I cant say for sure unless I know exactly what type of configuration your host has for the IIS env.
  • It's recommended also to choose yes for the “301 redirect from non-sef to sef URL” this option is pretty much a safe guard against duplicate content and it makes sure your URLs are all re-written
  • Choose yes for “301 redirect from JOOMLA SEF to sh404SEF” Same explanation as the last point except this will convert the ‘OUT OF THE BOX JOOMLA SEF URLs” to SH404SEF URLs. Did i confuse you?
  • Choose yes for “301 redirect www/non-www”. This is very important. You need to decide, what is your preferred setup, then go and create a “Google web master tools account” and follow the instructions here to change your “preferred domain. Then change tis setting accordingly.
  • The rest of these options are optional and you should read the info question marks.


SEO configuration applet

These are the settings where personal taste has an important role, but here are some guidelines/ideeas to help you to made the best choices.

    "Activate Meta management" set this to yes.
    "Remove Joomla Generator tag" set this to yes
    "Use table-less output" set this to yes
    "Insert h1 tags" set this to yes. Unless you have already setup your template to have only 1 “h1″ tag on all of your Joomla pages.
    "Change multiple h1 in h2" should be set to yes. Having one h1 tag on each of your pages is a best practice. Multiple H1s is kinda like spamming.
    "Insert title in Read more" should be set to yes. This will add keywords to the “read more” link when you hover your mouse over it. This is good for seo and keyword density on your page.
    "Insert outbound links symbol" should be set to no unless you want symbols on your internal pages that show links going outbound. This is normally used if multiple novice users are adding content to your website, you can in turn click through their articles and remove links that go to other websites or add “no follow” tags to the links.

Best Joomla Hosting Recommendation

ASPHostPortal.com provides our customers with Plesk Panel, one of the most popular and stable control panels for Windows hosting, as free. You could also see the latest .NET framework, a crazy amount of functionality as well as Large disk space, bandwidth, MSSQL databases and more. All those give people the convenience to build up a powerful site in Windows server. We offer Joomla hosting starts from $5/month only. We also guarantee 30 days’ money back and guarantee 99.9% uptime. If you need a reliable affordable Joomla Hosting, we should be your best choice.



Joomla Hosting - ASPHostPortal.com :: Easy Steps to Input javascript to Joomla

clock October 5, 2016 21:30 by author ben

You can actually insert javascript anywhere in your Joomla article, plugin, module or component. The javascript will run fine.

However, if you want you page to be XHTML compliant, then you must add your javascript to the <HEAD> section of your HTML page.

1. Loading External .js Javascript Files

    Method 1
        If your javascript is all contained in a .js file, you can use the following to load the javascript file. Note: Assume your javascript file is stored in media/system/js/

        JHTML::script('your_javascript_file.js');

        The default location for the javascript file is in media/system/js/. If your javascript file is stored in another folder, you can use the following to load the javascript file:

        JHTML::script('your_javascript_file.js', '/full/path/to/the/js/folder');

        If your javascript requires the requires Mootools, then set the third parameter to TRUE/ to automatically ensure that the Mootools library is loaded.

        // Set 3rd parameter to TRUE to load the Mootools library
        JHTML::script('your_javascript_file.js', '/full/path/to/the/js/folder', true);


    Method 2
        You can also use the following method to load an external javascript file:

        $document = JFactory::getDocument();
     $document->addScriptDeclaration(JURI::base(). 'plugins/content/yourplugin/yourplugin.js');


2. Loading inline Javascript

    Suppose you want to add the following javascript codes to the <HEAD> section of your HTML page:

    <script type="text/javascript">
    window.addEvent('domready', function() {
        new Rokmoomenu($E('ul.menu'), {
            bgiframe: false,
            delay: 500,
            animate: {
                props: ['opacity', 'width', 'height'],
                opts: {
                    duration:400,
                    fps: 100,
                    transition: Fx.Transitions.Quad.easeOut
                }
            }
        });
    });
    </script>


    Use the following to insert the javascript codes:

    $javascript = "
    <script type="text/javascript">
    window.addEvent('domready', function() {
        new Rokmoomenu($E('ul.menu'), {
            bgiframe: false,
            delay: 500,
            animate: {
                props: ['opacity', 'width', 'height'],
                opts: {
                    duration:400,
                    fps: 100,
                    transition: Fx.Transitions.Quad.easeOut
                }
            }
        });
    });
    </script>
    ";

    $document->addScriptDeclaration($javascript);

Best Joomla Hosting Recommendation

ASPHostPortal.com provides our customers with Plesk Panel, one of the most popular and stable control panels for Windows hosting, as free. You could also see the latest .NET framework, a crazy amount of functionality as well as Large disk space, bandwidth, MSSQL databases and more. All those give people the convenience to build up a powerful site in Windows server. We offer Joomla hosting starts from $5/month only. We also guarantee 30 days’ money back and guarantee 99.9% uptime. If you need a reliable affordable Joomla Hosting, we should be your best choice.



Joomla Hosting - ASPHostPortal.com :: How to Inserting, Updating and Removing data using JDatabase

clock October 5, 2016 20:12 by author Armend

How to Inserting, Updating and Removing data using JDatabase

This tutorial is split into two independent parts:

  • Inserting, updating and removing data from the database.
  • Selecting data from one or more tables and retrieving it in a variety of different forms.

This section of the documentation looks at inserting, updating and removing data from a database table

 

Joomla provides a sophisticated database abstraction layer to simplify the usage for third party developers. New versions of the Joomla Platform API provide additional functionality which extends the database layer further, and includes features such as connectors to a greater variety of database servers and the query chaining to improve readability of connection code and simplify SQL coding.
Joomla can use different kinds of SQL database systems and run in a variety of environments with different table-prefixes. In addition to these functions, the class automatically creates the database connection. Besides instantiating the object you need just two lines of code to get a result from the database in a variety of formats. Using the Joomla database layer ensures a maximum of compatibility and flexibility for your extension.

The Query

Joomla's database querying has changed since the new Joomla Framework was introduced "query chaining" is now the recommended method for building database queries (although string queries are still supported).
Query chaining refers to a method of connecting a number of methods, one after the other, with each method returning an object that can support the next method, improving readability and simplifying code.
To obtain a new instance of the JDatabaseQuery class we use the JDatabaseDriver getQuery method:

$db = JFactory::getDbo();
$query = $db->getQuery(true)
;

The JDatabaseDriver::getQuery takes an optional argument, $new, which can be true or false (the default being false).
To query our data source we can call a number of JDatabaseQuery methods; these methods encapsulate the data source's query language (in most cases SQL), hiding query-specific syntax from the developer and increasing the portability of the developer's source code.
Some of the more frequently used methods include; select, from, join, where and order. There are also methods such as insert, update and delete for modifying records in the data store. By chaining these and other method calls, you can create almost any query against your data store without compromising portability of your code.

Inserting a Record

Using SQL

The JDatabaseQuery class provides a number of methods for building insert queries, the most common being insert, columns and values

// Get a db connection.
$db = JFactory::getDbo();
// Create a new query object.
$query = $db->getQuery(true);
// Insert columns.
$columns = array('user_id', 'profile_key', 'profile_value', 'ordering');
// Insert values.
$values = array(1001, $db->quote('custom.message'), $db->quote('Inserting a record using insert()'), 1);
// Prepare the insert query.
$query
    ->insert($db->quoteName('#__user_profiles'))
    ->columns($db->quoteName($columns))
    ->values(implode(',', $values))
// Set the query using our newly populated query object and execute it.
$db->setQuery($query);
$db->execute();

Using an Object

The JDatabaseDriver class also provides a convenient method for saving an object directly to the database allowing us to add a record to a table without writing a single line of SQL.


// Create and populate an object.
$profile = new stdClass();
$profile->user_id = 1001;
$profile->profile_key='custom.message';
$profile->profile_value='Inserting a record using insertObject()';
$profile->ordering=1;
// Insert the object into the user profile table.
$result = JFactory::getDbo()->insertObject('#__user_profiles', $profile);

Notice here that we do not need to escape the table name; the insertObject method does this for us.
The insertObject method will throw a error if there is a problem inserting the record into the database table.
We need to ensure that the record does not exist before attempting to insert it, so adding some kind of record check before executing the insertObject method would be recommended.

Updating a Record

Using SQL

The JDatabaseQuery class also provides methods for building update queries, in particular update and set. We also reuse another method which we used when creating select statements, the where method.

$db = JFactory::getDbo();
$query = $db->getQuery(true);
// Fields to update.
$fields = array(
    $db->quoteName('profile_value') . ' = ' . $db->quote('Updating custom message for user 1001.'),
    $db->quoteName('ordering') . ' = 2'
);
// Conditions for which records should be updated.
$conditions = array(
    $db->quoteName('user_id') . ' = 42',
    $db->quoteName('profile_key') . ' = ' . $db->quote('custom.message')
);
$query->update($db->quoteName('#__user_profiles'))->set($fields)->where($conditions);
$db->setQuery($query);
$result = $db->execute();

Using an Object

Like insertObject, the JDatabaseDriver class provides a convenience method for updating an object.
Below we will update our custom table with new values using an existing id primary key:

// Create an object for the record we are going to update.
$object = new stdClass();
// Must be a valid primary key value.
$object->id = 1;
$object->title = 'My Custom Record';
$object->description = 'A custom record being updated in the database.';
// Update their details in the users table using id as the primary key.
$result = JFactory::getDbo()->updateObject('#__custom_table', $object,
'id');

Just like insertObject, updateObject takes care of escaping table names for us.
The updateObject method will throw a error if there is a problem updating the record into the database table.
We need to ensure that the record already exists before attempting to update it, so we would probably add some kind of record check before executing the updateObject method.

Deleting a Record

Finally, there is also a delete method to remove records from the database.

$db = JFactory::getDbo();
$query = $db->getQuery(true);
// delete all custom keys for user 1001.
$conditions = array(
    $db->quoteName('user_id') . ' = 1001',
    $db->quoteName('profile_key') . ' = ' . $db->quote('custom.%')
);
$query->delete($db->quoteName('#__user_profiles'));
$query->where($conditions);
$db->setQuery($query);
$result = $db->execute();

Best Joomla Hosting Recommendation

ASPHostPortal.com provides our customers with Plesk Panel, one of the most popular and stable control panels for Windows hosting, as free. You could also see the latest .NET framework, a crazy amount of functionality as well as Large disk space, bandwidth, MSSQL databases and more. All those give people the convenience to build up a powerful site in Windows server. We offer Joomla hosting starts from $5/month only. We also guarantee 30 days’ money back and guarantee 99.9% uptime. If you need a reliable affordable Joomla Hosting, we should be your best choice.



ASPHostPortal.com Announces ASP.NET Core 1.0.1 Hosting Solution

clock October 4, 2016 23:10 by author ben

ASPHostPortal.com has provided reliable Windows ASP.NET hosting plans, at the lowest prices, for the best services possible, on fastest nodes ever. We strongly believe in high quality standards and Hence, the customer will always find our services better than every other host in this industry. We provide Windows ASP.NET hosting plans on high performance servers and high-speed internet connection in the world. Now, we offer reliable ASP.NET Core 1.0.1 hosting with Best 24/7 customer support.

Microsoft this week released updates to ASP.NET Core, .NET Core and Entity Framework Core that consisted mainly of a growing list of fixes. Among the fix rollup is one that plugs up a potential security breakdown within ASP.NET Core. Microsoft details the issue in a TechNet security bulletin that was released at the same time.

According to the bulletin, the issue affects "the public version of ASP.NET Core MVC 1.0.0 whereView Components could receive incorrect information, including details of the current authenticated user." The bulletin goes on to explain that "If a View Component depends on the vulnerable code and makes decisions based on the current user, then the View Component could make incorrect decisions that result in elevation of privilege."

ASPHostPortal.com is set up with an aim to serve customers in an excellent manner by providing them quality service. We offer ASP.NET Core 1.0.1 hosting with affordable price, a lot of features, 99.99% uptime guarantee, 24/7 support, and 30 days money back guarantee. We strive to make sure that all customers have the finest web-hosting experience as possible. To learn more about our ASP.NET Core 1.0.1 Hosting, please visit http://asphostportal.com/ASPNET-Core-1-0-Hosting.aspx

About ASPHostPortal.com:
ASPHostPortal.com is The Best, Cheap and Recommended ASP.NET & Linux Hosting. ASPHostPortal.com has ability to support the latest Microsoft, ASP.NET, and Linux technology, such as: such as: WebMatrix, Web Deploy, Visual Studio, Latest ASP.NET Version, Latest ASP.NET MVC Version, Silverlight and Visual Studio Light Switch, Latest MySql version, Latest PHPMyAdmin, Support PHP, etc. Their service includes shared hosting, reseller hosting, and Sharepoint hosting, with speciality in ASP.NET, SQL Server, and Linux solutions. Protection, trustworthiness, and performance are at the core of hosting operations to make certain every website and software hosted is so secured and performs at the best possible level.



About ASPHostPortal.com

We’re a company that works differently to most. Value is what we output and help our customers achieve, not how much money we put in the bank. It’s not because we are altruistic. It’s based on an even simpler principle. "Do good things, and good things will come to you".

Success for us is something that is continually experienced, not something that is reached. For us it is all about the experience – more than the journey. Life is a continual experience. We see the Internet as being an incredible amplifier to the experience of life for all of us. It can help humanity come together to explode in knowledge exploration and discussion. It is continual enlightenment of new ideas, experiences, and passions

Corporate Address (Location)

ASPHostPortal
170 W 56th Street, Suite 121
New York, NY 10019
United States

Sign in