Learn VBA & Macros in 1 Week!

PHP - Wondering If This Is Even Possible

Full Excel VBA Course - Beginner to Expert

Wondering If This Is Even Possible	View Content

Hey guys wondering if this is possible or not
im wanting to add the b_x with the b_y so i select it out of the data base as 1 number.
The math im really going to do is more complex but just using add to simplifly what i want to do.
i would obviously need to assign it in some way so I can grab it to like $variable = $star_check1[];

This will acctually become a loop grabing several rows so if i could change it into one number would be alot easier.

$star_check3 = "SELECT b_x,b_y FROM planets WHERE x = '".($x)."' AND y = '".($y)."'";
$star_check2 = mysql_query($star_check3) or trigger_error("SQL", E_USER_ERROR);
$star_check1 = mysql_fetch_array($star_check2);

Full Excel VBA Course - Beginner to Expert

Just Wondering

Similar Tutorials

View Content

Just wondering if I have an if statement like:

if ( true || true || true )
{
   // do this
}

Is PHP clever enough to do this:

if ( true || skip_me|| skip_me)
{
   // do this
}

if ( false || true || skip_me )
{
   // do this
}

Like precedence for the leftmost conditions?

Thanks for any help.

Just Wondering Something About Extract()

Similar Tutorials

View Content

What is the difference between EXTR_PREFIX_SAME and EXTR_PREFIX_IF_EXISTS?

Wondering If This Page Will Work?

Similar Tutorials

View Content

Hi, I have a form that I am trying to get working. The page is named "reserv_test.php". Not sure if I am trying to do to much, but can anyone tell me if this will work? If so, what do I need to do to make it work?

Here is the code...
Code: [Select]
<html>
<head>
<title>Booking Form</title>

<script type="text/javascript">
function showMonth(str)
{
if (str=="")
{
document.getElementById("txtHint").innerHTML="";
return;
}
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","reserv_test.php?q="+str,true);
xmlhttp.send();
}
</script>

</head>
<body>
<div>
<p align="left"><font face="arial" size="4"><u>Booking Form</u></font></p>
<form method="post" action="resersend.php">
<p><font face="arial" size="2" color="#336600">Reservation month:</font>
<select name="months" onChange="showMonth(this.value)">
<option value="" selected="selected">Choose One</option>
<option value="May 2011">May 2011</option>
<option value="June 2011">June 2011</option>
<option value="July 2011">July 2011</option>
<option value="August 2011">August 2011</option>
<option value="September 2011">September 2011</option>
<option value="October 2011">October 2011</option>
<option value="November 2011">November 2011</option>
<option value="December 2011">December 2011</option>
<option value="January 2012">January 2012</option>
<option value="February 2012">February 2012</option>
<option value="March 2012">March 2012</option>
<option value="April 2012">April 2012</option>
</select>
</form></p><br />

<?php

$q=$_GET["q"];

$con = mysql_connect('my_host', 'my_user', 'my_pwd');
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("my_db", $con);

$sql="SELECT *
      FROM daterange
  WHERE DEND > DATE(NOW())
  AND STATUS='A' AND MONTH = '".$q."'
      ORDER BY RID, DATE, SITE";

$result = mysql_query($sql);

// Determine the number of reservation dates
$number = mysql_numrows($result);

// Create drop-down menu of reservation dates
print "<font size=\"3\" face=\"Arial\"><b>Select Your Reservation:</b><br>
<form action=\"resersend.php\" method=\"post\">
<select name=\"RID\">
    <option value=\"\">Choose One</option>";

for ($i=0; $i<$number; $i++) {
     $RID = mysql_result($result,$i,"RID");
     $DATE = mysql_result($result,$i,"DATE");
     $SITE = mysql_result($result,$i, "SITE");
$PRICE = mysql_result($result,$i, "PRICE");
     print "<option value=\"$RID\">$DATE, $SITE, $PRICE</option>";
}

print "</select><p align=left><label><font size=\"3\" face=\"Arial\">First Name: <input type=\"text\" name=\"FNAME\" size=\"50\" maxlength=\"50\" tabindex=\"1\"<br>";

print "<p align=left><label>Last Name: <input type=\"text\" name=\"LNAME\" size=\"50\" maxlength=\"50\" tabindex=\"2\"<br>";

print "<p align=left><label>Address Line 1: <input type=\"text\" name=\"ADDR1\" size=\"50\" maxlength=\"50\" tabindex=\"3\"<br>";

