PHP - Create A Certificate Script Help

I can't find out whats the problem here, would appreciate some input in how to think building my "if". The problem is that I don't seem to catch if an email exists, nor if user exists and neither can I create a new user :/.   Appreciate your help alot!

<?php

	// Start the session in case of errors to display within the page of user creation
	session_start();
	$err_msg = array();
	$errflag = false;



	// Check if the submit button was pressed
	if ($_SERVER['REQUEST_METHOD'] === 'POST'
		&& $_POST['submit'] === 'Skapa')
	{
		// Crypt password
		$options = ['cost' => 10];

		$username = strip_tags($_POST['uname']);
		$password = strip_tags(password_hash($_POST['pword'], PASSWORD_DEFAULT, $options));
		$email = strip_tags($_POST['uname'], '@');

		// Check so all the fields are filled
		if ($_POST['uname'] == '' || $_POST['pword'] == '' || $_POST['pwordcheck'] == '')
		{
			$err_msg[] = 'Please enter all fields<br>';
			$errflag = true;
		}

		// See if passwords and confirm matches
		if ($_POST['pword'] !== $_POST['pwordcheck'])
		{
			$err_msg[] = 'Passwords doesn\'t match!<br>';
			$errflag = true;
		}

		// Check password length, atleast 8 characters
		if (strlen($_POST['pword']) < 7)
		{
			$err_msg[] = 'Password must be atleast 8 characters long';
			$errflag = true;
		}

		// Check if email exists
		include_once('../includes/db.inc.php');
		$db = new PDO(DB_INFO, DB_USER, DB_PASS);

		$sql = "SELECT COUNT(*) AS count FROM movies WHERE email = :emailadress";
			$stmt = $db->prepare($sql);
			$stmt->bindParam(':emailadress', $email);
			$stmt->execute();
			$row = $stmt->fetch(PDO::FETCH_ASSOC);

		if ($row > 0)
		{
			$err_msg[] = 'Email already taken!';
			$errflag = true;
			$db = NULL;
		}
		

		// Check if user exists
		include_once('../includes/db.inc.php');
		$db = new PDO(DB_INFO, DB_USER, DB_PASS);

		$sql = "SELECT uname FROM users WHERE uname = :username";
			$stmt = $db->prepare($sql);
			$stmt->bindParam(':username', $username);
			$stmt->execute();
			$row = $stmt->fetch(PDO::FETCH_ASSOC);

		if ($row > 0)
		{
			$err_msg[] = 'User already exists';
			$errflag = true;
			$db = NULL;
		}

		if ($errflag = false)
		{
			// Everything passed, create the user!
			include_once('../includes/db.inc.php');
			$db = new PDO(DB_INFO, DB_USER, DB_PASS);

			$sql = "INSERT INTO users (uname, pword, email) VALUES (:username, :password, :emailadress)";
				$stmt = $db->prepare($sql);
				$stmt->bindParam(':username', $username);
				$stmt->bindParam(':password', $password);
				$stmt->bindParam(':emailadress');
				$stmt->execute();

			$_SESSION['uname'] = $username;
			header('Location: ../template/header.php');
			exit;
		}
				
		// If any error, send the user back and display messages
		if ($errflag == true)
		{
			$_SESSION['err_msg'] = $err_msg;
			session_write_close();
			header('Location: ../user/create.php');
			exit;
		}
	}

	else
	{
		$_SESSION['err_msg'] = $err_msg;
			session_write_close();
			header('Location: ../user/create.php');
		exit;
	}

?>

