PHP - A Php Function - Retrieval Ban For Present And Future?

I can't get it to use the item that is selected in the drop down box as the variable $va in the bit where it then queries the data base to retrieve only the line in the able that match the program_name with variable $va. variable $va would be the result of the drop down box.

Below is the code i have so far, any help would be appreciated.

Cheers.

Code: [Select]
<?php
include ('dbConn.php');

mysql_select_db($dbselect, $con);

$QuerySelects = "SELECT program_name FROM program_names";
$Query = mysql_query($QuerySelects) or die (mysql_errno() . ": " . mysql_error(). "\n");

echo '<label>Select Sto </label>';
echo '<select id="program_name"  name="program_name">';
echo '<option value="va">Select Store</option>';
 
while ($row = mysql_fetch_assoc($Query))
{
$va = $row['program_name'];
echo "<option value=''>$va</option>";
}
echo '</select>';



$QuerySelects1 = "SELECT * FROM offers1 WHERE end_date>CURDATE() AND program_name = '$va'";
$Query1 = mysql_query($QuerySelects1) or die (mysql_errno() . ": " . mysql_error(). "\n");



while($result=mysql_fetch_assoc($Query1)) {
include ('variables.php');
echo"
<div class='spacerbox'>
<div class='outerbox eviecodes'>
<div><div class='topbox'>
<div class='leftbox'>
<div class='offerimage'>
<div class='progdiv'><a class='progname' href=".$url." target='_blank'>".$program_name."</a></div>
</div>
</div>
<div class='rightbox'><div class='descbox boxwidth'><h1>
<a href=".$url." target='_blank'>".$description." at ".$program_name."</a></h1></div>
<div class='voubox boxwidth'><h2 class='vvv'>Voucher Code:<span class='vcode'>".$code."</span ></h2></div>

</div>
</div>
<div class='linkbox boxwidthl'>
<a href=".$url." target='_blank'>To Take Advantage of this offer at <span class='prodname'>".$program_name."</span>, click here!</a>
</div>
<div class='expires'>
<span class='end'>Expires:</span> <span>".$dateformat."</span >
 </div>
<div class='socialbox'>
{module Tell A Friend Module}
</div></div>
<div class='spacer'>
</div>
</div>
</div>
";
}
?>

I'm going bananas with one of those issues where it looks like everything is right but the code won't work.  I've included a script below that fetches data from a database and creates a drop down menu.  I'm trying to use a field called "gone" and enter 'gone' in that field when I want to delete the row but be able to retrieve it by making the field empty.  There is something in the WHERE clause of my sql that is screwing things up.  I get nothing retrieved with any of the WHERE clauses below.  Interestingly, when I take the where clause out completely, I get the rows that have no 'gone' in them.

The code is below.  None of the following in the included code get me a result.  All of them return nothing.  I also don't get any errors. Just nothing.

WHERE gone != 'gone'

WHERE gone <> 'gone'

WHERE gone = ''

WHERE gone = 'gone'

Without the WHERE clause it runs fine.

As a work around I tried using

if($row['gone'] == 'gone')  { continue;}

In the while.. function at the end of the file to bypass rows with 'gone' in the field.  It also stopped the script.

Here's my code:

<?php // person_selectall.php

/** Create new pdo object */

require 'Db.php';

//$sql = "SELECT person_id, fname, lname FROM Persons";
$sql = "SELECT * FROM Persons WHERE gone = ''";

$stmt = $pdo->prepare($sql);
$stmt->execute();

echo "<p><select class=\"select-field\" name=\"person_id\" >\n";

while ($row = $stmt->fetch()) {  
    
    $name = $row['fname'] . ' ' . $row['lname'];
    echo "<option value=\"" . $row['person_id'] . "\">" . $name . "</option>\n";
    
    }
    
echo "</select>";

?>

 

Hi all

I have a MySQL data base that is saving information from a form. One the form a user can add a business name which is text and a logo if they have one.

Now on my web page I want to beabe to display the picture if present if not I would like it to display the business name. How do I do this please. I know how to conect to DB etc just having problems getting my head around this problem.

Hi,

I have the following code in a WordPress theme which displays a companies website, Twitter and Facebook links.

