Help On PHP | Help Full PHP + JavaScript: 2011

Monday, 21 November 2011

Read the csv file and insert in mysql in php

<?php
if($_SERVER['REQUEST_METHOD']=='POST')
{

$cmpname='';
$uplpath=".";
$fname=$_FILES['upload']['name'];

move_uploaded_file($_FILES['upload']['tmp_name'],$uplpath."/".$fname);
$handle=fopen($uplpath."/".$fname,"r");
if($handle)
{
while(!feof($handle))
{
$str=fgets($handle,4096);
$arr=explode(',',$str);
$cnt = count($arr);
$cmp=$cmpname;
if($cnt>1)
{
$nm=$arr[0];
$mail=$arr[1];

echo $q="insert into test(name,email) values('$nm','$mail')";
$r=mysql_query($q) or die(mysql_error());
header("Location:result.php?suc=1");
}
}
}
else
{
$m=1;
}

}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<form action="" method="post" enctype="multipart/form-data">
<p>
<input type="file" name="upload" id="fileField" />
</p>
<p>
<input type="submit" name="button" id="button" value="Submit" />
</p>
</form>
</body>
</html>

Wednesday, 2 November 2011

How to hide folder without using any software?

cls
@ECHO OFF
title Folder Lock
if EXIST "Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}" goto UNLOCK
if NOT EXIST Lock goto MDLOCKER
:CONFIRM
echo Are you sure u want to Lock the folder(Y/N)
set/p "cho=>"
if %cho%==Y goto LOCK
if %cho%==y goto LOCK
if %cho%==n goto END
if %cho%==N goto END
echo Invalid choice.
goto CONFIRM
:LOCK
ren Lock "Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}"
attrib +h +s "Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}"
echo Folder locked
goto End
:UNLOCK
echo Enter password to Unlock folder
set/p "pass=>"
if NOT %pass%==enter your password here goto FAIL
attrib -h -s "Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}"
ren "Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}" Lock
echo Folder Unlocked successfully
goto End
:FAIL
echo Invalid password
goto end
:MDLOCKER
md Lock
echo Lock created successfully
goto End
:End

///

and then save it in .bat file and then run.

If you are run this file then if folder not exist there then automatically make .

Friday, 14 October 2011

Convert Varchar to Date Format in mysql

SELECT * FROM `tMembers` where str_to_date(sBirthDay,"%m/%d/%Y") between str_to_date('12/15/1985',"%m/%d/%Y") and str_to_date('09/22/1987',"%m/%d/%Y")

Wednesday, 7 September 2011

Youtube API(Upload video to our website)

First, download Zend Framework......

<?php

//debug
#error_reporting(E_ALL);

//include Zend Gdata Libs
require_once("Zend/Gdata/ClientLogin.php");
require_once("Zend/Gdata/HttpClient.php");
require_once("Zend/Gdata/YouTube.php");
require_once("Zend/Gdata/App/MediaFileSource.php");
require_once("Zend/Gdata/App/HttpException.php");
require_once('Zend/Uri/Http.php');

//yt account info
$yt_user = ' '; //youtube username or gmail account
$yt_pw = ' '; //account password
$yt_source = 'jh'; //name of application (can be anything)

//video path
$video_url = '1.mov';

//yt dev key
$yt_api_key = 'AI39s...'; //your youtube developer key

//login in to YT
$authenticationURL= 'https://www.google.com/youtube/accounts/ClientLogin';
$httpClient = Zend_Gdata_ClientLogin::getHttpClient(
$username = $yt_user,
$password = $yt_pw,
$service = 'youtube',
$client = null,
$source = $yt_source, // a short string identifying your application
$loginToken = null,
$loginCaptcha = null,
$authenticationURL);

$yt = new Zend_Gdata_YouTube($httpClient, $yt_source, NULL, $yt_api_key);

$myVideoEntry = new Zend_Gdata_YouTube_VideoEntry();
$filesource = $yt->newMediaFileSource($video_url);
$filesource->setContentType('video/quicktime'); //make sure to set the proper content type.
$filesource->setSlug('1.mov');

