15seconds

Day: February 3, 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/

  • SQL injection and eliminate script from table column and reduce transaction log

    ​SQL 인젝션 공격을 당했을 경우 인젝션 스크립트 지우는 저장 프로시저

    http://m.blog.naver.com/khihome/40114387404
    SQL Server 트랜잭션 로그 줄이기
    http://m.blog.naver.com/khihome/40114384771

  • 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

  • php korean encoding

    ​php 한글 인코딩

     

    http://junny1909.tistory.com/205
    asp to php converter
    http://www.resources.fortunedesign.co.uk/jspack/asp2php.html
    php pdo class
    http://codereview.stackexchange.com/questions/3806/pdo-wrapper-class

  • ​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/

  • windows musthave package

    ​Windows 필수 패키지

    무료 프로그램으로 더욱 다양해지는 Windows 기능.
    http://windows.microsoft.com/ko-kr/windows/essentials