What I am trying to do is display the text "Useful Links:" if one of the links exists, and hide the text if all are not present.

<p>Useful Links:</p>
<?php if ( $website = get_the_company_website() ) : ?>

                            <a class="company-website" href="<?php echo esc_url( $website ); ?>" itemprop="url" target="_blank" rel="nofollow"><?php _e('Website', 'jobseek'); ?></a>

                        <?php endif; ?>

                        <?php if ( get_the_company_twitter() ) : ?>

                            <a class="company-twitter" href="http://twitter.com/<?php echo get_the_company_twitter(); ?>"  target="_blank"><?php _e('Twitter', 'jobseek'); ?></a>

                        <?php endif; ?>

                        <?php
                        $facebook_link = get_post_meta( get_the_ID(), '_facebook_link', true );
                        if ( ! empty($facebook_link) ) : ?>
                            <a class="company-facebook" href="<?php echo $facebook_link; ?>"  target="_blank">Facebook</a>
   <?php endif; ?>

What would be the best way to show/hide the text depending on if the items are present or not?

Thanks

Hi, guys.

I want to present different ads to visitors in different countries.  For example, if a visitor is in Australia, I want him/her to see a different ad from, say, a visitor from the UK. Can this kind of thing be done with PHP? If so, will installing such a code slow down my site?

Any help will be appreciated very much.

Hello All,
 
I have been wrestling with a regex for a couple of hours now and I finally had to give in and ask for help.  The weird thing is that it works if there are no new lines in the text, it fails if there is a new line(s) present.  
 
The code:

$matches = array();
$pattern = '~\[CUSTOM_TAG(.*?)\](.*?)\[/CUSTOM_TAG\]~';
preg_match_all($pattern, $html, $matches);
if (!empty($matches[0])){
foreach($matches[0] as $code){
$parameter = preg_replace($pattern, '$1', $code);
$content = preg_replace($pattern, '$2', $code);//get the content between the pattern
}//foreach($matches[0] as $code){
}else{
echo 'Match failed';
}//if (!empty($matches[0])){

 
So with that code in mind, if the $html variable (the text to be processed) is:

$html = '<h1>Hello, world!</h1><p style="color:#ff0000;">Some red text</p>';

A match is found.  
 
 
If the $html variable is:

$html = '<h1>Hello, world!</h1>
<p style="color:#ff0000;">Some red text</p>';

Match not found
 
Hopefully I'm just missing something simple in my regex.
 
Thanks in advance!
Twitch

Hello everyone,

Let's say I am connecting to a database using PDO (I am excluding prepared statements for the sake of simplicity):
try 
{
$conn = new PDO('mysql:host=localhost;dbname=cms', 'root', 'password');
$result = $conn->query('SELECT * FROM news');
} 
catch (PDOException $e) 
{
echo 'Error: '.$e->getMessage();
exit;
}


So far I been using the following to manipulate the data in object form:
while ($row = $result->fetchObject()) {
echo $row->title;
echo $row->text;
}

My question is, is there a better way?

What is the foreach code equivalent to that? I have had no luck keeping the data in object form using foreach statements.

Which method is faster, while or foreach?

Thank you, any suggestions are highly appreciated.

