PHP - Fulltext In Boolean Mode Not Working Correcly

I have a MySql database (Server Version 5.6.12) with a fulltext index on the SectionText field in the FD table with this structu

CREATE TABLE `FD` (

  `FTS_DOC_ID` bigint(20) unsigned NOT NULL,

  `ReadingNo` int(11) DEFAULT NULL,

  `SequenceNo` int(11) DEFAULT NULL,

  `SectionTypeID` int(11) DEFAULT NULL,

  `SectionText` longtext,

  `FullDocNo` varchar(11) CHARACTER SET utf8 NOT NULL,

  `DocType` varchar(11) CHARACTER SET utf8 DEFAULT NULL,

  UNIQUE KEY `FTS_DOC_ID_INDEX` (`FTS_DOC_ID`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

I am able to do a very accurate fulltext proximity search (92 documents found) in PHPMyAdmin using this syntax:

SELECT SectionText

FROM fd

WHERE DocType = "text" AND

MATCH (SectionText) AGAINST ('"liver hepatic" @3' IN BOOLEAN MODE)

ORDER BY FTS_DOC_ID

But when I try to use this query on a webpage I get this error message:   Parse error: syntax error, unexpected 'liver' (T_STRING) in C:\wamp\www\ecr\proximity.php on line 77   When I remove the quotes like this:

MATCH (SectionText) AGAINST ('liver hepatic @3' IN BOOLEAN MODE)

There is no error, but there are no documents found.   Realistically, to do searches on the web, I need to use search variables provided via an input form (and preferably a parameterized query) such as:

MATCH (SectionText) AGAINST (':search1 :search2 @:proximity' IN BOOLEAN MODE)

But this also returns no documents found.   I need help getting this implemented on a web page.  If this needs to be posted in another forum (PHP), please advise.  But since the proximity search feature seems to be relatively new and somewhat obscure (couldn’t find anything about implementing it on a webpage via Google), I thought it best to start here.  Any help in solving this is greatly appreciated.

The issue I am having is that everytime I click the next button, it takes me to the index page.  My question is, how do I set up a proper search results link in "href="?page=1"     index.php

				<form action="search" method="GET">
					<input type="search" name="search" placeholder="Find products, services ...">
					<input type="submit" name="submit" value="">
				</form>

search.php

if(isset($_GET['submit']) && !empty($_GET['search'])) {	

	$value	= 	escape(trim(Input::get('search')));
	
	try { 

		// Find out how many items are in the table
		$q = DB::getInstance()->query("SELECT * FROM records WHERE MATCH(title) AGAINST('$value' IN BOOLEAN MODE)");
		
		$total = $q->count();
		
		// How many items to list per page
		$limit = 10;

		// How many pages will there be
		$pages = ceil($total / $limit);

		// What page are we currently on?
		$page = min($pages, filter_input(INPUT_GET, 'page', FILTER_VALIDATE_INT, array(
			'options' => array(
				'default'   => 1,
				'min_range' => 1,
			),
		)));
	
		// Calculate the offset for the query
		$offset = ($page - 1)  * $limit;

		// Some information to display to the user
		$start = $offset + 1;
		$end = min(($offset + $limit), $total);
		
		
		// Prepare the paged query
		$stmt = DB::getInstance()->query("SELECT users.*, records.* FROM records
		LEFT JOIN users ON records.user_id = users.user_id
		WHERE MATCH(title) AGAINST('$value' IN BOOLEAN MODE) ORDER BY relevance DESC LIMIT {$limit} OFFSET ".$offset);
		
		if($stmt->count()) {
			
			// Display the results
			foreach($stmt->results() as $row) {
				
				$date 			 = 	escape($row->posted);
				$record_date	 =	escape(Input::facebook_date_format($date));
				$record_id 		 = 	escape($row->record_id);
				$title			 = 	trim($row->title);
				$slug_title		 =	$row->slug_title;
				$view_count 	 = 	escape(intval(number_format($row->views + 1)));
				
				$username 		 = 	escape($row->username);
			
				require 'snippets/record_widget.php'; 
				
			}
			
		} else {
			?><div class="message"><?php echo 'No records found.';?></div><?php
		}
		
		<?php
		// The "back" link
		$prevlink = ($page > 1) ? '<a href="?page=1" title="First page"><img src="images/left-page-arrow-end.png"/></a> <a href="?page=' . ($page - 1) . '" title="Previous page"><img src="images/left-page-arrow-start.png"/></a>' : '<span class="disabled"><img src="images/left-page-arrow-end-disabled.png"/></span> <span class="disabled"><img src="images/left-page-arrow-start-disabled.png"/></span>';

		// The "forward" link
		$nextlink = ($page < $pages) ? '<a href="?page=' . ($page + 1) . '" title="Next page"><img src="images/right-page-arrow-start.png"/></a> <a href="?page=' . $pages . '" title="Last page"><img src="images/right-page-arrow-end.png"/></a>' : '<span class="disabled"><img src="images/right-page-arrow-start-disabled.png"/></span> <span class="disabled"><img src="images/right-page-arrow-end-disabled.png"/></a></span>';

		// Display the paging information
		?>
		<div class="pages">
			<span class="pages-arrows"><?php echo $prevlink; ?></span> <span class="pages-numbers"><?php echo $page; ?> of <?php echo $pages; ?></span> <span class="pages-arrows"><?php echo $nextlink; ?></span>
		</div>

	} catch (Exception $e) {
		echo '<p>', $e->getMessage(), '</p>';
	}
			

} else {

	Redirect::to('index');
	
}

Edited by man5, 20 August 2014 - 10:27 PM.

I'm not a programmer, so sometimes the php.net/manual reads like a foreign language to me.  I have a quick interpretation question:

I'm generating data in PHP for a MySQL stored procedure that has two comma separated value inputs.  The second input is always a series of 0's and 1's.  I'm trying to count the number of 1's for the second input (in the example below, it would be "3").

Example input sent to MySQL:$query_resolve = "CALL spParticipant_Test ('188,216,342,81,117,56','0,1,1,0,0,1')";

http://www.php.net/manual/en/function.count-chars.php is mostly helpful, but I am hoping for clarification on the mode I want to run.
Quote

Depending on mode count_chars() returns one of the following:

0 - an array with the byte-value as key and the frequency of every byte as value.
1 - same as 0 but only byte-values with a frequency greater than zero are listed.
2 - same as 0 but only byte-values with a frequency equal to zero are listed.
3 - a string containing all unique characters is returned.
4 - a string containing all not used characters is returned.


Do I want to run mode "1"?  Thanks so much for any feedback!

<script>
//Calculate Labour
    function filllabour(aa) {
	
	//Parse aa
	
	var the_string = aa;
	var parts = the_string.split('-', 2);

		// After calling split(), 'parts' is an array with two elements:
		// parts[0] is 'left or -'
		// parts[1] is 'right of -'

	var the_text = parts[0];
	var the_num  = parts[1];
	
	//Parse aa

	var dblQuantity = document.getElementById('lqlabour-' + the_num).value-0;
	var curRate = document.getElementById("llabour-" + the_num).value-0;
	var curRateHelper = document.getElementById("lhelper-" + the_num).value-0;
	var dblMarkup = document.getElementById("lmarkup-" + the_num).value-0;
	var curTotal = parseFloat(dblMarkup) / 100.0;
	llinetotal = ((dblQuantity * curRate) + (dblQuantity * curRateHelper)) * (1 + curTotal);
	llinetotal = llinetotal.toFixed(2);
    document.getElementById("ltotal-" + the_num).value = llinetotal;
	//document.getElementById(the_num).value = ("test");
	//alert(the_num);
	
	
	//collect all line totals	
	var inputs = document.getElementsByName("ltotal[]");
	var laboursubtotal = 0;

	for (var i = 0.00; i < inputs.length; i++){
		if (inputs[i].type = "text"){
			laboursubtotal += parseFloat(inputs[i].value, 10);
		}
	}
	//collect all line totals
	laboursubtotal = laboursubtotal.toFixed(2);
	document.getElementById("labourtotal").value = laboursubtotal;
	
		
	filltotal();
	
	
    }
//Calculate Labour
</script>

hi, in ie11 we are forced to use compatibility mode for one of our web applications written in php.  above is a script that from what I understand is the error is with getElementsByName.  any suggestions for me in ie11?  

Hello,    How can I create a webpage using HTML and have a div wrapper for the page become FULL SCREEN?   I'm guessing this would be done with Javascript. 

My my.cnf file has three sections (mysqld, mysqld_safe, mysql).  It seems that they represent different modes which MySQL runs in.  Is this correct?  I read that some recommend running in safe mode.  Should I be if it is being used to support PHP?  I typically start MySQL as "service mysqld start" when running Centos. How should I be starting it if I want it in safe mode.
 

Hello, forgive me for this question in advance. I have looked all day for a fix to this and nothing I have come across has resolved this. My host upgraded to the most recent PHP several months ago and since it has thrown errors on certain scripts. I have gotten tired of looking at them and haven't been able to find a fix on my own so here I am. I am getting the below error.    Notice: Undefined index: mode in /home4/mesquiu0/public_html/NSDisplay/NSStorms-include.php on line 38

if ($_REQUEST['mode'] == 'expired') {                    // We only want the expired storms
	$filetoRead = $expiredfile;
	$arraytoUse = $Expired;
} else {
	$filetoRead = $stormfile;
	$arraytoUse = $Active;
}

I am pretty sure it needs an inset call but not sure how to go about formatting that as I have done with the others errors I have come across. Any suggestions to this error?   -Thanks!

Hey all

Im trying to find a way to combine images but set the blend mode, like in Photoshop, selecting how layers are blended together.

I have looked at all the docs for GD with no luck...

Cheers in advanced

Maca134

can we set limit in safe mode as the hosting company would not off the safe mode so please help i get following error,

Warning: set_time_limit() [function.set-time-limit]: Cannot set time limit in safe mode in /home/evercash/public_html/5dollarmatrix.co.cc/admin.php on line 190

elseif($b=="Compress Matrix") {
set_time_limit(6000);
include "config.php";

i m using code for sending email through GMAIL SMTP as given below... can any one tell me that how i can send EMAIL through Centos 5 CLI mode.... i which folder places i save my PHP files or any other supporting files etc.
in graphical mode we use webbrowser but in Command line how i can use this project....
and also please tell me how i can run firefox in CLI mode.....

i m a new user of PHP and linux, please guide me in easy way.


<html>
<head>
<title>PHPMailer - SMTP (Gmail) advanced test</title>
</head>
<body>

<?php
require_once('/var/www/PHPMailer_v5.1/class.phpmailer.php');
//include("class.smtp.php"); // optional, gets called from within class.phpmailer.php if not already loaded

$mail = new PHPMailer(true); // the true param means it will throw exceptions on errors, which we need to

catch

$mail->IsSMTP(); // telling the class to use SMTP

try {
$mail->Host = "smtp.gmail.com"; // SMTP server
$mail->SMTPDebug = 2; // enables SMTP debug information (for testing)
$mail->SMTPAuth = true; // enable SMTP authentication
$mail->SMTPSecure = "ssl"; // sets the prefix to the servier
$mail->Host = "smtp.gmail.com"; // sets GMAIL as the SMTP server
$mail->Port = 465; // set the SMTP port for the GMAIL server
$mail->Username = "john@gmail.com"; // GMAIL username
$mail->Password = "password"; // GMAIL password

//$mail->AddReplyTo('name@yourdomain.com', 'First Last');
//$mail->AddAddress('user1@gmail.com', 'user1'); //Set Send To Address
$mail->AddAddress('receiveremail@gmail.com', 'user2'); //Set Send To Address

$mail->SetFrom('senderemail@gmail.com', 'senderemail Name'); // Set Send From Address
//$mail->AddReplyTo('name@yourdomain.com', 'First Last');

$mail->Subject = 'Email with Attachment with PHP is done';
$mail->AltBody = 'To view the message, please use an HTML compatible email viewer!'; // optional - MsgHTML

will create an alternate automatically
$mail->MsgHTML(file_get_contents('contents.html'));

$mail->AddAttachment('/images/asdf.pdf'); // attachment
$mail->AddAttachment('/images/asd.wav'); // attachment


$mail->Send();
echo "Message Sent OK</p>\n";

} catch (phpmailerException $e) {
echo $e->errorMessage(); //Pretty error messages from PHPMailer
} catch (Exception $e) {
echo $e->getMessage(); //Boring error messages from anything else!
}
?>

</body>
</html>

CREATE TABLE user (username varchar(20),password varchar(20),level varchar(20),PRIMARY KEY(username));

INSERT INTO `user` VALUES ('a', 'pass1', 'admin');
INSERT INTO `user` VALUES ('b', 'pass2', 'admin');
INSERT INTO `user` VALUES ('c', 'pass3', 'user');


This is my database

and

Registration.php

Code: [Select]
<html>
<head>
<script type="text/javascript">
  function a()
{
   var x = document.register.username.value;
   var y = document.register.pass.value;
   var z = document.register.pass2.value;
   
   if(x==""&& y==""&& z=="")
   {
    alert("Please insert all message!");
    return false;
   }
   if(x=="")
   {
     alert("Please insert an username!");
     return false;
   }
   if(y=="")
   {
     alert("Please insert an password!");
     return false;
   }
   if(z=="")
   {
     alert("Please insert an password2!");
     return false;
   }
   
   if (y!=z)
   {
     alert("Your passwords did not match");
     return false;
   }
   



}
</script>
</head>
<?php
    mysql_connect("localhost","root") or die(mysql_error());
    mysql_select_db("cute") or die(mysql_error());


     if (isset($_POST["sub"]))
     {
        $_POST['pass'] = md5($_POST['pass']);
      if (!get_magic_quotes_gpc())
       {
        $_POST['username'] = addslashes($_POST['username']);
        $_POST['pass'] = addslashes($_POST['pass']);
      }


       $usercheck = $_POST["username"];

       $check = mysql_query("SELECT username FROM regis WHERE username = '$usercheck'") or die(mysql_error());

       $check2 = mysql_num_rows($check);
        //if the name exists it gives an error
     if ($check2 != 0)
     {
      echo("<SCRIPT LANGUAGE='JavaScript'>window.alert('Sorry, the username" ." ".$usercheck." ". "is already in use.')</SCRIPT>");
      echo ("<SCRIPT LANGUAGE='JavaScript'>setTimeOut(window.location = 'registration.php',1)</script>");

     }

      else if($_POST['username'] && $_POST['pass'] && $_POST['pass2'] )
     {
      $insert = "INSERT INTO regis(username, password) VALUES ('".$_POST['username']."', '".$_POST['pass']."')";
      $add_member = mysql_query($insert);
      echo("<SCRIPT LANGUAGE='JavaScript'>window.alert('Registration had been succesfully added :)')</SCRIPT>");
      echo "<meta http-equiv='refresh' content='0; url=login.php'>";
     }

     }
     
?>
<body>



  <form name="register" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"  onsubmit="return a()">
  <table border='0'>
  <tr><td>Username:</td><td><input type="text"name="username" maxlength="60"></td></tr>
  <tr><td>Password:</td><td><input type="password" name="pass" maxlength="10"></td></tr>
  <tr><td>Confirm Password:</td><td><input type="password" name="pass2" maxlength="10"></td></tr>
  <tr><th colspan=2><input type="submit" name="sub" value="Register"></th></tr></table>
  </form>
 

  </body>
 </html>

My main problem when in registration iam did not put user level field because it is not secure but how to manage or how to detect when someone registering he or she is user or admin?

hey i was hoping to add a checkbox to my upload form on my site how would i accomplish something like this


set to mature [checkbox here]

Not sure at all if this is the right place for this post, but it seemed the most applicable spot. Mods, please move this thread if it is more appropriate elsewhere.   OK - We've got a client that's using - as far as I can tell - exclusively IE11 and has been running into an issue where IE is apparently deleting the contents of the 'Compatibility View Settings' when the browser is closed and/or the browsing history is cleared. According to the research I've done, this was a design decision by Microsoft when they updated IE to only display the 'broken page' icon when the browser thinks the page is broken (regardless IE's actual ability to correctly parse the page) and is fairly well documented in several different places on the Interwebs.   So, I know the issue, and I know that adding an "X-UA-Compatible" meta-tag in the target page's HTML should take care of the problem. The issue I'm having is this - we're redoing the site. Unfortunately, we're not redoing the pages that are causing the current problem, and the client has talked with someone who made mention of (rough quote here) 'a small bit of code that could be added to the link' that would force IE to render in compatibility mode.   I'm assuming the client's source is talking about the meta-tag in the link target page, and I haven't found anything in my Google searches to discount that theory, but I thought I'd ask here before I spoke with them about it in case I'm wrong.   Is there a flag that I can simply append to the URL that IE will parse and force a specific release-compatible view? Or really any way to force IE to render a webpage to a certain version that doesn't entail messing up the display to every other browser ever made or modifying the rendered page's source HTML?

Hi, I have an image uploader here and I am trying to have a user enter their password and check a box in order to submit their image.  I am having trouble validating the password.  I get this error message:

"Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/content/68/6372768/html/submit.php on line 58"

From this section of the code:

      $query = "SELECT * FROM user_info WHERE password = SHA($user_password)";
      $data = mysqli_query($dbc, $query);
      if (mysqli_num_rows($data) == 1) {
      $valid_password = true;
      }

Anyone see what I am doing wrong?  The password stored in my DB is encrypted with SHA. 


Code: [Select]
<?php
  // Start the session
  require_once('startsession.php');
  // Insert the page header
  $page_title = 'Submit an Image';
  require_once('header.php');
  require_once('appvars.php');
  require_once('connectvars.php');
  // Show the navigation menu
  require_once('navmenu.php');

  // Make sure the user is logged in before going any further.
  if (!isset($_SESSION['user_id'])) {
    echo '<center><table border="0" cellspacing = "20"><tr><td>';
    echo '<p class="login">Please <a href="login.php">log in</a> to access this page.</p>';
    echo '</td></tr></table></center>';
    // Insert the page footer
    echo '<div class="footer">';
    require_once('footer.php');
    echo '</div>';
    exit();
  }
?>

<div class="linkrow">
<!-- end .linkrow --></div>

<div class="contentBlue960">
<img src = "/IMAGES/WEBSITE/capBlue960.jpg">


<?php
  if (isset($_POST['submit'])) {
// Connect to the DB
    $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
    // Set password to false
    $valid_password = false;  
    // Grab the id data from the POST
    $image_name = $_FILES['image_name']['name'];
    $image_name_type = $_FILES['image_name']['type'];
    $image_name_size = $_FILES['image_name']['size']; 
    $user_password = (mysqli_real_escape_string($dbc, trim($_POST['user_password'])));
    $agree = mysqli_real_escape_string($dbc, trim($_POST['agree']));
    // Grab the id data from the DB
    
    if (!isset($_GET['user_id'])) {
    $query = "SELECT user_name, password FROM user_info WHERE user_id = '" . $_SESSION['user_id'] . "'";
    }
  else {
    $query = "SELECT user_name, password FROM user_info WHERE user_id = '" . $_GET['user_id'] . "'";
    }
  $data = mysqli_query($dbc, $query);
    $user_name = $row['user_name'];
    $password = $row['password'];
    
      $query = "SELECT * FROM user_info WHERE password = SHA($user_password)";
      $data = mysqli_query($dbc, $query);
      if (mysqli_num_rows($data) == 1) {
      $valid_password = true;
      }


// If image and password are entered
    if (!empty($user_password) && !empty($image_name)) {
// If the entered password matches the user's password
      if ($valid_password == true) {
// If the copyright is agreed to
      if (($agree) == ('checked')) {
// If the pic is valid
      if ((($image_name_type == 'image/gif') || ($image_name_type == 'image/jpeg') || ($image_name_type == 'image/pjpeg') || ($image_name_type == 'image/png'))
        && ($image_name_size > 0) && ($image_name_size <= GW_MAXFILESIZE)) {
        if ($_FILES['image_name']['error'] == 0) {
          // Move the file to the target upload folder
          $target = GW_UPLOADPATH . $image_name;
          if (move_uploaded_file($_FILES['image_name']['tmp_name'], $target)) {
            // Connect to the database
     $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)
      or die('Error connecting to MySQL server.');

            // Write the data to the database
            $query = "INSERT INTO user_images VALUES (0, '$user_name', NOW(), '$image_name')";
            mysqli_query($dbc, $query);

            // Confirm success with the user
            echo '<p>Thanks for submitting an image!  Under review as soon as possible.</p>';
            echo '<p><strong>User Name:</strong> ' . $user_name . '<br />';
            echo '<img src="' . GW_UPLOADPATH . $image_name . '" alt="Submitted Image" /></p>';
            echo '<p><a href="submit.php">&lt;&lt; Back to submit page.</a></p>';

            // Clear the id data to clear the form
            $user_name = "";
            $image_name = "";

            mysqli_close($dbc);
          }
          else {
            echo '<p class="error">Sorry, there was a problem uploading your screen shot image.</p>';
          }
        }
      }
      else {
        echo '<p class="error">The screen shot must be a GIF, JPEG, or PNG image file no greater than ' . (GW_MAXFILESIZE / 1024) . ' KB in size.</p>';
      }

      // Try to delete the temporary screen shot image file
      @unlink($_FILES['image_name']['tmp_name']);
    }
    else {
      echo '<p class="error">Must agree with and check copyright box.</p>';        
    }

} else {
      echo '<p class="error">Password Incorrect</p>';    
    }
} else {
   //   echo 'Pass' . $password . ' 1';
    //  echo 'User pass' . $user_password . ' 2';
   //   echo 'Checkbox' . $agree . ' 3';
  //    echo 'Username' . $user_name . ' 3';
      echo '<p class="error">Please enter all of the information to add your image.</p>';
    }
  }
//  mysqli_close($dbc);
?>

<table border="1" cellspacing = "20">
<tr><td width = 960px><h2>Submit an Image</h2></td></tr>
</table>


<table border="1" cellspacing = "20">
  <form enctype="multipart/form-data" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">

<tr><td width = "300">   
<input type="hidden" name="MAX_FILE_SIZE" value="<?php echo GW_MAXFILESIZE; ?>" />
<label for="image_name">Image:</label></td>
<td><input type="file" id="image_name" name="image_name" />
</td></tr>   
   
<tr><td width = "300">
<label for="user_password">Enter Password:</label></td>
<td><input type="text" id="user_password" name="user_password" /><br />
</td></tr>

<tr><td width = "300">     
<label for="terms">This image is my own work and I own all copyrights to it.</label></td>
<td><input type="checkbox" id="agree" name="agree" value = "checked"/><br />
</td></tr>
   
<tr><td width = "300">       
<input type="submit" value="Submit Image" name="submit" />
</td></tr>   
       
  </form>
</td>
</tr>
</table>


<img src = "/IMAGES/WEBSITE/bottomBlue960.jpg">
<!-- end .contentWhite960 --></div>

<div class="footer">
<?php
  // Insert the page footer
  require_once('footer.php');
?>
<!-- end .footer --></div>



Thanks if you can help,
Craig

why does the top code work and the bottom does not? what am i missing? the only real diffrence is the query.
im getting "Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in " for this code $numrows = mysql_num_rows($result).

the query works fine in phpmyadmin.

thanks


$query = "SELECT * FROM dsgi_servlist " ;
$result = mysql_query($query) ;
$numrows = mysql_num_rows($result) ;
echo $numrows ;



$sql = "SELECT COUNT(*) FROM dsgi_servlist where location = 'hdd'"; 
$result = mysql_query($sql) ;
$numrows = mysql_num_rows($result) ;
echo $numrows ;