PHP - Learning Projects For Php Functions?

Hello all. I'm looking to build a website in php that will be large in scope and I'm looking for some direction as to how to go about coding it. What I'm referring to exactly is the programming model. I'm new to the language, but not to programming, and I've read up on it and familiarized myself with the syntax over the past few days. Normally when I go about building a project I like to plan ahead how I'm going to build It so I don't run into tedious issues later on and this is what I need help with.   My concerns:  I am looking to use the alternative syntax for control structures as to make the php code inside my html readable and easier to manage but in terms of OOP when is it best for me to use classes vs functions?  I am leaning towards using both classes and functions. Classes to handle polling data, sanitizing it and storing it while the functions will be used , with the alternative syntax, to display the data. How should I go about properly setting my project assuming I will have many concurrent users using the website at once? Is using xml / INI files as a directory to look up information a good practice? Is it better to declare constant variables instead? When working with multiple includes is there an easier way to include a file than having to explicity write "dirname( dirname(__FILE__) )" everytime?   I'm essentially looking for guidance / tips as to good programming practices with this language Advanced practices are welcomed as well.     Development Tools: XAMPP ( Windows 7 Pro ) PHPStorm    Current directory structure plan:   Here is what I currently have:     The API class is a collection of functions that returns an object to be used at a later data.

<?php

/*
 * Development API Key
 * @since 1.0
 *
 * Rate Limit(s):
 * 10 request(s) every 10 second(s)
 * 500 request(s) every 10 minute(s)
 */
define( "__API_KEY__" , "---------------------------------" );

require_once dirname( dirname(__FILE__) ) . "\\settings.php";

class API
{

    // If successfull it returns an object from the url that's passed to this function.	
    private function api_call($url)
    {
	$result = null; // end result

        // Create a new curl handle.
        $ch = curl_init();

        curl_setopt($ch , CURLOPT_URL, "https://" . $url . "?api_key=" . __RIOT_API_KEY__); // set the URL
        curl_setopt($ch , CURLOPT_RETURNTRANSFER , true  ); // return the transfer as a string of the return value
        curl_setopt($ch , CURLOPT_SSL_VERIFYPEER , false ); // turn off ssl certificate verification

        // Execute the api call
        $response = curl_exec($ch);
        // Get info to analyze the result
        $ci = curl_getinfo($ch);

        $httpcode = $ci["http_code"];

        // If a curl error occured
        if(curl_errno($ch) || ($httpcode != "200"))
        {
            $die  = "Curl Error Code: "    . $httpcode       . "<br/>";
            $die .= "Curl Error Message: " . curl_errno($ch) . "<br/>";
            $die .= "Curl URL: "           . $ci["url"]      . "<br/>";
            die($die);
        } else {

            // Check if the api call we made was valid

            $response = json_decode($response, true);

            // If our response is an array check if it's an error response
            if(is_array($response))
            {
                $error_key = "status";
                if(array_key_exists($error_key, $response))
                {
                    $er = $response[$error_key];
                    $die  = "API Error Message: " . $er["message"]     . "<br/>";
                    $die .= "API Error Code: "    . $er["status_code"] . "<br/>";
                    die($die);
                }
            }

            // Our response is a valid object
            $result = $response;
    }

    private function sanitize_url($url)
    {
        // removes all whitespaces
        return trim(preg_replace( '/\s+/','',$url));
    }

    private function regional_endpoints()
    {
        static $regionini;

        if(is_null($regionini))
            $regionini = parse_ini_file(INI_REGIONAL_ENDPOINTS, true);

        return $regionini;
    }

    private function region_host($shortcode)
    {
        /*
         * regionalendpoints.ini
         * @since 1.0
         *
         * [SHORTCODE]
         * Description=<region_description>
         * Host=<host_url>
         */
        return $this->regional_endpoints()[strtoupper($shortcode)]["Host"];
    }

    public  function region_description($shortcode)
    {
        /*
        * regionalendpoints.ini
        * @since 1.0
        *
        * [SHORTCODE]
        * Description=<region_description>
        * Host=<host_url>
        */
        return $this->regional_endpoints()[strtoupper($shortcode)]["Description"];
    }

    public function api_object_by_name($name, $region)
    {
        /*
         * @Description: Get summoner objects mapped by standardized summoner name for a given list of summoner names.
         *
         *
         * @Returns: Map[string, SummonerDto]
         *
         * Object
         * ------------------------------------------------------------------------------------------------------
         * Name             Data Type          Description
         * ------------------------------------------------------------------------------------------------------
         * id	            long	           ID.
         * name	            string	           Name.
         * profileIconId    int                    ID of the summoner icon associated with the summoner.
         * revisionDate	    long	           Date summoner was last modified specified as epoch milliseconds.
         * Level            long	           Level associated with the summoner.
         */

         $api_url = "%s/api/col/%s/v1.4/obj/by-name/%s";

        return $this->api_call(sprintf($api_url,
            $this->region_host($region),
            strtolower($region),
            $this->sanitize_url($name)));
    }

}

Class that acts as the middle man between the api and the front end. Currently how it is set up it handles an internal queue.

<?php

include dirname(__FILE__) . "\\class-riotapi.php";

define( "SUMMONER_NAME" , 0 );
define( "SUMMONER_ID"   , 1 );

class Summoner
{

