Enable E-mail In PHP – Win

Table of content

• What Will You Need?
• Set Up Sendmail
• Change php.ini
• Conclusion

This will be a quick tutorial that will show you how to enable e-mail function in PHP on Windows.

Read the rest

PHP DomDocument Tutorial

Table of content

• Load Document
• Loop Through XML
• Retrieve Specific Element
• Conclusion

This will be a quick tutorial that will show you how to use PHP’s DOMDocument to parse your XML so you do not have to use XML parser. In this tutorial you’ll see how to loop through your XML file and how to extract some specific data. For this, we will use XML file that is available on w3school.com.

Read the rest

PHP Confirm Registration Link

Table of content

• File Structure
• Database Table
• Bootstrap And Config
  • config.php
  • db.php
  • bootstrap.php
• Home page
• Registration
• Confirming E-mail
• Logging in
• Logging out
• Conclusion

This will be quick tutorial on how you can implement confirm registration link into your PHP application. This will not be anything fancy, just simple HTML and PHP to show you how this work and one way how it can be implemented.

Read the rest

AJAX Multi-Level Comments

Table of content

• Intro
• Folder Structure
• MySQL Table
• Html And Css
  • main.css
  • index.php
• AJAX And Javascript
• Event Listeners For `Reply` Link
• Event Listener For Comment Submitting
• Generating Comments
• Saving Comments And AJAX
• Conclusion

In this tutorial we will create multi level comments. You must have seen comments on youtube and that they have levels depending on who replied to who. That’s exactly what we will build.

Read the rest

Permissions Using Bitwise

Table of content

• Bitwise operators
  • How do they work?
  • And operator (`&`)
  • Or operator (`|`)
  • Not operator (`~`)
• Defining permissions
• Create user classes
• Check if user can
• Test all roles and permissions

This will be a quick tutorial on how to use bitwise operators in PHP to create permissions control. Some of next tutorials will cover how to implement it in application and how to use database to store permissions for users. Now some basics.

Read the rest

Sql Queries Cache

Table of content

• Main Class
  • Variables And Constants
  • Methods
    • __construct
    • lifeTime
    • query
    • type
    • cacher
• Autoload
• Interface
• Cacher_Sql
  • Variables
  • Methods
    • __construct
    • setSql
    • setLifeTime
    • cleanCache
    • cacheLoad
    • cacheSave
• Testing
• Select all records
• Some compley query (JOIN)
• Conclusion

This will be intermediate tutorial about caching SQL query results. We will use interface to make support for extending available ways of caching your results. We will create cache that will use MySQL database and flat text files to store cache.

Read the rest

MySQL Quite Complex Queries

Table of content

• Longest entry
• Users and categories
• Conclusion

I’ve read an article about database design. It’s very simple but I try to design my databases/tables following that article. But there is one thing that is also important. You need to design your tables and their relations so that you can get almost everything your need with as much queries as possible. This is a part that MySQL-s complex queries are very useful. In two last jobs that I did I needed to optimize script as much as possible. One project is a plugin for Wordpress that I’m currently working on. When ever I do something I give my best to do it right and I really try to design relations and queries very good. Here are some examples of queries that I needed.

Read the rest

Advanced PHP User Login

Table of content

• What is TAN?
• Set up
• Markup and CSS
• Config and database connection
• AJAX Submit
• Validate Log In
• Creating new user
• Conclusion

If you ever had a bank account you are familiar with TAN-s (Transaction Authentication Number). What we will do today, is create user login using that kind of system. This will be just simple overview how to do it so you can create more complex and secure login systems. You need to have basic knowledge about classes, HTML, CSS and AJAX because I will not explain in depth what I do.

Read the rest

Where to post tutorials

When writing tutorials you want that they are seen by a lot of people. For that i use 7 internet pages where i publish links to them. Process is simple. Write few information, provide post url, press submit button and your tutorial is in their database. I’ll write something about for 3 of them because they have a lot of visitors.

Read the rest

Multi-query function

I needed a function that will take a string or a file and then split it into small SQL queries. I found few functions on Internet but they did not work as i expected. They all had following principle of work:

1. Take a string
2. Use function explode and “;” as a delimiter to create an array
3. Execute each row in array

Read the rest