PHP - Javascript Attached File Not Works

Back with more noob questions

so I was following a page in setting up a login system and so far it works how I want except for one minor thing

So I want when a user is logged into the system to see Profile div instead of Login and Register and I do that in my index.php with the following

 <?php  if(isset($_SESSION['username'])){
	echo 
    	"<div class='profile'> 
  		    <a href='logout.php'>Logout</a>
  		    
  		    </div> 
  		    ";
    }
    else{
    	echo 
    	"<div class='loginregister'> 
  		    <a href='login.php'>Login</a>
  		    <a href='register.php'>Register</a>
  		    </div> 
  		    ";
    }
    ?>

So when a user logs in it hits the login.php which looks like this 

<?php
    require('dbconnect.php');

    session_start();
    // When form submitted, check and create user session.
    if (isset($_POST['username'])) {
        $username = stripslashes($_REQUEST['username']);    // removes backslashes
        $username = mysqli_real_escape_string($conn, $username);
        $password = stripslashes($_REQUEST['password']);
        $password = mysqli_real_escape_string($conn, $password);
        // Check user is exist in the database
        $query    = "SELECT * FROM `Users` WHERE User='$username'
                     AND password='" . md5($password) . "'";
        $result = mysqli_query($conn, $query) or die(mysql_error());
        $rows = mysqli_num_rows($result);
        if ($rows == 1) {
            $_SESSION['username'] = $username;
            // Redirect to user dashboard page
            header("Location: index.php");
        } else {
            echo "<div class='form'>
                  <h3>Incorrect Username/password.</h3><br/>
                  <p class='link'>Click here to <a href='login.php'>Login</a> again.</p>
                  </div>";
        }
    } else {

and it starts the session_start() function whilst also allocating $_SESSION['username'] = $username so in theory when index.php loads if SHOULD (?) hit the correct if statement in the index.php file now outputting the Profile div instead of the Login and Register div.

Except it doesn't.

However when I include the auth_session.php at the top of my index.php file like (currently uncommented to test)

//<?php //include auth_session.php file on all user panel pages 
//include("auth_session.php");
//?>

with the Auth_session file looking like

<?php
    session_start();
    if(!isset($_SESSION["username"])) {
        header("Location: login.php");
        exit();
    }
    else { 
    }
?>

It does show the correct Profile div instead of the Login  and Register div.

So I'm trying to understand what is happening here as from the look of it the $_SESSION['username'] is allocated within login.php and the session_start() function is also started in login.php

So why would I need auth_session.php to be ran in order for the correct divs to show (I've not included auth_session.php as I want people to be able to see the site that aren't logged in)

Warm regards

<?php

require '<snip partial URL>mysqli.php';

// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

$result = mysqli_query($con,"SELECT `callsign`, `qth`, `submitted` FROM `lqplogs` ORDER BY `callsign`");

echo "<table>
<tr>
<th><u>CALLSIGN</u></th><th><u>QTH</u></th><th><u>LOG SUBMITTED</u></th>
</tr>";


while($row = mysqli_fetch_array($result)) {
  echo "<tr>";
  echo "<td>" . $row['callsign'] . "</td>";
  echo "<td>" . $row['qth'] . "</td>";
  echo "<td>" . $row['submitted'] . "</td>";
  echo "</tr>";
}

echo "</table>";

mysqli_close($con);
?>

"; while($row = mysqli_fetch_array($result)) { echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
CALLSIGN	QTH	LOG SUBMITTED
" . $row['callsign'] . "	" . $row['qth'] . "	" . $row['submitted'] . "
"; mysqli_close($con); ?> 

Hi, this query runs fine when I run it from PHPMyAdmin:
 

UPDATE `tran_term_taxonomy` SET `description` = (SELECT keyword from `good_keywords` ORDER BY RAND() LIMIT 1,1) WHERE `tran_term_taxonomy`.`taxonomy` = 'post_tag' AND `tran_term_taxonomy`.`description` = "" LIMIT 1

However, when I run the same query in a PHP file on my server, the page doesn't load at all. The message I get is: www.somesite.com is currently unable to handle this request. HTTP ERROR 500. This is my PHP code:

<?php 
include("/database/connection/path/db_connect.php"); 

$result4 = mysqli_query($GLOBALS["___mysqli_ston"], "UPDATE `tran_term_taxonomy` SET `description` = (SELECT keyword from `good_keywords` ORDER BY RAND() LIMIT 1,1) WHERE `tran_term_taxonomy`.`taxonomy` = 'post_tag' AND `tran_term_taxonomy`.`description` = "" LIMIT 1");
echo $result4;

?>

So how do I make this query work please? Thanks for your guidance.

$mbox = imap_open("{SERVER}", "user", "pass");

echo "<h1>Mailboxes</h1>\n";
$folders = imap_listmailbox($mbox, "{SERVER}", "*");

if ($folders == false) {
    echo "Call failed<br />\n";
} else {
    foreach ($folders as $val) {
        echo $val . "<br />\n";
    }
}

echo "<h1>INBOX</h1>\n";
$headers = imap_headers($mbox);

if ($headers == false) {
    echo "Call failed<br />\n";
} else {
    $i=0;
    foreach ($headers as $val) {

$i++;

        echo $val . "<br />\n";
    }
}

imap_close($mbox);

Hi all,

I need some help with my code as I've a trouble with sending the emails with images attachments. I'm using Pear Mail library to send the emails so when I send the emails with attachments to gmail, I am unable to see the attached images in my gmail inbox as there is no images show on the bottom of the subject unless when I open on my email so I can see the images attachments. And I am unable to see the images on yahoo when i sent the emails, so I sent a test email on my webmail with the images as attachments and I can see the images on gmail and yahoo with no problem. I think there is a problem with my PHP script that need to be resolve. 

Here is where I am getting the problem with:
       

//attachments
        if (is_array($email_attachments)) {
            foreach ($email_attachments as $attachments) {
                $filename = str_replace('uploads/', '', $attachments);
                $attachment = '';
                $file_path = '';
                $type = '';

                if (strpos($filename, '.png') !== false) {
                    $type .= 'image/png';
                }
    
                // ADD attachment(s)
                $attachment1 .= "--$boundary1\r\n";
                $attachment1 .= "Content-Type: $type; name=\"$filename\"\r\n";
                $attachment1 .= "Content-Transfer-Encoding: base64\r\n";
                $attachment1 .= "Content-Disposition: attachment; filename=\"$filename\"\r\n";
                $attachment1 .= "\r\n\r\n";
                $attachment1 .= $attachment;
                $attachment1 .= "\r\n\r\n";

                $body .= $attachment1;
                $mime->addAttachment($file_path, $type);
            }
        }

Here is the full code:

<?php

require_once('Mail.php');
require_once('Mail/mime.php');
require_once('Mail/IMAPv2.php');

ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

//Connect to the database
include('config.php');

// Connect to the server:
$username = 'myusername';
$password = 'mypassword';
$smtp_hostname = "smtp.mydomain.com";
$port = "587";
$attached_files = array();
$inline_images = array();
global $inline_images;

if (isset($_POST['send_to']))
{
    $from = "Mark <name@mydomain.com>";
    $to_email = $_POST['send_to'];
    $subject = $_POST['email_subject'];
    $message ='<div dir="ltr">' . $_POST['email_body'] . '</div>';
    $email_attachments = $_POST['email_attachment'];
    $total_emails = count($to_email);
    $email_number = $_POST['email_number'];
    $sent_message = $message;
    $attachment1 = '';
    $inline_id = 0.1;
    $success = '';
    $base64 = [];
    $src = [];

    //Check if the images is base64
    if (strpos($message, 'data:image/') !== false)
    {
        // read all image tags into an array
        preg_match_all('/<img.*?src="data:image\/.*;.*,(.*)".*?>/i', $message, $match, PREG_PATTERN_ORDER);
        $base64 = array_pop($match);

        if (is_array($src)) 
        {
            foreach($base64 as $images)
            {
                $type = end(explode('/', (explode(';', $images))[0]));
                $filename = md5(time().uniqid()). '.' . $type;
                $base64_string = str_replace('data:image/png;base64,', '', $images);
                $base64_string = str_replace(' ', '+', $base64_string);
                $decoded = base64_decode($base64_string);
                $fp = fopen("uploads/". $filename, "w+");
                fwrite($fp, $decoded);
                fclose($fp);
            }
        }
    }

    //check if the inline images is in the array
    if (strpos($message, '<img src=') !== false)
    {
        // read all image tags into an array
        preg_match_all('@src="([^"]+)"@' , $message, $match);
        $src = array_pop($match);

        if (is_array($src)) 
        {
            foreach ($src as $key => $value)
            {
                $parsed = parse_url($src[$key]);
                $filename = basename($parsed['path']);
                $content = file_get_contents($src[$key]);

                if (!file_exists($filename))
                {
                    $fp = fopen("uploads/". $filename, "w+");
                    fwrite($fp, $content);
                    fclose($fp);
                }
            }
        }
    }
    $boundary1 = '###'.md5(microtime()).'###';
    $boundary2 = '###'.md5(microtime().rand(99,999)).'###';


    foreach ($to_email as $to)
    {
        $name = '';
        $email = '';


        if (strpos($to, ' <') !== false) {
            $name_str = explode(' <', $to);
            $email_str = explode(' <', $to);
            $name = $name_str[0];
            $email = str_replace('>', '', $email_str);
            $email = $email[1];
        }
        $messageID = sprintf("<%s.%s@%s>",
            base_convert(microtime(), 10, 36),
            base_convert(bin2hex(openssl_random_pseudo_bytes(8)), 16, 36),
            'mydomain.com');
        $message_id = getMessageid(isset($message_id));
        $now = new DateTime();
        $email_id = $now->getTimestamp();
        $sent_date = date('Y-m-d H:i:s');
        $sent_mailbox1 = $link->prepare("SELECT * FROM sent WHERE message_id = ?");
        $sent_mailbox1->execute([$message_id]);
        $emailID = '';
        
        if (!$name == '' && !$email == '') {
            if ($name == $email) {
                $to = $email;
            }
        }


        if ($sent_mailbox1->rowCount() == 0)
        {
            $sent_mailbox1 = $link->prepare("INSERT INTO sent (from_email, to_email, message_id) VALUES (?,?,?)");
    
            if ($sent_mailbox1->execute([$from, $to, $message_id]))
            {
                $emailID = $link->lastInsertId();
            }
        }


        //check if the images is base64
        if (is_array($base64)) 
        {
            $sent_message .= 'http://mydomain.com/u/?id='.$email_id.'&attid='.$inline_id.'&msgid='.$message_id.'&view=attachment&display=view';
            $inline_id += 0.1;
        }
        else if (!$base64 == '') {
            $sent_message .= 'http://mydomain.com/u/?id='.$email_id.'&attid='.$inline_id.'&msgid='.$message_id.'&view=attachment&display=view';
            $inline_id += 0.1;
        }


        //check if the inline images is in the array
        if (is_array($src)) 
        {
            $sent_message .= 'http://mydomain.com/u/?id='.$email_id.'&attid='.$inline_id.'&msgid='.$message_id.'&view=attachment&display=view';
            $inline_id += 0.1; 
        }
        else if (!$src == '') {
            $sent_message .= 'http://mydomain.com/u/?id='.$email_id.'&attid='.$inline_id.'&msgid='.$message_id.'&view=attachment&display=view';
            $inline_id += 0.1;
        }
        $message .= '<img src="http://mydomain.com/track/Images/signature.gif?id='.$emailID.'&etc='.time(). '" ' . 'style="width:0;max-height:0;overflow:hidden" alt="">';


        $headers = array ('From' => $from, 
            'To' => $to, 
            'Subject' => $subject,
            'Reply-To' => $from,
            //'Content-Type'  => 'Content-Type: text/plain; charset="UTF-8"',
            'Content-Type'  => 'Content-Type: multipart/mixed; boundary="=_d909e7abc497193ad3b6636530382391"',
            'MIME-Version' => '1.0',
            'Received' => 'from mail.mydomain.com',
            'Date'  => date("r"),
            'Message-ID' => '<'.sha1(microtime(true)).'@mydomain.com>');


        $crlf = "\r\n";
        $mime = new Mail_mime(array('eol' => $crlf));
        //$mime = new Mail_mime("\r\n");
        $html = $message;
        $text = strip_tags($html);
        $body = $html;

        $mime->setTXTBody($text);
        $mime->setHTMLBody($html);

        //check if the img tags have url called display=view
        if (strpos($message, 'display=view') !== false) {
            $pattern = '@src="([^"]+)"@';
            $message = preg_replace_callback($pattern,"setImageLinks", $message);
    
            foreach ($inline_images as $inline_image) {
                $file_path =  $inline_image;
                $typeInt = imagetype($file_path);
    
                //code goes here to find the imagetype case
                switch ($typeInt) {
                    case IMG_GIF:
                        $imageType = 'image/gif';
                        break;
                    case IMG_JPG:
                        $imageType = 'image/jpg';
                        break;
                    case IMG_JPEG:
                        $imageType = 'image/jpeg';
                        break;
                    case IMG_PNG:
                        $imageType = 'image/png';
                        break;
                    case IMG_WBMP:
                        $imageType = 'image/wbmp';
                        break;
                    case IMG_XPM:
                        $imageType = 'image/xpm';
                        break;
                    default: 
                        $imageType = 'unknown';
                }
                $mime->addHTMLImage($file_path, $imageType);
            }
        }


        //attachments
        if (is_array($email_attachments)) {
            foreach ($email_attachments as $attachments) {
                $filename = str_replace('uploads/', '', $attachments);
                $attachment = '';
                $file_path = '';
                $type = '';

                if (strpos($filename, '.png') !== false) {
                    $type .= 'image/png';
                }
    
                // ADD attachment(s)
                $attachment1 .= "--$boundary1\r\n";
                $attachment1 .= "Content-Type: $type; name=\"$filename\"\r\n";
                $attachment1 .= "Content-Transfer-Encoding: base64\r\n";
                $attachment1 .= "Content-Disposition: attachment; filename=\"$filename\"\r\n";
                $attachment1 .= "\r\n\r\n";
                $attachment1 .= $attachment;
                $attachment1 .= "\r\n\r\n";

                $body .= $attachment1;
                $mime->addAttachment($file_path, $type);
            }
        }

        // always call these methods in this order
        $mime_params = array(
            'text_encoding' => '7bit',
            'text_charset'  => '"UTF-8"',
            'html_charset'  => '"UTF-8"',
            'head_charset'  => '"UTF-8"'
        );
        //$body = $mime->get(array('text_encoding' => '8bit','html_encoding' => '8bit'));
        $body = $mime->get($mime_params);
        $headers = $mime->headers($headers);

        $smtp_params = array ('host' => $smtp_hostname,
            'port' => $port,
            'auth' => true, // Note 1
            'username' => $username,
            'password' => $password);

        $smtp = Mail::factory('smtp', $smtp_params);
        $mail = $smtp->send($to, $headers, $body);
        

        if (PEAR::isError($mail)) 
        {
            echo("<p>" . $mail->getMessage() . "</p>");
        }
        else 
        {
            echo("<p>Email has been sent!</p>");
            $response = array("success"=>$success);
            echo json_encode($response);
        }
    }
}

Do you know why the images wont show up on yahoo and gmail when I send the images as attachment?

I have checked on the image path and i have put the correct image path so it should work fine.

If you can be able to test it for me to find out why the images wont display and if you fix the issue, please let me know what change I need to make so I will try it out.

Any advice would be much appreciated.

Thanks in advance.

I am trying to implement this for two days now but stuck with logics ! Please help.
What I can get the due left of every person easily for the following table [image attached] -
table link:  https://ibb.co/xC53Cf4
where
1.inc_due is the column to get total due for specific person like cust_id
2. inctype_id =11 is the type of dues paid for specific person (cust_id)
3. echo only due left by cust_id or person id

<?php
	$db=mysql_connect  ("localhost", "webwibco_charlie",  "Hello123") or die ('I cannot connect to the database  because: ' . mysql_error()); 
	$mydb=mysql_select_db("webwibco_products"); 

	include("header.php");

	$status = htmlspecialchars( @$_GET ['p'] );

	if ($status == "floorpuzzles") {

		     echo "<h1>Our Floor Puzzles</h1>";
		$sql="SELECT  ID, Name, Tags, Description, Category FROM products WHERE Category LIKE '%" . FloorPuzzles .  "%'"; 
		$result=mysql_query($sql); 
		while($row=mysql_fetch_array($result)){ 
			$Name  =$row['Name'];
			$ID  =$row['ID']; 
			$Description  =$row['Description'];  
			echo "<div class=\"box\">";
			echo "<h1>$Name</h1>";
			echo "<div class=\"floorbox\"><a href=\"?p=$ID\"><img src=\"images/products/catalogue/big/floorpuzzles/$ID.jpg\" class=\"small\"></a></div>";
			echo "<h2>$Description</h2>";
			echo "</div>";
		}
?>
<?
}else{



	if ($status == $_GET["p"]) {
		$sql="SELECT  ID, Name, Tags, Description, Pieces, Size, Barcode, Category FROM products WHERE ID = '" . $_GET['p'] .  "'";   
		$result=mysql_query($sql);   
		while($row=mysql_fetch_array($result)){  
			$Name  =$row['Name'];
			$ID  =$row['ID']; 
			$Description  =$row['Description']; 
			$Pieces  =$row['Pieces']; 
			$Size  =$row['Size']; 
			$Barcode  =$row['Barcode'];   
			echo "<div class=\"1\">";
			echo "<h1>$Name</h1>";
			echo "<div class=\"bigbox\">";
			echo "<div class=\"floorbox\"><img src=\"images/products/catalogue/big/floorpuzzles/$ID.jpg\" class=\"big\"></div>";
			echo "</div>";
			echo "</div>";
			echo "<div class=\"2\">";
			echo "<p>Puzzle Pieces: $Pieces</p>
				  <p>Puzzle Size: $Size</p>
				  <p>Barcode: $Barcode</p>";
			echo "</div>"; 
		} 
		}else{
?>
<?
			echo"<h1>Our Products</h1>
				<p>Our jigsaw puzzles are hand cut by skilled craftsmen and therefore each one is unique with self-correcting pieces. There is a strict quality control process at all stages by our highly experienced staff. The puzzles are durable and provide fun and excitement, enhancing learning and a child’s development.<p>
				<p>All of our jigsaws are made using materials from sustainable resources grown in managed forests. Where possible we support companies in the UK and source our components locally, most of our suppliers are in the East Midlands, many in Derbyshire and Nottinghamshire. We keep packaging to a minimum and take our environmental and ethical responsibilities very seriously.</p>
				<p>Reducing waste and recycling was a way of life for us before it became fashionable. We are constantly searching for new ideas and consult teachers when developing our jigsaws, which are often used within the national curriculum.</p> 
				<p>As well as making our own range, we manufacture for leading suppliers to the education market. Check for \"Made in Britain\" and it is probably made by us.</p>
				<p>We have a wide variety of products available for viewing, from classic floor puzzles to innovative inset trays. You can take a look at all our products on this page, simply use the navigation buttons to your left.</p>";

				
				}}

include("footer.php");
?>