Servage Magazine

I think we most of tech-savvy people have used Excel sheet or alike software to prepare huge tables to numbers of rows and columns. Generally, we give top row a heading role that shows what elements are listed in rest of the rows below. Same the way we do for the first column. Once all done, we go to view > Freeze Panes > Freeze Top Row or Freeze First Column. This simple yet popular workflow for database users or accounting professionals. Yes, but why we do that. Oh, merely get convenience in scrolling so we can read the top heading titles and select the corresponding cell down to any ...

In sense of a language, the word “Design” has broad spectrum of meanings, but for we web designers, have some limited scopes to feel it. If you are at planning and prototyping stages of development, simple boxes and lines will make a great design for you and your clients. Once you jump in to the graphics designing software, aesthetics of design part would become visible and color, shapes, typography, etc. visual elements will begin to make some sense for you and your clients. As soon as your programmer is giving final touch to your website or web application and your QA team is giving green signals to upload it on the ...

When we are thinking about the advertisement campaign our perspectives towards our website pages changes accordingly. If we have small website with a few pages and good home page, our home page will serve our all needs to attract, retain, and convert our visitors from Ad campaign successfully. The same is true for other things such as e-mail campaign and promotional/gift/voucher/coupon campaigns. Unfortunately, somewhat big size websites can’t offer such convenience, as they have limited scope to address bespoken needs of our campaigns on the home page therefore, we need some additional page/s as landing pages to meet our requirements. If you think about e-commerce storefront, you may ...

We are living in UX era where fast loading and quick interactions are mandatory performance credentials. In such conditions, styling in HTML is a suicidal attempt and packing up all styles in CSS is highly desirable skill for modern web programmers. In due course, today I am going to introduce you some basic and a few advance CSS properties related to text and textual content by-and-large. First, we will see that, which CSS property is doing what in your web documents and later on we will see how to and where to implement them correctly. Below I have mentioned the name of properties and their short introductory descriptions: Color: To set ...

PHP is a web-programming language that is easy to learn and implement. It is also a zero investment language due to its open-source license with a vast community to help if you are a beginner, learning a server-side script for your first time. Web programmers don’t need any special code editor as PHP code can integrate with any language and markup, including HTML. If you look at a PHP file, you will see simple text, HTML, CSS, JavaScript, and other scripting with the PHP code. Being a server-side language, PHP code gets executed on the server and delivers HTML to the client. Therefore, it adds no load to clients and has ...

Enter your password when prompted. You can then try the following command, which should result in something like the screen grab. SHOW databases; There may be other databases already created, and the test database may not be there. Bear in mind also that system administrators have ultimate control over everything and that you can encounter some unexpected setups. For example, you may find that you are required to preface all database names that you create with a unique identifying string to ensure that you do not conflict with databases created by other users. If you have any problems, have a word with your system administrator, who should be able to sort them out. Let ...

Historically, web programmers have been concerned with providing great user experiences at the moment a visitor enters a website or begins usage of a mobile app. Our primary motivation has always been delivering excellent presentation of information, regarding services or products. We seek to make the users’ journey smooth, happy, and convenient by utilizing the latest tools and technologies available on the web and/or with mobile platforms. Now, that history is being updated based on anticipation of user experiences. We need to think about the users before they arrive on our website, web application, mobile app, or even in our brick-and-mortar store. The objective now is to personally know ...

So, to enter MySQL’s command-line interface, select Start→Run and enter CMD into the Run box, then press Return. This will call up a Windows Command prompt. From there, enter one of the following (making any appropriate changes as just discussed): "C:\Program Files\Zend\MySQL51\bin" -u root "C:\Program Files (x86)\Zend\MySQL51\bin" -u root Note the quotation marks surrounding the path and filename. These are present because the name contains spaces, which the Command prompt doesn’t correctly interpret; the quotation marks group the parts of the filename into a single string for the Command program to understand. This command tells MySQL to log you in as the user root, without a password. You will now be logged in to MySQL and ...

As a web developer, I have come to realize that the old fixed canvases of our desktops are rapidly breaking apart. In today’s development world, we have to venture out to the different device landscapes which are all a bit fuzzy at the moment. We are tasked with designing something flexible and organic, so that we can make an appropriate pitch for great user experiences and performance optimization, without distracting our users at all. With this realization, I would like to have the reader look at JavaScript and its functionality on contemporary web programming, where hardware and software fragmentation is the norm. The most challenging part is deciding when ...

With well over ten million installations, MySQL is probably the most popular database management system for web servers. Developed in the mid-1990s, it’s now a mature technology that powers many of today’s most-visited Internet destinations. One reason for its success must be the fact that, like PHP, it’s free to use. But it’s also extremely powerful and exceptionally fast—it can run on even the most basic of hardware, and it hardly puts a dent in system resources. MySQL is also highly scalable, which means that it can grow with your website. In fact, in a comparison of several databases by eWEEK, MySQL and Oracle tied for both best performance and greatest scalability. MySQL Basics A ...