Skip to main content

Posts

Showing posts from 2017

GET THE DATABASE SIZE FROM THE MYSQL QUERY BROWSER

Run the below query you can get the Data Base Size in MySQL. 

If you run the query which is given below in MySQL Query Browser then you will get the two columns first will display the Data Base Name and the second will display the Data Base Size in MB. 




This will display list of all database :
SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ;


This will display specific database db_name:
SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES WHERE table_schema = "db_name"

Ajax Request

Client Side


$.ajax({ url: '/path/to/server', type: 'POST', data: { first_name : firstName, last_name: lastName, address: address, city: city, country: country }, success: function(result) { var obj = jQuery.parseJSON(result); if(obj.result == 'OK') { alert(obj.message); } else { alert(obj.message); } } });
Server Side
response from php file


echo json_encode(['result'=> 'OK', 'message' => 'This is message']);

The Importance of Redesigning Your Website

Redesigning a website takes time and money, but in the end a revamp is a wise investment. Your website is essentially a virtual business card, and your strongest online marketing tool.

Whether you’re looking for the best web development in LA or revamping in NYC, make the most of business by keeping your website fresh, up-to-date, and user-friendly.

Outdated The Web is constantly changing: Web technology that was once considered cutting-edge is most likely out-of-date today. A website makeover will give you and your business an advantage in the competitive, online sphere..

In fact, design is a leading factor in user trust. According to a study titled, “Trust and Mistrust of Online Health Sites,” 94 percent of the participants agreed that an updated, better looking website is more trustworthy than an outdated design, even if the information displayed on both is accurate and of equal quality.

Usability If your readers are unable to find what they’re looking for quickly, they will leave. To pr…

Content in Web Design

Once a visitor is a customer, it’s important to keep them coming back. The work doesn’t stop after the initial website launch, and any good web design company will help you understand the other factors for success, like engaging content. Posting fresh, relevant information on your website will ensure your site improves SEO while driving new and returning traffic.

Keep Visitors Coming Back With Engaging Content When it comes to web marketing, content is king. Engaging content can include anything from infographics, to videos, to opinion posts.

An infographic is one of the most basic ways to present information in a visual way; hence the name, info + graphic. Infographics are statistically proven to drive views faster than other types of content and are a powerful way to get your information out in a simple, visual format. In fact, studies show that infographics are shared and liked on social networks up to three times more often than other content.

Cater to Your Specific Audience to Drive …