$myVideoEntry->setMediaSource($filesource);

$myVideoEntry->setVideoTitle('name');
$myVideoEntry->setVideoDescription('desc');
// Note that category must be a valid YouTube category !
$myVideoEntry->setVideoCategory('Comedy');

// Set keywords, note that this must be a comma separated string
// and that each keyword cannot contain whitespace
$myVideoEntry->SetVideoTags('cars, funny');

// Upload URI for the currently authenticated user
$uploadUrl = "http://uploads.gdata.youtube.com/feeds/users/$yt_user/uploads";
// Try to upload the video, catching a Zend_Gdata_App_HttpException
// if availableor just a regular Zend_Gdata_App_Exception

try {
$newEntry = $yt->insertEntry($myVideoEntry,
$uploadUrl,
'Zend_Gdata_YouTube_VideoEntry');
} catch (Zend_Gdata_App_HttpException $httpException) {
echo $httpException->getRawResponseBody();
} catch (Zend_Gdata_App_Exception $e) {
echo $e->getMessage();
}

//this outputs a ton of garbage. not sure what to do with it yet.

/*echo "

" . var_dump($newEntry) . "

";
echo "

";*/

$state = $newEntry->getVideoState();

if ($state) {
ehco 'Upload status for video ID ' . $newEntry->getVideoId() . ' is ' .
$state->getName() . ' - ' . $state->getText() . "\n";

} else {
echo "Not able to retrieve the video status information yet. " .
"Please try again later.\n";

}

?>

Friday, 19 August 2011

Display data dynamically in Matrix format using PHP with pagination

<?php
$per_page = 6;
$display_columns = 3;
$page = isset($_GET['page']) ? (int) $_GET['page'] : 1;
$pages = implode(mysql_fetch_assoc(mysql_query("SELECT COUNT(*) FROM projects")));
//$pages= $pages/$display_columns;
$pages = ceil($pages / $per_page);
$querystring = "";
foreach ($_GET as $key => $value) {
if ($key != "page") $querystring .= "$key=$value&";
}
echo "Pages: ";
for ($i = 1; $i <= $pages; $i++) {
echo "<a " . ($i == $page ? "class=\"selected\" " : "");
echo "href=\"?{$querystring}page=$i";
echo "\">$i</a> ";
}
$i="";

$sqlm="select * from projects LIMIT " . (($page - 1) * $per_page) . ", $per_page";
$rsm=mysql_query($sqlm) or die("Database Error".mysql_error());
$count = mysql_num_rows($rsm);
$padding = ($display_columns-1)-(($count-1)%$display_columns);
echo '<table cellpadding=10>';
while($row=mysql_fetch_array($rsm))
{

if($i%$display_columns == 0)
echo '<tr>';
echo '<td>';

$id=$row["id"];
$in_sql="select * from projects where id=$id";
$r=mysql_query($in_sql) or die("Database Error".mysql_error());
if($rw=mysql_fetch_array($r))
{
$image=$rw['img'];
}

?>
<td>
<img src="admin/pages/Upload/<?=$image; ?>" width="160" height="160" style="border:#999;border:double"><br />
<h4><a href="projects_view.php?id=<?=$id?>"><?=$rw['title'];?></a></h4><h4 align="center"><?=$rw['cat_id'];?></h4>
</td>
<?
echo '</td>';

if($i%$display_columns == $display_columns-1)
echo '</tr>';
$i++;
}
if($padding!=0)
{
for($i=0;$i<$padding;$i++)
echo '<td></td>';
echo '</tr>';
}
echo '</table>';

?>

Tuesday, 19 July 2011

VB.NET Connection String

Imports System.Data.OleDb

Public Class Form1
Dim connetionString As String
Dim conn As OleDbConnection

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
connetionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\USER\Documents\Database3.accdb"
conn = New OleDbConnection(connetionString)
Try
conn.Open()
MsgBox("Done")
conn.Close()
Catch ex As Exception
MsgBox("Not Done")

End Try

End Sub
End Class

Saturday, 16 July 2011

PHP: Mail with HTML and mail() function.

<?php
include ("include/config.php");

