Pages

Tuesday, December 6, 2011

How to Convert, Cut, Trim, Re-size and Download any video from YouTube even on simple java based mobile. New trick revealed

I am going to give this tutorial by using which you can Download and Play any to your mobile.

First it is better to use multitab mobile browser like opera or ucweb browser


1)  Step 1 is very simple go to YouTube watch page in mobile version or simple desktop version



2) Then go to browser "Action" page to copy the URL

Step a)


Step b)



Step c)



Now your YouTube URL is Copied !


3)  Go to this website where you can convert your link to 3GP, MP4, MP3 etc in ANY DIMENSION YOU WANT LIKE 320*240 144 etc i don't remember now http://video.online-convert.com or type goo.gl/BVPy in web address


Step a) : Select the type you want to convert into.



Step b) Now paste the YouTube URL to this page
 
REMEMBER WE WANT ONLY SOME PART OF URL TRIM IT AFTER PASTING. IT SHOULD LOOK LIKE THIS http://www.youtube.com/watch?v=5pMOS9zC5GM

YOU COPIED = http://m.youtube.com/watch?gl=IN&hl=en&client=mv-google&v=NrXdauEv9HY 

YOU NEED = http://youtube.com/watch?v=NrXdauEv9HY




Step c)

Select size

4) Click "Convert" now it will show that your file is in process BUT DON'T WAIT JUST PUT YOUR EMAIL THEY WILL SEND DIRECT DOWNLOAD LINK TO YOUR MAIL JUST CLICK THEN DOWNLOAD



5) Open GMAIL or your mail on mobile after 1-2 Minutes. Check the link and click to download converted file.


 Excellent Feature no 1) as you are are just giving link so now upload data will be used :) only converted file data is used when you download it 
 Excellent Feature no 2) It is really fast as you are working on a super computer with converter installed I think may be they are having it :)




Thats It! any thing left ? Please let me know via comments you can subscribe to this blog oops there is no feed right now :)

Wednesday, November 16, 2011

How to show link title in other local languages like punjabi, hindi

Some sites which use local languages can't use title attributes of anchor tag  in some text as it starts showing BOXES in place of text.



So here is the solution





















Use BELOW CSS code



<style type="text/css">
a.tooltip span {display:none; padding:1px 1px; margin-left:60px;}
a.tooltip:hover span{display:inline; position:absolute; border:1px solid #000000; font-size:12px; background:#FFFFE1; color:#000000; box-shadow: 2px 2px 1px #888888;}
</style>


And use below code Where we want to show tooltip



<a href="#" class="tooltip"; > Hover Here <span> Tool tip Msg HRERE </span> </a>



I hope this would be the best solution :)

Also published on BloggerPlugnPlay.blogspot.com

Thursday, October 20, 2011

Way2sms Direct send sms link API send sms by just putting values in this link

http://demo.samplephpcodes.com/sms/way2sms.php?uid=USERNAME&pwd=PASSWORD&phone=MOB&msg=MSG

Way2sms direct login link just go to this link and get logged in !

http://site5.way2sms.com/content/index.html/Login1.action?username=Enter_User_Name &password=PASSWORD

Thursday, September 22, 2011

How to connect your JSP page with mysql database to create, insert and update tables

I am using Netbeans IDE 6.8 so the tutorial also based on that software

here we go

Requirements:

Download Connector/J 

Must have Mysql database installed

Step 1:


Extract Connector/J  and copy "mysql-connector-java-5.1.17-bin.jar" file and paste it in " apache-tomcat-5.5.33\apache-tomcat-5.5.33\common\lib "

NOTE : if you have more than such files in "apache-tomcat-5.5.33" folder than it will clash resulting connection failure


Step 2:


Paste below code to connect




        <%


                    String connectionURL = "jdbc:mysql://localhost:3306/Database_Name";
                    Connection connection = null;
                    Statement statement = null;
  try {


                        Class.forName("com.mysql.jdbc.Driver").newInstance();
                        connection = DriverManager.getConnection(connectionURL, "root", "pass");
                        statement = connection.createStatement();
                        String QueryString =
                                "create table new_Table (id int not null auto_increment,name " + "varchar(25),city varchar(20), primary key(id));";
                        statement.executeUpdate(QueryString);





                    out.print("Query Has Successfully Executed !");
 }
 catch (Exception ex) 
{
                    out.print("Can not execute query");
}
        %>



Above query will create a table "new_Table" in Database_Name

 Spares Parts


To Create Table Use:



String QueryString =  "create table user_master(id int not null auto_increment,name " + "varchar(25),city varchar(20), primary key(id));";



To Insert Table Use:


String QueryString = "INSERT INTO user_master (name, city) VALUES ( 'Name', 'Chd )";


To Update Table Use:


String QueryString = "UPDATE user_master SET name = 'jolly.exe', city = 'CHD' WHERE id = 2";

AD