Access to all membership facilities to Admin

 Pro Membership

 

   function pmmpro_allow_access_for_admins($hasaccess, $mypost, $myuser,       $post_membership_levels){
  
  //If user is an admin allow access.
if( current_user_can( 'manage_options' ) ){
$hasaccess = true;
} 
return $hasaccess;
}
add_filter('pmpro_has_membership_access_filter', 'pmmpro_allow_access_for_admins', 30, 4); 

Redirect Non Members to any page in pro Membership

 <?php function my_redirect_nonmembers() {

// Make sure PMPro is active.

if ( ! function_exists( 'pmpro_hasMembershipLevel' ) ) {

return;

}

// Ignore members. Change to check for specific levels.

if ( pmpro_hasMembershipLevel() ) {

return;

}

global $post;

if( ! is_admin() && ! empty( $post->ID ) ) {

if( $post->post_type == "page" || $post->post_type == "podcast-video" ) {

//check if the user has access to the parent

if( ! pmpro_has_membership_access( $post->ID ) ) {

wp_redirect( pmpro_url( "levels" ) );

exit;

}

}

}

// Update this array.

$not_allowed = array(

"/members/",

"/groups/",

"/groups/create/",

);

// Get the current URI.

$uri = $_SERVER['REQUEST_URI'];

// If we're on one of those URLs, redirect away.

foreach( $not_allowed as $check ) {

if( strpos( strtolower( $uri ), strtolower( $check ) ) !== false ) {

// Go to levels page. Change if wanted.

wp_redirect( pmpro_url( 'levels' ) );

exit;

}

}

}

add_action( 'template_redirect', 'my_redirect_nonmembers' );

What is jQuery?

 jQuery is a fast, small, and feature-rich JavaScript library. It makes things like HTML document traversal and manipulation, event handling, animation, and Ajax much simpler with an easy-to-use API that works across a multitude of browsers. With a combination of versatility and extensibility, jQuery has changed the way that millions of people write JavaScript.

Basic syntax is: $(selector).action()

• A $ sign to define/access jQuery
• A (selector) to "query (or find)" HTML elements
• A jQuery action() to be performed on the element(s)

Examples:

$(this).hide() - hides the current element.

$("p").hide() - hides all <p> elements.

$(".test").hide() - hides all elements with class="test".

$("#test").hide() - hides the element with id="test".

EXAMPLE: 

$(document).ready(function(){

   // jQuery methods go here...

});

Code to create Api key in PHP.

 An API key is used by a lot of Web API to provide a form of access control. The key usually is linked to the identity of the API user as well as bundle of rights like a quota or areas of the APIs which are open for access to that key

Example::

<?php


// get the HTTP method, path and body of the request

$method = $_SERVER['REQUEST_METHOD'];

$request = explode('/', trim($_SERVER['PATH_INFO'],'/'));

$input = json_decode(file_get_contents('php://input'),true);


// connect to the mysql database

$link = mysqli_connect('localhost', 'root', 'root', 'myDB');

mysqli_set_charset($link,'utf8');


// retrieve the table and key from the path

$table = preg_replace('/[^a-z0-9_]+/i','',array_shift($request));

$key = array_shift($request)+0;


// escape the columns and values from the input object

$columns = preg_replace('/[^a-z0-9_]+/i','',array_keys($input));

$values = array_map(function ($value) use ($link) {

  if ($value===null) return null;

  return mysqli_real_escape_string($link,(string)$value);

},array_values($input));


// build the SET part of the SQL command

$set = '';

for ($i=0;$i<count($columns);$i++) {

  $set.=($i>0?',':'').'`'.$columns[$i].'`=';

  $set.=($values[$i]===null?'NULL':'"'.$values[$i].'"');

}


// create SQL based on HTTP method

switch ($method) {

  case 'GET':

    $sql = "select * from `myform`".($key?" WHERE id=$key":''); break;

  case 'PUT':

    $sql = "update `myform` set $set where id=$key"; break;

  case 'POST':

    $sql = "insert into `myform` set $set"; break;

  case 'DELETE':

    $sql = "delete `myform` where id=$key"; break;

}


// excecute SQL statement

$result = mysqli_query($link,$sql);


// die if SQL statement failed

if (!$result) {

  http_response_code(404);

  die(mysqli_error());

}


// print results, insert id or affected row count

if ($method == 'GET') {

  if (!$key) echo '[';

  for ($i=0;$i<mysqli_num_rows($result);$i++) {

    echo ($i>0?',':'').json_encode(mysqli_fetch_object($result));

  }

  if (!$key) echo ']';

} elseif ($method == 'POST') {

  echo mysqli_insert_id($link);

} else {

  echo mysqli_affected_rows($link);

}


