Posts

Showing posts from November, 2020

Set date time auto file in MySQL

Image

สคริปตรวจสอบความถูกต้องของ email

 if(filter_var($email, FILTER_VALIDATE_EMAIL) === false){              $response['message'] = 'Please enter a valid email.';   }

สคริปตรวจสอบว่ามี file แนบมาในแบบฟอร์มหรือไม่

if (! empty ( $_FILES [ "file" ][ "name" ])){  .... .... } 

aJax upload submit form with file

<script type="text/javascript"> $(document).ready(function(e){     // Submit form data via Ajax     $("#fupForm").on('submit', function(e){         e.preventDefault();         $.ajax({             type: 'POST',             url: 'submit.php',             data: new FormData(this),             dataType: 'json',             contentType: false,             cache: false,             processData:false,             beforeSend: function(){                 $('.submitBtn').attr("disabled","disabled");                 $('#fupForm').css("opacity",".5");             },       ...

insert data and get last id

  $sql =  "INSERT INTO MyGuests (firstname, lastname, email) VALUES ('John', 'Doe', 'john@example.com')" ; $last_id = mysqli_insert_id($conn);

jQuery check for file extension before uploading

ใช้ jQuery ตรวจสอบประเภทไฟล์ก่อน Upload  HTML < input type = "file" id= "FilUploader" /> jQuery $( "#FilUploader" ).change( function ( ) { var fileExtension = [ 'jpeg' , 'jpg' , 'png' , 'gif' , 'bmp' ]; if ($.inArray($( this ).val().split( '.' ).pop().toLowerCase(), fileExtension) == -1 ) { alert( "Only formats are allowed : " +fileExtension.join( ', ' )); } });