Razvan Pandor

Gasiti coordonatele cu Google Maps

Aceasta pagina foloseste APIul Google Maps pentru a afla cu precizie coordonatele geografice (latitudine si longitudine) pentru orice punct de pe pamant.
Aveti doua posibilitati : prin miscarea iconitei ori prin scrierea adresei,orasului,locului daca nu stiti exact pozitia pe harta. Locatia de start este Alba Iulia – in centrul Romaniei.

Gasiti coordonatele miscand harta

1. Faceti Drag and Drop pe harta pentru a o misca
2. puteti face zoom pentru mai multa precizie 3. Puteti misca markerul pentru a stabili cu exactitate locul caruia doriti sa ii aflati coordonatele geografice. Coordonatele se improspateaza dupa fiecare miscare.

Aflati coordonatele introducand numele si/sau adresa locului cautat

Scrieti adresa intreaga: Strada, numar, oras, tara. Pentru orase mari si locuri faimoase tara este optionala. “Casa Poporului” sau “Sibiu”.

demo..

The triumph of coal marketing

Had to copy a large DB into a new one…Since MySQL Administrator and PHPMyAdmin failed to backup the 3.7Gb Database I was forced to do it from Shell like this:

mysqldump -u user -p db-name > output_file.out
 /*- launch this from the shell as root with the credentials of the source DB*/

mysql -u user -p new_db-name < output_file.out
/* - this will copy from the dump file into the new database.
you can also download the resulting file and use it on
another server - you could do this the old fashion way by
 copying it on your local machine and then upload it to your
 new server and launch the previous command or if you have "scp":*/

scp output_file.out user@remote_ftp_path

1) Go to Google Translate
2) Set it to translate from German to German
3) Copy + paste the following text into the translate box:
pv zk pv pv zk pv zk kz zk pv pv pv zk pv zk zk pzk pzk pvzkpkzvpvzk kkkkkk bsch
or
bch tz tz tz bsch tz tz bch tz tz bch tz bsch tz tz tz bch tz tz tz bsch tz tz bch tz tz bch tz bsch
4) Click “listen”.
The beatbox tool is one of the things that Google didn’t have… now.. there you go!

Recently I had to save a DataBase from a server only with FTP access and without any tool like PhpMyAdmin or Cpanel. I had only the FTP credentials, the name of the DataBase and the credentials to access the DataBase.

So if you want to save a database to a file only with the aid of PHP here’s a small function that does the trick:

 function backup_tables($host,$user,$pass,$name,$tables = '*')
{
	$link = mysql_connect($host,$user,$pass);
	mysql_select_db($name,$link);
    	//get all of the tables - if the tables parameter is "*" all the tables will be taken
	if($tables == '*')
	{
		$tables = array();
		$result = mysql_query('SHOW TABLES');
		while($row = mysql_fetch_row($result))
		{
			$tables[] = $row[0];
		}
	}
	else
	{
                 //$tables should be a string of table names separated by coma
		$tables = is_array($tables) ? $tables : explode(',',$tables);
	}

	//cycle through the tables  and build the text to be written into the dump file
	foreach($tables as $table)
	{
		$result = mysql_query('SELECT * FROM '.$table);
		$num_fields = mysql_num_fields($result);

		$return.= 'DROP TABLE '.$table.';';
		$row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE '.$table));
		$return.= "\n\n".$row2[1].";\n\n";

		for ($i = 0; $i < $num_fields; $i++)
		{
			while($row = mysql_fetch_row($result))
			{
				$return.= 'INSERT INTO '.$table.' VALUES(';
				for($j=0; $j<$num_fields; $j++)
				{
					$row[$j] = addslashes($row[$j]);
					$row[$j] = ereg_replace("\n","\\n",$row[$j]);
					if (isset($row[$j])) { $return.= '"'.$row[$j].'"' ; } else { $return.= '""'; }
					if ($j<($num_fields-1)) { $return.= ','; }
				}
				$return.= ");\n";
			}
		}
		$return.="\n\n\n";
	}

	//save the dump file
	$handle = fopen('db-backup.sql','w+');
	fwrite($handle,$return);
	fclose($handle);
}