// close mysql connection


mysqli_close($link);

?>

WEB STRATEGY

 

Web Design and Website Development

Go beyond brochure-ware, create websites that drive traffic, leads and conversions in eCommerce platforms like Magento, WooCommerce and Shopify and open-source CMS's like WordPress and Drupal.

Web designers must always begin by considering a client’s website objectives and then move on to an Information Architecture (IA) to set a website’s information hierarchy and help guide the design process. Next, web designers can start creating wireframes and finally move to the design stage. Web designers may use several basic design principles to achieve an aesthetically pleasing layout which also offers excellent user experience.

 Important points related to web design. 

•  It’s important for web designers to create a balanced layout. In web design we refer to heavy (large and dark colors) and light (small and lighter colors) elements. 
• Using the correct proportion of each is critical to achieving a balanced website design. In color theory, contrasting colors are ones placed opposite one another on the color wheel (see also complementary colors). 
• Web design offers a few other areas where contrast is applicable.
•  Designers look at contrasting sizes, textures and shapes to define and draw attention to certain sections of the website. 
•  We touched on this a bit when discussing contrast. Emphasis is a design principles founded in the intentional “highlighting” of certain important elements of the website layout. 
• It’s important to note that if you emphasize everything on the page you end up emphasizing nothing. Imagine a page in a book where 80% of the content is highlighted in yellow.
• Also called repetition or rhythm, consistency is a critical web design principle. For example, clean and consistent navigation provides the best user experience for your website visitors.

MYSQL Delete Query

 If you want to delete a record from any MySQL table, then you can use the SQL command DELETE FROM. You can use this command at the mysql> prompt as well as in any script like PHP.

Syntax

The following code block has a generic SQL syntax of the DELETE command to delete data from a MySQL table.

DELETE FROM table_name [WHERE Clause]

• If the WHERE clause is not specified, then all the records will be deleted from the given MySQL table.
• You can specify any condition using the WHERE clause.
• You can delete records in a single table at a time.

The WHERE clause is very useful when you want to delete selected rows in a table.

Deleting Data Using a PHP Script

You can use the SQL DELETE command with or without the WHERE CLAUSE into the PHP function – mysql_query(). This function will execute the SQL command in the same way as it is executed at the mysql> prompt.

Example

Try the following example to delete a record from the tutorial_tbl whose tutorial_id is 3.

<?php
   $dbhost = 'localhost';
   $dbuser = 'root';
   $dbpass = '';
   $conn = mysql_connect($dbhost, $dbuser, $dbpass);
   
   if(! $conn ) {
      die('Could not connect: ' . mysql_error());
   }

   $sql = 'DELETE FROM tutorials_tbl WHERE tutorial_id = 3';

   mysql_select_db('TUTORIALS');
   $retval = mysql_query( $sql, $conn );

   if(! $retval ) {
      die('Could not delete data: ' . mysql_error());
   }
   echo "Deleted data successfully\n";
   mysql_close($conn);
?>

Delete Record From Datatbase Using MYSQL

 The SQL DELETE command is used to delete rows that are no longer required from the database tables. It deletes the whole row from the table. Delete command comes in handy to delete temporary or obsolete data from your database.The DELETE command can delete more than one row from a table in a single query. This proves to be advantages when removing large numbers of rows from a database table.

 Once a row has been deleted, it cannot be recovered. It is therefore strongly recommended to make database backups before deleting any data from the database. This can allow you to restore the database and view the data later on should it be required.

Syntax

The following code block has a generic SQL syntax of the DELETE command to delete data from a MySQL table.

DELETE FROM table_name [WHERE Clause]

• If the WHERE clause is not specified, then all the records will be deleted from the given MySQL table.
• You can specify any condition using the WHERE clause.
• You can delete records in a single table at a time.

The WHERE clause is very useful when you want to delete selected rows in a table.

Deleting Data from the Command Prompt

This will use the SQL DELETE command with the WHERE clause to delete selected data into the MySQL table – tutorials_tbl.

Example

The following example will delete a record from the tutorial_tbl whose tutorial_id is 3.

root@host# mysql -u root -p password;
Enter password:*******

mysql> use TUTORIALS;
Database changed

mysql> DELETE FROM tutorials_tbl WHERE tutorial_id=3;
Query OK, 1 row affected (0.23 sec)

mysql>

Deleting Data Using a PHP Script

You can use the SQL DELETE command with or without the WHERE CLAUSE into the PHP function – mysql_query(). This function will execute the SQL command in the same way as it is executed at the mysql> prompt.

