<?
// Authenticated group
Route::group(array('before' => 'auth'), function() {
    // CSRF protection group
    Route::group(array('before' => 'csrf'), function() {
        // Order Step 1 (POST AJAX)
        Route::post('/orders/step1Ajax', array(
            'as' => 'orders-step1-ajax',
            'uses' => 'OrderController@postOrderStep1Ajax'
        ));
    });
});    
?>

<?
class OrderController extends BaseController {
    public function postOrderStep1Ajax() {
        if (Request::ajax()) {
            $searchSourceCode     = Input::get('searchSourceCode');
            
            $jsonSourceCodes    = DB::table('sourceCodes')
                ->distinct()
                ->take(12)
                ->where('sourceCode','LIKE', $searchSourceCode . '%')
                ->orderBy('sourceCode','DESC')
                ->get();
            
            return $jsonSourceCodes->toJson();
        }
    }
}
?>

$(document).ready(function() {
	$( '#searchSourceCode' ).autocomplete({
		source: 	function( request, response ) {
			$.ajax({
				type: 		'POST',
				url: 		'http://localhost/Laravel_Auth/fresh/public/orders/step1Ajax',
				data: 		$( '#frmSourceCodeEntry' ).serialize(),
				dataType: 	'JSON',
				success: 	function( data ) {
					response( $.map( data.sourceCodeData, function( item ) {
						return {
							label: item.sourceCode + "(" + item.sourceCodeId + ")",
							sourceCode: item.sourceCode,
							sourceCodeId: item.sourceCodeId
						}
					}));
				}
			});		
		},
		minLength: 	2,
		select: 	function( event, ui ) {
			var sourceCodeId	= ui.item.sourceCodeId;

			if (sourceCodeId === "undefined") {
				console.log('Undefined sourceCode');
			} else {
				$( '#hiddenSourceCodeId' ).attr( 'value', sourceCodeId );
			}

			console.log(ui.item.sourceCode + ' ' + ui.item.sourceCodeId);
		}
	});
})

@extends('layout.main')
@include('includes.jQuery')
@include('includes.autosuggest')
{{ HTML::script("http://localhost/Laravel_Auth/fresh/app/js/orderStep1Autosuggest.js") }}

@section('content')
	<form action="{{ URL::route('orders-step1-post') }}" id="frmSourceCodeEntry" name="frmSourceCodeEntry" method="post">
		<div class="field">
			Source Code: <input type="search" id="searchSourceCode" name="searchSourceCode" {{ (Input::old('searchSourceCode')) ? ' value="' . e(Input::old('searchSourceCode')) . '"' : '' }}>
			@if($errors->has('searchSourceCode'))
				<span style="background:red">{{ $errors->first('searchSourceCode') }}</span>
			@endif
		</div>
		<input type="hidden" name="hiddenSourceCodeId" id="hiddenSourceCodeId">
		<input type="submit" value="Next">
		{{ Form::token() }}
	</form>
@stop

Aniki fucked around with this message at 01:02 on Oct 16, 2014

revmoo fucked around with this message at 21:24 on Oct 16, 2014

<?php
 
// Create connection
$link = mysqli_connect('');
 
// Check connection
if (mysqli_connect_errno())
{
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
 
// This SQL statement selects ALL from the table 'data'
$sql = "SELECT * FROM data ORDER BY `UniqueID` ASC";
 
// Check if there are results
if ($result = mysqli_query($link, $sql))
{
    // If so, then create a results array and a temporary one
    // to hold the data
    $resultArray = array();
    $tempArray = array();
 
    // Loop through each row in the result set
    while($row = $result->fetch_object())
    {
        // Add each row into our results array
        $tempArray = $row;
        array_push($resultArray, $tempArray);
    }
 
    // Finally, encode the array to JSON and output the results
    echo json_encode($resultArray);
}
 
// Close connections
mysqli_close($result);
mysqli_close($link);
?>

thegasman2000 fucked around with this message at 00:25 on Oct 21, 2014

o.m. 94 fucked around with this message at 22:21 on Oct 20, 2014

thegasman2000 fucked around with this message at 00:25 on Oct 21, 2014

<?php
 
// Create connection
$con=mysqli_connect('');
 
// Check connection
if (mysqli_connect_errno())
{
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
 
// This SQL statement selects ALL from the table 'data'
$sql = "SELECT * FROM `data` ORDER BY `UniqueID` ASC";
 
// Check if there are results
if ($result = mysqli_query($con, $sql))
{
    // If so, then create a results array and a temporary one
    // to hold the data
    $resultArray = array();
    $tempArray = array();
 
    // Loop through each row in the result set
    while($row = $result->fetch_object())
    {
        // Add each row into our results array
        $tempArray = $row;
        array_push($resultArray, $tempArray);
    }
 
    // Finally, encode the array to JSON and output the results
    echo json_encode($resultArray);
}
 
// Close connections
mysqli_close($result);
mysqli_close($con);
?>

thegasman2000 fucked around with this message at 00:24 on Oct 21, 2014

kiwid fucked around with this message at 18:11 on Oct 21, 2014

kiwid fucked around with this message at 19:45 on Oct 21, 2014

<?
// connect to the ftp server
$conn = ftp_connect($server);
ftp_login($conn, $username, $password);
ftp_pasv($conn, true);

// get all mp4 files into an array with date modified timestamp
$data = [];
$files = ftp_nlist($conn, '');
foreach ($files as $file) {
    if (pathinfo($file, PATHINFO_EXTENSION) == 'mp4')
    {
        $data[$file] = ftp_mdtm($conn, $file);
    }
}

arsort($data, SORT_NUMERIC); // sort the array by date modified, newest first
$video_time = Settings::get('video_time'); // get the date modified of the last file downloaded

// foreach mp4 file, if file is newer or doesn't exist, download it
foreach ($data as $file => $time)
{
    if (($time > $video_time->value) || ( ! file_exists('video/video_comments.mp4')))
    {
        ftp_get($conn, 'video/video_comments.mp4', $file, FTP_BINARY);
        Settings::update('video_time', $time);
    }

    break; // only check the newest file
}

ftp_close($conn);
?>

kiwid fucked around with this message at 02:52 on Oct 22, 2014