Posts by pzuurveen

is the colum called $league_id or maybe league_id ?

Re: Number Courses = Number rows

pzuurveen 90 Posting Whiz in Training

13 Years Ago

what is the problem?

pzuurveen 90 Posting Whiz in Training

13 Years Ago

ok at

a possible value for $league

put in a value that the php varible $league might have

do the same for

a possible vaule for $weeknr

but with the php variable $weeknr

pzuurveen 90 Posting Whiz in Training

13 Years Ago

in your testing you missed a part of the query
Add

AND league_id=`[I] a possible value for $league[/I]` AND week_nr < [I] a possible vaule for $weeknr[/I] AND fixture_ignore='no' ORDER BY week_nr

Re: Storing & Using Long Form Values : Best Practice?

pzuurveen 90 Posting Whiz in Training

13 Years Ago

simply test for it

if (!( $key=='submit')){
 $columns[$key] = "'" . mysql_real_escape_string($value) . "'";
}

pzuurveen 90 Posting Whiz in Training

13 Years Ago

with a error like this there usaly an error in the myslq query
post that part
problebly look something like

$query="SELECT ....FROM ... WHERE ....";
$result=mysql_query($query);

pzuurveen 90 Posting Whiz in Training

13 Years Ago

My bad, I asumed that you had a form with checkboxes.
If a checkbox is not cheched it will not be in $_POST
There for if(issset()) is good enough.
if you need also check it value you can simpliy use an &&.
You still need to use isset() or you get an notice if it doen't exist

$trim = mysql_real_escape_string(trim($var));

if(isset($_POST['RecipesType1']) && $_POST['RecipesType1']==1 )
$query .= "RecipesType1=1 AND ";

mysql_real_escape_string($_POST) is not necessary because you don't use the value in the query

Re: how to fetch a website then process it ?

pzuurveen 90 Posting Whiz in Training

13 Years Ago

what are trying to do
Hack user profiles from playstation.com?

Web Development html-css php

pzuurveen 90 Posting Whiz in Training

13 Years Ago

Re: Pass Alternate values with image button

think you should use the <button > not the <inpute type='image'>

see http://webdesign.about.com/od/htmltags/p/input-image-tag.htm

pzuurveen 90 Posting Whiz in Training

13 Years Ago

Re: session

change line 3 to

print_r($_SESSION);

and see...

or you can check and fall back to a defalt