Hello,can anyone help me create members search script? here is image example     here is 'users 'table

  `id` int(11) NOT NULL auto_increment,
  `age` varchar(200) collate utf8_unicode_ci NOT NULL,
  `city` varchar(200) collate utf8_unicode_ci NOT NULL,
  `username` varchar(30) collate utf8_unicode_ci NOT NULL,
  `password` varchar(150) collate utf8_unicode_ci NOT NULL,
  `salt` varchar(10) collate utf8_unicode_ci NOT NULL,
  `mgroup` int(3) NOT NULL,
  `email` varchar(100) collate utf8_unicode_ci NOT NULL,
  `ip` varchar(15) collate utf8_unicode_ci NOT NULL,
  `posts` int(11) NOT NULL,
  `date_joined` varchar(25) collate utf8_unicode_ci NOT NULL,
  `logged_in` int(1) NOT NULL default '0',
  `last_action_time` int(25) NOT NULL,
  `signature` text collate utf8_unicode_ci NOT NULL,
  `avatar` varchar(300) collate utf8_unicode_ci NOT NULL default 'default',
  `what_is_doing` varchar(30) collate utf8_unicode_ci NOT NULL,
  `what_is_doing_id` varchar(100) collate utf8_unicode_ci NOT NULL,
  `name` varchar(200) collate utf8_unicode_ci NOT NULL,
  `website` varchar(200) collate utf8_unicode_ci NOT NULL,
  `title` varchar(150) collate utf8_unicode_ci NOT NULL,
  `rank_pips` int(11) NOT NULL,
  `friends` tinytext collate utf8_unicode_ci NOT NULL,
  `blocks` tinytext collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

Please help me? 
Edited by sopranolv, 30 January 2015 - 05:26 AM.

I am looking at the ImageMagick library to create thumbnails from about 800 pdf files.
I'd like to use php because the information needs to be stored in a database.
Is ImageMagick up to the task? Would you recommend an alternative library? Any other advice is appreciated.

Thanks,

-Brian

hi i'm trying to create a php file from a script but i dont seem to be getting it right the file doesn't exist already am trying to create it.

Code: [Select]
<title>test</title> <?php 
 include_once"includes/db_connect.php";
 
 $sql=mysql_query("SELECT `urlName` FROM `products` WHERE `category`='1'");
while($fetch=mysql_fetch_object($sql)){
 $File = "".$fetch->urlName.".php"; 
 $handle = fopen($File, 'w');
 fclose($handle);
}
 ?>

I have this form that is far to long. I need to set it up in 3 pages. One page about the person getting the Gift Certificate, one for the person purchasing the certificate and another for credit card information.  I have read about hidden variable but am a noobie.  Any thoughts would be greatly appreciated.

We are working on a new student application system. Due to privacy laws,
everything will be done behind https. However, this is one of many systems
looked after by the system administrators. I would like to safeguard against
the situation several years down the road when the certificate expires.
There are several administration pages that will be checked frequently by
the graduate admin assistant. While this person has no technical background,
a warning several months before the certificate expires would allow her
to remind the technical staff to renew the certificate.

I know I can use curl to connect to my own server, but that seems like
a long way to do it (and an extra https connection). Is there any way to
get the certificate information for the current https connection from
the server or from the php runtime?

I've been looking for a function or a couple of functions which will allow me to get the Certificate Expiration date for a given website. I've tried openSSL, but their functions only seem to work on the current server, which is useless to me because my server doesn't allow SSL or certificates. I just want the certificate of an external website, e.g. www.gna.org has a certificate (signed by themselves, but a certificate nonetheless).
I've also tried cURL, since that allows you to access a remote server, but that will just check their certificate - it doesn't offer any functionality for e.g. checking when it will expire.

This seems like a simple enough question, but I haven't found anything about it anywhere, so I'm asking here.

Thanks a bunch in advance,
-IsmAvatar

I recently installed a SSL certificate for one of my domains, on a hosting account that includes several other domains.  To redirect visitors to the SSL version of the website (because the SSL certificate only works for the www. version of the site) I use the following code in my .htaccess file:   #First rewrite any request to the wrong domain to use the correct one (here www.)

Honestly, for something like this I don't know how to go about creating this script..

So I want to create a script that will generate every combination of 2 numbers that range from 0-749, so 750x750 = 562500 possible combinations, so for example, 0/749, 43/87, 0/0, 1/1, 2/1, 1/2, 500/450, 405/673, etc..

How would I go about starting to write a script that can generate all of the possible combinations and and put them in an array or write them to a file?

