Home » Archive by category Tech

Use the PHP addslashes function to fix SQL INSERT problems

More PHP MySQL FAQ: Can you share an example of how to use the PHP addslashes function when creating a SQL INSERT statement? When you’re inserting records into a database table with plain PHP (as opposed to using a PHP framework), some of the fields you’re inserting may have characters...
Continue reading

메이븐 (maven) 설치 및 이클립스 연동하기

메이븐은 다음 사이트에서 다운로드 받을 수 있다. http://maven.apache.org/download.html       다운로드 페이지에서 Maven 3.0.4 (Binary zip) – apache-maven-3.0.4-bin.zip 을 다운 받는다. (현재 최신버전) 다운받은 zip 파일을 원하는 경로로 이동하여 압축해제 한다.        환경변수 등록 및 확인      다음으로 maven을 환경변수에 등록하여야 한다. 컴퓨터 –...
Continue reading

4 ways to delete mapped network drives in Windows

more   3. Use Windows/File Explorer to remove a network location mapping from your PC by erasing its shortcut A network location mapping is actually a shortcut stored as a file on your Windows PC. If you can’t delete it using the first method we’ve shown, you can...
Continue reading

PHP Validation And Verification

https://www.phpjabbers.com/php-validation-and-verification-php27.html   Now we have to set this class to apply for every character that we enter. So we add a (+) plus sign after our class definition. We are still missing something. We have not defined the range of our validation test. We have to set which...
Continue reading

OpenCart 2 Search Engine Friendly URLs

Search engine friendly (SEF), human-readable or clean URLs are URLs that make sense to both humans and search engines because they explain the path to the particular page they point to. Using SEF URLs you can convert the standard URLs such as:   http://mydomain.com/index.php?route=product/category&path=20   to their SEO equivalent:...
Continue reading

SQL datetimeconversion

more Execute the following T-SQL scripts in Microsoft SQL Server Management Studio (SSMS) Query Editor to demonstrate T-SQL CONVERT and CAST functions in transforming string SQL date formats, string time & string datetime data to datetime data type. Practical examples for T-SQL DATE / DATETIME functions. — SQL...
Continue reading

오픈 소스 무료 쇼핑몰 프로그램

오픈 소스 무료 쇼핑몰프로그램   해외   l  마젠토(Magento) : 100만건 이상의 다운로드를 기록한 무료 오픈 소스 온라인스토어 http://www.magentocommerce.com/download 설치 블로그 : http://chez.egloos.com/1861931 http://maeon.com/install/magento-install   l  오에스커머스(OSCommerce) : 독일에서 개발한 무료 오픈 소스 온라인 스토어 소프트웨어 http://www.oscommerce.com/Products 설치방법 : http://maeon.com/install/oscommerce-install   l  젠카트(ZenCart) : osCommerce 에서 파생 오픈...
Continue reading

NET Framework Data Provider for SQL Server connection strings

more   Standard Security Server=myServerAddress;Database=myDataBase;User Id=myUsername; Password=myPassword; SQL Server 2000 SQL Server 2005 SQL Server 2008 SQL Server 2012 SQL Server 7.0 Trusted Connection Server=myServerAddress;Database=myDataBase;Trusted_Connection=True; SQL Server 2000 SQL Server 2005 SQL Server 2008 SQL Server 2012 SQL Server 7.0 Connection to a SQL Server instance The server/instance...
Continue reading

How to: Create or Add a Setup Project

https://msdn.microsoft.com/en-us/library/19x10e5c(v=vs.100).aspx To create a new setup project On the File menu, point to Add, then click New Project. In the resulting Add New Project dialog box, in the Project Types pane, open the Other Project Types node, open Setup and Deployment Projects, and select Visual Studio Installer. In the...
Continue reading