Georgi Mitev's blog for scripts tutorials and something else

The MySql database backup website backup is very similar to the previous backup that I showed you 2 days ago. We are going to create a php file that is going to dump our database into filename with the current date and time.

Ok so let’s get going:
1. Create the file “backup_database.php” and input the following code into it:
<?php exec(‘cd /home/your_user/backup/db/;mysqldump –add-drop-table -h localhost –user=your_user –password=your_pass database_name > `date +%y-%m-%d_%H-%M`.sql’); ?>

Sometimes the path to your home dir looks different than ‘/home/your_user/’, so execute the ‘pwd’ command like explained in my previous post

Here we use the command mysqldump in a tutorial that I wrote previously about the dumping the sql database from one host to another. Now the database will be saved directly on the server that is hosting your website

Continue reading »

Hello guys and ladies,
Long time no see . Today I’m going to show you how to make a php script to perform full website backup the script can be executed via http request or via ssh shell or like a cron job .
We all know about the most standard way to add backup for your website maintenance for example using the Cron Jobs in the CPanel. If you already don’t know this – if your hosting provider does support CPanel you should be able to access it via this URL: www.yourwebsite.com/cpanel

Continue reading »

Today i found this very cool tutorial regarding the using of using ssl with PHP.

I’ll copy here the most interesting of it.

HTTP with PHP Sockets

// don’t need to specify http, it’s the default protocol
$hostname = “www.google.com”;
$port = 80;

// create and configure the client socket
$fp = fsockopen($hostname, $port); // optional: $error_number, $error_string, $connect_timeout
if ($fp) {
stream_set_timeout($fp, 30); // seconds to wait for i/o operations

// send request headers
fwrite($fp, “GET / HTTP/1.1\r\n”);
fwrite($fp, “Host: $hostname\r\n”);
fwrite($fp, $additional_headers); // Accept, User-Agent, Referer, etc.
fwrite($fp, “Connection: close\r\n”);

// read response
$response = “”;
while (!feof($fp)) {
$response .= fgets($fp, 128);
}
echo $response;

// close the socket
fclose($fp);
}
Continue reading »

I needed to create a backup on my mysql database on remote host. I found out that there is a way that you can actually do that with mysqldump . I didn’t believe that it will be so easy but i decided to give it a try. After all the stuff i read on the net about it there was’nt a single working example of it – so after some testing i managed to do it
so here it is:

first i will show you how to use mysqldump to backup your database on your harddrive on your local computer under windows. Go to your command prompt -> Start -> Run -> write “cmd” -> hit enter
go to your mysql bin directory, in case that you use xampp, and it’s installed on c:\xampp, it should be in c:\xampp\mysql\bin
you can do that by typing “cd \” and then “cd xampp\mysql\bin” (i’m trying to write this tutorial as simple as possible so that everybody will get it )

after that, to backup your database on local mashine you should write:
mysqldump –add-drop-table -h localhost –user=root –password=yourpass yourDBname > OutputFile.sql

voilla

so if you want to backup your database to remote host the command gets a bit more sophisticated
here we go:

copy databse and it’s data from one server to another:
mysqldump –user=root –password=yourPassword –opt localDB | mysql -h 192.168.1.35 –user=root –password=remotePassword remoteDB

In our case we copy our local database “localDB” into the database “remoteDB” on the machine with 192.168.1.35

we can also do the command like this:
mysqldump -h 192.168.1.17 –user=test –password=12345 –opt remoteDB
| mysql -h 192.168.1.51 –user=root –password=bg_820918 remoteDB

in this case we copy the database “remoteDB” from remote host to another remote host in the database “remoteDB”

now you see how powerfull mysqldump really is, and that’s only few of the things it’s capable of
I hope this will was usefull for someone

Hello fellas,  because these days i had a case where i had to include some RSS feed on my site and i needed a very simple and fast solution in php how to do it i was very dissapointed from what i’ve found on the web. There are all kind of widgets, tools PHP scripts using the xml-reader class, whatever – but i just needed some very simple solution. So ofcourse i had to write it myself at the end

in this example i’m going to import feed from yahoo’s technology news rss:

Continue reading »

I’m going to talk about some good object oriented practices for small/medium projects. The object oriented programming itself will save you enourmous amount of time. The inheritance is part of the Object Oriented Programming (OOP) and is very good thing that is going to save you even more time when you start to use some object oriented model in your programming.

Let’s say we need to have some root class – lets say “Base”, with the __construct() (the class’s constructor) – notice that since PHP 5.0 the constructor of a class is defined in __constructs(), instead of “the-name-of-your-class”(). Anyway you can define the constructor information in Base() as well, but better do it in __construct, because you don’t know if there will be support for the old PHP 4 constructors in PHP 6

so let’s get on business..
Continue reading »

I don’t know if this will be interesting for you, but it was very interesting for me when i found that it is very easy to modify header information and send POST/GET variables through header using php. Anyway with CURL you are able to do much more that just modify the header information etc., but we wont have that time-frame

I will give you simple example where i login through script on localhost on some site – in this example: “gametrailers.com” – without actually enter any username and password , i think this will be the easiest way to understand it.

so here is the example:
Continue reading »

Hello today i’m going to talk about resizing your the images in your site.
So let’s say for example that you have a CMS system – like Joomla for example. In the administration you usually have functionality like – uploading images and linking them in your content.
But often the problem with that is that usually the customers will upload too large images (copied in raw jpeg directly from their cameras) and when they link them to the content of their website, it get’s really messy.
Anyway you can fix this by writing some script that directly resize the image to some resolution like 500px/* for example, but what will happen if you want to put lightbox or something other to show the image in large resolution, or you just want to put some function to download the original file etc. You simply can’t because the image was resized at the moment it was uploaded on the server.

How about dinamically resize the image at the very  moment that client requests it?

So that way we wont have a big image that the client has to download, and at the same time we will still have the original, good resolution copy of the image, in case that we need it. We can also use the following PHP script for creating thumbnails.

Well – as you will see below it’s not hard at all to do it,  i mean not hard at all

Continue reading »

This is metal gear solid kind-a game W. i highly recommend it if you have’nt tried it before. You come in the role of the bad alien that kills FBI agents, and in the same time unknown why you must have to kill all sorts of weird robots etc. This is very classic game so don’t miss it ;D

if you want to play the game – click Continue reading

Continue reading »

Hello ,
these days i was making a lot of compliments about Windows 7, i was telling my friends how fast and stable it is, even that it’s still in Beta . Well i think that it is double as fast compared to Vista, double as stable, double …. blablabla
… and also you have double the toolbars, double the menu items double everything