    private $riotapi        = null;

    private $summoner       = null;
    private $arr_summoners  = null;
    private $region         = null;


    public function __construct()
    {
        // Create our riot api object
        $this->riotapi = new RiotAPI();
    }


    public function summoner_exists($summoners, $region, $type = SUMMONER_NAME)
    {
        static $eoa; // end of array

        // If our array of summoners is empty or we have reached the end of the array.
        if( empty($this->arr_summoners) || $eoa )
        {
            // Get an array of summoner information from the riot api based on the type of information
            // supplied.
            switch($type)
            {
                case SUMMONER_NAME :
                    $this->arr_summoners = $this->riotapi->api_summoner_by_name($summoners, $this->region = $region);
                    break;

                case SUMMONER_ID :
                    $this->arr_summoners = $this->riotapi->api_summoner_by_id($summoners, $this->region = $region);
                    break;
            }

            // If our array of summoners isn't empty.
            if( !empty($this->arr_summoners) )
            {
                // Set our current summoner the first element in the array.
                $this->summoner = reset($this->arr_summoners);
            } else {
                // We failed to acquire any summoner information so return false.
                return false;
            }

            $eoa = false;

        } else {

            // If we have not reached the end of the summoners array set our current
            // summoner to the next element.
            $next = next($this->arr_summoners);

            // Have we reached the end of the array?
            if( $next ) {
                // No. Set our current summoner to the next element.
                $this->summoner = $next;
            } else {
                // Yes. Set our end of array variable to true.
                $eoa = true;
                // End the loop
                return false;
            }

        }

        return true;
    }


    public function summoner_id()
    {
        return $this->summoner["id"];
    }


    public function summoner_name()
    {
        return $this->summoner["name"];
    }


    public function summoner_profile_icon_id()
    {
        return $this->summoner["profileIconId"];
    }


    public function summoner_last_updated()
    {
        return $this->summoner["revisionDate"];
    }


    public function summoner_level()
    {
        return $this->summoner["summonerLevel"];
    }


    public function summoner_mastery_pages()
    {
        return $this->riotapi->api_summoner_masteries($this->summoner_id(),
            $this->region)[$this->summoner_id()]["pages"];
    }

}

Functions.php file that is a collection of functions that echo out information. 

<?php

require_once "settings.php";
include DIR_INCLUDE . "class-summoner.php";

function summoner_exists($summoners, $region = "NA", $type = SUMMONER_NAME)
{
    global $cs;
    if(!isset($cs)){
        $cs = new Summoner();
    }
    return $cs->summoner_exists($summoners, $region, $type);
}

function summoner_name()
{
    global $cs;
    if(isset($cs)){
        echo $cs->summoner_name();
    }
}

?>

index.php - Example of how I'm currently using the functions.php file.

<?php include "functions.php"; ?>
<html xmlns="http://www.w3.org/1999/xhtml">
<body>

<?php while(summoner_exists("cyllo")) : ?>

    <div>Summoner Name: <?php summoner_name(); ?></div>
    <div>Summoner ID: <?php summoner_id(); ?></div>
    <div>Summoner Profile icon ID: <?php summoner_profile_icon_id(); ?></div>
    <div>Last Updated: <?php summoner_last_updated(); ?></div>
    <div>Summoner Level: <?php summoner_level(); ?></div>

