PHP - Range() - Mixing Letters With Numbers?

This topic has been moved to PHP Regex.

http://www.phpfreaks.com/forums/index.php?topic=333172.0

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=318062.0

So I already have this below...

$state = array (
    1 => 'Sectional',
    2 => 'Regional',
    3 => 'Semi-state',
    4 => 'State'
);

Can those numbers be a range -- 1-16, 17-32, 33-48 and 49-64 -- without just listing them all?

 

 

Just looking to know if this is the proper way to implement this:

I need the below if to be true when any number between 100 and 1000 is the value of x, including say "105.55"

if($x>= 100 && $x <= 1000){
}


Basically I'm asking will a value of x with a decimal in it not cause the if statement to be true.

I have two seperate piece of code.  One which sorts description and one which sorts price.  However, I am looking to almalgamate them into one.  I have tried the following however I appear to be way off. 

I want to select a product description with one link and then select a price range.  However, I want the price range to read the description. 

<?phpif( isset($_GET['description' ; 'price' ]))
$description = $_GET['description' ; 'price'];
$query = "SELECT * FROM productfeed WHERE description like '%$description%' LIMIT 0, 10";
$query = "SELECT * FROM productfeed WHERE price like '%$price%' LIMIT 0, 10";
$fetchdata = mysql_query($query) or die("query: $query<br>
This has an error: " . mysql_error() . '<br>');while($row = mysql_fetch_array($fetchdata)) {
$id = $row['id'];
$image = $row['awImage'];
$link = $row['link'];
$description = $row['description'];
$fulldescription = $row['fulldescription'];
$price = $row['price'];


<?phpif( isset($_GET['description']))
$description = $_GET['description'];
$query = "SELECT * FROM productfeed WHERE description like '%$description%' LIMIT 0, 10";
$fetchdata = mysql_query($query) or die("query: $query<br>
This has an error: " . mysql_error() . '<br>');while($row = mysql_fetch_array($fetchdata)) {
$id = $row['id'];
$image = $row['awImage'];
$link = $row['link'];
$description = $row['description'];
$fulldescription = $row['fulldescription'];
$price = $row['price'];


<?phpif( isset($_GET['price']))
$price = $_GET['price'];
$query = "SELECT * FROM productfeed WHERE price like '%$price%' LIMIT 0, 10";
$fetchdata = mysql_query($query) or die("query: $query<br>
This has an error: " . mysql_error() . '<br>');while($row = mysql_fetch_array($fetchdata)) {
$id = $row['id'];
$image = $row['awImage'];
$link = $row['link'];
$description = $row['description'];
$fulldescription = $row['fulldescription'];
$price = $row['price'];

Hi guys.

This is my first post here - so HELLO.

I am a very experienced software developer, but new to web work. I am building a software tool using PHP (primarily). As such, many of my questions will concern optimum solutions (in so far as they may be determined), best practices, and the unwritten standards that will surely have evolved through the PHP community over time.

My first question concerns the mixing of HTML and PHP. My efforts so far contain a mix, but it doesn't "feel" right. I am using straight XHTML, PHP echo, and also heredoc. I can post the code if folk think it may help. But what is the general view as to whether "mixing" like this is a good and accepted practice, or is another approach preferred?

Many thanks in advance for any replies.

S

Hi,   Assume that I have 50 RGB color values and I want to mix all of them and reach to a final single value which is mixture of all. how can I do that in PHP.   Thanks.

Hi,
I need to sort variables in groups of up to 15 and put it in an array. For example:
$exstract['center_tabOpBody_0'] =5
$exstract['center_tabOpBody_1'] =6
$exstract['center_tabOpBody_2'] =8
$exstract['center_tabOpBody_3'] =1


Should yield:
ARRAY(
          = center_tabOpBody_1,center_tabOpBody_2,center_tabOpBody_3 // <-----15 [1] = center_tabOpBody_0 //<----5
)

Is there some simple function do do the "efficiency" sort?

Thanks,
Vadim

Hi im trying to mix php and html in a form however when i do this the whole page disapears and i dont know why
the working form is:
http://valiantflight.comlu.com/emailer/contact.php
<html>
<head>
<title>Contact Us</title>
</head>
<body>
<fieldset>
<legend>Contact Us</legend>
<form action="contact.php" method="post">

<input type="hidden" name="frmsubmit">
Your Email:*<br>



<input type="text" name="email"><br>
Subject:*<br>
<select name="subject">
<option value=""></option>
<option value="1">Recruitment</option>
<option value="2">Absense</option>
<option value="3">Enquiry</option>
</select>



<br>
Message:*<br>
<textarea name="message" cols="50" rows="5"></textarea>



<br>
        <?php           require_once('recaptchalib.php');
           $publickey = "6LeB8LwSAAAAAKwvC3HWJNwWw9vYiSEkvFEvDduD"; // you got this from the signup page
           echo recaptcha_get_html($publickey);
         ?> 




<br>
<input name"Submit" type="submit" value="Send Email">

</form>
Required fields are marked with a *<br><br>
<?php
if(isset($_POST['frmsubmit'])){
$email = $_POST['email'];
$subject = $_POST['subject'];
$message = $_POST['message'];

//checcking that all relevent information is entered and correct
require_once('recaptchalib.php');
$privatekey = "6LeB8LwSAAAAAA_0IIEnAxL5uOau0TBm83Iog7Ey";
$resp = recaptcha_check_answer ($privatekey, $_SERVER["REMOTE_ADDR"], $_POST["recaptcha_challenge_field"], $_POST["recaptcha_response_field"]);
    

if(!$message || !$email || !$subject)
{
$errmessage ="<font color='red'>The marked areas in the form have not been filled in correctly.</font>";
}
if (!$resp->is_valid) 
{
$errmessage ="<font color='red'>The text entered does not match the picture provided.</font>";

}

//Sending the email if nothing is wrong
if(!$errmessage)
{
header("location:send.php?subject=".$subject."&email=".$email."&message=".$message."");
}else{

echo $errmessage;
}
}
?>
</fieldset>
<br><br><br>
</body>
</html>
and the one that doesnt work is:
http://valiantflight.comlu.com/emailer/test/contact.php
<html>
<head>
<title>Contact Us</title>
</head>
<body>
<fieldset>
<legend>Contact Us</legend>
<form action="contact.php" method="post">
<?php
if(isset($_POST['frmsubmit'])){
$email = $_POST['email'];
$subject = $_POST['subject'];
$message = $_POST['message'];

//checcking that all relevent information is entered and correct
?>

<input type="hidden" name="frmsubmit">
Your Email:*<br>
<input type="text" name="email">
<?php
if(!$email)
{
$errmessage ="<font color='red'>The marked areas in the form have not been filled in correctly.</font>";
echo("<font color='red'><br>Please enter your email.</font>");
}
?>
<br>
Subject:*<br>
<select name="subject">
<option value=""></option>
<option value="1">Recruitment</option>
<option value="2">Absense</option>
<option value="3">Enquiry</option>
</select>
<?php
if(!$subject)
{
$errmessage ="<font color='red'>The marked areas in the form have not been filled in correctly.</font>";
echo("<font color='red'><br>Please select a subject.</font>");
}
?>

<br>
Message:*<br>
<textarea name="message" cols="50" rows="5"></textarea>
<?php

if(!$message)
{
$errmessage ="<font color='red'>The marked areas in the form have not been filled in correctly.</font>";
echo("<font color='red'><br>Please enter a message to send.</font>");
}

?>


<br>
        <?php 
require_once('recaptchalib.php');
$publickey = "6LeB8LwSAAAAAKwvC3HWJNwWw9vYiSEkvFEvDduD"; // you got this from the signup page
echo recaptcha_get_html($publickey);
require_once('recaptchalib.php');
$privatekey = "6LeB8LwSAAAAAA_0IIEnAxL5uOau0TBm83Iog7Ey";
$resp = recaptcha_check_answer ($privatekey, $_SERVER["REMOTE_ADDR"], $_POST["recaptcha_challenge_field"], $_POST["recaptcha_response_field"]);
          if (!$resp->is_valid) 
{
$errmessage ="<font color='red'>Some parts of the form have not been entered correctly and have been marked above</font>";
echo("<font color='red'>The text you entered does not match the picture provided.</font>");

}
?>


<br>
<input name"Submit" type="submit" value="Send Email">

</form>
Required fields are marked with a *<br><br>
<?php
    

//Sending the email if nothing is wrong
if(!$errmessage)
{
header("location:send.php?subject=".$subject."&email=".$email."&message=".$message."");
}else{

echo $errmessage;
}
}
?>
</fieldset>
<br><br><br>
</body>
</html>

If anyone can help it would be really great

Thanks,


Blink359

Hi All,

I have the following code which works fine:

$mysqli = new mysqli("server", "user", "pass", "database");
if($mysqli->connect_error) {
exit('Could not connect');
}



$sql = "SELECT customer_contactname, customer_companyname, customer_phonenumber, customer_emailaddress, customer_address1, customer_address2, customer_city, customer_postcode
FROM ssm_customer WHERE customer_id = ?";

$stmt = $mysqli->prepare($sql);
$stmt->bind_param("s", $_GET['q']);
$stmt->execute();
$stmt->store_result();
$stmt->bind_result($ccontname, $ccompname, $cphoneno, $cemail, $cad1, $cad2, $ccity, $cpost);
$stmt->fetch();
$stmt->close();

however, when i use my dbconn.php as an include rather than the top section of this code, i get the following error: function prepare() on null

The error references the following

$stmt = $mysqli->prepare($sql);

In my database connection file, i am using the following:

$conn = mysqli_connect($db_servername, $db_username, $db_password, $db_name);

This seems to be the issue and i believe i am mixing procedural and object based but not sure why there should be a difference here?

when i used my database connection file, i do change $mysqli->prepare to $conn->prepare

Kind Regards

Edited February 4, 2019 by Adamhumbug

I'm trying to input the results from a query into html, but I'm just getting the variable names rather than their values.  I used single quotes for the echo statement, but I think I must need to switch to double to do that.  But then I have problems with the double quotes from the class names (ex. class="SideBoxTitle"). 

Code: [Select]
<?php
// get user's videos from database
$conn = mysqli_connect($dbhost, $dbuser, $dbpass) 
or die("MySQL Error: " . mysql_error());

$query = "SELECT * FROM haas12_test.videos";

$result = mysqli_query($conn, $query)
or die ("Couldn't execute query.");

while($row = mysqli_fetch_assoc($result))
{
extract($row);

echo ' 
<div id="topBox"  class="mainVideoSideBoxes" >
    
      <div class="SideBoxTitle" ><h3> $vidtitle </h3> </div><!-- close SideBoxTitle -->
        <div class="sideBoxVidContainer"> 
            <div class="SideBoxScreenCast" > $vidurl </div><!-- close SideBoxScreenCast -->
            <div class="SideBoxDesc" ><p> $viddesc </p> </div><!-- close SideBoxDesc -->
        </div><!-- close sideBoxVidContainer -->
    
</div><!-- close mainVideoSideBoxes -->

</div><!-- close mainVideoSideBoxes -->
'; // end echo staement
}

?>

Hello

my mysql db got row pageurl

pageurl
http://www.google.gr
http://www.yahoo.com
http://www.phpfreaks.com

i whant to echo  11,12,13 letter only  ***********goo******
but i whant to show and count the *******

how can i do this? any idea?

How in php using the preg_replace php function can i allow only the basic english a-z letters, numbers 0-9 and unicode code letters and remove anything else?

Hello,

I have a script coded in PHP and alot of JavaScript and I have problems with

languages like Arabic and Hebrew ( non Latin characters) ..

It is showed as question marks in the website like this ( ?????????) and in the database ..

I converted the SQL Database from Latin Swedish to UTF-8 in phpmyadmin and now the database is correct but the website is still in question marks .

In every HTML code you can see this :

........... content="text/html; charset=utf-8"/>

and I tried changing the same php pages to UTF-8 using text editors but nothing happened .

any help will be great. thanks.