PHP - How To Select Background By Query String Parameter?

Warning: mysql_query() expects parameter 1 to be string, resource given in C:\wamp\www\mariyano\profile.php on line 37

Help me to solve this problem

I just want to display the datas in table

Thanks in advance

Hi, I have the following mqsql query which works fine on my page called property.php

<?php

$result = mysql_query("SELECT * FROM properties WHERE Property_Name='Test Hotel'") or die(mysql_error()); 

$row = mysql_fetch_array( $result );

echo "Property Name: ".$row['Property_Name'];
echo "<br>Property Rating: ".$row['Property_Rating'];
echo "<br>Property Address: ".$row['Property_Address'];
?>

Where I use the value of 'Test Hotel' for Property Name in above, how can I insert this value from a url parameter like /property.php?propertyname=Test Hotel?

Thanks so much.

I have a strange error from the code below. I have run the query with the resulting values in PHPMyAdmin and it works fine.

The code is:
$query = "SELECT * FROM sn_matches WHERE (P1_ID='".$P1_ID."' AND P2_ID='".$P2_ID."') OR (P1_ID='".$P2_ID."' AND P2_ID='".$P1_ID."')";
while($row = mysql_fetch_assoc($query)){

The error is:
Quote

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, string given in /customers/ronflorax.com/ronflorax.com/httpd.www/snookerstats/h2h.php on line 21


Line 21 is the one which has mysql_fetch_assoc on it.

Any help would be much appreciated!

Hey, all.  I'm new to php/mysql.

I'm getting the warning:
Quote

mysql_fetch_array() expects parameter 1 to be resource, string...line 39


with reference to the mysql_fetch_array function in the following code:

mysql_select_db("calculators", $con);

$query = "SELECT * FROM calculator WHERE Abbreviation = '" . $_GET['abbreviation'] . "'";

$result = mysql_query($query, $con);

while($row = mysql_fetch_array($result)) {
//some code...
  }



The code runs fine, but I'd like to know why I'm getting the warning.  I've looked at similar post on this forum and other forums and can't quite get a straight answer.

Thanks a bunch,

Davis

PHP Warning:  file_exists() expects parameter 1 to be string, array given in /home/mysite/public_html/display.mysite.com/wp-content/themes/mytheme/form.php on line 9

PHP Warning:  file_exists() expects parameter 1 to be string, array given in /home/mysite/public_html/display.mysite.com/wp-content/themes/mytheme/form.php on line 13

I have a form that is having some issues and in the error log I see a bunch of these warnings. What is wrong with this??   I numbered the offending lines below (lines 9 & 13)   Thanks for any help on this.

function CheckExistance($VUrl)

{

/*9*/    if ( file_exists($VUrl) )

        echo $VUrl;

/*13*/    elseif ( file_exists(str_replace('www.display.mysite.com','www.display.com', $VUrl)) )

        echo str_replace('www.display.mysite.com','www.mysite.com', $VUrl);

    else

        echo str_replace('www.mysite.com','www.display.mysite.com', $VUrl);

}

Edited by damion, 02 July 2014 - 06:01 PM.

Here is the error:
Code: [Select]
Warning: image_type_to_extension() expects parameter 1 to be long, string given in C:\wamp\www\Login\inc\edit-profile.php on line 23
Here is the code for line 23:
Code: [Select]
$type = image_type_to_extension($_FILES['pic']['type'], true);
Here is the code for the whole page:
Code: [Select]
<?php
if(!$userb)
{
login('?p=edit-profile');
die();
}
if(isset($_POST['submit']))
{
$mottof = mysql_real_escape_string(bb($_POST['motto']));
$aboutf = mysql_real_escape_string(bb($_POST['about']));
$interesrsf = mysql_real_escape_string(bb($_POST['interests']));
$booksf = mysql_real_escape_string(bb($_POST['books']));
$authorsf = mysql_real_escape_string(bb($_POST['author']));
$randf = mysql_real_escape_string(bb($_POST['random']));
if($_FILES['pic']['type'] == 'image/gif' || $_FILES['pic']['type'] == 'image/jpeg' || $_FILES['pic']['type'] =-'image/pjpeg' || $_FILES['pic']['type'] == 'image/png')
{
if($_FILES['pic']['size'] < 8388608)
{
if($_FILES['pic']['name'] != '')
{

//mkdir('/images/user_images/' .$user_log);
$type = image_type_to_extension($_FILES['pic']['type'], true);
move_uploaded_file($_FILES['pic']['tmp_name'], 'images/user_images/' .$user_log .'pp' .$type);
$path = 'images/user_images/' .$user_log .'pp' .$type;
}
else 
{
$path = 'images/user_images/user.jpg';}
}
$q2 = "UPDATE login_info
SET profile_picture = '$path'
WHERE user='$user_log'

";
mysql_query($q2) or die(mysql_error());


}


$query = "
UPDATE login_info
SET motto = '$mottof', about = '$aboutf', fav_books = '$booksf', fav_authors = '$authorsf', interests = '$interesrsf', random = '$randf'
WHERE user='$user_log'
";
mysql_query($query);






echo '<h3> Profile Updated </h3>';
}
$q = "SELECT * FROM login_info WHERE user='$user_log' ";
$s = mysql_query($q) or die(mysql_error());
$r = mysql_fetch_assoc($s);
$motto = $r['motto'];
$about = $r['about'];
$books= $r['fav_books'];
$authors = $r['fav_authors'];
$rand = $r['random'];
$interests = $r['Interests'];
if(isset($_GET['act'])){$red = '?p=' .$rpage ;} else {$red='?p=edit_profile';}
echo"

<form action='?p=edit-profile' enctype='multipart/form-data' method='post' >
<label>Motto: </label>
<input type='text' name='motto' value='$motto' placeholder='Motto' />
<label> About :</label>
<textarea name='about' cols='40' rows='10'> $about</textarea>
<label> Interests: </label>
<textarea name='interests' cols='40' rows='10'> $interests </textarea>
<label> Favorite Books: </label>
<textarea name='books' cols='40' rows='10'> $books </textarea>
<label> Favorite Authors </label>
<textarea name='author' cols='40' rows='10'> $authors </textarea>
<label> Random: </label>
<textarea name='random' cols='40' rows='10'> $rand </textarea>
";
?>
<script type='text/javascript'>
function if_checked()
{
if($('#cur').is(':checked'))
{
$('#pic').attr('disabled', true);
}
else
{
$('#pic').removeAttr('disabled');
}
}
</script>
<label> Profile Pictu </label>
<input type='checkbox' name= 'current' id='cur' onchange="if_checked();" checked /> <label for='current' style='display:inline;'> Current profile picture </label> <br />
<input type='file' id='pic' name='pic' disabled="disabled" />
<br />
<input type='submit' value ='Submit' name='submit' />
</form>
Ive used the function before and I havent encountered this error. Im not sure what it means.

Hi,

I'm getting this error:

Warning: mktime() expects parameter 5 to be long, string given in /home/user/public_html/include/functions.php on line 58

The code is:
if($Date_Format == 1) #For dd-mm-yyyy
{
$Date_Output = date("d-m-Y",mktime(0,0,0,$Month,$Day,$Year));
}
elseif($Date_Format == 2) #For dd/mm/yyyy
{
$Date_Output = date("d/m/Y",mktime(0,0,0,$Month,$Day,$Year));
}
elseif($Date_Format == 3) #For mm-dd-yyyy
{
$Date_Output = date("m-d-Y",mktime(0,0,0,$Month,$Day,$Year));
}
elseif($Date_Format == 4) #For mm/dd/yyyy
{
$Date_Output = date("m/d/Y",mktime(0,0,0,$Month,$Day,$Year));
}
elseif($Date_Format == 5) #For Mon Day YYYY
{
$Date_Output = date("M D Y",mktime(0,0,0,$Month,$Day,$Year));
}
elseif($Date_Format == 6) #For Month Day YYYY
{
$Date_Output = date("F D Y",mktime(0,0,0,$Month,$Day,$Year));
}

elseif($Date_Format == 7) #For Date"nd" Month YYYY
{
$Date_Output = date("d\\t\h F Y",mktime(0,0,0,$Month,$Day,$Year));
}
elseif($Date_Format == 8) #For Month Day YYYY
{
$Date_Output = date("F d Y",mktime(0,0,0,$Month,$Day,$Year));
}
elseif($Date_Format == 9) #For Month Day YYYY
{
$Date_Output = date("d/m/Y H:i",mktime($DateDispsplittimehr,$DateDispsplittimemin,0,$Month,$Day,$Year)); // Line 58
}

return $Date_Output;
}
else
{
return NULL;

Line 58 says

$Date_Output = date("d/m/Y H:i",mktime($DateDispsplittimehr,$DateDispsplittimemin,0,$Month,$Day,$Year));


I really appreciate any help on this.

Hello all,   Based on the suggestion of you wonderful folks here, I went away for a few days (to learn about PDO and Prepared Statements) in order to replace the MySQLi commands in my code. That's gone pretty well thus far...with me having learnt and successfully replaced most of my "bad" code with elegant, SQL-Injection-proof code (or so I hope).   The one-and-only problem I'm having (for now at least) is that I'm having trouble understanding how to execute an UPDATE query within the resultset of a SELECT query (using PDO and prepared statements, of course).   Let me explain (my scenario), and since a picture speaks a thousand words I've also inlcuded a screenshot to show you guys my setup:   In my table I have two columns (which are essentially flags i.e. Y/N), one for "items alreay purchased" and the other for "items to be purchased later". The first flag, if/when set ON (Y) will highlight row(s) in red...and the second flag will highlight row(s) in blue (when set ON).   I initially had four buttons, two each for setting the flags/columns to "Y", and another two to reverse the columns/flags to "N". That was when I had my delete functionality as a separate operation on a separate tab/list item, and that was fine.   Now that I've realized I can include both operations (update and delete) on just the one tab, I've also figured it would be better to pare down those four buttons (into just two), and set them up as a toggle feature i.e. if the value is currently "Y" then the button will set it to "N", and vice versa.   So, looking at my attached picture, if a person selects (using the checkboxes) the first four rows and clicks the first button (labeled "Toggle selected items as Purchased/Not Purchased") then the following must happen:   1. The purchased_flag for rows # 2 and 4 must be switched OFF (set to N)...so they will no longer be highlighted in red. 2. The purchased_flag for row # 3 must be switched ON (set to Y)...so that row will now be highlighted in red. 3. Nothing must be done to rows # 1 and 5 since: a) row 5 was not selected/checked to begin with, and b) row # 1 has its purchase_later_flag set ON (to Y), so it must be skipped over.   Looking at my code below, I'm guessing (and here's where I need the help) that there's something wrong in the code within the section that says "/*** loop through the results/collection of checked items ***/". I've probably made it more complex than it should be, and that's due to the fact that I have no idea what I'm doing (or rather, how I should be doing it), and this has driven me insane for the last 2 days...which prompted me to "throw in the towel" and seek the help of you very helpful and intellegent folks. BTW, I am a newbie at this, so if I could be provided the exact code, that would be most wonderful, and much highly appreciated.   Thanks to you folks, I'm feeling real good (with a great sense of achievement) after having come here and got the great advice to learn PDO and prepared statements.   Just this one nasty little hurdle is stopping me from getting to "end-of-job" on my very first WebApp. BTW, sorry about the long post...this is the best/only way I could clearly explaing my situation.   Cheers guys!

case "update-delete":
	if(isset($_POST['highlight-purchased'])) 
		{
			// ****** Setup customized query to obtain only items that are checked ******
			$sql = "SELECT * FROM shoplist WHERE";
					for($i=0; $i < count($_POST['checkboxes']); $i++)
						{
							$sql=$sql . " idnumber=" . $_POST['checkboxes'][$i] . " or";
						}
					$sql= rtrim($sql, "or");
											
			$statement = $conn->prepare($sql);
			$statement->execute();
																						
			// *** fetch results for all checked items (1st query) *** //
			$result = $statement->fetchAll();

			$statement->closeCursor();
											
			// Setup query that will change the purchased flag to "N", if it's currently set to "Y"
			$sqlSetToN = "UPDATE shoplist SET purchased = 'N' WHERE purchased = 'Y'";
											
			// Setup query that will change the purchased flag to "Y", if it's currently set to "N", "", or NULL
			$sqlSetToY = "UPDATE shoplist SET purchased = 'Y' WHERE purchased = 'N' OR purchased = '' OR purchased IS NULL";

			$statementSetToN = $conn->prepare($sqlSetToN);
			$statementSetToY = $conn->prepare($sqlSetToY);
											
			/*** loop through the results/collection of checked items ***/
			foreach($result as $row)
				{
					if ($row["purchased"] != "Y")
						{
							// *** fetch one row at a time pertaining to the 2nd query *** //
							$resultSetToY = $statementSetToY->fetch();
															
							foreach($resultSetToY as $row)
								{															
									$statementSetToY->execute();																
								}
						}
					else
						{
							// *** fetch one row at a time pertaining to the 2nd query *** //
							$resultSetToN = $statementSetToN->fetch();
															
							foreach($resultSetToN as $row)
								{															
									$statementSetToN->execute();																
								}
						}
				}
				break;
		}

 CRUD Queston.png   20.68KB   0 downloads    

if($pid != "") {
    $bname = $_REQUEST['bname'];
    $btitle = $_REQUEST['btitle'];
    $btags = $_REQUEST['btags'];
    $bdesc = $_REQUEST['bdesc'];
    $btext = $_REQUEST['btext'];
    $bimg = $_REQUEST['bimg'];
    $bimgalt = $_REQUEST['bimgalt'];
            
            $data = "";
                if($bname!="") { $data = $data." 'bname' => ".$bname.", "; }
                if($btitle!="") { $data = $data."'btitle' => ".$btitle.", "; }
                if($btags!="") { $data = $data."'btags' => ".$btags.", "; }    
                if($bdesc!="") { $data = $data."'bdesc' => ".$bdesc.", "; }
                if($btext!="") { $data = $data."'btext' => ".$btext.", "; }    
                if($bimg!="") { $data = $data."'bimg' => ".$bimg.", "; }    
                if($bimgalt!="") { $data = $data."'bimgalt' => ".$bimgalt.", "; }
                $data = $data."'pid ' =>". $pid.", " ;
                $data = "[".$data."]";
                
            
            $build = "";
                if($bname!="") { $build = $build." page_name = :bname,"; }
                if($btitle!="") { $build = $build." page_title = :btitle,"; }
                if($btags!="") { $build = $build." page_tags = :btags,"; }
                if($bdesc!="") { $build = $build." page_desc = :bdesc,"; }
                if($btext!="") { $build = $build." page_text = :btext,"; }
                if($bimg!="") { $build = $build." page_img = :bimg,"; }
                if($bimgalt!="") { $build = $build." page_imgalt = :bimgalt,"; }
                $build = $build." page_id = :pid";
                
                
                    
            $sql = "UPDATE pages SET ".$build." WHERE page_id=:pid";
            echo $sql."<br /><br />";            
            echo $data."<br /><br />";    
            
            $stmt= $pdo->prepare($sql);
            $stmt->execute($data);

 Result of echo SQL and Data

UPDATE pages SET page_name = :bname, page_title = :btitle, page_tags = :btags, page_desc = :bdesc, page_text = :btext, page_img = :bimg, page_imgalt = :bimgalt, page_id = :pid WHERE page_id=:pid

[ 'bname' => Home, 'btitle' => Market Net, 'btags' => full stack development, search engine ready, professional web development, web design, 'bdesc' => Market net gives you online access to market traders country wide, Support Local businesses today, 'btext' =>

Market Net is the place for you to find those goodies you saw on the markets, buy them online and support small local businesses. Watch this space for more information.

Test

#D hvac

, 'bimg' => supportlocal.jpg, 'bimgalt' => Support Local Small Businesses, 'pid ' =>106, ]

Yet I am getting said error message.  What am I doing wrong?

I'm going to create a web page with <iframe> tag & want that the src of <iframe> change as 

I've made a few attempts at this, but I'm likely not making much sense.... I'm working on how to phrase the question.

I had a MySQL database where I used to combine user first AND last names in a single string... I called that string "Member"

So if I filtered:
www.mysite.com/members.php?Member=Peter

It would find and display all Peters: Peter Rabbit and Peter Griffith and Pope Peter.  This is what I want.

I'm now keeping each name (first and last) in separate strings (as separate variables?), and I am combining them in an array to display on the website:

Code: [Select]
$First = $First;
$Last = $Last;

$member = array($Last, $First,);
foreach ($Member as $key => $v ) if (!$v) unset ($Member[$key]);
$Member = implode(', ', $Member);
echo $Member;

Now I've lost the ability to search all the members for Peter.

So if I filtered:
www.mysite.com/members.php?First=Peter
...it would work.... for Peter Rabbit and Peter Griffith, but not Pope Peter

I cannot query the entire array?  I can no longer check members (first and last names) for Wayne?
www.mysite.com/members.php?Member=Peter

I'm betting I can, but there's a lot more to it... and 8 hours of Googling haven't helped much.

Thanks for listening.

~Wayne

Hello,   I recently posted here about an issue I was having with my database orientated products page.   I have now run into another problem where say if, /db.php was typed or /db.php?p=IDoNotExist was typed, it returns blank.   I have in my code the desired content to be displayed, but it just doesn't seem to want to make a show.   I was also wondering if it is possible to show different content for whatever the URL is, so for no parameter, the content about the products, and a non existent one, maybe "Product not found"?   Here is my code:

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

	include("header.php");

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

	if ($status == "floorpuzzles") {

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



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

				
				}}

include("footer.php");
?>

The final echo is what I wish to be displayed on the URL without or with an invalid parameter.   Here is my site URL: http://www.webwib.co...saws/search.php (note that only the "Floor Puzzles" category has content within it).   Thank you in advance for assistance.

I have the following code just to insert a username and hashed password into the database but somehow I am getting this error and I couldn't find out where I am doing it wrong...can someone please give me a hand?   I tried it in two ways and both errors... the first few lines are just connecting database which worked fine and a password.php so I can use password_hash() with my php version

$hash = password_hash('xx', PASSWORD_BCRYPT, array('cost' => 10));
$username = 'xx';


$insertQuery = $db->prepare("
		INSERT INTO et_todo (username, password)
		VALUES (:username, :hash)
	");

$insertQuery->execute(array(
		'username' => $username,
		'password' => $hash
	));

also tried

$hash = password_hash('xx', PASSWORD_BCRYPT, array('cost' => 10));

$insertQuery = $db->prepare("
		INSERT INTO et_todo (username, password)
		VALUES ('xx', :hash)
	");

$insertQuery->execute(array(
		'username' => 'xx',
		'password' => $hash
	));

Hi, Everyone! This my first time posting here. Anyways, I've been having problem getting the correct data from my database. I want to select the total_on/off_hours,exposure,plate_number, and terminal_status. But when I select the terminal_status, there are duplicates, I already used the DISTINCT function. It's a little hard to explain so, I'll just show you.   Here's a screen cap of my code trying to get just the terminal_status       What's the problem? What should I do? Any suggestions/help will be much appreciated.

i am unable to select total_comment from mysql table related to each post..   For detail information check http://stackoverflow...-query-in-mysql