Month: February 2016

Microsoft IIS 7.0 and later with php 7

​

Microsoft IIS 7.0 and later with php 7
http://php.net/manual/kr/install.windows.iis7.php#install.windows.iis7
http://php.net/manual/kr/mysql.installation.php
mysqli vs PDO drivers
http://code.tutsplus.com/tutorials/pdo-vs-mysqli-which-should-you-use–net-24059
php 한글 manual
http://php.net/manual/kr/
deprecated in php7 – php_mysql.dll
https://wiki.php.net/rfc/remove_deprecated_functionality_in_php7
mysqli_pagenation.php
https://www.developphp.com/video/PHP/Pagination-MySQLi-Google-Style-Paged-Results-Tutorial
http://www.9lessons.info/2010/10/pagination-with-jquery-php-ajax-and.html
http://www.phpgang.com/how-to-create-advance-pagination-in-php-mysql-with-jquery_404.html
PDO_pagenation.php
http://www.phpro.org/tutorials/Pagination-with-PHP-and-PDO.html
http://www.phpro.org/tutorials/Filtering-Data-with-PHP.html

MySQL Workbench localhost connection errors

​mysql localhost 접속 오류시

MySQL Workbench에서 localhost 접속시 can’t connect Mysql 5.* server on ‘127.0.0.1’ (10061) 접속 오류 해결 방법
https://dukeom.wordpress.com/2011/08/12/mysql-workbench%EC%97%90%EC%84%9C-localhost-%EC%A0%91%EC%86%8D%EC%8B%9C-cant-connect-mysql-5-server-on-127-0-0-1-10061-%EC%A0%91%EC%86%8D-%EC%98%A4%EB%A5%98-%ED%95%B4%EA%B2%B0-%EB%B0%A9/

Remote Desktop Black screen Windows Server 2008 r2

​

Remote Desktop Black screen Windows Server 2008 r2
Nick van Vuren
29/08/2014   No
Comments on Remote Desktop Black screen Windows
Server 2008 r2
When a users tries to log on, the workstation or server hangs on a blank
screen/black screen.
With the administrator account, i found in the registry the following
Warning:
EVENT ID 4006
The Windows logon process has failed to
spawn a user application. Application name: . Command line parameters:
C:\Windows\system32\userinit.exe.
To fix this issue, i had to add the groups NT AUTHORITY\Authenticated Users
and the NT AUTHORITY\INTERACTIVE to the local group “Users”.
After this, the user was able to log on again and the Desktop did show
up.

Set database from SINGLE USER mode to MULTI USER

​

Set database from SINGLE USER mode to MULTI USER
use master
GO
declare @sql as varchar(20), @spid as int
select @spid = min(spid) from master..sysprocesses where dbid = db_id(‘sample’) and spid != @@spid
while (@spid is not null)
begin
print ‘Killing process ‘ + cast(@spid as varchar) + ‘ …’
set @sql = ‘kill ‘ + cast(@spid as varchar)
exec (@sql)
select
@spid = min(spid)
from
master..sysprocesses
where
dbid = db_id(‘sample’)
and spid != @@spid
end
ALTER DATABASE DB_NAME SET MULTI_USER; GO
———————————————–
select
    d.name,
    d.dbid,
    spid,
    login_time,
    nt_domain,
    nt_username,
    loginame
from sysprocesses p
    inner join sysdatabases d
        on p.dbid = d.dbid
where d.name = ‘sample’
GO
You can add the option to rollback your change immediately.
ALTER DATABASE DB_NAME
SET MULTI_USER
WITH ROLLBACK IMMEDIATE
USE master;
GO
ALTER DATABASE sample
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
GO
ALTER DATABASE sample
SET READ_ONLY;
GO
ALTER DATABASE sample
SET MULTI_USER;
GO
–Make Database Read Only
USE [master]
GO
ALTER DATABASE sample SET READ_ONLY WITH NO_WAIT
GO
–Make Database Read/Write
USE [master]
GO
ALTER DATABASE sample SET READ_WRITE WITH NO_WAIT
GO

ms sql server database restore

​데이타베이스 복원.

