'php, codeigniter'에 해당되는 글 68건

RewriteEngine On
RewriteCond $1 !^(index\.php|images|captcha|data|include|uploads|robots\.txt)
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ /index.php/$1 [L]

출처 : http://www.jkun.net/300

<?
$week = array("일요일","월요일","화요일","수요일","목요일","금요일","토요일");
$date = date("Y-m-d");
echo $week[date('w',strtotime($date))];
?>

<?php
// Quote variable to make safe
function quote_smart($value)
{
	// Stripslashes
	if (get_magic_quotes_gpc()) {
		$value = stripslashes($value);
	}
	// Quote if not integer
	if (!is_numeric($value)) {
		$value = "'" . mysql_real_escape_string($value) . "'";
	}
	return $value;
}

// Connect
$link = mysql_connect('mysql_host', 'mysql_user', 'mysql_password')
	OR die(mysql_error());

// Make a safe query
$query = sprintf("SELECT * FROM users WHERE user=%s AND password=%s",
	quote_smart($_POST['username']),
	quote_smart($_POST['password']));

mysql_query($query);
?>

출처 : http://hoooow.tistory.com/m/post/151

WHERE CONCAT_WS(f_bill_title,f_bill_no,f_bill_daesu) like '%7%'
WHERE regexp_like(name,'AA|BB|DD')

if(eregi("\.\.|/", $filename )) {
	echo "상대경로로 접근할 수 없습니다.";
	exit;
}

출처 : http://m.blog.daum.net/_blog/_m/articleView.do?blogid=0YdvX&articleno=146#

<?php
// File and new size
$filename = 'source.jpg';
$percent = 0.5;

// Content type
// header('Content-Type: image/jpeg');

// Get new sizes
list($width, $height) = getimagesize($filename);
$newwidth = $width * $percent;
$newheight = $height * $percent;

// Load
$thumb = imagecreatetruecolor($newwidth, $newheight);
$source = imagecreatefromjpeg($filename);

// Resize
imagecopyresized($thumb, $source, 0, 0, 0, 0, $newwidth, $newheight, $width, $height);

// Output
imagejpeg($thumb, "target.jpg", 100);
?>