Printing label using PHP and ZPL

    // output row from database
    $id = mysql_result($result,0,0);
    $serial = mysql_result($result,0,1);
    $company = mysql_result($result,0,2);
    $phone = mysql_result($result,0,3);
    $url = 'http://intranet/asset/?do=10&id='.$id;
    //$url = urlencode($url);

    // create ZPL script
    $handle = fopen($file_name, 'w') or die('Cannot open file:  '.$file_name);
    $data = '^XA^LH10,10^FO10,10';
    $data = $data."\n".'^BQN,2,4^FDQ '.$url.'^FS';
    $data = $data."\n".'^FT175,60^A0N,45,48^FDASSET ID: '.$id.'^FS';
    $data = $data."\n".'^FT175,105^A0N,34,33^FDS/N: '.$serial.'^FS';
    $data = $data."\n".'^FT175,150^A0N,23,20^FD'.$company.' '.$phone.'^FS';
    $data = $data."\n".'^FT175,175^A0N,15,15^FD'.date('m/d/Y g:i A').'^FS^XZ';
    fwrite($handle, $data);
    fclose($handle);

    // FTP ZPL script to Zebra printer
    $server = '192.168.21.101';
    $mode = 'FTP_BINARY';
    $connection = ftp_connect($server);
    $login = ftp_login($connection, 'user', '');

    if (!$connection || !$login) {
        die('Connection attempt failed!');
    }
    $upload = ftp_put($connection, 'label.zpl', $file_name, FTP_BINARY);

    if (!$upload) {
        echo 'FTP upload failed!';
    }

    ftp_close($connection);


    //delete ZPL script
    unlink($file_name);