PHP - Can't Get A Specific Query String Parameter From Url

This is my code
$file = "E:/wamp/www/Project/Changes/".$LineNo.".txt";
if(file_exists($file))
{
fopen($file,'a') or die("can't open file");
fwrite($file,$Username);
}
else
{
fopen($file,'w');
fwrite($file,$Username);
}

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!

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.

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

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?

This is probably a simple one. I just couldn't find a tutorial to the specific thing I'm trying.

I have a string that looks like: "(abbreviated name with.) second abbrev. name."

I'm trying to find a way to break this apart so I can have:

$var1 = "abbreviated name with."
$var2 = "second abbrev. name."

I've looked at substr and a couple others and I'm not sure quite how to do this, because the ')' could be in a differing location.

I have a form with some dropdownlist that get populated dynamically(depends on what the user chooses) with jquery and an xml file. In the form I have a button that takes the info and populates another form with the values of the ddl. I have coded script which populates the second form with jquery and the name of each input get dynamically added like so:

Code: [Select]
<input type="text" value="'+model+'" name="Model_'+model+'" id="'+model+'" readonly size="'+model.length+'" />
<input type="text" value="'+model+'" name="Model'+model+'" id="'+model+'" readonly size="'+model.length+'" />>
<input type="text" value="'+color+'" name="Color'+color+'" id="'+color+'" readonly size="'+color.length+'" />
<input type="text" value="'+part+'" name="Part'+part+'" id="'+part+'" readonly size="'+part.length+'" />
<input type="text" value="$'+price+'" name="Price'+price+'" id="'+price+'" readonly size="'+price.length+'" />
<input type="text" value="'+qty+'" name="Quantity'+qty+'" id="'+qty+'" readonly size="'+qty.length+'" />
<input type="text" value="'+total+'" name="Total'+total+'" id="'+total+'" readonly size="'+total.length+'" />

What I want to do is grab the name of the element and remove the underscore and everything else form rileft to right so I am left with just the word before the underscore. I tried using substr($key,0,-28) but that wont work since everything after the underscore will have a different length. I was wondering if there is a way i can keep everything before the underscore and remove the underscore and everything after that.
Thanks in advance for any input I get.

I know it is an "if" statement, but I am struggling with a simple issue.

I want to format specific words, like a keyword. (ex: <b>Open</p>, if that word is contained in my ".$data['status']." field of the database ".$db_prefix."fieldstatus.

Code: [Select]
$sql = dbquery(
"SELECT * FROM ".$db_prefix."fieldstatus
ORDER BY fieldstatus_id ASC"
);

if (iADMIN) echo "<center><a href='".MODS."fieldstatus_panel/fieldstatus_admin.php'>".$locale['imp135']."</a><br><br></center>";

if (dbrows($sql)) {
$i = 0;
echo "<table width='100%' cellpadding='0' cellspacing='1'>\n";

while ($data = dbarray($sql)) {

echo "<tr><td valign='top'><font size='1' color='#db3026'><b>".$data['fields']."</b> is </font><font size='1'>".$data['status']."</font></td></tr><tr>
</tr>\n";
}
echo "</table>\n";
} else {
echo "<center><br>\n".$locale['imp141']."<br><br>\n</center>\n";
}

Any suggestions would be greatly appreciated.

I embed videos on my site. I submit the embed codes to my database using a form. The codes look like this:

<iframe width="560" height="315" src="//www.youtube.com/embed/xDIgbjDGsOM?rel=0" frameborder="0" allowfullscreen></iframe>

Before I submit each code, I have to change its width and height, and I have to add this:

&showinfo=0

after this:

?rel=0

Is there a function that will allow me to do all of that simultaneously?   I know about str_ireplace(). It will let me replace ?rel=0 with ?rel=0&showinfo=0, but I don't know how to simultaneously make the other changes.   It's not helping that the embed code includes quotation marks.

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

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

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.