Jump to content

Warning: mysql_query() expects parameter 2 to be resource, object given in F:\xampp\htdocs\taranaki2.php on line 69


dean012
Go to solution Solved by PravinS,

Recommended Posts

Failed to connectarrow-10x10.png to MySQL:
Warning: mysql_query() expects parameter 2 to be resource, object given in F:\xampp\htdocs\taranaki2.php on linearrow-10x10.png 69

Notice: Undefined variable: resultarrow-10x10.png in F:\xampp\htdocs\taranaki2.php on line 81

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in F:\xampp\htdocs\taranaki2.php on line 81

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<!--


-->
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name="keywords" content="" />
<meta name="description" content="" />
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>Yakity Yak</title>
<link href='http://fonts.googleapis.com/css?family=Oswald:400,300' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Abel|Satisfy' rel='stylesheet' type='text/css'>
<link href="style.css" rel="stylesheet" type="text/css" media="screen" />
</head>
<body>
<div id="wrapper">
  <p><!-- end #header --></p>
  <div id="header" class="container">
    <div id="logo">
      <h1><a href="#">Yakity Yak</a></h1>
    </div>
    <div id="menu">
      <ul>
        <li class="current_page_item"><a href="file:///D:/blackpolish/homepage.php">Homepage</a></li>
        <li><a href="file:///D:/blackpolish/trip.php">Destinations</a></li>
        <li><a href="#">contact </a></li>
        <li><a href="#">Login</a></li>
		<li><a href="adminlogin.php">Leader</a></li>
        <li></li>
        <li></li>
      </ul>
    </div>
  </div>
  <blockquote>
    <blockquote>
      <p> <center><img src="../../Documents/Unnamed Site 2/IMG_1913.jpg" width="999" height="388"  alt=""/></center>  </p>
    </blockquote>
  </blockquote>
  <div id="page">
    <div class="post">
      <h2 class="title"><a href="#">Taranaki</a></h2>
			<div class="entry">
				<table border='1'>
    
    </div>

	


 
</body>
</html>
<?php
/* This code establishes a connection with the database on the server. 
The mysql_connect accepts three parameters. The mysql_select_db attempts to select the database that data will be retrived from. 
It accepts two parameters, one is the name of the database and the other is the connection variable.*/
   
$con=mysqli_connect("localhost","root","","assesment");
// Check connection
if (mysqli_connect_errno())

$result = mysqli_query($con,"SELECT * FROM taranaki");
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
if(isset($_POST['update'])){
$UpdateQuery= "UPDATE taranaki SET ID='$_POST[ID]',Destination='$_POST[Destination]',Difficulty='$_POST[Difficulty]' ";
mysql_query($UpdateQuery, $con);
};



echo "<table border='1'>
<tr>
<th>ID</th>
<th>Destination</th>
<th>Difficulty</th>
</tr>";

while($row = mysqli_fetch_array($result)){
  echo "<form action=taranaki2.php method=post>";{
  echo "<tr>";
  echo "<td>" . '<input type="text"  name="ID" value=""/>'.         $row['ID'] .          "</td>";
  echo "<td>" . '<input type="text" name="Destination" value=""/>'. $row['Destination'] . "</td>";
  echo "<td>" . '<input type="text"  name="Difficulty" value=""/>'. $row['Difficulty'] .  "</td>";
  echo "<td>". '<input type="submit" name="update" value="update"/>'.                       "</td>";
  echo "</tr>";
  echo "</form>";}
echo "</table>";
}

mysqli_close($con);
?>
Link to comment
Share on other sites

i done that now i got

Warning: mysql_query() expects parameter 1 to be string, resource given in F:\xampp\htdocs\taranaki2.php on linearrow-10x10.png 73

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in F:\xampp\htdocs\taranaki2.php on line 83

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<!--