Hi all!  I am trying to get an admin status ("y" or "n" to be retieved from an SQL select.  I do so in the following function:

Code: [Select]
function get_admin_status($username) {
   // query database for the name for a category id
   $conn = db_connect();
   
   $result = $conn->query("select admin from user
             where username='".$username."'");

   $result = @$conn->query($query);
   
   if (!$result) {
     return false;
   }
   $num_cats = @$result->num_rows;
   if ($num_cats == 0) {
      return false;
   }
   $row = $result->fetch_object();
   return $row->admin;
}

I then utilize this function in another file in the following code.  However, the adminhome.php page never loads.  It always goes to "survey1.php" .  I'm not sure why this is happening.  Any help would be appreciated.  Thanks for you time!

Code: [Select]
if ($username && $password) {
// they have just tried logging in
login($username, $password);
$admin = get_admin_status($username);
if($admin == "y"){
header("Location: adminhome.php");
}
else{
//login($username, $password);
// if they are in the database register the user id
$_SESSION['valid_user'] = $username;
$_SESSION['admin'] = $admin;
header("Location: survey1.php");
}

Hi I am currently making a site where users can upload second hand books for sale, I have everything working as i wish apart from i am having trouble creating a account page where users can review the books they have posted.

so far i use the following code to bring view a the data associated with an uploaded book based on its id

Code: [Select]
  public static function getById( $id ) {
    $conn = new PDO( DB_DSN, DB_USERNAME, DB_PASSWORD );
    $sql = "SELECT * FROM books WHERE id = :id";
    $st = $conn->prepare( $sql );
    $st->bindValue( ":id", $id, PDO::PARAM_INT );
    $st->execute();
    $row = $st->fetch();
    $conn = null;
    if ( $row ) return new Book( $row );
  }

I think i can use a similar function for my user account however, each book entered by a user has their member id attached to it, which is gained from there id in the members table which in turn is stored in $_SESSION['id']. My question is, is there a way to rework the code above to have something like select * where member_id = $_SESSION['id']. I have tried a few things and get stuck manly due to the fact i dont know what to replace the current :id with.

Thanks in advance, i hope i explained it well enough for you lot to understand.

Ian

Hello,

I am writing a data retrieval script, in order to print data stored in a DB. For some reason the script does not work..

More details below..

Code: [Select]
the form that calls the initiator script..

<form method='get' action="init.Get.php">
<div><input type="submit" name="get" value="See Data"></div>   
</form>

Code: [Select]
the initiator script

<?php
include 'dataGet.class.php';
$data= new getData();
$data= getData($name, $email, $text);
?>

Code: [Select]
my class..

<?php
class getData {
    private $name;
    private $email;
    private $text;
    
    function __construct(){
        $this->host = 'localhost';
        $this->uname = 'root';
        $this->pword = '1111';
        $this->dbname = 'teststorage';
        $this->dbtable = 'userData';
        }
    function getData($name, $email, $text){
        $this->dbconnect = mysql_connect($this->host, $this->uname, $this->pword);
        if (!$this->dbconnect) die("Connection Unable " . mysql_error());
        
        mysql_select_db($this->dbname);
        $sql_query = "SELECT * FROM $this->dbtable ";
        $result = mysql_query($sql_query);
        
        if ($result){
            echo $result;
        }
        else{
            echo "Retrieval Unsuccesful";
        }
        mysql_close($sql_query);
    }
}

?>

Can someone please tell me what am I doing wrong?

Thank you in advance.

Hello, 

Hoping someone could help me with hiding a video player if a video is not present in the db. I have split up the code to make it easier to understand. Thanks in advance 






(int) $ListId=$_GET['ListID'];
  function mysql_resultTo2DAssocArray ( $result) {
$i=0;
$ret = array();
while ($row = mysql_fetch_assoc($result)) {
foreach ($row as $key => $value) {
$ret[$i][$key] = $value;
}
$i++;
}
return ($ret);


--------------------------------------------------------------------------------------------


$querys = mysql_query("SELECT * FROM video WHERE listingID = '$ListId' ");
  $Details_video=mysql_resultTo2DAssocArray ($querys);  
 

--------------------------------------------------------------------------------------------




<div class="right_col">

<p id='preview'>The player will show in this paragraph</p>

<script type='text/javascript' src='/flvPlayer/swfobject.js'></script>
<script type='text/javascript'>
var s1 = new SWFObject('/flvPlayer/player-viral.swf','player','280','200','9');
s1.addParam('allowfullscreen','true');
s1.addParam('allowscriptaccess','always');
s1.addParam('autostart','true');
s1.addParam('image','/flvfiles/<?php echo $Details_video[0]['imagePath']?>');

s1.addParam('flashvars','&file=/flvfiles/<?php echo $Details_video[0]['videoPath']?>&image=/flvfiles/<?php echo $Deatls_video[0]['imagePath']?>&dock=false&autostart=true');
s1.write('preview');
</script>

Hie,

When I use PHP to gain data from another webpage I usually use
file_get_contents

Is there a faster way to retrieve data from webpages faster since it only seems to do around 200 website line retrievals per minute?

Is cURL faster?
Thank you