$fname=$_POST['name'];
$email="From:".$_POST['email'];
$comp=$_POST['company'];
$msg1=$_POST['message'];

$tomail="swapn_developers@yahoo.com";
$msg="Company Name : " .$comp."
"."Message : " .$msg1;

$headers = "From: $email\r\n";
$headers .= "Content-type: text/html\r\n";

mail($tomail,"Contact Us Message",$msg,$headers);
?>

How to Download Image , txt file or any file without save as or without open in php?

<?php

$file=$_GET['file'];//get the file name

//$file = 'monkey.gif';

if (file_exists($file)) {
header('Content-Description: File Transfer');
header('Content-Type: application/octet-stream');
header('Content-Disposition: attachment; filename='.basename($file));
header('Content-Transfer-Encoding: binary');
header('Expires: 0');
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Pragma: public');
header('Content-Length: ' . filesize($file));
ob_clean();
flush();
readfile($file);
exit;
}
?>

Friday, 15 July 2011

AJAX-Passing the multiple value to another page.

Wednesday, 13 July 2011

INNER JOIN in MYSQL

SELECT * FROM shipping_name as sn INNER JOIN region_shipping as rs ON (rs.ship_id=sn.id) where rs.reg1!='' and rs.reg_1!='' or rs.reg2!='' and rs.reg_2!='' or rs.reg3!='' and rs.reg_3!='' or rs.reg4!='' and rs.reg_4!='' or rs.reg5!='' and rs.reg_5!='' or rs.reg6!='' and rs.reg_6!='' and sn.ship_price!=''

Tuesday, 5 July 2011

bb-press customize login module

if ( !function_exists('bb_check_login') ) :
function bb_check_login($user, $pass, $already_md5 = false) {
global $wp_users_object;

if ( !bb_get_option( 'email_login' ) || false === strpos( $user, '@' ) )
{ // user_login
$user = $wp_users_object->get_user( $user, array( 'by' => 'login' ) );

} else { // maybe an email
echo $email_user = $wp_users_object->get_user( $user, array( 'by' => 'email' ) );
echo "
".$user = $wp_users_object->get_user( $user, array( 'by' => 'login' ) );

// 9 cases. each can be FALSE, USER, or WP_ERROR
if (
( !$email_user && $user ) // FALSE && USER, FALSE && WP_ERROR
||
( is_wp_error( $email_user ) && $user && !is_wp_error( $user ) ) // WP_ERROR && USER
) {
// nope: it really was a user_login
// [sic]: use $user
} elseif (
( $email_user && !$user ) // USER && FALSE, WP_ERROR && FALSE
||
( $email_user && !is_wp_error( $email_user ) && is_wp_error( $user ) ) // USER && WP_ERROR
) {
// yup: it was an email
$user =& $email_user;
} elseif ( !$email_user && !$user ) { // FALSE && FALSE
// Doesn't matter what it was: neither worked
return false;
} elseif ( is_wp_error( $email_user ) && is_wp_error( $user ) ) { // WP_ERROR && WP_ERROR
// This can't happen. If it does, let's use the email error. It's probably "multiple matches", so maybe logging in with a username will work
$user =& $email_user;
} elseif ( $email_user && $user ) { // USER && USER
// both are user objects
if ( $email_user->ID == $user->ID ); // [sic]: they are the same, use $user
elseif ( bb_check_password($pass, $user->user_pass, $user->ID) ); // [sic]: use $user
elseif ( bb_check_password($pass, $email_user->user_pass, $email_user->ID) )
$user =& $email_user;
} else { // This can't happen, that's all 9 cases.
// [sic]: use $user
}
}

if ( !$user )
return false;

if ( is_wp_error($user) )
return $user;

if ( !bb_check_password($pass, $user->user_pass, $user->ID) )
return false;

// User is logging in for the first time, update their user_status to normal

MSP Selection-2010

I am Finaly Selected in Microsoft Student Partners 2010..so I am Happy....

Sunday, 6 February 2011

Micosoft Tech Vista 2011

This is good experience for me and I know about the new technologies of the Microsoft.