print "<p align=left><label>Address Line 2: <input type=\"text\" name=\"ADDR2\" size=\"50\" maxlength=\"50\" tabindex=\"4\"<br>";

print "<p align=left><label>City: <input type=\"text\" name=\"CITY\" size=\"50\" maxlength=\"50\" tabindex=\"5\"<br>";

print "<p align=left><label>State (abbrev.): <input type=\"text\" name=\"STATE\" size=\"2\" maxlength=\"2\" tabindex=\"6\"<br>";

print "<p align=left><label>Zip Code: <input type=\"text\" name=\"ZIP\" size=\"5\" maxlength=\"5\" tabindex=\"7\"<br>";

print "<p align=left><label>Contact Phone Number: (<input type=\"text\" name=\"PHONE1\" size=\"3\" maxlength=\"3\" tabindex=\"8\"";
print "<label>)<input type=\"text\" name=\"PHONE2\" size=\"3\" maxlength=\"3\" tabindex=\"9\"";
print "<label>-<input type=\"text\" name=\"PHONE3\" size=\"4\" maxlength=\"4\" tabindex=\"10\"<br>";

print "<p align=left><label>Email: <input type=\"text\" name=\"EMAIL\" size=\"50\" maxlength=\"50\" tabindex=\"11\"<br>";

Any help would be appreciated. Thanks.

Newbie Wondering About Ver. Differences; 4.4.9 V. 5.x

Similar Tutorials

View Content

I don't know if this is the correct type of question to ask here - I built a sandbox about 3 months ago with the latest XAMPP. I know that it came with PHP 5.x [5.2 I think]. I am not at home right now to check it. I just found out that the host server is running 4.4.9. I have no control over the host, or host selection. I am going to attempt to get a database online using basic [I hope] PHP scripts to query the otherwise static database. Are there major differences in the versions that I need to watch out for? I realize that I will now have to get 4.4.9 installed on my sandbox. I plan on using Dreamweaver CS5 to get my pages built. The main site is built and managed by another person using Expression Web 2. I am also unaware if the master.dwt built in Expression can be somehow brought into my PHP for site consistency. I am open to all comments and suggestions.

Wondering About New Line Behaviour.

Similar Tutorials

View Content

I have 2 pieces of different code that get run at different times, but act on the same text file.
(The first example writes data and the second rewrites data with some expired data removed from the rewrite.)

The first code example appends data to a new line each time it is run except when it is run just after the second code example has ran. When run after the second example, the first code example will append the data to the last line of the text file instead of appending to a new line.
Why is this?

Here is the first code example...
Code: [Select]
<?php

$message = "Hello, World! \nGoodbye!";
$message_br = str_replace("\n", '<br />', $message); // couldn't use nl2br because i needed to remove the \n completely.
$userName = "Anon";
$coordinates = "1234567890";
$locationType = "geo";
$dateDay = "23";
$dateMonth = "2";
$dateYear = "2011";
$timeHour = "9";
$timeMins = 45;
$timeAMPM = "AM";

// Format the time/Date
date_default_timezone_set('UTC');
$inputTime = date('c', mktime((int)$timeHour, (int)$timeMins, 0, (int)$dateMonth, (int)$dateDay, (int)$dateYear));

// Send all data so far, to an array.
$entry_array = array();
array_push($entry_array, $inputTime, $locationType, $coordinates, $userName, $message_br);

// write the array to CSV file.
$fp = fopen('messages.txt', 'a');
fputcsv($fp, $entry_array, "|");
fclose($fp);

?>

Here is the second...
Code: [Select]
<?php

$one_day = 60*60*24;
$timestamp = time();
date_default_timezone_set('UTC');
$expiry_date = date('c', $timestamp+$one_day);

$future_date = array();
$delete_line = array();

// Open existing data in the text file.
$lines = file('messages.txt', FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES);
foreach ($lines as $line){
  list($field1, $field2, $field3, $field4, $field5) = explode('|', $line);
  if ($field1 < $expiry_date){
    array_push($delete_line, $line); // add to the to-be-deleted array.
  }
  else { array_push($future_date, $line); }
}

$array2string = implode("\n", $future_date); // convert array data to string.

// write the data to CSV file.
$fp = fopen('messages.txt', 'w');
fwrite($fp, $array2string);
fclose($fp);

?>

Wondering Why This Specific Section Of Code Not Working? Please Help?

Similar Tutorials

View Content

