Learn VBA & Macros in 1 Week!

PHP - Baffled On This One...

Full Excel VBA Course - Beginner to Expert

Baffled On This One...	View Content

Hey everyone, I'm getting an error on this code and I'm having a difficult time sorting it out. Most of this page is in html, but here is what little PHP I'm using as of now:

Code: [Select]

<select class="ddbox2" name="occasion">
<option value="select" selected>- Select -</option>

<?php

$resdate = "02/20/2012";

$result = mysql_query("SELECT `time` FROM delivery_times WHERE `index` > '0'");

while ($row = mysql_fetch_row($result)) {

$posstime = $row[0];

$reserved = mysql_query("SELECT * FROM reservations WHERE `resdate` = '$resdate' AND `deltime` == '$posstime'");
$rowcheck = mysql_num_rows($reserved); // <-- THIS IS LINE 198

if ($rowcheck == 0) {

echo "<option value='$posstime'>$posstime</option>";

}

}

?>

</select>

What I'm doing is creating a dropdown menu for an html form depending on what is in my database, but here is the error that I'm getting:

"Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\wamp\www\new_site\custform.php on line 198"

When I change line 198 to read: $rowcheck = mysql_num_rows($result); I don't get the error, but I don't get the information that I need to complete my task. I was thinking that maybe this query isn't allowed in a while loop for some reason, but I don't think that would be the case. Any ideas on what I could be doing wrong?

Full Excel VBA Course - Beginner to Expert

Baffled For This... Why It Is Working?

Similar Tutorials

View Content

Hello, NOTE: I'm not asking for help to modify the code below, only looking for feedback regarding why it is working I'm working over other's people code and I found this lines:

                       <div class="button-container" style="top:20px; left:0px">
                            <input type="submit" name="submit" value="Get Report"
                              <a href="#" class="large-button" style="left: 0px" >
                                 <div class="button-glare">&nbsp;</div>
                              </a>
                        </div>

Clearly the input tag is wrong (W3C validator confirm it), however works fine and does what is supposed to do (apply some css styles over the submit button). IE11 Developer tools detect the errors, but FF nor Chrome does. this is what it looks like (attached image) and this is the related CSS

/* CSS Document */
  /* Button Containers  */

.button-container {
    float: left;
    overflow: visible;
    position: relative;
}

.button-container .large-button {
    background: linear-gradient( to top, green, lightgray);
    border-radius: 6px;
    font-size: 14px;
    font-weight: bold;
    color: #FFFFFF;
    line-height: 14px;
    padding: 10px 20px 8px;
    text-shadow: -1px -1px 1.5px rgba(0, 0, 0, 0.5);
    position: relative;
}
.button-container .button-glare {
    border-radius: 4px;
    height: 50%;
    left: 1px;
    position: absolute;
    right: 1px;
    top: 1px;
    z-index: -1;
}

any idea why it does work? thanks Miko

Probably Simple But Kinda Baffled

Similar Tutorials

View Content

The alias form isn't being read for some reason, with having $alias = $_POST['alias']; i don't quiet understand why this isn't it isn't being picked up as a variable below, any clues? cheers
Code: [Select]
<?php include("header.php");
if(isset($_POST['formAlias']) &&
$_POST['formAlias'] == 'Yes')
{
$alias = $_POST['alias'];
$alias = preg_replace("/[^a-zA-Z0-9_]/", "", $alias);
$namelength = strlen($alias);
if($namelength < 3){
$error1="Your alias must be at least 3 characters!</span></div>";
echo $error1;
}else{
}
$query = sprintf("SELECT COUNT(id) FROM players WHERE UPPER(alias) = UPPER('$alias')",
mysql_real_escape_string($alias));
$result = mysql_query($query);
list($count) = mysql_fetch_row($result);
if($count >= 1) {
$error1="$alias is already taken.";
echo $error1;
}else{
}
$sql = "updatehereble";
mysql_query($sql) or die(mysql_error());
}else{
}
?>
</p>
<p>
<input name="alias" type="text" id="alias">
</p>
<form action="alias.php" method="post">
Do you wish to use an alias?
<input type="checkbox" name="formAlias" value="Yes" />
<input type="submit" name="formSubmit" value="Submit" />
</form>

