Query Posts keyword

While I was creating a search function in WordPress I found it hard to filter query_posts with a keyword. Then I simply tried to add &s=keyword and it worked. So for all you out there, having the same problem here is a pice of code how to make this work:

<?php

global $query_string;

$keyword = “my epic keywords”;

query_posts( $query_string . “&s=”.$keyword );

?>


Import large CSV file into MySQL

Tags: , ,

When I was about to import a large CSV file into MySQL I kind of ran into a problem. Since phpMyAdmin does not like large files I had to find another solution. ( Dident get it if I could SSH it, hehe). Well I found dbForge! Perfect program for the job, though it cost some money but perhaps worth it, running trail period now. If you know any simalry program thats free, let me know! :)


Recover Asus Laptop

When I was about to recover a Asus Laptop I find it kind of hard to find the recovery bot up if the Windows is broken. But after a while I found out that if you press F9 on boot up you will get into the recovery screen. From there it is kind of easy. Post here if you get into any trouble!


Strtoupper Å Ä Ö fix UTF-8

As you might know the Stroupper dont work with special chars like Å Ä Ö. Also its not working to do str_replace sice Å Ä Ö is not supported there. But there is a way to do this easy with mb_stroupper and use UTF-8, see my example:

$string = “åäö”;

$string=mb_strtoupper($string, “utf-8″);

echo $string;

Enjoy!

$string=mb_strtoupper($string, “utf-8″);

Backup and restore MySQL tables/database

If you have a lagre database that you will take backup on you might find it hard to do so with example phpmyadmin. MySQL made commando for this so you easy can do this in your terminal on both Windows and Linux. I will first go with Linux. OBS: The commando are the same for both Linux and Windows.

MySQLdump commando

mysqldump -u username -ppassword database_name table_name > /your/way/to/sql/file/file_name.sql

SQL for restore table/database

mysql -u username -ppassword database_name < /your/way/to/sql/file/file_name.sql

If you want to backup full database just dont write the table name on first commando.

If you use Windows you have to go to you bin folder who is in your mysql folder. For example in EasyPHP the way is:

c:\program\easyphp-folder\mysql\bin

From there run the commando. Also if you did not understand, you first run the location in simple CMD and then run the commando.


FTP server Ubuntu with graphic

GproFTPD is a good graphic based FTP server for Ubuntu. For install simpley type:

sudo apt-get update

sudo apt-get install gproftpd.

After installation just start the program by: sudo gproftpd and setup your FTP server and users.

Screenshot2


Unexpected end of mysql – EasyPHP

Tags: ,

When I was running EasyPHP on my Vista machine I got error:

unexpected end of mysql

To solve this just quit easyPHP and then right click on easyphp.exe and run as administrator. Hope it helped. Dident find this trick on google so perhaps you did :-)

Good luck!


Skype in your Nokia N97

Tags: , ,

Now I finally got my new Nokia N97 and I really like this “little” phone! But since I am as you already know a huge fan of Skype I just had to install it on my new phone. But skype have not yet created a offical version of Skype to Nokia N97 so I decide to install a multi msg client and found out that Fring is the best working one! It support skype-out witch I really like. Also have some other nice furtures! Try it out if you are looking for Skype client for Nokia N97!


Skype on Ubuntu, Linux

Tags: ,

I just have to thanks skype that they made a version for Ubuntu. Its very importent to me since I am support on telephone by skype daily and need it to run, and ofcourse work… The sad thing about skype on Ubuntu is that it is not that developed as it is on Windows. Perhaps it makes seance but still, very frustrating. Some times when I get a call or even when I call people the program is getting some random error and the call just dismiss and you have to kill the process and start it again before it works witch can be little enjoying. The same problem also happens when you are writing with someone, so I would be very glad if they might fix this. Another problem is that is pretty difficult to use your USB-microphone on Skype since it do not catch new hardware. So atm I am using my pre installed microphone on my laptop witch is not good at all.

So, overall I am glad that is exist but still… please try to upgrade it very soon, I need it!

Looking for download link? Just go to www.skype.com


Skype on Ipod touch

Tags: ,

I have just discovered that you can use Skype to your Ipod touch, and ofcource you have to buy a microphone to it. But since I never tried it I am interested in what you, visitor, have for experience of this. Is there any microphone that you can recommend to me? Do it work with regular microphones Skype-iPod-Touchor do I need to buy a specific one, for Ipod? Also, it works on every Ipod touch? I tried Skype without microphone and it worked excellent! Please give me your thoughts!