SQL Script to Backup all SQL Server Databases Backup all databases on your server using T-SQL is a much simpler and faster. Below T-SQL script will generate backup of all databases with date stamp in backup file name. Update the backup path in below script. DECLARE @dbname NVARCHAR(256) DECLARE @filepath NVARCHAR(512) DECLARE @fileName NVARCHAR(512) DECLARE @Date NVARCHAR(40) -- Database backup directory SET @filepath = 'D:\backup\' -- filename format SELECT @Date = CONVERT(NVARCHAR(20),GETDATE(),110) DECLARE backup_cursor CURSOR READ_ONLY FOR SELECT name FROM master.sys.databases WHERE name NOT IN ('master','model','msdb','tempdb') -- exclude system databases AND state = 0 -- Online database AND is_in_standby = 0 -- database is not read only for log shipping OPEN backup_cursor FETCH NEXT FROM backup_cursor INTO @dbname WHILE @@FETCH_STATUS = 0 BEGIN SET @fileName = @filepath + @dbname + '_' + @Date + '.bak' BACKUP DATABASE @dbname TO DISK = @fileName WITH INIT FETCH NEXT FROM backup_cursor INTO @dbname END CLOSE backup_cursor DEALLOCATE backup_cursor

Problem with AJAX when send JSON to PHP, ¿ParseError?

Fayyazuddin

I have this problem

My Ajax request:

 function test(){
        
        const json = {"name" : {"name" : "test", "other" : 4} };

        $.ajax({
            type: "POST",
            url: "http://localhost:8080/print.php",
            data: {m:json, mm:"5"},
            dataType: 'application/json; charset=utf-8',
            cache: false,
            success: function(neu){
                console.log(neu.status);
            },
            error: function( jqXHR, textStatus, errorThrown ) {
                console.log(textStatus);
                console.log(errorThrown);
            }
        }).fail( function( jqXHR, textStatus, errorThrown ) {
            console.log(textStatus);
            console.log(errorThrown);
        });

  }

My PHP (print.php)

<?php
  header('Access-Control-Allow-Origin: *');
  header('Content-type: application/json');
  $ticket = $_POST['m'];
  // if remove this, print "ok" "ok" and i don't know why, never had problem with that
  $connector = new NetworkPrintConnector("192.168.1.5",9100);
  $printer = new Printer($connector);
  //
  $response['status'] = "ok";
  echo json_encode($response);
?>

When i make test(); on console Return : "ok" 1 time , no errors (always good)

But when i make test();test(); at the same time on console... Return : "ok" only 1 time, when it should be "ok" "ok" without errors

ok
parsererror
index.php:8408 SyntaxError: Unexpected token < in JSON at position 0
at JSON.parse (<anonymous>)
at n.parseJSON (jquery.js?v=270:4:5309)
at vc (jquery.js?v=270:4:7397)
at x (jquery.js?v=270:4:10802)
at XMLHttpRequest.<anonymous> (jquery.js?v=270:4:14767)
index.php:8411 parsererror
index.php:8412 SyntaxError: Unexpected token < in JSON at position 0
at JSON.parse (<anonymous>)
at n.parseJSON (jquery.js?v=270:4:5309)
at vc (jquery.js?v=270:4:7397)
at x (jquery.js?v=270:4:10802)
at XMLHttpRequest.<anonymous> (jquery.js?v=270:4:14767)

jquery.js is just jquery 2.1.4 library.

I tried: Quit dataType: 'application/json; charset=utf-8', and put dataType: 'json', Without dataType, With and Without : header('Content-type: application/json'); on PHP..