    <div>
        <?php mastery_pages(); ?>
    </div>

<?php endwhile; ?>
</body>
</html>

Hello,   Can you guys point me to something where I can follow some tutorial or something and learning CI?  I've already made tons of 'Cars' models... 'Dogs' .. 'Cats'.. etc but I really need some project where I can follow steps to creat and learn while I create.    p.s. I think I post this thread in right place but please correct me if is wrong.   Thank's!

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=359016.0

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=343169.0

I have a script I am putting together that simulate a cricket game. The only issue is, that there are a huge number of functions because there doesn't seem to be any other way to do this properly. As well as this, there a while() loop and all this seems to be leading to the page reaching a max 30 second timeout when generating the result.

My code is attached below, it is quite messy at the moment because i've just be working on it, but I was wondering if anyone has any solutions of how I can speed this up or change to prevent a timeout:

<?php
// Error reporting
error_reporting(E_ALL);

// Connect DB
mysql_connect("wickettowicket.adminfuel.com", "rockinaway", "preetha6488") or die(mysql_error());

// Select DB
mysql_select_db("wickettowicket") or die(mysql_error());

// MySQL queries to find batsmen and bowlers 
$array_batsmen = mysql_query('SELECT id, name, ability, strength FROM wtw_players WHERE team_id = 1 ORDER BY id ASC');
$array_bowlers = mysql_query('SELECT id, name, ability, strength FROM wtw_players WHERE team_id = 2');

// Start table for data 
$data = '<table width="600px">';

// Create blank scorecard
while ($array_bat = mysql_fetch_array($array_batsmen))
{
$data .= '<tr><td>'.$array_bat['name'].'</td><td></td><td></td><td>0</td></tr>';
}

// Set up arrays for players 
$current_batsman = $current_bowler = array();

// Reset query
mysql_data_seek($array_batsmen,0);

$in_one = $in_two = $it = '';

function currentBatsman($id, $name, $ability, $strength, $out, $in, $runs)
{
global $current_batsman;


$current_batsman = array (
'id' => $id,
'name' => $name,
'ability' => $ability,
'strength' => $strength,
'out' => $out,
'in' => $in,
'runs' => $runs
);

echo 'set current';
}

// Set up arrays of batsmen
while ($array = mysql_fetch_array($array_batsmen))
{

if ($it < 3 && $in_one == '') 
{
currentBatsman($array['id'], $array['name'], $array['ability'], $array['strength'], 0, 1, 0);

$batsmen[$array['id']] = array (
'id' => $array['id'],
'name' => $array['name'],
'ability' => $array['ability'],
'strength' => $array['strength'],
'out' => 0,
'in' => 1,
'runs' => 0
);

$in_one = $array['id'];
$current = $array['id'];
$it++;
}
else if ($it < 3 && $in_two == '') 
{
$batsmen[$array['id']] = array (
'id' => $array['id'],
'name' => $array['name'],
'ability' => $array['ability'],
'strength' => $array['strength'],
'out' => 0,
'in' => 1,
'runs' => 0
);

$in_two = $array['id'];
$it++;
}
else 
{
$batsmen[$array['id']] = array (
'id' => $array['id'],
'name' => $array['name'],
'ability' => $array['ability'],
'strength' => $array['strength'],
'out' => 0,
'in' => 0,
'runs' => 0
);
}

}

// Bowler Array
while ($array = mysql_fetch_array($array_bowlers))
{
$bowlers[] = array (
'name' => $array['name'],
'ability' => $array['ability'],
'strength' => $array['strength']
);

}

// Reset both queries
mysql_data_seek($array_bowlers,0);
mysql_data_seek($array_batsmen,0);



function changeBatsman($just_out)
{
global $array_batsmen, $batsmen; 

//Update array
$batsmen[$just_out] = array (
'in' => 1,
'out' =>  1
);

while ($array = mysql_fetch_array($array_batsmen))
{
if ($just_out != $array['id'] && $batsmen[$array['id']]['out'] != 0) currentBatsman($array['id'], $array['name'], $array['ability'], $array['strength'], 0, 1, 0);
}

// Reset query
mysql_data_seek($array_batsmen,0);

echo 'change batsman';
}

function swapBatsman($other_batsman)
{
global $array_batsmen, $batsman; 

while ($array = mysql_fetch_array($array_batsmen))
{
if ($other_batsman != $array['id'] && $batsman[$array['id']]['out'] != 0 && $batsman[$array['id']]['in'] == 1) currentBatsman($array['id'], $array['name'], $array['ability'], $array['strength'], 0, 1, 0);
}

// Reset query
mysql_data_seek($array_batsmen,0);

echo 'swap batsman';
}

$runs = $outs = $balls = $overs = 0;

$played = array();

function selectBowler()
{
global $bowlers, $current_bowler;

// Select random bowler
$choose_bowler = array_rand($bowlers, 1);

$current_bowler = array (
'name' => $bowlers[$choose_bowler]['name'],
'ability' => $bowlers[$choose_bowler]['ability'],
'strength' => $bowlers[$choose_bowler]['strength']
);

 

}

/*
function selectBatsman();
{
global $array_batsmen;

while ($array_batsmen[]['out'] != 1)
{


}*/

function bowl()
{
global $batsmen, $bowlers, $current_bowler, $current_batsman, $data, $balls, $outs, $runs;

if ($current_batsman['out'] == 0)
{
echo 'bowling';
// Set the initial number
$number = rand(0, 190);

// Ability of batsman
if ($current_batsman['ability'] > 90) $number += 30;
else if ($current_batsman['ability'] > 70) $number += 15;
else if ($current_batsman['ability'] > 50) $number += 2;
else $number = $number;

// Strength of batsman
if ($current_batsman['strength'] > 90) $number += 15;
else if ($current_batsman['strength'] > 70) $number += 10;
else if ($current_batsman['strength'] > 50) $number += 5;
else $number = $number;

// Depending on overs
if ($balls > 270) $number += 30;
else if ($balls > 120) $number -= 10;

// Ability
if ($current_bowler['ability'] > 90) $number -= 30;
else if ($current_bowler['ability'] > 70) $number -= 15;
else if ($current_bowler['ability'] > 50) $number -= 2;
else $number = $number;

// If batsman has made a huge total of runs, we need to knock some numbers off - more likely to get out
if ($current_batsman['runs'] > 200) $number -= 70;
else if ($current_batsman['runs'] > 100) $number -= 30;

// Finally sort out runs
if ($number > 190) $run = 6;
else if ($number > 170) $run = 4;
else if ($number > 160) $run = 3;
else if ($number > 100) $run = 2;
else if ($number > 50) $run = 1;
else if ($number > 10) $run = 0;
else if ($balls > 120 && $number > 0) $run = 0;
else $run = -1;

// Increase number of balls
$balls += 1;

// Are they out?
if ($run == -1)
{
$current_batsman['out'] = 1;

$played[] = $current_batsman['id'];
$find = '<tr><td>'.$current_batsman['name'].'</td><td></td><td></td><td>0</td></tr>';
$replace = '<tr><td>'.$current_batsman['name'].'</td><td></td><td>'.$current_bowler['name'].'</td><td>'.$current_batsman['runs'].'</td></tr>';

$data = str_replace($find, $replace, $data);


changeBatsman($current_batsman['id']); 



echo 'out';

}
else
{
$current_batsman['runs'] += $run;
$runs += $run;

if ($run == 1 || $run == 3)
{
swapBatsman($current_batsman['id']);
echo 'time to swap';
}

echo $run;


}

// Count outs
if ($current_batsman['out'] == 1)
$outs += 1;


}
}

function game()
{
global $main, $batsmen, $bowlers, $data, $batted, $balls, $outs, $current_batsman;

// Check if possible
while ($balls <= 295 && $outs < 10)
{

selectBowler();

// Actually bowl now

bowl();


}


}


game();



echo $data;

Hello, I'm Dustin I going back to school for software development. this semester I am taking PHP and Javescript.

I have a copy of the Developer's Library book PHP and MySQL Web Development. It teaches PHP 5.3 and MySQL 5.1. It is an extensive book of almost 1000 pages. I know that PHP is now at 5.5, but is this still good enough to learn the basics or are there major differences?    Thanks.    

Can't figure out what is wrong with my function getVars here is my code
Code: [Select]
<?php
echo"<?xml version=\1.0\"encoding=\UFT-8\"\x3f>";
echo"\n";
?>

<!DOCTYPE html PUBLIC"-//W3C//DTD XHTML 1.0 Transitional//EN"
  "http://www.w3.org/TR/xhtmll/DTD/xhtmll-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml"
  xml:lang="en"lang="en">

<head>
  <title>My third PHP Generated Document</title>
</head>
<body>
<h2> My Third PHP Document </h2>
  <?php
  echo "<h3>Today is ".date('l, F d, Y')."</h3>";
  ?>

<?php
  //calculate the area of an equilateral triangle
  function calcTriangle($cVal) {
    $halfSide = $cVal/2;
    $otherSide = sqrt(($cVal*$cVal) - ($halfSide*$halfSide));
    $area = $otherSide * $halfSide;
    echo "<p>The area of an equilateral triangle whose sides are
    {$calcValue} is {$areaValue}.</p>\n";
  }
  //calculate the area of a circle
  function calcCircle($cVal) {
    $areaValue = $calcValue * $calcValue * pi();
    echo "<p>The area of a circle whose radius is
    {$calcValue} is {$areaValue}.</p>\n";
  }
  //calculate the area of s square
  function calcSquare($cVal) {
    $areaValue = $calcValue * $calcValue;
    echo "<p>The area of a square whose sides are
    {$calcValue} is {$areaValue}.</p>\n";
  }
  //function to test variables
  function testVars() {
    global $_POST;
    if (empty($_POST['vfld'])) {
      echo "<h3>Error</h3>";
      echo "<p>You must enter a value!</p>\n";
      return "no";
    }
    else {
      return "yes";
    }
}
  //function to get variables
  function getVars(&$a, &$b, &$c) {
    global $_POST;
    $a->$workValue = $_POST['vfld'];
    $b->$workType = $_POST['tfld'];
    $c->$calcValue = (float) $workValue;
    return;
  }