Example

Try the following example to delete a record from the tutorial_tbl whose tutorial_id is 3.

<?php
   $dbhost = 'localhost';
   $dbuser = 'root';
   $dbpass = '';
   $conn = mysql_connect($dbhost, $dbuser, $dbpass);
   
   if(! $conn ) {
      die('Could not connect: ' . mysql_error());
   }

   $sql = 'DELETE FROM tutorials_tbl WHERE tutorial_id = 3';

   mysql_select_db('TUTORIALS');
   $retval = mysql_query( $sql, $conn );

   if(! $retval ) {
      die('Could not delete data: ' . mysql_error());
   }
   echo "Deleted data successfully\n";
   mysql_close($conn);
?>

Update Data With MYSQL

 There may be a requirement where the existing data in a MySQL table needs to be modified. You can do so by using the SQL UPDATE command. This will modify any field value of any MySQL table.

Syntax

The following code block has a generic SQL syntax of the UPDATE command to modify the data in the MySQL table −

UPDATE table_name
SET column1=value, column2=value2,...
WHERE some_column=some_value 

You can update one or more field altogether.

The WHERE clause is very useful when you want to update the selected rows in a table.

Updating Data Using a PHP Script

You can use the SQL UPDATE command with or without the WHERE CLAUSE into the PHP function – mysql_query(). This function will execute the SQL command in a similar way it is executed at the mysql> prompt.

Example

The following example to update the tutorial_title field for a record having tutorial_id as 3.

<?php
   $server = 'localhost';
   $username = 'root';
   $password = '';
   $conn = mysql_connect($dbhost, $dbuser, $dbpass);
   
   if(! $conn ) {
      die('Could not connect: ' . mysql_error());
   }

   $sql = 'UPDATE tutorials_tbl
      SET tutorial_title="Learning JAVA"
      WHERE tutorial_id=3';

   mysql_select_db('TUTORIALS');
   $retval = mysql_query( $sql, $conn );
   
   if(! $retval ) {
      die('Could not update data: ' . mysql_error());
   }
   echo "Updated data successfully\n";
   mysql_close($conn);
?>

What PHP is?

 

PHP stands for Hypertext Preprocessor. PHP is a powerful and widely-used open source server-side scripting language to write dynamically generated web pages. PHP scripts are executed on the server and the result is sent to the browser as plain HTML.

 PHP can be integrated with the number of popular databases, including MySQL, PostgreSQL, Oracle, Sybase, Informix, and Microsoft SQL Server.

PHP can be embedded within a normal HTML web pages. That means inside your HTML documents you'll have PHP statements like this:



Example:

<!DOCTYPE HTML>
<html>
<head>
    <title>PHP Application</title>
</head>
<body>
<?php
// Display greeting message
echo 'Hello World!';
?>
</body>
</html>

 What You Can Do with PHP 

There are lot more things you can do with PHP. 

•  You can generate dynamic pages and files. 
• You can create, open, read, write and close files on the server. 
• You can collect data from a web form such as user information, email, credit card information and much more. 
• You can send emails to the users of your website. 
• You can send and receive cookies to track the visitor of your website.
•  You can store, delete, and modify information in your database. 
• You can restrict unauthorized access to your website. 
• You can encrypt data for safe transmission over internet.

How to Update Data MySQL?

 There may be a requirement where the existing data in a MySQL table needs to be modified. You can do so by using the SQL UPDATE command. This will modify any field value of any MySQL table.

Syntax

The following code block has a generic SQL syntax of the UPDATE command to modify the data in the MySQL table −

UPDATE Syntax-

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

Updating Data Using a PHP Script

You can use the SQL UPDATE command with or without the WHERE CLAUSE into the PHP function – mysql_query(). This function will execute the SQL command in a similar way it is executed at the mysql> prompt.

Example

The following example to update the tutorial_title field for a record having tutorial_id as 3.

<?php $dbhost
$dbhost = 'localhost:3036';
$dbuser = 'root';
$dbpass = 'rootpassword';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn ) {
die('Could not connect: ' . mysql_error());
}
$sql = 'UPDATE tutorials_tbl SET tutorial_title="Learning JAVA" WHERE tutorial_id=3'
SET tutorial_title="Learning JAVA"
WHERE tutorial_id=3';
mysql_select_db('TUTORIALS');
$retval = mysql_query( $sql, $conn );
if(! $retval ) {
die('Could not update data: ' . mysql_error());
}
echo "Updated data successfully\n";
mysql_close($conn);
?>