Thanks for the help in advanced!

-CLUEL3SS

Hi guys,

Before I am going to create php script to make a proxy detection, I want to ask that if it possible to create a method that checking whether if the proxy server is a located governments or fbi. Is it possible?

If so, what method I would use?


Thanks,
Mark

I've decided to "re-learn" PHP.

I've created a registration script which works well, however, the login script is not going to plan for me.

This is the script:

<?php include "./global/global.php"; ?>
<?php error_reporting (E_ALL ^ E_NOTICE); ?>

<?php

$username = $_POST['username'];
$password = $_POST['password'];

$submit = $_POST['submit'];

if($submit){
    $sql1 = "SELECT * FROM test2 WHERE username = '".$username."'";
    $res1 = mysql_query($sql1) or die(mysql_error());
    
    $numrows = mysql_num_rows($res1);
        
    if($numrows != 0){
        while($row = mysql_fetch_assoc($res1)){
            $dbusername = $row['username'];
            $dbpassword = $row['password'];
        }
        
        if($username==$dbusername && $password==$dbpassword){
            ob_start();
            $_SESSION['username']=$username;
            header("Location: index.php");
        }
    }else{
        echo("That user doesn't exist!");
    }               
}else{
    
    ?>
    <form action="login.php" method="POST">

    <input type="text" name="username" />
    <input type="password" name="password" />
    <input type="submit" name="submit" value="Login" />

    </form>
    
<?php

}

?>

The problem is that it isn't building the session, so when I go back to the homepage, which looks like this:

<?php include "./global/global.php"; session_start(); ?>
<?php error_reporting (E_ALL ^ E_NOTICE); ?>

<html>

<?php

if($_SESSION){
    echo("Welcome, ".$_SESSION['username']);
}else{
    echo("Please login <a href='login.php'>here</a>");
}

?>

</html>

It shows that I should login.

I can't seem to see what's wrong because I have a script very similar to it and it works fine, so if anyone could help, I'd appreciate it.

Hi folks,

a few days back, we enabled SSL on our office server and the intranet migrated to https. Everything is ok on the intranet.

On the public internet, we noticed today that the page on our website, which connects to our office server to fetch and display data was throwing an error, which I presumed was a Security Certificate issue... An area that's like the Dark Side of the Moon for me..

the webpage - https://liveconnections.in/hotjobs.php

This is the error from the logs

 PHP Warning: file_get_contents(): SSL operation failed with code 1. OpenSSL Error messages:
error:14090086:SSL routines:ssl3_get_server_certificate:certificate verify failed 
PHP Warning: file_get_contents(): Failed to enable crypto 
PHP Warning: file_get_contents(): SSL operation failed with code 1. OpenSSL Error messages:
error:14090086:SSL routines:ssl3_get_server_certificate:certificate verify failed

Anycase, the internet was willing to help and so I updated the code to a curl function. The Data is not displaying still...

However, when I try to access the office server by loading the php page in my localhost, the data is displayed.

Here's the code... where am i going wrong ?

<?php 
	//error_reporting(E_ERROR | E_PARSE | E_ALL);
	$page="jobs-listing";
?>
<header class="section background-livec text-center">
            <h3 class="text-white margin-bottom-0 text-size-40 text-thin text-line-height-1">Current & Hot Jobs</h3>
        </header>