  $workValue = (isset($_POST['vfld']))?$_POST['vfld']:'';
  $workType = (isset($_POST['tfld']))?$_POST['tfld']:'';
  if (isset($_POST['submit'])) {
  if ($_POST['submit'] == "Clear") {
    clearVars();
  } elseif ($_POST['submit'] == "Calculate") {
    getVars();
  $continue = testVars();
    if ($continue == "yes") {
      switch ($workType) {
      case "circle":
        calcCircle($workVal);
        break;
      case "square":
        calcSquare($workVal);
        break;
      case "triangle":
        calcTriangle($workVal);
        break;
      }
    }
  }
}
<form method="post" action="hw06.php"
   id="form1" name="form1">
  <p>
  Enter a number here :
  <input type="text" id="vfld" name="vfld"
  value="<?php echo $workValue; ?>"/>
  </p>
  <p>
  This number is:
  <br />
  <input type="radio" name="tfld" value="circle"
  <?php if ($workType == "circle") {
    echo 'checked="checked"'; } ?> />
  : the radius of a circle
  <br />
  <input type="radio" name="tfld" value="square"
  <?php if ($workType == "square") {
    echo 'checked="checked"'; } ?> />
  : the length of one side of a square
  <br />
  <input type="radio" name="tfld" value="triangle"
  <?php if ($workType == "triangle") {
    echo 'checked="checked"'; } ?> />
  : the length of one side of an equilateral triangle
  </p>
  <p>
  <input type="submit" name="submit" value="Calculate" />
  <input type="submit" name="submit" value="Clear" />
  </p>
  </form>

<div id="footer">
</div>

</body>

</html>

and here are my errors
Warning: Missing argument 1 for getVars(), called in /studfs1/homepage/CISS-225/hw06.php on line 69 and defined in /studfs1/homepage/CISS-225/hw06.php on line 55

Warning: Missing argument 2 for getVars(), called in /studfs1/homepage/CISS-225/hw06.php on line 69 and defined in /studfs1/homepage/CISS-225/hw06.php on line 55

Warning: Missing argument 3 for getVars(), called in /studfs1/homepage/CISS-225/hw06.php on line 69 and defined in /studfs1/homepage/CISS-225/hw06.php on line 55

Notice: Undefined variable: workValue in /studfs1/homepage/CISS-225/hw06.php on line 57

Fatal error: Cannot access empty property in /studfs1/homepage/CISS-225/hw06.php on line 57

Any help would be greatly appreciated please explain too

Hi, I am wanting to build a small internal web portal, hopefully in php, however I just want to check that I can do a few key things before I go down this road.  This is for work, so rather than waste a bunch of time, I've got a few quick questions hopefully someone can answer for me.

1) Is it possible to grab NT login information such as NTSID, Domain username, Full name based on domain login