if (isset($_SESSION['product_name'])
        $name=$_SESSION['product_name'];
else $name='Mr X';

Re: welcome user in all php pages

pzuurveen 90 Posting Whiz in Training

13 Years Ago

oeps!

simplypixie commented: What is that supposed to mean -1

pzuurveen 90 Posting Whiz in Training

13 Years Ago

Is't that excely what you want?
Does't it mean that your 'cookies' are not of RecipesType2 and therefore should be not returned as result if you check RecipesType2?
Else you neat to explane the var-type and posible values of RecipesType2 in your DB

Re: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

pzuurveen 90 Posting Whiz in Training

13 Years Ago

you got an error in your query
that's why mysql_query retuns FALSE and not a MySQL result resource.

$sql = "
SELECT *
FROM pqdb_articles, pqdb_categories
WHERE article_id = " . mysql_real_escape_string($article_id) . "
$query_ext
AND category_id = article_cat
";

what is $query_ext ?

pzuurveen 90 Posting Whiz in Training

13 Years Ago

your code works only if the recipes can be of only one type

remove line 7 to 24

$var = @$_POST['search'] ;
$trim = trim($var);
$query = "SELECT * FROM recipes WHERE";
if(isset($_POST['RecipesType1']))
     $query .= "RecipesType1=1 AND ";
if(isset($_POST['RecipesType2']))
     $query .= "RecipesType2=1 AND ";
// ....
$query .= "RecipesName LIKE \"%$trim%\" order by RecipesId ";

pzuurveen 90 Posting Whiz in Training

13 Years Ago

post what your code you have sofar and we go from there

Re: Looped Form to save in Same page

pzuurveen 90 Posting Whiz in Training

13 Years Ago

do something like

$NameArray=$_POST['name'];
foreach($NameArray as $Employee_Name)
   {

pzuurveen 90 Posting Whiz in Training

13 Years Ago

Re: echo print

Tested your main with cereals createtable.php
works fine for me

what do you get if you execute createtable.php directly?

pzuurveen 90 Posting Whiz in Training

13 Years Ago

Re: Alert Box & Refresh Page

Gess nthat you get a 'header already send' error

That because headers have to be sende before any output and that includes javascript

if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
else header('Location: http://www.example.com/index.php');

Put the alert in the index.php (or use something better then an alert box)

pzuurveen 90 Posting Whiz in Training

13 Years Ago

Re: echo print

$('#response').load('createtable.php');

this go's wrong if creatatble.php contains things like <html>, <title>, or <head>
for creatatble.php use cereals code and noting else.

Re: Drop Down Menu & The Processes After

pzuurveen 90 Posting Whiz in Training

13 Years Ago

you will not get back a $_POST
you can see thi if you do a var_dump($ _POST);

if(!isset($_POST['form1'])){
dropdown_empty();

will not work.
use

if (is_set($_POST['select']) $month = $_POST['select'];
else dropdown_empty();

even better

if (is_set($_POST['select'] && !empty($_POST['select'])) $month = $_POST['select'];
else dropdown_empty();

as it also checks if it has a value

Re: Check database if already exists

pzuurveen 90 Posting Whiz in Training

13 Years Ago

you are still not using backticks as ardav told you to
` is diverend than '
` is on the same key as the ~ ( atleast on my keyboard)

or you can copy and past ardav code

Re: how to treat div as submit button

pzuurveen 90 Posting Whiz in Training

13 Years Ago

trie

<div class="button_outside" id="share" onclick="javascript: document.forms["myform"].submit();">
    <div class="button_inside">Share</div>
</div>

Re: problem passing text with chars " and '

pzuurveen 90 Posting Whiz in Training

13 Years Ago

htmlentities does this for you

Re: Use of undefined constant harga (translate: price)

pzuurveen 90 Posting Whiz in Training

13 Years Ago

use

$r['harga']

and

$r['deskripsi']

Re: Use of undefined constant username

pzuurveen 90 Posting Whiz in Training

13 Years Ago

the correct way is

$_SESSION['username']

Re: problem passing text with chars " and '

pzuurveen 90 Posting Whiz in Training

13 Years Ago

check out htmlentities

Re: Fatal error: Cannot redeclare number_of_days() (previously declared in C:\xampp\htdoc

pzuurveen 90 Posting Whiz in Training

14 Years Ago

take your declaration of function number_of_days
outside your while loop
best is top of the script

Re: Help with this url passing variable code

pzuurveen 90 Posting Whiz in Training

14 Years Ago

Or if you gone use that var more: do

$edit_mileage= $_GET['edit_mileage']

Re: Help with this url passing variable code

pzuurveen 90 Posting Whiz in Training

14 Years Ago

That is not advissed.

In PHP 5.3.0 that has been DEPRECATED e.a it doesn't work anymore

Re: Help with this url passing variable code

pzuurveen 90 Posting Whiz in Training

14 Years Ago

If i understand corectly:
You have something like a form (no listing) that sends data to a page (listing 1)
that sends the data to /i-cmsys/editableinvoice/index.php (listing 2)

if so:
Data send in th url is GET data
use

echo $_GET['edit_mileage'];

pzuurveen 90 Posting Whiz in Training

14 Years Ago

Re: Display image path error

at line 6

Row['path']

still doesn't exist
you create it at line 11

#while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){

when php has an error like that u often get a blank screen
to show errors: start your script with

error_reporting(E_ALL);

pzuurveen 90 Posting Whiz in Training

14 Years Ago

Re: Display image path error

In your first script
where is the array

$row['path'];

(line 6)

come from?

pzuurveen 90 Posting Whiz in Training

14 Years Ago

Re: PHP Loop error

You use

mysql_free_result($result)

as part of your loop

so the second time in the while loop $result is empty

pzuurveen 90 Posting Whiz in Training

14 Years Ago

Re: move_uploaded_file error..

from your err msg
file name= /www/parctice/test/htdocs/Misa Campo073.jpg linux will read this as call to /www/parctice/test/htdocs/Misa passing a parameter Campo073.jpg

pzuurveen 90 Posting Whiz in Training

14 Years Ago

Re: move_uploaded_file error..

I 'm always suspicious about filenames with spaces

$fileName=str_replace(" ","_",$fileName);

Re: Mysql database fields with new lines ignored by PHP

pzuurveen 90 Posting Whiz in Training

14 Years Ago

are your comment text?
The u can't store them in a longint. Just use TEXT as ur column type
If there are numerical i don't see the problem with new lines

Re: include php page and get variables

pzuurveen 90 Posting Whiz in Training

14 Years Ago

Re: live links.

The width is part of the image tag

echo "<td><img width = '75' src='http://". $row['url'] . "' /></td>";

Web Development display image php

Kniggles commented: works a treet thanks +1

pzuurveen 90 Posting Whiz in Training

14 Years Ago

You have an error in your select statmend on line 5

echo "DB_Backup <select name='DB_Backup'>";

Re: back insertion updation problem

pzuurveen 90 Posting Whiz in Training

14 Years Ago

If you check the value befor youre query, and ,if empty, just not include in your insert, mysql shout use the default NULL

Re: back insertion updation problem

pzuurveen 90 Posting Whiz in Training

14 Years Ago

all i can think of is to set the dafault to NULL
what's not the same as zero (=numerical value where NULL means doesn't exist)

Re: Function can't access another function's variables

pzuurveen 90 Posting Whiz in Training

14 Years Ago

this might shed some light

/**
 * Define MyClass
 */
class MyClass
{
    public $public = 'Public';
    protected $protected = 'Protected';
    private $private = 'Private';

    function printHello()
    {
        echo $this->public;
        echo $this->protected;
        echo $this->private;
    }
}

$obj = new MyClass();
echo $obj->public; // Works
echo $obj->protected; // Fatal Error
echo $obj->private; // Fatal Error
$obj->printHello(); // Shows Public, Protected and Private

(copyed it form php.net)

Re: Printing multiple Database values

pzuurveen 90 Posting Whiz in Training

14 Years Ago

Re: image button not posting

an input image returns an x an y coordinate from wher you pressed on the image
http://htmlhelp.com/reference/html40/forms/input.html

You get a $_POST and a $_POST back

Web Development javascript

pzuurveen 90 Posting Whiz in Training

14 Years Ago

Re: image button not posting

You missed the closing ' on your $_POST

<?php if (isset($_POST['submit'])){echo "clicked";}

Web Development javascript

pzuurveen 90 Posting Whiz in Training

14 Years Ago

You can mak this->title an array

class Entry
   {
   private $title = array();

change the constuctor:

$result=mysql_query($query);
while($row=mysql_fetch_array($result))
   {
   $this->title[]=$row['TITLE'];
   }

pzuurveen 90 Posting Whiz in Training

14 Years Ago

Re: Session Value is missing

you have to pass along the session id for it to work
see:
http://nl.php.net/manual/en/session.idpassing.php

Re: selected="selected" on Submit

pzuurveen 90 Posting Whiz in Training

14 Years Ago

What do you have as your form action?
if you call the same scrip the form rest it self.
The seleced value is in your $_POST
do

<?
var_dump($_POST);
?>

pzuurveen 90 Posting Whiz in Training

18 Years Ago

Re: parse error

You used " in a string . This is't
nessarray. Just remove them

echo "<center><br><br><a href=http://novatrader.net/index.php?option=com_puarcade&Itemid=51>&lt;&lt;&nbsp;Choose Another Game</a></center>";