<?php 
	$industry = $_GET['industry'];
	$location = $_GET['location'];
	$expMin = $_GET['expMin'];
	$expMax = $_GET['expMax'];
	$sortBy = $_GET['sortBy'];
	$cpg    = $_GET['page'];
	
	if(empty($cpg) || $cpg==1)
		$npl = 1;
	else {
		//$npl = (($cpg+1)*10) - 9;
		$npl = $_GET['startingRowNo'];
	}

	$industry = str_replace(' ', '%20', $industry);
	$location = str_replace(' ', '%20', $location);
	
	$url = "https://xx.xxx.xxx.xxx/WebService/rest/";

	function file_get_contents_curl($url) {
	$ch = curl_init();
	curl_setopt($ch, CURLOPT_HEADER, 0);
	curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); //Set curl to return the data instead of printing it to the browser.
	curl_setopt($ch, CURLOPT_URL, $url);
	$data = curl_exec($ch);
	curl_close($ch);
	return $data;
	}

	if(!empty($sortBy)) { 
		$json = file_get_contents_curl($url.'getHeadersBySearch?industry='.$industry.'&location='.$location.'&expMin='.$expMin.'&expMax='.$expMax.'&sortBy='.$sortBy.'&startingRowNo='.$npl.'&noOfRows=1000000');
		$data = json_decode($json);
	} else if(!empty($industry) || !empty($location) || !empty($expMin) || !empty($expMax)) {
		$json = file_get_contents_curl($url.'getHeadersBySearch?industry='.$industry.'&location='.$location.'&expMin='.$expMin.'&expMax='.$expMax.'&sortBy=&startingRowNo='.$npl.'&noOfRows=1000000');
		$data = json_decode($json);
	} else {	
		//$json = file_get_contents_curl($url.'getOnlineWebPosting');
		$json = file_get_contents_curl($url.'getHeadersBySearch?industry='.$industry.'&location='.$location.'&expMin='.$expMin.'&expMax='.$expMax.'&sortBy=&startingRowNo='.$npl.'&noOfRows=1000000');
		$data = json_decode($json);
		
		//if (!$data) echo "Data Not Found" ;
	}

	if($sortBy=='DESC' || $sortBy=='') {
		$aclass = 'down_arrow';
	} else {
		$aclass = 'up_arrow';
	}
	$json2 = file_get_contents_curl($url.'getSearchData');
	$data2 = json_decode($json2);

	$industry = str_replace('%20', ' ', $industry);
	$location = str_replace('%20', ' ', $location);
	if($industry=='F amp A - BPO') {
		$industry = 'F & A - BPO';
	}	
	if($industry=='OIL amp GAS') {
		$industry = 'OIL & GAS';
	}
?>
        

<div class="section background-white"> 

	<div class="background-white"> 
	<p class="text-padding-bot text-letter-spacing1">A cross-section of Jobs currently available. We recommend you to contact our Executives for further info. <br />
	More details available when the Job is '<strong>View'</strong>ed. </p>
	</div>