2) show/hide objects based on above login

The portal is meant to be a front end access to a bunch of reports, and the ntsid and username are used as authentication for these reports.  The idea is that a user navigates to the site, it says Hi John, here are the reports you have access to.  The only part I really need to worry about is the hiding and showing of the reports, since they have their own built in security.

I'll also want to have an add user page, which will mean i'll need a button that grabs an ntsid based on a username entered in a field.

Are these things possible?

Regards,
Matt

I just decided to start up on OOP, and it seems quite fun (yes, I find programming fun). But, I'm having trouble on this test OOP page.

This is suppose to return the private variable $name, and if it's empty, it's suppose to echo the no name to return message.

Code:


<?php

class findName
{

private $name;

public function setName($sname)

{

if(!$sname)

{

$this->name = "There is no name to return.";

}

else

{

$this->name=$sname;

}

}

public function getName()

{

return $this->name;

}
}

$n = new findName();
$n->getName();

?>


If there is an easier way to do this, please let me now!

Hello everybody, I'm Nishio and I started to program like a month ago, my basic idea was to be able to create websites and to work as a freelancer, I know HTML and CSS from what I can design a simple website, but most of the people who look for freelancers also look for PHP/ASP knowledge, and I know some basics of PHP, like variables, booleans and NULL, constants, arrays, if statement, but I don't know how to acctualy do anything a little more complex with it.
So I guess what I am asking for is a mentor, somebody who would tell and show me how do I connect PHP with web design I already know.
And no I do not have any money, so I am basicly asking for somebody who has nothing to do for 1/2 hours a day and knows PHP.
Thanks in advance, and sorry if I posted in a wrong section.

