PHP form for entering data to MySQL database - Page 3 - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

penguinsrule · 08-23-2006, 02:56 PM

thank you so much you helped me understand php and mysql and soon i will be taking a course in it thanks

you know when you seach data eg

id name Gender
1 john male
2 bob male
3 Sue female
4 Michael male
5 Matthew male

and your query result female only

id name Gender
3 Sue female

No0oB · 08-23-2006, 03:04 PM

PHP Code:


		
			
$sql = "SELECT * FROM tablename WHERE gender = 'female'";

Substitute tablename. In case gender is not the name of the field, substitute that as well.

penguinsrule · 08-23-2006, 05:23 PM

*********YOUR POST HAS BEEN EDITED PLEASE USE THE CORRECT TAGS FOR PHP********
As you are very cleaver how do you get $name2 to go into the function
its sends it accross like this
send.php?file=11&file2=db11

PHP Code:


		
			
<?php

$name2 = $_GET['file2'];

function scandir($dirstr) {

        passthru("/usr/bin/count.sh $name2 2>&1 ");



        echo "</pre>\n";

}



                scandir("$fullpath");

?>

Thanks for the help

No0oB · 08-23-2006, 06:03 PM

you mean in this passthru?
I'd try following

PHP Code:


		
			
passthru("/usr/bin/count.sh/".$name2."2>&1 ");

But it looks really weird to me, as you have a file with .sh ending. So basically, there shouldnt come anything afterwards.... or no? o0

penguinsrule · 08-23-2006, 06:17 PM

ill try it now the file type is correct dont worry its a script
Tryed it didnt work shame
this is what it is before
passthru("/usr/bin/count.sh/ tel458 2>&1 ");

No0oB · 08-23-2006, 07:08 PM

I would say youre missing a comma somewhere

Quote:

Originally Posted by php.net

void passthru ( string command [, int &return_var] )

Thats the structure of your function

penguinsrule · 08-23-2006, 07:12 PM

yeah but it works if you put the name maunaly

PHP Code:


		
			
<?php

$name2 = $_GET['file2'];

function scandir($dirstr) {

       passthru("/usr/bin/count.sh nameoffile 2>&1 ");



        echo "</pre>\n";

}



                scandir("$fullpath");

?>

No0oB · 08-23-2006, 09:10 PM

[quote=No0oB]

PHP Code:


		
			
passthru("/usr/bin/count.sh ".$name2." 2>&1 ");

Well then try this, when its the correct scheme

penguinsrule · 08-23-2006, 09:46 PM

hi found soltion
thanks for your great effort kept me think thanks, weird .sh that what made this time different. How can you totla the size of a field i have no clue

<?php
$name2 = $_GET['file2'];
function scandir($name) {
passthru("/usr/bin/count.sh $name 2>&1 ");

echo "</pre>\n";
}

scandir("$name2");
?>

No0oB · 08-25-2006, 01:21 PM

Which field do you mean?