<?php 
//$data='';
//if($data!=''){ ?> 

		<?php //if ($checkyear>2017) { ?>

        <div class="subJobs">
        	<ul>
        	    	<li> Industry <br /> 
        	        	<select name="industry" id="industry" class="sel">
			            	<option value="">Select Industry Name</option>
					<?php for($i=0; $i<count($data2[0]); $i++) { ?>
						<?php if(isset($industry) && $industry==$data2[0][$i]) { ?>
							<option selected value="<?php echo $data2[0][$i];?>"><?php echo $data2[0][$i];?></option>
						<?php } else { ?>
							<option value="<?php echo $data2[0][$i];?>"><?php echo $data2[0][$i];?></option>
						<?php } 
					} ?>
		        	</select>                    
                    	</li>
		        <li>Location<br /> 
		        	<select name="city" id="city" class="sel">
				    	 <option value="">Select City Name</option 
					><?php $m=0; for($j=0; $j<count($data2[1]); $j++) { ?>
						<?php $locat = explode(",",$location); ?>
						<?php if($locat[$m]!="" && $locat[$m]==$data2[1][$j]) { ?>
							<option selected value="<?php echo $data2[1][$j];?>"><?php echo $data2[1][$j];?></option>
						<?php ++$m; } else { ?>
							<option value="<?php echo $data2[1][$j];?>"><?php echo $data2[1][$j];?></option>
						<?php } 
					} ?>
				</select>
		        </li>
		       <li>Experience <br /> 
			       <select name="minyear" class="sel2" id="minyear">
			       	    <option value="">Min</option>
				    <?php for($ii=0; $ii<46; $ii++) { ?>
					<?php if($expMin!="" && $expMin==$ii) { ?>
						<option selected value="<?php echo $ii; ?>"><?php echo $ii; ?></option>
					<?php } else { ?>
				    		<option value="<?php echo $ii; ?>"><?php echo $ii; ?></option>
				    	<?php } 
				    } ?>
			       </select>
			       <select name="maxyear" class="sel2" id="maxyear" onchange="return select_max();">
			       	    <option value="">Max</option>
				    <?php for($ii=0; $ii<51; $ii++) { ?>
					<?php if($expMax!="" && $expMax==$ii) { ?>
						<option selected value="<?php echo $ii; ?>"><?php echo $ii; ?></option>
					<?php } else { ?>
				    		<option value="<?php echo $ii; ?>"><?php echo $ii; ?></option>
				    	<?php } 
				    } ?>
			       </select>
			       <!-- select name="" class="sel2" id="sort">
					<option value="">Select</option>
					<option value="ASC">ASC</option>
					<option value="DESC">DESC</option>
			       </select -->		       
		       </li>
               <li class="ser"><button type="button" onclick="search_by_category()" class="btn btn-default" style="margin-top:25px;"><i class="fa fa-search"></i> Search</button></li>
            </ul>
        </div>
       <!-- Selected Jobs Headline Info -->
		<div class="line">
			<p class="text-dark text-center text-size-16">
			<?php if($industry) echo 'Showing ' .  '<b>' . $industry .'</b>' .  ' Jobs' ; ?>  
			<?php if($location) echo ' at ' .  '<b>' . $location .'</b>' ; ?>
			<?php if($expMin) echo ' with Min ' .  '<b>' . $expMin .'</b>' ; ?>
			<?php if($expMax) echo ' to Max '.  '<b>' . $expMax.'</b>' ; ?>
			<?php if($expMin | $expMax) echo ' Years Experience' ;?>
			</p>
	</div>  

       <!-- Jobs Table -->
        <table id="example" class="display" cellspacing="0" width="100%">
            <thead>
              <tr>
                <th class="jobs_noshow text-center" width="5%">S.No</th>
                <th class="text-center" width="15%">Posted On</th>
                <th class="text-center" width="30%">Job Title</th>
                <th class="jobs_noshow text-center" width="15%">Level</th>
                <th class="jobs_noshow text-center" width="15%">Location</th>
                <th class="jobs_noshow text-center" width="15%">Job Code</th>
                <th class="text-center" width="5%">Action</th>
              </tr>
            </thead>
            <tbody>
              <?php $ri=1; foreach($data as $kk=>$d) { ?>
				  <?php  
					$date_posted = $d->postedDate; // get the Posted Date
					$date_posted_year=date("Y",strtotime($date_posted)); // Get the Year from the date and store in a variable
					if ($date_posted_year>$jobs_restrict_year) { // Show only Jobs posted after this year ?>
					  <tr>
						<td class="jobs_noshow text-center"><?php echo $ri; ?></td>
						<td class="text-center"><?php echo $d->postedDate; ?></td>
						<td><?php echo $d->title; ?></td>
						<td class="jobs_noshow  ctext notreq"><?php echo $d->level; ?></td>
						<td class="jobs_noshow text-center notreq"><?php echo $d->location; ?></td>
						<td class="jobs_noshow  text-center"><?php echo $d->requirementID; ?></td>
						<td class="text-center"><a class="button background-livec border-radius text-white" style="color:white" data-fancybox="ajax" href="?contentid=jobs-detail&requirementID=<?php echo $d->requirementID; ?>&requirementSeqNo=<?php echo $d->requirementSeqNo; ?>" data-type="ajax">View</a></td>
					  </tr>
				  <?php } ?>
              <?php $ri=$ri+1; } ?>
            </tbody>
          </table>
          <script type="text/javascript">
			$(document).ready(function () {
				var table = $('#example').DataTable( {
					"pageLength": 25,
					"sPaginationType":"full_numbers",
					"oLanguage": {
					"sInfo": 'Showing _START_ to _END_ of _TOTAL_ Jobs.',
					"sInfoEmpty": '',
					"sEmptyTable": "No Jobs found currently",
					}
				}); 
				$('#example').removeClass( 'display' ).addClass('table table-striped table-bordered');
			});
   		  </script>
          <style> .dataTables_filter { display: none; } </style>
          <!-- End of Table -->
 </div>      