-->
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name="keywords" content="" />
<meta name="description" content="" />
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>Yakity Yak</title>
<link href='http://fonts.googleapis.com/css?family=Oswald:400,300' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Abel|Satisfy' rel='stylesheet' type='text/css'>
<link href="style.css" rel="stylesheet" type="text/css" media="screen" />
</head>
<body>
<div id="wrapper">
  <p><!-- end #header --></p>
  <div id="header" class="container">
    <div id="logo">
      <h1><a href="#">Yakity Yak</a></h1>
    </div>
    <div id="menu">
      <ul>
        <li class="current_page_item"><a href="file:///D:/blackpolish/homepage.php">Homepage</a></li>
        <li><a href="file:///D:/blackpolish/trip.php">Destinations</a></li>
        <li><a href="#">contact </a></li>
        <li><a href="#">Login</a></li>
		<li><a href="adminlogin.php">Leader</a></li>
        <li></li>
        <li></li>
      </ul>
    </div>
  </div>
  <blockquote>
    <blockquote>
      <p> <center><img src="../../Documents/Unnamed Site 2/IMG_1913.jpg" width="999" height="388"  alt=""/></center>  </p>
    </blockquote>
  </blockquote>
  <div id="page">
    <div class="post">
      <h2 class="title"><a href="#">Taranaki</a></h2>
			<div class="entry">
				<table border='1'>
    
    </div>

	


 
</body>
</html>
<?php
/* This code establishes a connection with the database on the server. 
The mysql_connect accepts three parameters. The mysql_select_db attempts to select the database that data will be retrived from. 
It accepts two parameters, one is the name of the database and the other is the connection variable.*/
   
$con=mysql_connect("localhost","root","","assesment");
if(isset($_POST['update'])){
$UpdateQuery = "UPDATE taranaki SET ID='$_POST[ID]', Destinations='$_POST[Destinations]', Difficulty='$_POST[Difficulty]' " ;
mysql_query($UpdateQuery, $con);
};
// Check connection
if (mysqli_connect_errno())


  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }


$result = mysql_query($con,"SELECT * FROM taranaki");


echo "<table border='1'>
<tr>
<th>ID</th>
<th>Destinations</th>
<th>Difficulty</th>
</tr>";

  while($row = mysqli_fetch_array($result));{
  echo "<form action=taranaki2.php method=post>";{
  echo "<tr>";
  echo "<td>" . '<input type="text"  name="ID" value=""/>'.         $row['ID'] .          "</td>";
  echo "<td>" . '<input type="text" name="Destinations" value=""/>'. $row['Destinations'] . "</td>";
  echo "<td>" . '<input type="text"  name="Difficulty" value=""/>'. $row['Difficulty'] .  "</td>";
  echo "<td>". '<input type="submit" name="update" value="update"/>'.                       "</td>";
  echo "</tr>";
  echo "</form>";}
echo "</table>";
}

mysql_close($con);
?>
Link to comment
Share on other sites

and now i got this Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in F:\xampp\htdocs\taranaki2.php on linearrow-10x10.png 85

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<!--


-->
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name="keywords" content="" />
<meta name="description" content="" />
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>Yakity Yak</title>
<link href='http://fonts.googleapis.com/css?family=Oswald:400,300' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Abel|Satisfy' rel='stylesheet' type='text/css'>
<link href="style.css" rel="stylesheet" type="text/css" media="screen" />
</head>
<body>
<div id="wrapper">
  <p><!-- end #header --></p>
  <div id="header" class="container">
    <div id="logo">
      <h1><a href="#">Yakity Yak</a></h1>
    </div>
    <div id="menu">
      <ul>
        <li class="current_page_item"><a href="file:///D:/blackpolish/homepage.php">Homepage</a></li>
        <li><a href="file:///D:/blackpolish/trip.php">Destinations</a></li>
        <li><a href="#">contact </a></li>
        <li><a href="#">Login</a></li>
		<li><a href="adminlogin.php">Leader</a></li>
        <li></li>
        <li></li>
      </ul>
    </div>
  </div>
  <blockquote>
    <blockquote>
      <p> <center><img src="../../Documents/Unnamed Site 2/IMG_1913.jpg" width="999" height="388"  alt=""/></center>  </p>
    </blockquote>
  </blockquote>
  <div id="page">
    <div class="post">
      <h2 class="title"><a href="#">Taranaki</a></h2>
			<div class="entry">
				<table border='1'>
    
    </div>

	


 
</body>
</html>
<?php
/* This code establishes a connection with the database on the server. 
The mysql_connect accepts three parameters. The mysql_select_db attempts to select the database that data will be retrived from. 
It accepts two parameters, one is the name of the database and the other is the connection variable.*/
   
$con=mysql_connect("localhost","root","","taranaki");
if(isset($_POST['update'])){
$UpdateQuery = "UPDATE taranaki2 SET ID='$_POST[ID]', Destinations='$_POST[Destinations]', Difficulty='$_POST[Difficulty]' WHERE ID='$_POST[hidden]'"; ;
mysql_query($UpdateQuery, $con);
};


// Check connection
if (mysqli_connect_errno())


  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }


