Learn VBA & Macros in 1 Week!

PHP - Live Streaming Cricket World Cup Matches. How To Enhance The Performance

Full Excel VBA Course - Beginner to Expert

Live Streaming Cricket World Cup Matches. How To Enhance The Performance	View Content

I have a website http://www.pbm-biz.com/cricket/ where I am streaming Live Cricket world cup matches. My question is that during the streaming, I would like to keep the code in PHP so that others don't copy it. I can't find any solution. Any suggestions.

Thanks,

Faisal

Full Excel VBA Course - Beginner to Expert

Php Streaming Using Ming

Similar Tutorials

View Content

Hi,
I've been trying,for a while now, to stream mp3 using MING extension. I have the later XAMPP 1.7.4 installed.

So the code goes something like :
Code: [Select]
<?php
$m = new SWFMovie();
$m->setRate(12.0);
$m->streamMp3(file_get_contents('a.mp3',"r"));
$m->setFrames(1420);
header('Content-type: application/x-shockwave-flash');
$m->output();

?>

'a.mp3' is in the same directory as of the php file.

It opens the file, reads the file - but i've no idea what is it doing after that. There are no errors or warnings. A white ' FLASH ' screens comes up. Thats all.

I've tried googling this thing up. I didn't find anything.

What am I doing wrong?

Streaming Video With Php

Similar Tutorials

View Content

So i have a large video files, 1.5 gigs even.
I made an html5 video player where the source is a php file.
The php file is supposed to go below the web root and serve the video file to the html5 video tag.

This all works just fine if the video using a script that uses HTTP_RANGE to serve the file in parts to the client.
The problem is, once one video is playing - i can't do anything else. Its like the server locks up. I mean i can scrub that video, i can do anything to that page. I just can't navigate away. But i can open a new browser and play a new video. But again, once that first one is playing, or even paused, i can't do anything else.

That is of course until i restart apache.

Any ideas on how to stream these large files better? I have a feeling they are set to stream and never stop.
This is the code for that

Code: [Select]
function rangeDownload($file) {

$fp = @fopen($file, 'rb');

$size = filesize($file); // File size
$length = $size; // Content length
$start = 0; // Start byte
$end = $size - 1; // End byte
// Now that we've gotten so far without errors we send the accept range header
/* At the moment we only support single ranges.
* Multiple ranges requires some more work to ensure it works correctly
* and comply with the spesifications: http://www.w3.org/Protocols/rfc2616/rfc2616-sec19.html#sec19.2
*
* Multirange support annouces itself with:
* header('Accept-Ranges: bytes');
*
* Multirange content must be sent with multipart/byteranges mediatype,
* (mediatype = mimetype)
* as well as a boundry header to indicate the various chunks of data.
*/
header("Accept-Ranges: 0-$length");
// header('Accept-Ranges: bytes');
// multipart/byteranges
// http://www.w3.org/Protocols/rfc2616/rfc2616-sec19.html#sec19.2
if (isset($_SERVER['HTTP_RANGE'])) {

$c_start = $start;
$c_end = $end;
// Extract the range string
list(, $range) = explode('=', $_SERVER['HTTP_RANGE'], 2);
// Make sure the client hasn't sent us a multibyte range
if (strpos($range, ',') !== false) {

// (?) Shoud this be issued here, or should the first
// range be used? Or should the header be ignored and
// we output the whole content?
header('HTTP/1.1 416 Requested Range Not Satisfiable');
header("Content-Range: bytes $start-$end/$size");
// (?) Echo some info to the client?
exit;
}
// If the range starts with an '-' we start from the beginning
// If not, we forward the file pointer
// And make sure to get the end byte if spesified
if ($range == '-') {

// The n-number of the last bytes is requested
$c_start = $size - substr($range, 1);
}
else {

$range = explode('-', $range);
$c_start = $range[0];
$c_end = (isset($range[1]) && is_numeric($range[1])) ? $range[1] : $size;
}
/* Check the range and make sure it's treated according to the specs.
* http://www.w3.org/Protocols/rfc2616/rfc2616-sec14.html
*/
// End bytes can not be larger than $end.
$c_end = ($c_end > $end) ? $end : $c_end;
// Validate the requested range and return an error if it's not correct.
if ($c_start > $c_end || $c_start > $size - 1 || $c_end >= $size) {

header('HTTP/1.1 416 Requested Range Not Satisfiable');
header("Content-Range: bytes $start-$end/$size");
// (?) Echo some info to the client?
exit;
}
$start = $c_start;
$end = $c_end;
$length = $end - $start + 1; // Calculate new content length
fseek($fp, $start);
header('HTTP/1.1 206 Partial Content');
}
// Notify the client the byte range we'll be outputting
header("Content-Range: bytes $start-$end/$size");
header("Content-Length: $length");

// Start buffered download
$buffer = 1024 * 8;
while(!feof($fp) && ($p = ftell($fp)) <= $end) {

if ($p + $buffer > $end) {

// In case we're only outputtin a chunk, make sure we don't
// read past the length
$buffer = $end - $p + 1;
}
set_time_limit(0); // Reset time limit for big files
echo fread($fp, $buffer);
flush(); // Free up memory. Otherwise large files will trigger PHP's memory limit.
}

fclose($fp);

}

