PHP - Insert Php Output Into A Scrolling Marquee

Hello, I'm having a bit of a problem here, all help to this issues would be much appreciated

I am trying to use text boxes to insert numbers into the database based on what is inputed.
If I have a string, like this for example:
$variable = 09385493;

And I want to insert it into the database like this:
mysql_query("INSERT INTO integers(number)
VALUES ('$variable')");

When checking the integers table in my database, looking at the number field, the $variable that was inserted is outputted as
9385493

Notice the number zero was taken out of the front of the number. If the number is double 0's (009385493), both of those zero's would disappear, too.

Thanks

This topic has been abducted by aliens, probed, and dropped off in JavaScript Help

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

This topic has been moved to JavaScript Help.

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

I have implemented this slider http://kgperazim.com/test/film2 , however I'd like my header and footer to stay on screen whenever I'm scrolling horizontally.   What would be the best solution to do that with css?   Thx for any advice.

This topic has been moved to HTML Help.

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

Click his links.

http://www.dreamerlines.lv/

Pretty cool huh?

This topic has been moved to JavaScript Help.

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

I'm not getting any errors but I"m not getting the output I'm expecting. When it gets the characterIDList values if there is a value for that field it needs to take that value then explode it and get the ID and characterName of each of the values so say the value inside of characterIDList was 2,3 then for each of those values it would find the characterName and ID of the value and be able to put each of them as a LI inside the UL.  I was hoping I could have the charactersQuery separate because I use it for the dropdown.

Code: [Select]
$newsQuery = "
    SELECT
        news.categoryID,
        news.newsTitle,
        news.newsPicture,
        news.content,
        news.characterIDList
    FROM
        news
        LEFT JOIN categories
            ON news.categoryID = categories.ID
    WHERE
        news.ID = '" . $newsID . "'";
$newsResult = mysqli_query ( $dbc, $newsQuery ); // Run The Query
echo $newsQuery;
$row = mysqli_fetch_array ( $newsResult, MYSQL_ASSOC );
$characterIDList = $row[ 'chracterIDList' ];

$characterIDList = explode(',',  $characterIDList);

foreach($characterIDList as $value){
    $charactersQuery = "
        SELECT
            ID,
            characterName
        FROM
            characters
        ORDER BY
            characters.characterName";
    $charactersResult = mysqli_query ( $dbc, $charactersQuery ); // Run The Query
}

Code: [Select]
<div class="field required">
            <label for="charactersDrop">Characters Involved</label>
            <ul id="characterList" style="list-style: none; margin-left: 195px;">
            <?php
              mysqli_data_seek( $charactersResult, 0 );
              while($row = mysqli_fetch_array ( $newsResult, MYSQL_ASSOC )) {
                if ($row['characterName'] == NULL  ) { 
                    
                } else {
             ?>
                    <li characterID="<?php echo $row['ID']; ?>" characterName="<?php echo htmlentities( $row['characterName'] ); ?>"><?php echo htmlentities($row['characterName']); ?> <a href="#">Remove</a></li>   
             <?php }} ?>
            </ul>
            <select class="dropdown" name="charactersDrop" id="charactersDrop" title="Characters Dropdown" style="margin-left: 195px;">
                <option value="">- Select -</option>
               <?php
                    mysqli_data_seek( $charactersResult, 0 );
                    while ( $row = mysqli_fetch_array ( $charactersResult, MYSQL_ASSOC ) ) { 
                        print "<option value=\"".$row['ID']."\">".$row['characterName']."</option>\r";
                    }
                ?>
            </select>
            <input type="button" value="Add Character" class="" onclick="CharactersInvolved()"/>
        </div>

the print_r($a)'s result is



views_handle_field_node Object

(

[view]=>view Object

(
[db_table] => views_view
[base_table] => node
[args] => Array
(
[0] => My entry 1
)

[use_ajax] =>
[result] => Array
(
[0] => stdClass Object
(
[nid] => 5
[node_title] => Title of a test entry
[node_revisions_body] =>
[node_revisions_format] => 1
[node_vid] => 5
[term_data_name] => My first test term name
[term_data_vid] => 1
[term_data_tid] => 1
[vocabulary_name] => Vocabulary 1
[node_revisions_vid] => 5
)

[1]=> stdClass Object
(
[nid] => 8
[node_title] => Title of a test entry
[node_revisions_body] =>
[node_revisions_format] => 1
[node_vid] => 5
[term_data_name] => My first test term name
[term_data_vid] => 1
[term_data_tid] => 1
[vocabulary_name] => Vocabulary 1
[node_revisions_vid] => 5
..
[2]..
..





now i want to output the [nid]=>5 and[nid]=>8.....and all the nid's value.i use this, but can't work.

$views_handle_field_node->$view->$result[]->nid. what's the correct output of it.

Hello.

I'm looking for some help to make a script.
The script should  run a .bat file, and get the output from it. (The text from the console).

Regards
Worqy

help me.
i have an index.php file in admin folder.
this is the code inside the file:
Code: [Select]
<?php
?>

Or any other code
and i get output 0 ,
but if i echo something else then i get the string has output,

help find out what is the problam please!!!

Hey folks,

I have made a cart for buying drinks. I also made an sql database. But when I click on the email button, I receive an email but only with the id of the products. I would like to have an output with the id of the product, but also the name of the product ( the name of the column in sql is also 'name')

this is my code and you can check it out on  http://fhcs.be/cart-demo3/

thanks in advance

cart.php

<?php
// Include MySQL class
require_once('inc/mysql.class.php');
// Include database connection
require_once('inc/global.inc.php');
// Include functions
require_once('inc/functions.inc.php');
// Start the session

session_start();
// Process actions
$cart = $_SESSION['cart'];
$action = $_GET['action'];
switch ($action) {
case 'add':
if ($cart) {
$cart .= ','.$_GET['id'];
} else {
$cart = $_GET['id'];
}
break;
case 'delete':
if ($cart) {
$items = explode(',',$cart);
$newcart = '';
foreach ($items as $item) {
if ($_GET['id'] != $item) {
if ($newcart != '') {
$newcart .= ','.$item;
} else {
$newcart = $item;
}
}
}
$cart = $newcart;
}
break;
case 'update':
if ($cart) {
$newcart = '';
foreach ($_POST as $key=>$value) {
if (stristr($key,'qty')) {
$id = str_replace('qty','',$key);
$items = ($newcart != '') ? explode(',',$newcart) : explode(',',$cart);
$newcart = '';
foreach ($items as $item) {
if ($id != $item) {
if ($newcart != '') {
$newcart .= ','.$item;
} else {
$newcart = $item;
}
}
}
for ($i=1;$i<=$value;$i++) {
if ($newcart != '') {
$newcart .= ','.$id;
} else {
$newcart = $id;
}
}
}
}
}
$cart = $newcart;
break;
}
$_SESSION['cart'] = $cart;
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>PHP Shopping Cart Demo &#38;#0183; Cart</title>
<link rel="stylesheet" href="css/styles.css" />
</head>

<body>

<div id="shoppingcart">

<h1>Your Shopping Cart</h1>


<?php
echo writeShoppingCart();

?>

</div>

<div id="contents">

<h1>Please check quantities...</h1>

<?php
echo showCart();
?>

<p><a href="index.php">Back to bookshop...</a></p>

<form action="mail.php" method="post">
<input type="submit" name="sendemail" value="Email" />
<input type="hidden" name="cart" value="<?= $cart; ?>" />
</form>




</div>

</body>
</html>


mail.php

<?php


session_start();
 
if($_POST['sendemail'] == 'Email')
{
 
 
  $headers = 'From: Sender <andrej13@gmail.com>';
  mail('andrej13@gmail.com', 'Subject', $_SESSION["cart"] , $headers);
  
  
  echo 'Your mail has been sent';
}
else
{
  echo 'message not sent';
}


?>


and the functions.php

<?php
function writeShoppingCart() {
$cart = $_SESSION['cart'];
if (!$cart) {
return '<p>You have no items in your shopping cart</p>';
} else {
// Parse the cart session variable
$items = explode(',',$cart);
$s = (count($items) > 1) ? 's':'';
return '<p>You have <a href="cart.php">'.count($items).' item'.$s.' in your shopping cart</a></p>';
}
}

function showCart() {
global $db;
$cart = $_SESSION['cart'];
if ($cart) {
$items = explode(',',$cart);
$contents = array();
foreach ($items as $item) {
$contents[$item] = (isset($contents[$item])) ? $contents[$item] + 1 : 1;
}
$output[] = '<form action="cart.php?action=update" method="post" id="cart">';
$output[] = '<table>';
foreach ($contents as $id=>$qty) {
$sql = 'SELECT * FROM products WHERE id = '.$id;
$result = $db->query($sql);
$row = $result->fetch();
extract($row);
$output[] = '<tr>';
$output[] = '<td><a href="cart.php?action=delete&id='.$id.'" class="r">Remove</a></td>';
$output[] = '<td>'.$name.'</td>';
$output[] = '<td>&euro;'.$price.'</td>';
$output[] = '<td><input type="text" name="qty'.$id.'" value="'.$qty.'" size="3" maxlength="3" /></td>';
$output[] = '<td>&euro;'.($price * $qty).'</td>';
$total += $price * $qty;
$output[] = '</tr>';
}
$output[] = '</table>';
$output[] = '<p>Grand total: <strong>&euro;'.$total.'</strong></p>';
$output[] = '<div><button type="submit">Update cart</button></div>';
$output[] = '</form>';
} else {
$output[] = '<p>You shopping cart is empty.</p>';
}
return join('',$output);
}

?>

I don't have any output after I push the button :s I dont know how
http://fhcs.be/index3.php
Code: [Select]
<?php
// Include MySQL class
require_once('inc/mysql.class.php');
// Include database connection
require_once('inc/global.inc.php');
// Include functions

session_start();
?>
<?php if (!isset($_POST['submit'])) { ?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">

        <form method="post" action="<?php echo $PHP_SELF; ?>">
        <input type="submit" value="Toon Output" name="submit"/>
         

<?php
$dranken=array()   ;
$DrinkResult=mysql_query("SELECT name,price FROM products")or die(mysql_error());

      while($DrinkRow=mysql_fetch_assoc($DrinkResult)){
         $dranken[] = $DrinkRow;

      }
echo "<table>";

    foreach ($dranken as $DrinkRow) {
$optionlist = "<select name='{$DrinkRow['name']}_aantal'>";
for  ($i=0;$i<10;++$i) {
$optionlist .= "<option value='$i'>$i</option>";
}
$optionlist .= "</select>";
echo "<tr><td>".$DrinkRow['name']." ".$DrinkRow['price']."</td>\n";
echo "<td>$optionlist</td></tr>\n";
}
echo "</table>";
?>
     

    </form>

    <?php
    }
    
    
$dranken=array()   ;
$DrinkResult=mysql_query("SELECT name,price FROM products")or die(mysql_error());

      while($DrinkRow=mysql_fetch_assoc($DrinkResult)){
         $dranken[] = $DrinkRow;

      }
echo "<table>";
    

    $totaalPrijs = 0;

    foreach ($dranken as $DrinkRow) {
        $aantal = $_POST[$DrinkRow['name'] . "_aantal"];
        if ($aantal > 0) {
            $prijsperDrank = $aantal * $DrinkRow['price'];
            echo $DrinkRow['name'] . " : " . $aantal . " Prijs: " . $prijsperDrank . "</br>";
$totaalPrijs=$totaalPrijs + $prijsperDrank; }
    
}
if($totaalPrijs>0){    
    echo " totaal: " .$totaalPrijs;}
    ?>

</html>

Hi. I found a code online but unfortunately, the data is retrieved via variables. How can i convert this code to retrieve the data from database instead. Thank you in ADVANCE!

Code: [Select]
var members = [
    ['Steven B. Ayres', '1911-1913', 'New York', 'Independent Democrat', '1861-1929'],
    ['William Augustus Ayres', '1915-1921 1923-1934', 'Kansas', 'Democratic', '1867-1952'],
    ['William Hanes Ayres', '1951-1971', 'Ohio', 'Republican', '1916-2000']
];

Hi all,

Is there a simple way to log the command output of a linux console?

This command locks up my screen. It is a screen on an Aastra IP phone.

$command = 'logsave /var/www/html/aastra/test.log ls';

shell_exec($command);


Thanks!