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, …
Year: 2015
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 …
PHP – Issue yourself a certificate – PDF and PHP Read more →
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 …
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 …
PHP MySql – Getting data from a database into a HTML Table
Some time ago, about 10 days to be more precise, I have decided to take a better look at PHP and to try to understand why so many people hate it actually. After all, as a VBA developer (or if …
PHP MySql – Getting data from a database into a HTML Table Read more →
Python – Algorithm – Calculate Average distance with Dijkstra
In the current article I will try to solve a problem for calculation of average distance with Dijkstra, given in codeforces.com contest here in pdf. What is the problem like? We have n weighted graphs like this: For each given graph, …
Python – Algorithm – Calculate Average distance with Dijkstra Read more →
C# – Enable Migrations in Visual Studio using Entity Framework
This article is rather small, but its target is to remind me how to enable migrations of database in Visual Studio. Thus, the steps are: Press Ctrl + Q to go to the quick launch. In the quick launch write …
C# – Enable Migrations in Visual Studio using Entity Framework Read more →
Python Algorithms – Maximum combinations of coins
Sometimes complicated algorithms are really easy to be written down. The current problem is solved in 6 lines of code (from line 5 to line 11), but it you need to put effort to understand how the algorithm works and what are …
Python Algorithms – Maximum combinations of coins Read more →
Python Algorithms – Full Dijkstra is stunning again
Yesterday I have spent some hours, trying to resolve one problem for shortest paths. The problem was coming from HackBulgaria and was somehow similar to these two problems here: Get the shortest path in a weighted graph with Dijkstra Dijkstra for …
Python Algorithms – Full Dijkstra is stunning again Read more →
Python – Get the shortest path in a weighted graph – Dijkstra
Today, I will take a look at a problem, similar to the one here. In the article there, I produced a matrix, calculating the cheapest plane tickets between any two airports given. Today, the task is a little different. I would …
Python – Get the shortest path in a weighted graph – Dijkstra Read more →
Review – Pivot Tables Smart Data Analysis
Although I have started to learn new stuff lately, such as Python and SQL server, I am still interested in MS Excel and whatever is being published on the subject. I have noticed that the book “Pivot Tables Smart Data …
Python – Calculating words in matrix – contest problem
Today I was looking into the following problem for word counter in python from Hack Bulgaria: You are given a rectangular table filled with characters and a word. Your task is to count the occurrences of the word in the …
Python – Calculating words in matrix – contest problem Read more →
Python – Dijkstra algorithm for all nodes
In this article I will present the solution of a problem for finding the shortest path on a weighted graph, using the Dijkstra algorithm for all nodes. The problem is formulated by HackBulgaria here. Pretty much, you are given a …
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 …
SQL Server – Solution of the first part of the SoftUni Exam for SQL Server Read more →
Review – 11 incredible Excel conditional Formatting Tricks, Excel Shortcuts, 7 Genius ways of using Advance Filter
Today I have received something, that at first looked as a spam e-mail, but for some reason the spam filter has not caught it. Then I took a second look at it and I have noticed, that it was from …
Python – two solutions in codeforces.com
Yesterday, I have decided to make an account in codeforeces.com and to check how the system works. Pretty much quite well, in 90 minutes I have managed to solve 2 of the 5 problems: I have decided to stop, because for …
Python – Usage of a Binary Tree with List in Python
After the article here, concerning the building of the binary trees and their usefulness, today I will show how to use these trees in action 🙂 Imagine that we have the following problem, used in arena.hackbulgaria.com: Implement a program in …
Python – Usage of a Binary Tree with List in Python Read more →
Python – Build a binary tree list in python
Binary trees are really useful, if you are solving an algorithmic problem. They consists of nodes (a.k.a vertices) and edges. Thus, each node has two edges, which are leading to another node. Something like this: The above tree is a simple random non-balanced …
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 …
SQL Server – Create two tables with primary and foreign key with SQL code Read more →
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 …
Review – Wing IDE
Some two weeks ago, I was coding in Python with Notepad++ as a text editor and I was getting really tired, because the program was not running the way I wanted it and I had to print a lot of …
SQL Server – Conditional Query And Multiple Tables Join (Many to Many Query)
As I have already started some time ago with SQL Server, in this article I will present the way to write a if-else case in sql query. The database is available here, I have used a sample DB for one …
SQL Server – Conditional Query And Multiple Tables Join (Many to Many Query) Read more →
SQL Server – Simple Transaction in SQL Server
So, after starting with SQL Server custom views, SQL Server Triggers, SQL Server Procedures and Functions, now it is time to pay some attention to SQL Transaction as well. What are transactions? Microsoft says the following: A transaction is a single …
SQL Server – Procedures and Functions in SQL
So, continuing from yesterday with the SQL Server subject, it is time to introduce some nice ways of writing functions and procedures in SQL. What is the idea, behind the functions and the procedures in SQL? Pretty much, I would …
SQL Server – create trigger to log changes in DB
About 6 months ago I wrote about the way to create a log sheet in Excel with VBA. Nowadays, as far as I am doing a small upgrade from MS Excel to MS SQL Server 🙂 , I was interested …
SQL Server – create trigger to log changes in DB Read more →
SQL Server – Create Custom View in Microsoft SQL Server Management Studio
Speaking about SQL, I have noted something really interesting in MS SQL Server Management Studio, which would probably be of use in MS Access as well. This is the saved custom view. It is not present in MS Access, but …
SQL Server – Create Custom View in Microsoft SQL Server Management Studio Read more →
SQL Server – Generate data in Microsoft SQL Server Management Studio
The legend says that when the chess was invented, the inventor was asked to pick a price from the local king. Thus, he asked for one grain for the first cell of the chess board, 2 for the second, 4 …
SQL Server – Generate data in Microsoft SQL Server Management Studio Read more →
SQL Server – How to generate sql script from a db
If you are interested in DB development, then most probably you have tried to generate a sql script from your database. In this article I will show you how to do it with Microsoft SQL Server Management Studio. So, lets …
SQL Server – How to generate sql script from a db Read more →
Python – Algorithm Challenge – First Day At School
Yesterday, I have started to solve problems from a challenging Russian site for programming competitions. Today, I have decided to spend about 30 minutes on another problem, which seemed easy, but I am already spending hours on it, without being able …
Python – Algorithm Challenge – First Day At School Read more →