No Matches Problem

Similar Tutorials

View Content

I'm trying to come up with some code...and need to echo certain things based on which query failed.

There are several query's and while loops nested together.

I'm trying to use this...

Code: [Select]
<?php
$rs = mysql_query($sql,$dbc);
if (! $rs) { echo "You aren't scheduled to work in the next seven days...but check back often as the schedule is adjusted often."; }
$matches = 0;
while ($row = mysql_fetch_assoc($rs))
{
$matches++;
//rest of code here...which work when there are matches...
?>

With no matches, it isn't echoing anything...instead of "You aren't scheduled to work in the next seven days...but check back often as the schedule is adjusted often."

If I echo out $rs, I get RESOURCE ID #6

Any ideas? Thanks!

Count Matches

Similar Tutorials

View Content

Hello guys.

I have the following code and I would like to count the number of times that the word has been replaced.
I tried echo count ($replacement) and echo count ($match) but both only show "1". I want to be able to tell if there has been a replacement and send a warning email and/or add a flag in the db.

Code: [Select]
$search_for_bad_words = mysql_query("SELECT * FROM badwords WHERE 1");

$ad_title2 = $ad_title;
$ad_body2 = $ad_body;
//$wordlist = "shit:cr*p|dang:d*ng|shoot:sh**t";
$seperate_text = "|";
$entry_seperate_text = ":";

while($row = mysql_fetch_array($search_for_bad_words))
{
$wordlist = $wordlist.$seperate_text.$row[word].$entry_seperate_text.$row[r_word];
}
$words = explode('|', $wordlist);
foreach ($words as $word) {
list($match, $replacement) = explode(':', $word);
$ad_title2 = preg_replace("/([^a-z^A-Z]?)($match)([^a-z^A-Z]?)/i", "$1".$replacement."$3", $ad_title2);
$ad_body2 = preg_replace("/([^a-z^A-Z]?)($match)([^a-z^A-Z]?)/i", "$1".$replacement."$3", $ad_body2);
}

Thanks for all your help!

Help Needed With Streaming A Video

Similar Tutorials

View Content

Hi, i am trying to stream a video from Rackspace clould files account. I could simply get the url of the video file and stream the video using the php api they have provided. But they have provided a stream function which they suggest to be used for video streaming or for large images.

Here is the code of the api :

    /**
         * Streaming read of Object's data
         *
         * Given an open PHP resource (see PHP's fopen() method), fetch the Object's
         * data and write it to the open resource handle.  This is useful for
         * streaming an Object's content to the browser (videos, images) or for
         * fetching content to a local file.
         *
         * Pass in $hdrs array to set specific custom HTTP headers such as
         * If-Match, If-None-Match, If-Modified-Since, Range, etc.
         *
         * Example:
         * <code>
         * # ... authentication/connection/container code excluded
         * # ... see previous examples
         *
         * # Assuming this is a web script to display the README to the
         * # user's browser:
         * #
         * <?php
         * // grab README from storage system
         * //
         * $my_docs = $conn->get_container("documents");
         * $doc = $my_docs->get_object("README");
         *
         * // Hand it back to user's browser with appropriate content-type
         * //
         * header("Content-Type: " . $doc->content_type);
         * $output = fopen("php://output", "w");
         * $doc->stream($output); # stream object content to PHP's output buffer
         * fclose($output);
         * ?>
         *
         * # See read() above for a more simple example.
         * #
         * </code>
         *
         * @param resource $fp open resource for writing data to
         * @param array $hdrs user-defined headers (Range, If-Match, etc.)
         * @return string Object's data
         * @throws InvalidResponseException unexpected response
         */
        function stream(&$fp, $hdrs=array())
        {
            list($status, $reason) =
                    $this->container->cfs_http->get_object_to_stream($this,$fp,$hdrs);
            #if ($status == 401 && $this->_re_auth()) {
            #    return $this->stream($fp, $hdrs);
            #}
            if (($status < 200) || ($status > 299
                    && $status != 412 && $status != 304)) {
                throw new InvalidResponseException("Invalid response (".$status."): "
                    .$reason);
            }
            return True;
        }

Here is the sample code they shared :

    $output = fopen("test.jpg", "w");
      $pic->stream($output);
      fclose($output);

If i echo the $pic variable, it just contains the name of the file. How do i display the image and how do i use this for streaming a video? Iam very new to php, so kindly help me. Thanks.

Php Streaming File Loops When It's Not Suppose To

Similar Tutorials

View Content

Hi all, I've been running into some issues trying to stream .mp3 files, specifically Safari/Flash... Firefox works great. I'm about to throw in the towel on this one and try another streaming solution, so I thought I'd reach out and connect with the PHP pros here before trying something else.

Basically, the PHP streamer takes a track guid variable and token variable(MD5), looks up the field in the DB, gets the url and then proceeds to stream the file with no caching, and keeping the URL hidden from the user so they can't download it. The token variable is there to assure that the url is only used once. Once it is, the script will not allow the stream if the token/track guid combo already exists in the DB. The problem with the looping is that once that token has been used it won't stream the track, which is how it's suppose to work, sans looping. I've put an MYSQL INSERT into the code to verify that it does loop.. usually I see 3- :wtf:5 consecutive entries in the DB for that token. So Firefox does not do this.. and I gather it's something to do with how the client streams with the "readfile" function.

Pasted below is some code to show the headers and the readfile function I am using. I can post the rest of the script if need be.

//$path and $tokenApproved are variables i set earlier in the script

date_default_timezone_set('GMT');
$date = date(DATE_RFC822);
$filesize = ffilesize($path);
$shortlen = $filesize - 1;

//ffilesize() is a custom filesize function

if($tokenApproved)
{

header("Content-type: audio/mpeg");

header("Content-Length: $filesize");

header('Content-Range: bytes 0-'.$shortlen.'/'.$filesize);

header("Expires: $date");

header('Content-Disposition: filename="eztunesaudio.mp3"');

header("Cache-Control: no-store, no-cache, must-revalidate");

header("Cache-Control: post-check=0, pre-check=0", false);

readfile($path);
}

//eztunesaudio.mp3 is just a default name I give the stream

Help... Checking If Dom Textcontent Matches Row Thats In Database.

Similar Tutorials

View Content

Hello,

I am trying to get this backlink checker that checks to make sure another website has my link on their website, so far I can check to make sure the "href" link is there and is correct, but I cant get the textContent to prove valid or not it seems to always be proving true even when the textConent is not in the mysql database.

The other persons website will have this:
<a href="http://businessinvestingsorce.com">Business Investing Source</a>

I need to make sure Business Investing Source (the textContent) matches the anchor in the database.

Here is my code:

Code: [Select]
<?php

function CheckForAnchorMatch($anchortext) {

$query = mysql_query("SELECT * FROM allowed_anchor WHERE anchor='$anchortext'");
if(mysql_num_rows($query) != 0) {
return true;
}

return false;

}

function CheckForTargetUrl($links, $target) {
    foreach ($links as $link) {
        if (strpos($link, $target) !== false) {
            return true;
        }
    }

    return false;
}

function ExtractHrefLinks($html) {
    $dom = new DOMDocument;
    $linkUrls = array();


    @$dom->loadHTML($html);
    $links = $dom->getElementsByTagName('a');

    foreach ($links as $link){
        $linkUrls[] = $link->getAttribute('href');
    }

    return $linkUrls;
}

function ExtractAnchorText($html) {
    $dom = new DOMDocument;
    $AnchorTexts = array();


    @$dom->loadHTML($html);
    $links = $dom->getElementsByTagName('a');

    foreach ($links as $link){
        $AnchorTexts[] = $link->textContent;
    }
    return $AnchorTexts;
}

function backlink_check($contenturl){

$url = 'businessinvestingsource.com';
$source = $contenturl;

$falseFound = false;

    $html = file_get_contents ( $source );
    $links = ExtractHrefLinks($html);

    if (CheckForTargetUrl($links, $url) === false) {
        $falseFound = "true";
        $reportArray[$source] = 0;
    } else {
        $falseFound = "false";
    }

    $html = file_get_contents ( $source );
    $anchortext = ExtractAnchorText($html);

    if (CheckForAnchorMatch($anchortext) === false) {
        $falseFound = true;
    } else {
        $falseFound = false;
    }

return $falseFound;
}
?>
Help greatly appreciated

Find Next Result That Matches Query

Similar Tutorials

View Content

I have this query to show the current class I'm in:
Code: [Select]
$GetTimeTable = "SELECT * FROM timetable WHERE username='$username' AND Subject_date='$today_date'";
Then I have this to display current class:
Code: [Select]
if($TimeNow >= $Start_time && $TimeNow <= $End_time){
echo "Current Class: ";
echo $Subject;}
How would I find next class that day?

Matches Multiple Words In Regex?

Similar Tutorials

View Content

Hi there

I am beginning to learn regex in php. I was wondering why the following regex pattern wasn't finding the two words in the string and replacing them with welcome? '/(Hello).*?(Hi)/is'

Code: [Select]
$patterns = array();
$patterns[0] = '/(Hello).*?(Hi)/is';

$replacements = array();
$replacements[0] = 'Welcome';

ksort($patterns);
ksort($replacements);
echo preg_replace($patterns, $replacements, $string);

Any help would be much appreciated. Thanks a million!

Insert Into Table If Id Matches Session Id

Similar Tutorials

View Content

Im trying to insert a name into my database but I need it to go into the column that matches the sessions user id

Code: [Select]
"INSERT INTO users SET name = '".$_POST['name']."'";

how do I tell it to put name into name column with id matching Session id.

really appreicate if someone could please help me with this.

Preg_match_all Returns Matches That Doesn't Exist

Similar Tutorials

View Content

First time post, be easy on me... I'm using preg_match_all to return an array with all the matches. I know I'm missing something fundamental, but I either keep looking past it or am more screwy than I know. Sample String

CC-BY-ND-NC

I'm using the following code

preg_match_all("/cc|creative commons|copyright|by|sa|nc|nd/i",$exifmeta['copyright'],$cmeta)

I would expect to see

Array
(
    [0] => Array
        (
            [0] => CC
            [1] => BY
            [2] => ND
            [3] => NC
        )

)

What I get is

Array
(
    [0] => Array
        (
            [0] => CC
            [1] => BY
            [2] => ND
            [3] => NC
            [4] => sa
        )

)

Search Script | Need To Query The Database And Tell Me If There Is No Matches

Similar Tutorials

View Content

Hi guys and girls,

I am having trouble finding out wether the query made no matches rather than just displaying the matches.

So what I would want is for the search term to look at the database, and if there's not matches then say, "No match for your search term"

Code: [Select]
function search_applications() {

global $dbc;

echo '<form method="post" action="" id="search">'. "\n";
echo '<label for="search_applications">Search for an application</label>'. "\n";
echo '<input type="text" name="search_applications" />'. "\n";
echo '<input type="submit" name="submit" />'. "\n";
echo '</form>'. "\n";

if(isset($_POST['submit'])){

$search_applications = $_POST['search_applications'];

if ($search_applications == "")
{
echo "<p>You forgot to enter a search term";
}

//if (preg_match("/\b$search_applications\b/i")){
if(preg_match("/^[ a-zA-Z]+/", $search_applications)){

//for testing the variables
//echo $search_applications;

$sql="SELECT title, category, content FROM distributors_content WHERE title LIKE '%" . $search_applications . "%' OR category LIKE '%" . $search_applications ."%' OR content LIKE '%" . $search_applications ."%'";
$result=mysqli_query($dbc, $sql);
//-create while loop and loop through result set
while($row=mysqli_fetch_array($result)){
$title =$row['title'];
$category=$row['category'];
$content=$row['content'];

//-display the result of the array
echo "<ul>\n";
echo '<li> <a href="index.php?article='.$row['title'].'&&page=application" title=""> '.$title . ' ' . $category . '</a></li>'."\n";
echo "</ul>";
}
}else{

echo "<p>Enter another search term</p>";
}
}
}

Any pointers would be good

Thank you

Check If Dropdown Option Matches And Select

Similar Tutorials

View Content

Hi,

I am doing an EDIT user page and would like to check records with a dropdown and then set as selected, please help!

<select name="BrokerID" class="small-input">

<option value="Please select an option">Please select a Broker</option>

<?php

while($row2 = mysql_fetch_array($broker))

{

echo '<option name="BrokerID" value="'.$row2['BrokerID'].'">'.$row2['BrokerName'].'</option>';

}

</select>

Php Stream Mp4, Detect When Client Stops Streaming, Or Disconnects

Similar Tutorials

View Content

I am currently streaming my mp4 files perfectly fine using php. My issue is, how do I detect when the video is either no longer being watched, or disconnected? I need to run a function after this so that I know the video is no longer being watched for analytics. Is there a way maybe with sockets or something? I'm currently using this.

if (file_exists($request)) {
        $fp = @fopen($request, 'rb');
        $size = filesize($request);
        $length = $size;
        $start = 0;
        $end = $size - 1;
        header("Content-Type: video/mp4");
        header('Accept-Ranges: 0-' . $length);

        if (isset($_SERVER['HTTP_RANGE'])) {
            $c_start = $start;
            $c_end = $end;
            list(, $range) = explode('=', $_SERVER['HTTP_RANGE'], 2);

            if (strpos($range, ',') !== false) {
                header('HTTP/1.1 416 Requested Range Not Satisfiable');
                header('Content-Range: bytes ' . $start . '-' . $end . '/' . $size);
                exit();
            }

            if ($range == '-') {
                $c_start = $size - substr($range, 1);
            }
            else {
                $range = explode('-', $range);
                $c_start = $range[0];
                $c_end = (isset($range[1]) && is_numeric($range[1]) ? $range[1] : $size);
            }

            $c_end = ($end < $c_end ? $end : $c_end);
            if (($c_end < $c_start) || (($size - 1) < $c_start) || ($size <= $c_end)) {
                header('HTTP/1.1 416 Requested Range Not Satisfiable');
                header('Content-Range: bytes ' . $start . '-' . $end . '/' . $size);
                exit();
            }

            $start = $c_start;
            $end = $c_end;
            $length = ($end - $start) + 1;
            fseek($fp, $start);
            header('HTTP/1.1 206 Partial Content');
        }

        header('Content-Range: bytes ' . $start . '-' . $end . '/' . $size);
        header('Content-Length: ' . $length);
        ob_end_flush();
        $buffer = 8192;
        $time_start = time();
        $bytes_read = 0;

        while (!feof($fp) && (($p = ftell($fp)) <= $end)) {
            $response = stream_get_line($fp, $buffer);
            echo $response;
            $bytes_read += strlen($response);

            if (30 <= time() - $time_start) {
                file_put_contents('/var/www/html/movieCon/'.$user.'_'.$token.'_'.$movie_id.'.con', time());
                $time_start = time();
                $bytes_read = 0;
            }
        }

        fclose($fp);
        exit();
    }

Speed Performance.

Similar Tutorials

View Content

Im going to use a large array of arrays, each of one having a lot of values and some sub arrays. My question is... is faster to use arrays or is better to have a object to acces using methods and all? i suppose objects are slower...

Also i was planing in use arrays with string keys in nearly all places, normally these are slower, but in php hashes and arrays are the same tipe so i dont know...

Echo Out Something When $selected_dir Matches The Same Name (first Part) Of A Html File

Similar Tutorials

View Content

Hi I want to echo out something when I post the value of a radio button and this value matches the same name of a html file. How can I formulate my code to achieve that? What I have so far:

 <?php  
 
   if (isset($_POST['submitradio']))
{ 
    $selected_dir = $_POST['radio1'];

  echo substr($selected_dir, 0, -4);
  echo '<img src="'.$selected_dir.'" />';
  
} 
?>

So far I get for example the name of the image(order.gif) and the image order. gif. What I now want is to formulate my code so that I can say if I have an image called "order.gif" and a file called "order.html" that I can then echo out some thing. I don't want to actually name the image or the html file. I just want to say if I have two different file types that start with the same name then I can echo out what ever. How can I do that?

In_array() Very Slow Performance

Similar Tutorials

View Content

I have the following simple code to test against collision on a primary key I am creating:

Code: [Select]
$machine_ids = array();
for($i = 0; $i < 100000; $i++) {
//Generate machine id returns a 15 character alphanumeric string
$mid = Functions::generate_machine_id();

if(in_array($mid, $machine_ids)) {
die("Collision!");
} else {
$machine_ids[] = $mid;
}
}

die("Success!");

Any idea why this is taking minutes to run? Anyway to speed it up?

How Can I Optimize My Php Code For Better Performance

Similar Tutorials

View Content

I am very new to PHP and have tried various techniques but I am getting a 500 error when clicking on the export button to download a csv report. I'm not sure why the previous developer did it this way.

Is there a better why in PHP to make this code better? Willing to understand and learn from an PHP expert.

The database is MYSQL.

            $coursefilterid = $_GET['course'];

            $conn = new mysqli($host, $username, $password, $database);
            if ($conn->connect_error) {
                die("Connection failed: " . $conn->connect_error);
            }

            $sqluserenrolled = "select mdl_user.username, mdl_user_enrolments.userid as enrolleduserid, mdl_enrol.courseid from mdl_user_enrolments
    Inner Join
    mdl_enrol
    on 
    mdl_enrol.id = mdl_user_enrolments.enrolid
    Inner Join
    mdl_user
    on
    mdl_user.id = mdl_user_enrolments.userid
    where  
    mdl_enrol.courseid = '" . $coursefilterid . "'
    order by mdl_user.username
    
    ";

            $queryenrolleduser = mysqli_query($conn, $sqluserenrolled);

            ?>

<html>
<head>
</head>
<body>

    <form method="post"
        action="<?php echo "userlistssiexport.php?id=$coursefilterid"?>">
        <input type="hidden" name="exportcourseid"
            value="<?php echo $coursefilterid;?>"> <input type="hidden"
            name="sessid" value="<?php echo $USER->sesskey;?>"> <input
            class="btn btn-primary" type="submit" name="submit"
            value="<?php echo "Export";?>">
    </form>


<?php
            $noteid = "";
            $cmId = "";
            ?>
          
    <table class="data-table">
        <caption class="title">User info</caption>
        <thead>
            <tr>
                <th>Username</th>
                <th>Firstname</th>
                <th>Lastname</th>
                <th>Email</th>
                <th>Last login</th>
                <th>Createddate</th>
                <th>Position</th>
                <th>Organization</th>
                <th>Certificate Request Date</th>
                <th>Role1</th>
                <th>Role2</th>
                <th>Role3</th>
            </tr>
        </thead>
        <tbody>

    <?php

            while ($row = mysqli_fetch_array($queryenrolleduser)) {

                $enrolleduserid = $row['enrolleduserid'];

                $sql = "select mdl_user.username as username, 
        mdl_user.firstname as firstname,
        mdl_user.lastname as lastname,
        mdl_user.email as email,
       mdl_user.lastlogin as lastaccess,
        mdl_user.timecreated as createddate,
        mdl_user_info_data.data as position 
        
        
        from mdl_user
        Inner Join 
        mdl_user_info_data
        on
        mdl_user_info_data.userid = mdl_user.id
        Inner Join
        mdl_user_info_field
        on 
        mdl_user_info_field.id = mdl_user_info_data.fieldid
        Inner Join
        mdl_user_lastaccess
        on
        mdl_user_lastaccess.userid = mdl_user.id
        
        
        where  mdl_user_info_field.id = 1
        and
        mdl_user.deleted = 0
        and
        mdl_user.id = '" . $enrolleduserid . "'
        group by mdl_user.username
        order by mdl_user.username
    
        ";
                $query = mysqli_query($conn, $sql);

                if (! $query) {
                    die('SQL Error: ' . mysqli_error($conn));
                } else {}

                ?>

        <?php
                $no = 1;
                $total = 0;
                $username = '';
                $coursename = '';
                $content = '';
                $modulename = '';
                $organization = '';
                $userid = '';
                $certificatedate = '';
                $userrole = '';
                $enrolleduserid = '';

                while ($row = mysqli_fetch_array($query)) {
                    // Do something here
                    $username = $row['username'];
                    $coursename = $row['coursename'];
                    $content = $row['content'];
                    $noteid = $row['noteid'];
                    // $notedatetime = date("d/m/y g:i (A)", $row['notedate']);
                    $notedatetime = date("D M j Y G:i A", $row['notedate']);
                    $lastaccess = date("D M j Y G:i A", $row['lastaccess']);
                    $createddate = date("D M j Y G:i A", $row['createddate']);
                    $datafile = $username . $coursename . $content;

                    echo '<tr>      
                    <td>' . $row['username'] . '</td>
                    <td>' . $row['firstname'] . '</td>
                    <td>' . $row['lastname'] . '</td>
                    <td>' . $row['email'] . '</td>                          
                    <td>' . $lastaccess . '</td>                                    
                    <td>' . $createddate . '</td>   
                    <td>' . $row['position'] . '</td>    
                                                    
                ';
                    $modid = $row['contextid'];
                    // Get module name

                    $sqlmodule = "select mdl_user.username as username, 
        mdl_user.firstname as firstname,
        mdl_user.lastname as lastname,
        mdl_user.email as email,
        FROM_UNIXTIME(mdl_user_lastaccess.timeaccess) as lastaccess,
        FROM_UNIXTIME(mdl_user.timecreated) as createddate,
        mdl_user_info_data.data as organization 
        
        
        from mdl_user
        Inner Join 
        mdl_user_info_data
        on
        mdl_user_info_data.userid = mdl_user.id
        Inner Join
        mdl_user_info_field
        on 
        mdl_user_info_field.id = mdl_user_info_data.fieldid
        Inner Join
        mdl_user_lastaccess
        on
        mdl_user_lastaccess.userid = mdl_user.id
        
        
        where  mdl_user_info_field.id = 3
        and
        mdl_user.deleted = 0
        and
        mdl_user.username ='" . $username . "'";

                    $querymodule = mysqli_query($conn, $sqlmodule);
                    ?>              
            <?php
                    $modulenamelink = "";
                    while ($row = mysqli_fetch_array($querymodule)) {

                        $organization = $row['organization'];
                    }

                    echo '<td>' . $organization . '</td>';

                    $sqlCertificateDateuid = "select id from mdl_user where username = '" . $username . "'";

                    $queryCertificateDateuid = mysqli_query($conn, $sqlCertificateDateuid);
                    while ($row = mysqli_fetch_array($queryCertificateDateuid)) {

                        $userid = $row['id'];
                    }

                    $sqlcertificatedate = "select * from mdl_certificateemail where userid = '" . $userid . "'
        and courseid = '" . $coursefilterid . "'";

                    $querycertificaterequestdate = mysqli_query($conn, $sqlcertificatedate);
                    while ($row = mysqli_fetch_array($querycertificaterequestdate)) {

                         $certificatedate = date("D M j Y g:i:s A", $row['unixdatetimecertificate']);
                    }
                    echo '<td>' . $certificatedate . '</td>';

                    $sqluserrole = "select mdl_role_assignments.userid, mdl_role_assignments.roleid,mdl_course_modules.course, mdl_role.shortname as rolename,FROM_UNIXTIME(mdl_role_assignments.timemodified)  from mdl_role_assignments 
        Inner Join
        mdl_context
        on
        mdl_context.id = mdl_role_assignments.contextid
        Inner Join
        mdl_course_modules
        on 
        mdl_course_modules.instance = mdl_context.instanceid
        Inner Join
        mdl_role
        on 
        mdl_role.id = mdl_role_assignments.roleid
        
        where mdl_course_modules.course = '" . $coursefilterid . "'
        and
        mdl_role_assignments.userid = '" . $userid . "'
        group by
        mdl_role_assignments.userid,
        mdl_role_assignments.roleid,
        mdl_course_modules.course,
        mdl_role.shortname,
        mdl_role_assignments.timemodified
        
        order by mdl_role_assignments.timemodified
        ";

                    $userlistrole = '';
                    $queryuserrole = mysqli_query($conn, $sqluserrole);
                    while ($row = mysqli_fetch_array($queryuserrole)) {

                        $userrole = $row['rolename'];
                        $userlistrole = array(
                            array(
                                $userrole
                            )
                        );
                        // echo '<td>'.$userrole.'</td>';
                    }

                    foreach ($userlistrole as $listrole) {

                        // echo $listrole;
                    }

                    $teacherrole = array(
                        'student'
                    );
                    foreach ($teacherrole as $rolename) {
                        $role = $DB->get_record('role', array(
                            'shortname' => $rolename
                        ));
                        $context = get_context_instance(CONTEXT_COURSE, $coursefilterid);
                        // $context = context_course::instance($cid1);
                        $teachers = get_role_users($role->id, $context);

                        foreach ($teachers as $teacher) {

                            $teacherid = $teacher->id;
                            if ($teacherid == $userid) {
                                echo '<td>student</td>';
                            }
                        }
                    }

                    $teacherrole = array(
                        'editingteacher'
                    );
                    foreach ($teacherrole as $rolename) {
                        $role = $DB->get_record('role', array(
                            'shortname' => $rolename
                        ));
                        $context = get_context_instance(CONTEXT_COURSE, $coursefilterid);
                        // $context = context_course::instance($cid1);
                        $teachers = get_role_users($role->id, $context);

                        foreach ($teachers as $teacher) {

                            $teacherid = $teacher->id;
                            if ($teacherid == $userid) {
                                echo '<td></td>';
                                echo '<td>editingteacher</td>';
                            }
                        }
                    }

                    $teacherrole = array(
                        'manager'
                    );
                    foreach ($teacherrole as $rolename) {
                        $role = $DB->get_record('role', array(
                            'shortname' => $rolename
                        ));
                        $context = get_context_instance(CONTEXT_COURSE, $coursefilterid);
                        // $context = context_course::instance($cid1);
                        $teachers = get_role_users($role->id, $context);

                        foreach ($teachers as $teacher) {

                            $teacherid = $teacher->id;
                            if ($teacherid == $userid) {
                                echo '<td>manager</td>';
                            }
                        }
                    }
                    echo '</tr>';
                }
            }

            ?>

    
        </tbody>
        <tfoot>

        </tfoot>
    </table>
</body>
</html>

<?php
    }
}