<?php // } else { ?>
<div style="margin: 20px 0 40px 0px;height:200px;text-align:center;">
<h1 style="font-size:16px;">Server is unavailable at the moment. Please try after some time.</h1>
</div>
<?php //}?>     
  
</div>


<!--jobs end-->
<script type="text/javascript">
	function search_by_category() {
		industry	= $('#industry option:selected').val();
		//city1		= $('#city option:selected').val();
		minyear		= $('#minyear option:selected').val();
		maxyear		= $('#maxyear option:selected').val();
		//sortBy		= $('#sort option:selected').val();
		var city = $('select#city').val();
		var cur_pg = "<?php echo $cpg; ?>";
		var tot = "<?php echo $total; ?>";
		var tot_pgs = Math.ceil(tot/25);
		//if(cur_pg=="")
			cur_pg = 1;
		var last_pg = tot_pgs - cur_pg;
		if(last_pg==0)
			records = tot - ((tot_pgs -1) * 25);
		else
			records = 25;

		var strt_val = ((cur_pg-1) * 25) + 1; 
		
		if(industry=='F & A - BPO')
			industry ='F amp A - BPO';
		if(industry=='OIL & GAS')
			industry ='OIL amp GAS';
		city1 = document.getElementById("city").value;
		if(city1=="" || city1=="null") {
			city="";
		}		
		if(industry!="" || city!="" || minyear!="" || maxyear!="") {
			location.href="hotjobs.php?contentid=hotjobs&industry="+industry+"&location="+city+"&expMin="+minyear+"&expMax="+maxyear+"&sortBy=&startingRowNo=1"+"&noOfRows="+records+"&page="+cur_pg;
		} else {
			//alert("Please select any one of the fields");
			location.href="hotjobs.php?contentid=hotjobs&industry="+industry+"&location="+city+"&expMin="+minyear+"&expMax="+maxyear+"&sortBy=&startingRowNo=1"+"&noOfRows="+records+"&page="+cur_pg;
		}
	}
	function sort_by_location() {
		var order = '<?php echo $sortBy; ?>';
		industry	= $('#industry option:selected').val();
		city		= $('#city option:selected').val();
		minyear		= $('#minyear option:selected').val();
		maxyear		= $('#maxyear option:selected').val();
		city1 = document.getElementById("city").value;
		if(industry=='F & A - BPO')
			industry ='F amp A - BPO';
		if(industry=='OIL & GAS')
			industry ='OIL amp GAS';
		if(city1=="") {
			city="";
		} else {
			city = $('select#city').val();
		}
		if(order=="" || order=="DESC") {
			location.href="hotjobs.php?contentid=hotjobs&industry="+industry+"&location="+city+"&expMin="+minyear+"&expMax="+maxyear+"&sortBy=ASC"+"&startingRowNo=1&noOfRows=10";
		} else {
			location.href="hotjobs.php?contentid=hotjobs&industry="+industry+"&location="+city+"&expMin="+minyear+"&expMax="+maxyear+"&sortBy=DESC"+"&startingRowNo=1&noOfRows=10";
		}
	}

	function select_max() {
		minyear = document.getElementById("minyear").value;
		maxyear = document.getElementById("maxyear").value;
		if(parseInt(maxyear)>=parseInt(minyear)) {
			return true;
		} else {
			if(maxyear!="") {
				alert("Maximum year must be equal or greater than minimum year");
				$('#maxyear').val("");
				return false;
			}
		}
	}
	
</script>
	
	

Also, if i change the $url in my code to https:// , no data is displayed...

I raised a Support request to the Hosting provider, but they seem to have vanished into the ozone....

Any help would be highly appreciated.

Cheers - Murali

 

 

 