http://m.blog.naver.com/mavis5/10079514586
https://msdn.microsoft.com/ko-kr/library/ms189272(v=sql.120).aspx
— 복구 준비
USE MSDB
GO효
— 백업파일 확인 (TYPE:D – 풀, L – 로그, I – 차등백업)
SELECT BACKUP_START_DATE, TYPE, DATABASE_NAME, PHYSICAL_DEVICE_NAME
FROM MSDB.DBO.BACKUPSET A JOIN MSDB.DBO.BACKUPMEDIAFAMILY B ON A.MEDIA_SET_ID = B.MEDIA_SET_ID
WHERE DATABASE_NAME = ‘ELOC2001’
AND  BACKUP_START_DATE > GETDATE() – 2
ORDER BY BACKUP_START_DATE DESC
— 풀백업 파일 정보 확인
RESTORE HEADERONLY FROM DISK = @FILEPATH –‘L:\SQL_BACKUP\AAA.FULL
RESTORE FILELISTONLY FROM DISK = @FILEPATH –‘L:\SQL_BACKUP\AAA.FULL
— 복구 진행
USE MASTER
GO
— 복구모델이 SIMPLE인경우
 — 1. 풀백업 복구 백업진행
 RESTORE DATABASE @DB_NAME
  FROM DISK = @FILEPATH WITH  NORECOVERY
  –, REPLACE — 복구시 기존 파일 교체할 때
  –, MOVE ‘@LOGICAL_NAME’ TO ‘@PYSICAL_PATH’ — 복구시 파일 위치 변경할 때
 — 2. 차등백업 복구 (해당하는경우 만)
 RESTORE DATABASE @DB_NAME
  FROM DISK= @FILEPATH WITH NORECOVERY
 — 3. 복구 마무리
 RESTORE DATABASE @DB_NAME WITH RECOVERY
 — 4. 다중 사용자로 변경
 ALTER DATABASE @DB_NAME SET MULTI_USER
— 복구모델이 FULL, BULK_LOGGED인경우 (차등백업, 로그백업 사용한다)
 — 0. 비상로그 백업 : 마지막 로그 백업로 사용
 BACKUP LOG @DB_NAME TO DISK = @FILEPATH
  WITH NORECOVERY — db상태를 복구중으로 변경한다 -> DB 변경사항 없게 한다!
  –, { CONTINUE_AFTER_ERROR | NO_TRUNCATE }
 — 1. 풀백업 복구
 RESTORE DATABASE @DB_NAME  FROM DISK = @FILEPATH WITH  NORECOVERY
  –, MOVE ‘@LOGICAL_NAME’ TO ‘@PYSICAL_PATH’ — 복구시 파일 위치 변경할 때
 — 2. 차등백업 복구 (해당하는경우 만)
 RESTORE DATABASE @DB_NAME  FROM DISK= @FILEPATH WITH NORECOVERY
 — 3. 로그백업 복구
 RESTORE LOG @DB_NAME  FROM DISK=@LOG_BAL_FILE_1_PATH WITH NORECOVERY
 RESTORE LOG @DB_NAME  FROM DISK=@LOG_BAL_FILE_2_PATH WITH NORECOVERY
 RESTORE LOG @DB_NAME  FROM DISK=@LOG_BAL_FILE_3_PATH WITH NORECOVERY
 RESTORE LOG @DB_NAME  FROM DISK=@LOG_BAL_FILE_4_PATH WITH NORECOVERY–, STOPAT = ‘0000-00-00 00:00:00.000’ — 지정시간 복구
 — 4. 복구 마무리
 RESTORE DATABASE @DB_NAME WITH RECOVERY
 — 5. 다중 사용자로 변경
 ALTER DATABASE @DB_NAME SET MULTI_USER

​Using MySQL Stored Procedures with PHP mysql/mysqli/pdo

​Using MySQL Stored Procedures with PHP mysql/mysqli/pdo

http://www.joeyrivera.com/2009/using-mysql-stored-procedures-with-php-mysqlmysqlipdo/
http://www.mysqltutorial.org/php-calling-mysql-stored-procedures/
Connection string save to non web folder “……..
class.pdo.db.php
http://culttt.com/2012/10/01/roll-your-own-pdo-php-class/
https://gist.github.com/skhani/5aebd11015881fb3d288
http://culttt.com/2012/09/24/prevent-php-sql-injection-with-pdo-prepared-statements/
PDO
http://codereview.stackexchange.com/questions/3806/pdo-wrapper-class

jquery Multi file upload preview

​jquery Multi file upload preview

 

http://www.fyneworks.com/jquery/multifile/#Usage
http://www.raymondcamden.com/2013/09/10/Adding-a-file-display-list-to-a-multifile-upload-HTML-control
http://www.formget.com/upload-multiple-images-using-php-and-jquery/
CAPTCHA php
http://www.codeproject.com/Articles/26595/CAPTCHA-Image-in-PHP

​

https://ellislab.com/codeigniter/user-guide/libraries/file_uploading.html
http://www.tutorialchip.com/php-upload-class/#tab-download
http://www.heylove.de/
http://jindo.dev.naver.com/smarteditor/user_guide/