PHP MySQL search form [duplicate]
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
This question already has an answer here:
Warning: mysqli_error() expects exactly 1 parameter, 0 given error [closed]
3 answers
How to display errors for my MySQLi query? [duplicate]
3 answers
When to use single quotes, double quotes, and back ticks in MySQL
12 answers
Reference - What does this error mean in PHP?
32 answers
I'm trying to create a search form in php that is connected to a mysql db, but i have some problems and i don't know how to solve them.
I have a db with some different tables (db-brand1, db-brand2, db-brand3 and db-brand4) in which are some rows with different brand clients and obv clients so. All tables contain row as: firstame, lastname, id_client, id_2client, email ( p.k. )
so I created two php files. One for connection db called conn.php that I report below
<?php
$host = "localhost";
$userName = ".....";
$password = ".....";
$dbName = ".....";
// Create database connection
$conn = new mysqli($host, $userName, $password, $dbName);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
?>
and connection to db works correctly.
and other file that include the search form and query result called as search.php
<?
error_reporting(E_ALL);
ini_set('display_errors', '1');
include("conn.php");
$search_output = "";
if (isset($_POST["submit"])){
if($_POST['brand'] == "brand1"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand1 WHERE email = 'email";
}
else if ($_POST['brand'] == "brand2"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand2 WHERE email = 'email'";
}
else if ($_POST['brand'] == "brand3"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand3 WHERE email = 'email'";
}
else if ($_POST['brand'] == "brand4"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand4 WHERE email = 'email'";
}
$query = mysqli_query($conn,$sqlcommand) or die (mysqli_error($conn));
$search_output .="<hr />query result";
if ($row = mysqli_fetch_array($query)){
$email = $row ["email"];
$id-client = $row ["id_client"];
$id-2client = $row ["id_2client"];
$search_output .= "<p> $email - $id_client - $id_2client </p>";
} else{
$search_output= "<hr /> No result";
}
}
?>
<html>
<head>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
<title>Search form</title>
</head>
<body>
<section>
<div class="container">
<div class="row my-5">
<h1>Search form</h1>
</div>
<form name="search-info" method="post" action="<?php echo $_SERVER ['PHP_SELF']; ?>">
<div class="form-group">
<label for="exampleFormControlInput1">Enter client email</label>
<input type="email" class="form-control" id="exampleFormControlInput1" placeholder="clientemail@email.com" name="email">
</div>
<div class="form-group">
<label for="exampleFormControlSelect1">Select the brand</label>
<select class="form-control" id="exampleFormControlSelect1" name="brand">
<option value="brand1">Brand1</option>
<option value="brand2">Brand2</option>
<option value="brand3">Brand3</option>
<option value="brand4">Brand4</option>
</select>
</div>
<button class="btn btn-primary" type="submit" name="submit">Submit</button>
</form>
</div>
</section>
<section>
<div class="container">
<div class="row">
<p><?php echo $search_output; ?></p>
</div>
</div>
</section>
<script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin="anonymous"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQx"</script>
</body>
</html>
But nothing works correctly... i haven't php error, but i think that are problem with this part of code
$query = mysqli_query($conn,$sqlcommand)
or with correct execution of it
$search_output = "";
if (isset($_POST["submit"])){
if($_POST['brand'] == "brand1"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand1 WHERE email = 'email";
}
else if ($_POST['brand'] == "brand2"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand2 WHERE email = 'email'";
}
else if ($_POST['brand'] == "brand3"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand3 WHERE email = 'email'";
}
else if ($_POST['brand'] == "brand4"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand4 WHERE email = 'email'";
}
If i try to input an email contained in db_brand2 and select so brand2 from select option, i receive error as below
Warning: mysqli_error() expects exactly 1 parameter, 0 given in /home/../../search.php on line 26
that is $query = mysqli_query($conn,$sqlcommand) or die (mysqli_error());
How could solve it :/ ?
Thank you so much
php mysql forms search
marked as duplicate by Funk Forty Niner
StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;
$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');
$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
Jan 3 at 14:06
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
add a comment |
This question already has an answer here:
Warning: mysqli_error() expects exactly 1 parameter, 0 given error [closed]
3 answers
How to display errors for my MySQLi query? [duplicate]
3 answers
When to use single quotes, double quotes, and back ticks in MySQL
12 answers
Reference - What does this error mean in PHP?
32 answers
I'm trying to create a search form in php that is connected to a mysql db, but i have some problems and i don't know how to solve them.
I have a db with some different tables (db-brand1, db-brand2, db-brand3 and db-brand4) in which are some rows with different brand clients and obv clients so. All tables contain row as: firstame, lastname, id_client, id_2client, email ( p.k. )
so I created two php files. One for connection db called conn.php that I report below
<?php
$host = "localhost";
$userName = ".....";
$password = ".....";
$dbName = ".....";
// Create database connection
$conn = new mysqli($host, $userName, $password, $dbName);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
?>
and connection to db works correctly.
and other file that include the search form and query result called as search.php
<?
error_reporting(E_ALL);
ini_set('display_errors', '1');
include("conn.php");
$search_output = "";
if (isset($_POST["submit"])){
if($_POST['brand'] == "brand1"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand1 WHERE email = 'email";
}
else if ($_POST['brand'] == "brand2"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand2 WHERE email = 'email'";
}
else if ($_POST['brand'] == "brand3"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand3 WHERE email = 'email'";
}
else if ($_POST['brand'] == "brand4"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand4 WHERE email = 'email'";
}
$query = mysqli_query($conn,$sqlcommand) or die (mysqli_error($conn));
$search_output .="<hr />query result";
if ($row = mysqli_fetch_array($query)){
$email = $row ["email"];
$id-client = $row ["id_client"];
$id-2client = $row ["id_2client"];
$search_output .= "<p> $email - $id_client - $id_2client </p>";
} else{
$search_output= "<hr /> No result";
}
}
?>
<html>
<head>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
<title>Search form</title>
</head>
<body>
<section>
<div class="container">
<div class="row my-5">
<h1>Search form</h1>
</div>
<form name="search-info" method="post" action="<?php echo $_SERVER ['PHP_SELF']; ?>">
<div class="form-group">
<label for="exampleFormControlInput1">Enter client email</label>
<input type="email" class="form-control" id="exampleFormControlInput1" placeholder="clientemail@email.com" name="email">
</div>
<div class="form-group">
<label for="exampleFormControlSelect1">Select the brand</label>
<select class="form-control" id="exampleFormControlSelect1" name="brand">
<option value="brand1">Brand1</option>
<option value="brand2">Brand2</option>
<option value="brand3">Brand3</option>
<option value="brand4">Brand4</option>
</select>
</div>
<button class="btn btn-primary" type="submit" name="submit">Submit</button>
</form>
</div>
</section>
<section>
<div class="container">
<div class="row">
<p><?php echo $search_output; ?></p>
</div>
</div>
</section>
<script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin="anonymous"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQx"</script>
</body>
</html>
But nothing works correctly... i haven't php error, but i think that are problem with this part of code
$query = mysqli_query($conn,$sqlcommand)
or with correct execution of it
$search_output = "";
if (isset($_POST["submit"])){
if($_POST['brand'] == "brand1"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand1 WHERE email = 'email";
}
else if ($_POST['brand'] == "brand2"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand2 WHERE email = 'email'";
}
else if ($_POST['brand'] == "brand3"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand3 WHERE email = 'email'";
}
else if ($_POST['brand'] == "brand4"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand4 WHERE email = 'email'";
}
If i try to input an email contained in db_brand2 and select so brand2 from select option, i receive error as below
Warning: mysqli_error() expects exactly 1 parameter, 0 given in /home/../../search.php on line 26
that is $query = mysqli_query($conn,$sqlcommand) or die (mysqli_error());
How could solve it :/ ?
Thank you so much
php mysql forms search
marked as duplicate by Funk Forty Niner
StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;
$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');
$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
Jan 3 at 14:06
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
mysqli_error()
that requires a connection and your query failed because of a few reasons. Hint: "hyphens" = "minus".
– Funk Forty Niner
Jan 3 at 14:05
Also, never use-
in database names. only_
if you really need a separator
– Joppe De Cuyper
Jan 3 at 14:06
Hi, thank you. I wrote in a wrong way here. I used minus _ in database names in real php file, so problem isn't here.
– Paolo Gregorio
Jan 3 at 14:11
i don't understand why this my answer was put as duplicate. I read other post similar mine without find correct solution. However i added mysqli_error($conn) instead previous mysqli_error( ), but whentry to search something from search form ( connected to my db ) the only answer i have is "No result", but i should have in answer correct result of query. Someone can help me to check if there're some problems with this block of if - else ?
– Paolo Gregorio
Jan 3 at 17:17
add a comment |
This question already has an answer here:
Warning: mysqli_error() expects exactly 1 parameter, 0 given error [closed]
3 answers
How to display errors for my MySQLi query? [duplicate]
3 answers
When to use single quotes, double quotes, and back ticks in MySQL
12 answers
Reference - What does this error mean in PHP?
32 answers
I'm trying to create a search form in php that is connected to a mysql db, but i have some problems and i don't know how to solve them.
I have a db with some different tables (db-brand1, db-brand2, db-brand3 and db-brand4) in which are some rows with different brand clients and obv clients so. All tables contain row as: firstame, lastname, id_client, id_2client, email ( p.k. )
so I created two php files. One for connection db called conn.php that I report below
<?php
$host = "localhost";
$userName = ".....";
$password = ".....";
$dbName = ".....";
// Create database connection
$conn = new mysqli($host, $userName, $password, $dbName);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
?>
and connection to db works correctly.
and other file that include the search form and query result called as search.php
<?
error_reporting(E_ALL);
ini_set('display_errors', '1');
include("conn.php");
$search_output = "";
if (isset($_POST["submit"])){
if($_POST['brand'] == "brand1"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand1 WHERE email = 'email";
}
else if ($_POST['brand'] == "brand2"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand2 WHERE email = 'email'";
}
else if ($_POST['brand'] == "brand3"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand3 WHERE email = 'email'";
}
else if ($_POST['brand'] == "brand4"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand4 WHERE email = 'email'";
}
$query = mysqli_query($conn,$sqlcommand) or die (mysqli_error($conn));
$search_output .="<hr />query result";
if ($row = mysqli_fetch_array($query)){
$email = $row ["email"];
$id-client = $row ["id_client"];
$id-2client = $row ["id_2client"];
$search_output .= "<p> $email - $id_client - $id_2client </p>";
} else{
$search_output= "<hr /> No result";
}
}
?>
<html>
<head>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
<title>Search form</title>
</head>
<body>
<section>
<div class="container">
<div class="row my-5">
<h1>Search form</h1>
</div>
<form name="search-info" method="post" action="<?php echo $_SERVER ['PHP_SELF']; ?>">
<div class="form-group">
<label for="exampleFormControlInput1">Enter client email</label>
<input type="email" class="form-control" id="exampleFormControlInput1" placeholder="clientemail@email.com" name="email">
</div>
<div class="form-group">
<label for="exampleFormControlSelect1">Select the brand</label>
<select class="form-control" id="exampleFormControlSelect1" name="brand">
<option value="brand1">Brand1</option>
<option value="brand2">Brand2</option>
<option value="brand3">Brand3</option>
<option value="brand4">Brand4</option>
</select>
</div>
<button class="btn btn-primary" type="submit" name="submit">Submit</button>
</form>
</div>
</section>
<section>
<div class="container">
<div class="row">
<p><?php echo $search_output; ?></p>
</div>
</div>
</section>
<script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin="anonymous"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQx"</script>
</body>
</html>
But nothing works correctly... i haven't php error, but i think that are problem with this part of code
$query = mysqli_query($conn,$sqlcommand)
or with correct execution of it
$search_output = "";
if (isset($_POST["submit"])){
if($_POST['brand'] == "brand1"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand1 WHERE email = 'email";
}
else if ($_POST['brand'] == "brand2"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand2 WHERE email = 'email'";
}
else if ($_POST['brand'] == "brand3"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand3 WHERE email = 'email'";
}
else if ($_POST['brand'] == "brand4"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand4 WHERE email = 'email'";
}
If i try to input an email contained in db_brand2 and select so brand2 from select option, i receive error as below
Warning: mysqli_error() expects exactly 1 parameter, 0 given in /home/../../search.php on line 26
that is $query = mysqli_query($conn,$sqlcommand) or die (mysqli_error());
How could solve it :/ ?
Thank you so much
php mysql forms search
This question already has an answer here:
Warning: mysqli_error() expects exactly 1 parameter, 0 given error [closed]
3 answers
How to display errors for my MySQLi query? [duplicate]
3 answers
When to use single quotes, double quotes, and back ticks in MySQL
12 answers
Reference - What does this error mean in PHP?
32 answers
I'm trying to create a search form in php that is connected to a mysql db, but i have some problems and i don't know how to solve them.
I have a db with some different tables (db-brand1, db-brand2, db-brand3 and db-brand4) in which are some rows with different brand clients and obv clients so. All tables contain row as: firstame, lastname, id_client, id_2client, email ( p.k. )
so I created two php files. One for connection db called conn.php that I report below
<?php
$host = "localhost";
$userName = ".....";
$password = ".....";
$dbName = ".....";
// Create database connection
$conn = new mysqli($host, $userName, $password, $dbName);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
?>
and connection to db works correctly.
and other file that include the search form and query result called as search.php
<?
error_reporting(E_ALL);
ini_set('display_errors', '1');
include("conn.php");
$search_output = "";
if (isset($_POST["submit"])){
if($_POST['brand'] == "brand1"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand1 WHERE email = 'email";
}
else if ($_POST['brand'] == "brand2"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand2 WHERE email = 'email'";
}
else if ($_POST['brand'] == "brand3"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand3 WHERE email = 'email'";
}
else if ($_POST['brand'] == "brand4"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand4 WHERE email = 'email'";
}
$query = mysqli_query($conn,$sqlcommand) or die (mysqli_error($conn));
$search_output .="<hr />query result";
if ($row = mysqli_fetch_array($query)){
$email = $row ["email"];
$id-client = $row ["id_client"];
$id-2client = $row ["id_2client"];
$search_output .= "<p> $email - $id_client - $id_2client </p>";
} else{
$search_output= "<hr /> No result";
}
}
?>
<html>
<head>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
<title>Search form</title>
</head>
<body>
<section>
<div class="container">
<div class="row my-5">
<h1>Search form</h1>
</div>
<form name="search-info" method="post" action="<?php echo $_SERVER ['PHP_SELF']; ?>">
<div class="form-group">
<label for="exampleFormControlInput1">Enter client email</label>
<input type="email" class="form-control" id="exampleFormControlInput1" placeholder="clientemail@email.com" name="email">
</div>
<div class="form-group">
<label for="exampleFormControlSelect1">Select the brand</label>
<select class="form-control" id="exampleFormControlSelect1" name="brand">
<option value="brand1">Brand1</option>
<option value="brand2">Brand2</option>
<option value="brand3">Brand3</option>
<option value="brand4">Brand4</option>
</select>
</div>
<button class="btn btn-primary" type="submit" name="submit">Submit</button>
</form>
</div>
</section>
<section>
<div class="container">
<div class="row">
<p><?php echo $search_output; ?></p>
</div>
</div>
</section>
<script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin="anonymous"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQx"</script>
</body>
</html>
But nothing works correctly... i haven't php error, but i think that are problem with this part of code
$query = mysqli_query($conn,$sqlcommand)
or with correct execution of it
$search_output = "";
if (isset($_POST["submit"])){
if($_POST['brand'] == "brand1"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand1 WHERE email = 'email";
}
else if ($_POST['brand'] == "brand2"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand2 WHERE email = 'email'";
}
else if ($_POST['brand'] == "brand3"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand3 WHERE email = 'email'";
}
else if ($_POST['brand'] == "brand4"){
$sqlcommand="SELECT email, id_client, id_2client FROM db-brand4 WHERE email = 'email'";
}
If i try to input an email contained in db_brand2 and select so brand2 from select option, i receive error as below
Warning: mysqli_error() expects exactly 1 parameter, 0 given in /home/../../search.php on line 26
that is $query = mysqli_query($conn,$sqlcommand) or die (mysqli_error());
How could solve it :/ ?
Thank you so much
This question already has an answer here:
Warning: mysqli_error() expects exactly 1 parameter, 0 given error [closed]
3 answers
How to display errors for my MySQLi query? [duplicate]
3 answers
When to use single quotes, double quotes, and back ticks in MySQL
12 answers
Reference - What does this error mean in PHP?
32 answers
php mysql forms search
php mysql forms search
edited Jan 3 at 17:09
Paolo Gregorio
asked Jan 3 at 14:04
Paolo GregorioPaolo Gregorio
12
12
marked as duplicate by Funk Forty Niner
StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;
$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');
$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
Jan 3 at 14:06
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
marked as duplicate by Funk Forty Niner
StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;
$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');
$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
Jan 3 at 14:06
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
mysqli_error()
that requires a connection and your query failed because of a few reasons. Hint: "hyphens" = "minus".
– Funk Forty Niner
Jan 3 at 14:05
Also, never use-
in database names. only_
if you really need a separator
– Joppe De Cuyper
Jan 3 at 14:06
Hi, thank you. I wrote in a wrong way here. I used minus _ in database names in real php file, so problem isn't here.
– Paolo Gregorio
Jan 3 at 14:11
i don't understand why this my answer was put as duplicate. I read other post similar mine without find correct solution. However i added mysqli_error($conn) instead previous mysqli_error( ), but whentry to search something from search form ( connected to my db ) the only answer i have is "No result", but i should have in answer correct result of query. Someone can help me to check if there're some problems with this block of if - else ?
– Paolo Gregorio
Jan 3 at 17:17
add a comment |
mysqli_error()
that requires a connection and your query failed because of a few reasons. Hint: "hyphens" = "minus".
– Funk Forty Niner
Jan 3 at 14:05
Also, never use-
in database names. only_
if you really need a separator
– Joppe De Cuyper
Jan 3 at 14:06
Hi, thank you. I wrote in a wrong way here. I used minus _ in database names in real php file, so problem isn't here.
– Paolo Gregorio
Jan 3 at 14:11
i don't understand why this my answer was put as duplicate. I read other post similar mine without find correct solution. However i added mysqli_error($conn) instead previous mysqli_error( ), but whentry to search something from search form ( connected to my db ) the only answer i have is "No result", but i should have in answer correct result of query. Someone can help me to check if there're some problems with this block of if - else ?
– Paolo Gregorio
Jan 3 at 17:17
mysqli_error()
that requires a connection and your query failed because of a few reasons. Hint: "hyphens" = "minus".– Funk Forty Niner
Jan 3 at 14:05
mysqli_error()
that requires a connection and your query failed because of a few reasons. Hint: "hyphens" = "minus".– Funk Forty Niner
Jan 3 at 14:05
Also, never use
-
in database names. only _
if you really need a separator– Joppe De Cuyper
Jan 3 at 14:06
Also, never use
-
in database names. only _
if you really need a separator– Joppe De Cuyper
Jan 3 at 14:06
Hi, thank you. I wrote in a wrong way here. I used minus _ in database names in real php file, so problem isn't here.
– Paolo Gregorio
Jan 3 at 14:11
Hi, thank you. I wrote in a wrong way here. I used minus _ in database names in real php file, so problem isn't here.
– Paolo Gregorio
Jan 3 at 14:11
i don't understand why this my answer was put as duplicate. I read other post similar mine without find correct solution. However i added mysqli_error($conn) instead previous mysqli_error( ), but whentry to search something from search form ( connected to my db ) the only answer i have is "No result", but i should have in answer correct result of query. Someone can help me to check if there're some problems with this block of if - else ?
– Paolo Gregorio
Jan 3 at 17:17
i don't understand why this my answer was put as duplicate. I read other post similar mine without find correct solution. However i added mysqli_error($conn) instead previous mysqli_error( ), but whentry to search something from search form ( connected to my db ) the only answer i have is "No result", but i should have in answer correct result of query. Someone can help me to check if there're some problems with this block of if - else ?
– Paolo Gregorio
Jan 3 at 17:17
add a comment |
0
active
oldest
votes
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
mysqli_error()
that requires a connection and your query failed because of a few reasons. Hint: "hyphens" = "minus".– Funk Forty Niner
Jan 3 at 14:05
Also, never use
-
in database names. only_
if you really need a separator– Joppe De Cuyper
Jan 3 at 14:06
Hi, thank you. I wrote in a wrong way here. I used minus _ in database names in real php file, so problem isn't here.
– Paolo Gregorio
Jan 3 at 14:11
i don't understand why this my answer was put as duplicate. I read other post similar mine without find correct solution. However i added mysqli_error($conn) instead previous mysqli_error( ), but whentry to search something from search form ( connected to my db ) the only answer i have is "No result", but i should have in answer correct result of query. Someone can help me to check if there're some problems with this block of if - else ?
– Paolo Gregorio
Jan 3 at 17:17