Hello everyone, I am working on a form that is similar to a shopping cart system and I am thinking of creating a button that submits the checked value and saves them to a $_SESSION variable. And also a link that links to a cart.html that takes the values of a $_SESSION variable. I am have trouble figuring what tag/attribute should I use in order to achieve that.   Right now my code attached below submits the checked values to cart.html directly. However I want my submit button to save the checked box to a $_SESSION variable and STAY on the same page. And then I will implement a <a> to link to the cart.php.   I researched a little bit about this subject and I know it's somewhat related to ajax/jquery. I just wanted to know more about it from you guys. I appreciate your attention for reading the post and Thanks!   Below is the form that I currently have:

<form name= "finalForm" method="POST" action="cart.php">
<input type="Submit" name="finalSelected"/>

<?php foreach($FinalName as $key => $item) {?>
<tr>
<td><input type="checkbox" name="fSelected[]" value="<?php echo htmlspecialchars($FinalID[$key])?>" />
<?php echo "$FinalID[$key] & $item";?>
</td>
</tr>
<?php } ;?>

Below is the code for cart.php

<?php
require ('connect_db.php');
if(isset($_POST['finalSelected']))
{
	if(!empty($_POST['fSelected']))
	{
		$chosen = $_POST['fSelected'];
		foreach ($chosen as $item)
			echo "aID selected: $item </br>";
		$delimit = implode(", ", $chosen);
		print_r($delimit);
	}

}
if(isset($delimit))
{
$cartSQL = "SELECT * from article where aID in ($delimit)";
$cartQuery = mysqli_query($dbc, $cartSQL) or die (mysqli_error($dbc));
while($row = mysqli_fetch_array($cartQuery, MYSQLI_BOTH))
{
	$aTitle[] = $row[ 'name' ];
}
}
?>

<table>
	
		<?php if(isset($delimit)) { 
		$c=0; foreach($aTitle as $item) {?>
		<tr>
		<td>
			<?php echo $aTitle[$c]; $c++;?>
		</td>
		</tr>
		<?php }}?>
</table>

Hi everyone!

I've been working on a php script to replace links that contain a query with direct links to the files they would redirect to.

I'm having trouble echoing $year in my script. Listed below is the script, just below ,$result = mysql_query("SELECT * FROM $dbname WHERE class LIKE '%$search%'") or die(mysql_error());, in the script I try to echo $year. It doesn't show up in the table on the webpage. Everything else works fine. Any help wold be appreciated greatly. Thanks in advance.



<?php
include 'config2.php';

$search=$_GET["search"];

// Connect to server and select database.
mysql_connect($dbhost, $dbuser, $dbpass)or die("cannot connect");
mysql_select_db("vetman")or die("cannot select DB");


$result = mysql_query("SELECT * FROM $dbname WHERE class LIKE '%$search%'") or die(mysql_error());
// store the record of the "" table into $row
//$current = '';
echo "<table align=center border=1>";
echo "<br>";
echo "<tr>";
echo "<td align=center>";
?>
<div style="float: center;"><a><h1><?php echo $year; ?></h1></a></div>


<?php
echo "</td>";
echo "</tr>";
echo "</table>";


// keeps getting the next row until there are no more to get
if($result && mysql_num_rows($result) > 0)

{
    $i = 0;
    $max_columns = 2;
    echo "<table align=center>";
echo "<br>";
    while($row = mysql_fetch_array($result))
   {
       // make the variables easy to deal with
       extract($row);

       // open row if counter is zero
       if($i == 0)

          echo "<tr>";

          echo "<td align=center>";
          ?>
          <div style="float: left;">
          <div><img src="<?php echo $image1; ?>"></div>

  </div>


          <?php
          echo "</td>";

       // increment counter - if counter = max columns, reset counter and close row
       if(++$i == $max_columns)
       {
           echo "</tr>";
           $i=0;
       }  // end if
   } // end while
} // end if results

// clean up table - makes your code valid!
if($i > 0)
{
    for($j=$i; $j<$max_columns;$j++)
        echo "<td>&nbsp;</td>";
   echo '</tr>';
}
mysql_close();
 ?>
</table>