$sql = "SELECT * FROM taranaki2";
$myData = mysql_query($sql,$con);

echo "<table border=1>
<tr>
<th>ID</th>
<th>Destinations</th>
<th>Difficulty</th>
</tr>";

while($record = mysql_fetch_array($myData));{
echo "<form action=taranaki2.php method=post>";
echo "<tr>";
echo "<td>" . '<input type="text"  name="ID" value=""/>'.         $record['ID'] .          "</td>";
echo "<td>" . '<input type="text" name="Destinations" value=""/>'. $record['Destinations'] . "</td>";
echo "<td>" . '<input type="text"  name="Difficulty" value=""/>'. $record['Difficulty'] .  "</td>";
echo "<td>". '<input type="submit" name="update" value="update"/>'.                       "</td>";
echo "<td>" . "<input type=hidden name=hidden value=" . $record['ID'] . " </td>";
echo "</tr>";
echo "</table>";
echo "</form>";
}

mysql_close($con);
?>
Link to comment
Share on other sites


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<!--


-->
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta name="keywords" content="" />
<meta name="description" content="" />
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>Yakity Yak</title>
<link href='http://fonts.googleapis.com/css?family=Oswald:400,300' rel='stylesheet' type='text/css'>
<link href='http://fonts.googleapis.com/css?family=Abel|Satisfy' rel='stylesheet' type='text/css'>
<link href="style.css" rel="stylesheet" type="text/css" media="screen" />
</head>
<body>
<div id="wrapper">
<p><!-- end #header --></p>
<div id="header" class="container">
<div id="logo">
<h1><a href="#">Yakity Yak</a></h1>
</div>
<div id="menu">
<ul>
<li class="current_page_item"><a href="file:///D:/blackpolish/homepage.php">Homepage</a></li>
<li><a href="file:///D:/blackpolish/trip.php">Destinations</a></li>
<li><a href="#">contact </a></li>
<li><a href="#">Login</a></li>
<li><a href="adminlogin.php">Leader</a></li>
<li></li>
<li></li>
</ul>
</div>
</div>
<blockquote>
<blockquote>
<p> <center><img src="../../Documents/Unnamed Site 2/IMG_1913.jpg" width="999" height="388" alt=""/></center> </p>
</blockquote>
</blockquote>
<div id="page">
<div class="post">
<h2 class="title"><a href="#">Taranaki</a></h2>
<div class="entry">
<table border='1'>

</div>



<?php
/* This code establishes a connection with the database on the server.
The mysql_connect accepts three parameters. The mysql_select_db attempts to select the database that data will be retrived from.
It accepts two parameters, one is the name of the database and the other is the connection variable.*/

$con = mysql_connect("localhost","root","","taranaki");
if (!$con){
die("Can not connect: " . mysql_error());
}
mysql_select_db("taranaki",$con);



if(isset($_POST['update'])){
$UpdateQuery = "UPDATE taranaki2 SET ID='$_POST[ID]', Destinations='$_POST[Destinations]', Difficulty='$_POST[Difficulty]' ,WHERE ID='$_POST[hidden]'"; ;
mysql_query($UpdateQuery, $con);
};




$sql = "SELECT * FROM taranaki2";
$myData = mysql_query($sql,$con);

echo "<table border=1>
<tr>
<th>ID</th>
<th>Destinations</th>
<th>Difficulty</th>
</tr>";

while($record = mysql_fetch_array($myData));{
echo "<form action=taranaki2.php method=post>";
echo "<tr>";
echo "<td>" . '<input type="text" name="ID" value=""/>'. $record['ID'] . "</td>";
echo "<td>" . '<input type="text" name="Destinations" value=""/>'.$record['Destinations'] . "</td>";
echo "<td>" . '<input type="text" name="Difficulty" value=""/>'. $record['Difficulty'] . "</td>";
echo "<td>" . "<input type=hidden name=hidden value=" . $record['ID'] . " </td>";
echo "<td>" . "<input type=submit name=update value=update" . " </td>";
echo "<td>" . "<input type=submit name=delete value=delete" . " </td>";
echo "</tr>";
echo "</table>";
echo "</form>";
}

mysql_close($con);
?>

</body>
</html>

Link to comment
Share on other sites

STOP NOW!

 

Use mysqli_ and you'll be headed in a great direction!  See the big fat warning?

 

Big Fat MySQL Extension Warning

This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:

 

USE MySQLi INSTEAD

Edited by objnoob
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.