Utterly Baffled- Update A Table

Similar Tutorials

View Content

Hi

I'm trying to update a form to a mysql database- it's simply all text fields except for one integer which is the primar key (auto increment etc)
http://www.arts.ulster.ac.uk/interviews/test.php
http://www.arts.ulster.ac.uk/interviews/thanks3.php

test.php holds the form and the recaptcha which all seems to be fine and it posts to thanks3.php which (when i switched to $_GET) is passing the variables to that page but those values are not being stored.

I then input my query into the mySQL query browser:
INSERT INTO UCASinterviews VALUES ('','$name','$address','$UCAS','$tel','$email','$mob','$subject','$interviewdate','$interviewtime','$parents');

which updated the values i put in but gave this error:
Incorrect integer value: '' for column 'ID' at row 1

thanks3.php just won't transfer that info to the table no matter what I try. I used $_GET, I used PHP_SELF, I stripped the rest of the page away to make sure nothing was conflicting and now I'm totally stumped- please could someone look at this with fresh eyes?

test.php:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Untitled Document</title>
</head>

<body>

<form action="thanks3.php" method="post" id="form2" style="margin-left:15px; display:;">

<dl id="contform">



                            <dd><label>Name:</label><br />
<input class="padform" type="text" name="name" size="43" maxlength="20" tabindex="2"/></dd>
   <label>UCAS ID:</label><br />
<input class="padform" name="UCAS" type="text" id="UCAS" tabindex="3" size="43" maxlength="30"/></dd>
  <dd>
  <label>Email:</label><br />
<input class="padform" name="email" type="text" id="email" tabindex="3" size="43" maxlength="30"/></dd>
<dd>
  <label>Mobile:</label><br />
<input class="padform" name="mob" type="text" id="mob" tabindex="3" size="43" maxlength="30"/></dd>
<dd>
  <label>Landline:</label><br />
<input class="padform" name="tel" type="text" id="tel" tabindex="3" size="43" maxlength="30"/></dd>

<dd>
  <label>Subject:</label><br />
<select name="subject" tabindex="1" class="padform">
                             <option value="English">English</option>
                                <option value="European Studies">European Studies</option>
                                <option selected value="Film Studies">Film Studies</option>
                             <option value="French">French</option>
                             <option value="German">German</option>
                             <option value="History">History</option>
                             <option value="Irish">Irish</option>
                             <option value="Spanish">Spanish</option>
<option value="Journalism">Journalism</option>
                             <option value="Photo Imaging">Photo Imaging</option>
                             <option value="Media Studies and Production">Media Studies & Production</option>
                             <option value="Interactive Media Arts">Interactive Media Arts</option>


                            </select></dd>

<dd><label>Address:</label><br />
  <textarea class="padform"name="address" cols="40" rows="15" id="address" tabindex="5"/>
  </textarea></dd>

   <dd>
  <label>Preferred Interview Date:</label>
  <select name="interviewdate" class="padform">
                                <option value="26/02/11">26 February 2011</option>
                                <option selected value="12/03/11">12 March 2011</option>
  </select>
  </dd>
  <dd>
  <label>Preferred Interview Time:</label>
  <select name="interviewtime" class="padform">
                                <option value="AM">Morning (AM)</option>
                                <option selected value="PM">Afternoon (PM)</option>
  </select>
  </dd>
<dd>
  <label>Parents/Guardians:</label>
  <select name="parents" class="padform">
                                <option value="1">1</option>
                                <option selected value="2">2</option>
  </select>

