Category: Just Tricks

All the other languages.

MySQL for MS Excel

Yes, it exists! Today, I somehow managed to install it from here. This is how it looks like: Just a small icon in the Excel data tab. Once you click, you are asked to make the connection with the DB. Due

Tagged with: , ,

Angular JS – Just Another To-Do App

In the last year, I have made quite enough To-Do apps – just in VitoshAcademy.com I have published one with PHP with login functionality,  and I had quite a big project (about 3 days of coding from 3 coders ) here

Tagged with: , ,

AngularJS – Make a scope function with Angular

In the current article, I would simply make a scope function with Angular JS. This is always useful to have in your toolbox:   Yup! The code is simple and the idea came from this app here, but mine is

Tagged with: ,

ASP.NET Hello World with VB.NET

ASP.Net is one of the technologies, which I have not mentioned in my site. Thus, I will start mentioning it, because it is probably amongst the very few, which use still use VB. And due to some weird reason, I

Tagged with:

JavaScript – A simple calculator with lots Bootstrap

Have you ever dreamt of making the simplest application for calculating two numbers? Nope? Me also. But anyhow, I have started to make it only with JavaScript, without jQuery and it turned out to be fun after some time. That is

Tagged with: , , ,

XML with PHP – make links easily

I really did not think to make a post about it, but as far  as I have lost about 15 minutes in research how to do it, it is obviously that spending some 10 minutes more would be valuable. The

Tagged with: , ,

AJAX – JQuery – PHP – JSON – Get data from DB with AJAX

Some time ago I have made a simple ToDo list with PHP here. Today, using its database and one function from the list, I have decided to make the todo list with Ajax. This means, that you should not refresh

Tagged with: , , ,

jQuery – Build a background with changing pictures with jQuery

So, animation in jQuery is a powerful thing! 🙂 Indeed. In the current article, I will show you the code, which I have used to produce the following beautiful video. It is just a few seconds, but you may still

Tagged with: , ,

jQuery – A simple game with JQuery events

Working with JQuery becomes interesting, after you get some ideas what to do and you see how easy it is to build it. Although the code below can be made about 8 times less, I have really enjoyed copying and

Tagged with: , , ,

jQuery – DOM – InsertBefore, PrependTo and other examples

So I have tried to learn a little about jQuery and its DOM functions and this is what I have managed to do today – an example with “insertBefore”, “prependTo”, “insertAfter” and “appendTo”. Pretty much that is what the example

Tagged with: , , ,

PHP – JQuery – MySQL – Make a simple drop down menu

After the simple ToDo list here, I have decided to add more features to it. So, a possible feature, looks like this – you have a drop down menu with all the users in the database: Then, after a selection,

Tagged with: , ,

PHP – Build a HTML Table From any Query

As far as I am putting some efforts towards PHP and understanding why it is so hated by programmers all around, I have decided that the results from the queries should be always easily displayed in an HTML table. A

Tagged with: , , ,

PHP – Make a simple To Do list with PHP

Some two days ago I have decided that it would be more fun if I try to make a simple PHP todo list, while trying to learn the language. 🙂 After all, I have made this exercise with JS (no

Tagged with: , ,

PHP – Simple guessing game

Indeed simple. These are the rules (from a homework of the SoftUni): Implement a “Guess Number Game” in PHP. Keep the secret number in the user’s session and indicate “Up” or “Down” after each guess. At the start page of

Tagged with: , ,

JQuery Strange Game – A way to tease yourself with JQuery events

The idea here is to try to start the YouTube clip, which is embedded in the light blue square, just bellow the jelly fish. I am using mouseout, mousemove and click events with JQuery to illustrate their way of working.

Tagged with: , , , ,

JQuery – Select First, Last, Nth, Second Children

Ever wondering how to select children in JQuery? No? Then skip to the next article. My case is the following – I present a div with divs, and I try to select its children, changing the borders and the background.

Tagged with: , , ,

JQuery – Randomize Anything – Random Numbers with Random Colors

Some years ago, while I was writing my master thesis (I have two of them in two different languages), I remember that I was told that I should write something that is not written before and I should convince the reader

Tagged with: , , ,

PHP – Inheritance and Overload in a Class

Have you ever dreamt to understand the inheritance and the overload from once 5 minute example? No such dreams? Anyway, in case you ever tend to think about it, here is the example with PHP. Let’s imagine that we have

Tagged with: , ,

PHP – Make Iterator with PHP Class

PHP and iterators… Violin and boxing… Anyway, it is possible and the possibility is since some years ago. In this article I will simply show how to make an iterator with a PHP class. And I would iterate in a

Tagged with: , ,

PHP – class with functions

After some time with JS and Python, this week I have decided to continue with PHP. So, let’s see how you can make a class with a function in PHP. My class would be called Investment, with 3 public variables

Tagged with: ,

jQuery – a Simple Example With Two Links

Today I have started to take a better look at JQuery. And it seems wonderful! Indeed. Full of wonders 🙂 Thus, I have started to code something trivial – like the picture below: With JQuery, this click option of the

Tagged with:

JavaScript – Format HTML with JavaScript code

Have you ever tought of formatting HTML with JS in stead of CSS? Why have you tought about it? Anyway, if playing with formats is your thing, here is a small example how to achieve the following picture with JS

Tagged with: ,

Java Script – Random pictures

Imagine that you are in a situation, on which you are wondering among 8 different choices. Thus, the following program would be able to help you take a solution. Or at least to check the way JS works with arrays,

Tagged with: , ,

PHP – Issue yourself a certificate – PDF and PHP

As you are probably aware, this site is called VitoshAcademy. As far as the site is called this way, I have tought of finding a way to issue automatic certificates with PDF and PHP. And this is exactly what I am going

Tagged with: ,

PHP – Get data from XML to HTML file with PHP

Now continuing with PHP – today I will show you how to use a simple xml file and to get its data to a PHP file in the Internet. Not as difficult as it seems actually – XML files are

Tagged with: , ,

PHP – Writing to a file with php

  Reading and writing always come together. Thus, after presenting the way to read from a file, now it is time to be able to write:   Writing in PHP is not a challenge, the only tricky part is to

PHP – Reading from a file into a HTML table

As I have already mentioned in a previous article here, lately PHP has attracted my attention. Thus, today I will show how to build a small HTML table from a txt file, using each line in the file as a

Tagged with: , ,

SQL Server – Solution of the first part of the SoftUni Exam for SQL Server

Just a day ago I have participated at an exam, organized from SoftUni for SQL server. The exam can be found here and the questions for it are here. In the current article I will present my answers from the first part

Tagged with: , , , ,

SQL Server – Create two tables with primary and foreign key with SQL code

There is a simple way in VBA and in Python to create tables in the database you need, giving the tables a name of a variable and the type of a variable. In SQL Server, we also have a way

Tagged with: , , , ,

SQL Server – Get data below the avarage; Difference between Left and Right Join Explained

I have started to explain tricks with SQL Server in a series of articles about a week or two ago. Today I will use a database, mentioned in a previous article. Get data below average The task is to get top

Tagged with: , , ,
Top