else {
    header("Location:/index.php");
    // echo "something";
    die();
}
}

else {

header("Location:/index.php");
die();

}

?>

How To Do A Mysql/php Performance Test?

Similar Tutorials

View Content

I want to do a test while refreshing the page 100 times with 500 rows in a table, and then without 500 rows in a table and with different kind of php code, i need to do some type of testing to get results back in to show which way is faster for mysql/php.

Any idea how to do this any scripts out there or a built in php/mysql function?

Thanks

Mysqli::multi_query() Performance

Similar Tutorials

View Content

A few questions that if I was more knowledgeable about MySQL (such as the query log that I've heard of).
- Does mysqli::multi_query() make multiple requests to the server or just one?
- If it is just splitting the queries on the semicolon and then making multiple requests, is it still faster than looping and querying in PHP?
- Does it take less memory than, lets say, mysql_query() foreach query?
- Is it faster than, lets say again, mysql_query() looped?

The last 2 I can probably just benchmark myself but I'm hoping someone will know off had.

Background (blah blah blah)
I'm working on a lean rapid development framework for myself (and maybe others eventually) to use. Much like Cake and other frameworks it does a lot of queries, often times more then you need. The sacrifice of course is performance VS ease of development, but I'm trying to not make a martyr out of my framework :-)

I've observed on many occasions that simple queries can take more time than a complex query on seemingly random occasions. My understanding is that this is because of the connection, not the real amount of time it took for the server to query. I figure if I avoid multiple requests to the server I will cut down on the time everything takes. My theory is based on the same concept of combining all your CSS and JS files into single files to avoid dozens of HTTP requests which slow down page load time.