At the moment I have <input type="hidden" name="iput-time1" value="2021-06-21 01:00"> and the time gets put in the script by

$IpTime= $_POST['iput-time1'];

So how can I get the time that I would put in <td>01:00</td> and do away with the hidden input bit.

I have no idea even if I explained that right

Hey people!   I'm new here and I desperately need your help! I have my PHP exam on monday so I'm practicing with codeacademy. I know it's easy stuff for you, but don't judge and help a girl out please!   These are the instructions: Create a class called Cat. Add two public properties to this class: $isAlive ought to store the value true and $numLegsshould contain the value 4. Add a public $name property, which gets its value via the__construct()or. Add a public method calledmeow(), which returns "Meow meow". Create an instance of the Catclass, which has the $name "CodeCat". Call the meow() method on thisCat and echo the result. This is my code: <?php

When I say I'm a noobie, I'm not kidding!   I'm using a hosting service (Bluehost) that offers PHP 5.4.30 and mySQL 5.5.37 and am trying to work through a beginners tutorial. Using the service's PHPMyAdmin tool, I have no trouble creating a database and table that I can manipulate using this tool. My problem is with my very first php command:   $db = new mysqli(localhost, 'me', 'pw', 'RR');   'me' and 'pw' are my Bluehost signon credentials that were also required to get into the PHPMyAdmin tool. 'RR' is the actual name of the database I'd created. I'm not sure if these are what mySQL is looking for. I also tried 'root' and a null password as done in the tutorial, but that didn't help. The message I get is:   Connect failed: Access denied for user 'me'@'localhost' to database 'RR'   I'd love to get somewhat proficient on PHP/mySQL. Please help.

Hey sorry that I am asking this question, though I have gotten around to learn connecting to a database and also do the retrieve, yet I am not necessarily getting to learn doing INSERT, UPDATE and DELETE the proper way.   The tutorials available are often not best, I have found a good book ("Object Oriented Programming in PHP5") which teaches SELECT, yet not necessarily INSERT, UPDATE and DELETE.   I am really wondering how does one get to learn CRUD with PHP OOP, how did you people learn this? How can I learn INSERT, UPDATE and DELETE as well with PHP OOP?

I feel like paying for this on Elance or Fiverr. I am not sure how else to learn this by now, I have tried quite a bit, I have looked at scripts and tutorials and books. And it has just gotten as far as connecting to the database and doing the "fetching" ("SELECT", or also "retrieve").   Too bad that what is available is not necessarily best. Otherwise I would say one could understand the principle quickly and also pick up on a programming language quickly.   Please bear with me, I would appreciate suggestions.