Commented in red is the code that doesn't produce anything. It is 3/4 of the way down the page..
Thanks for looking!

Code: [Select]
<?php
error_reporting(E_ALL);
ini_set("display_errors", 1);

$host= "";
$db_name= "";
$db_user= "";
$db_password= "";

ob_start();

if(isset($_POST['newBidder'])) {
$newBidder= isset($_POST['newBidder']) ? $_POST['newBidder'] : '';
$bidderId= $newBidder;

mysql_connect("$host", "$db_user", "$db_password")or die("cannot connect to server");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM bidders WHERE biddersId='$bidderId'";
$result=mysql_query($sql);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row

if($count==0){
// Add $biddersId and redirect to anypage
mysql_Query("INSERT INTO bidders (biddersId)
VALUES ('$bidderId')");
header("Location: index.php");
exit();
  }
}

////////////////////////////////////

if(isset($_POST['deleteBidder']))
{
$deleteBidder= isset($_POST['deleteBidder']) ? $_POST['deleteBidder'] : '';
mysql_connect("$host", "$db_user", "$db_password")or die("cannot connect to server");
mysql_select_db("$db_name")or die("cannot select DB");

mysql_query("DELETE FROM bidders WHERE biddersId='$deleteBidder'");
header("Location: index.php");
exit();
}

////////////////////////////////////

if (isset($_POST['itemDescription'], $_POST['itemPrice'], $_POST['winningBidder'], $_POST['itemQty']))
{
$itemDescription= isset($_POST['itemDescription']) ? $_POST['itemDescription'] : '';
$itemPrice= isset($_POST['itemPrice']) ? $_POST['itemPrice'] : '';
$winningBidder= isset($_POST['winningBidder']) ? $_POST['winningBidder'] : '';
$itemQty= isset($_POST['itemQty']) ? $_POST['itemQty'] : '';

mysql_connect("$host", "$db_user", "$db_password")or die("cannot connect to server");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM bidders WHERE biddersId='$winningBidder'";
$result=mysql_query($sql);

$count=mysql_num_rows($result);
// If result matched, table row must be 1 row

if($count==0){
echo "That Bidder Number is NOT logged in, ";
echo "would you like to set this bidder as active?";
echo " Enter 1 for NO or 2 for YES";
echo "<form action= \"process.php\" method= \"POST\">";
echo "<input type =\"text\" name= \"logUser\"/>";
echo "<input type= \"submit\" value = \"Submit\"/>";
exit();
  }
}
$logUser= isset($_POST['logUser']) ? $_POST['logUser'] : '';
if ($logUser= '1') {
header("Location: inprogress.php");
exit();
}

if ($logUser= '2'){

// Add $biddersId and redirect to anypage
mysql_connect("$host", "$db_user", "$db_password")or die("cannot connect to server");
mysql_select_db("$db_name")or die("cannot select DB");

mysql_Query("INSERT INTO bidders (biddersId)  ////This won't add biddersid to database///////[
VALUES ('$winningBidder')");

mysql_query("INSERT INTO transactions       /////This won't add details to the database either?/////
VALUES('$itemDescription', '$itemPrice','$winningBidder', '$itemQty', '$totalPrice')")
or die(mysql_error());
header("Location: inprogress.php");
exit();
   }

////////////////////////////////////////

echo "<font color= \"red\" face=\"calibri\" size=\"4\">That bidder is already logged, Please press your browsers back button and try again.</font>";

ob_end_flush();

?>

I have one database with 2 tables as follows
bidders table ONLY has biddersId field;
transactions has (in order) itemDescription, itemPrice, bidderId, itemQty, totalPrice

everything else works, except updating the database with the above?

Am I doing something wrong in MySql. I have all eroors on , but i get NONE when running the script?

Filter_var Custom Regex Not Working Wondering Why?

Similar Tutorials

View Content

I'm having a lot of trouble validating things using custom regex. I'm trying to validate usernames without spaces using numbers and/or letters with optional underscores.

This is my code but it isn't validating anything, nothing is ever validated.

Whatever I write it says the username isn't valid.

if(isset($_POST['submit'])){
if(filter_var($_POST['value1'], FILTER_VALIDATE_REGEXP, array("options"=>array("regexp"=>"/^[\w.-]{{3},{28}}$/")))){
echo "Value is a valid username.";
} else {
echo "Value is NOT a valid username.";
}
}
?>

Any help regarding this issue will be greatly appreciated.
Thanks!