</dd>
<dd>
  <p>
                 <?php
          require_once('recaptcha/recaptchalib.php');
          $publickey = "6LdU2b4SAAAAAGsh6Z78HjunUL6Mt-ZqCXtIimOs"; // you got this from the signup page
          echo recaptcha_get_html($publickey);
        ?>

                </p>

</dd>


<dd style="background:none;"><input class="btn" type="submit" name="submit" value="Send" tabindex="6" id="submit" /></dd>
  </dl>



</form>


   </div>

</body>
</html>

thanks3.php

<?php
  require_once('recaptcha/recaptchalib.php');
  $privatekey = "6LdU2b4SAAAAAN_Z9rLyvle0vb4n4EbyAVyXDa6V";
  $resp = recaptcha_check_answer ($privatekey,
                                $_SERVER["REMOTE_ADDR"],
                                $_POST["recaptcha_challenge_field"],
                                $_POST["recaptcha_response_field"]);

  if (!$resp->is_valid) {
    // What happens when the CAPTCHA was entered incorrectly
    die ("The reCAPTCHA wasn't entered correctly. Go back and try it again." .
         "(reCAPTCHA said: " . $resp->error . ")");
  } else {
    // Your code here to handle a successful verification

  require_once("../includes/db_connect.php");

if($_POST['submit']=="true"){
$name=$_POST['name'];
$address=$_POST['address'];
$UCAS=$_POST['UCAS'];
$mobile=$_POST['mob'];
$email=$_POST['email'];
$tel=$_POST['tel'];
$subject=$_POST['subject'];
$interviewdate=$_POST['interviewdate'];
$interviewtime=$_POST['interviewtime'];
$parents=$_POST['parents'];

$addEntry="INSERT INTO UCASinterviews VALUES ('','$name','$address','$UCAS','$tel','$email','$mob','$subject','$interviewdate','$interviewtime','$parents');";
$addResult=mysql_query($addEntry,$db);
}
  }
?>

I have other forms working with this near enough the same structure/layout/code - i'm ready to have a coronary! Is it the database setup? It's same as it ever was myISAM, UTF unicode...

Baffled About Line 2 Error Message In Simple Script

Similar Tutorials

View Content

PHP = 5.5.14 MySQL = 5.2.17 I've cloned a mysqli_connect() statement in a 'require' file placed in a non-public access location on the server. It's the same format (and location) currently working fine with another application, EXCEPT i changed the database name to what I need to use for this application, AND added the $con= part on the front end to substitute for the commented out $con= line in the example code I'm modifying to insert data into a new MySQL DB Table. The dB Table is fine and I have Inserted data via myPHPAdmin with no problems. Only two form variables are in the simple PHP script thus far just to test if it will work before proceeding. I've used pseudonames for the actual /home/.... location and filename, and am now Baffled about the Line 2 Error Message I'm getting (below the code).

<?php

require '/home/myusername/domains/mydomain.com/myclonedrequire.php';

//$con=mysqli_connect("example","uid","pwd","my_db");
// Check connection
if (mysqli_connect_errno()) {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

// escape variables for security
$year = mysqli_real_escape_string($con, $_POST['year']);
$callsign = mysqli_real_escape_string($con, $_POST['callsign']);


$sql="INSERT INTO `lqplogs` (`year`, `callsign`)
VALUES ('$year', '$callsign');

if (!mysqli_query($con,$sql)) {
  die('Error: ' . mysqli_error($con));
}
echo "1 record added";

mysqli_close($con);
?>

ERROR Message: Warning: Unexpected character in input: '\' (ASCII=92) state=1 in (above file & location) on line 2 There are NO '\' characters in any of my files. Here is the simple Form file code:

<?php
?>
<html:
<head><title></title></head>
<body>
<form action="insert.php" method="post">
YEAR: <input type="text" name="year">
CALLSIGN: <input type="text" name="callsign">
<input type="submit">
</form>
</body>
</html>
<?php
?>

Thanks for any assistance! -FreakingOUT