Php/mysql Programmers, Please Help Me Out !

u wrote

$nko = "insert into uk(name,address,sex) values('$oruko','$addr','$se')";


it ought to be

$nko = "insert into uk(name,address,sex) values($oruko,$addr,$se)";

and hope u named the file for the php script wapa.php

Wapa.php
====================================================================================
<? php

include  ("dbinfo.php");
//Declare your variables man ! dude

$name = addslashes($_POST['name']);
$address = addslashes($_POST['address']);
$sex = addslashes($_POST['sex']);

// if i hit the submit button, it should insert my records
if($wapa){
$sql = " INSERT INTO uk (name,address,sex)VALUES("$name", "$address", "$sex")";
echo " Your information inserted successfully";
}else {
echo " Sorry you entry can not be registerd at this time ";
}
?>




db.php
=====================================================================================
Copy into your db information i mean in a notepad and save it as dbinfo.php change the details oo

<?php

$database = "dbname";
$host = " localhost";
$username = "smartsoft";
$password = " nairaland";

$conn = mysql_connect ("locahost", "root", "")or die ("cannot connect at this time");
$db = mysql_select_db ("dbname",$conn)or die (mysql_error());
?>

Note : remember that i don't need to put my password because i'm using XAMPPS, it's when i want to upload i can now put in my password.

=====================================================================================

I didn't test it ooo just try and test it,  any problem just let me know i will fix and it will work got to run to church now see ya.

Hey is (uk) your table or Database  huh ? Check that well ooooooo

you can also try place it in a if {} statement ,  then go for customs errors will help you will building more complex application ,  Also you need to do Object oriented programming and have security in mind when coding .


Always have a file called "conect.php" which makes the db connection placed somewhere else on the host

the reuse it by call

require_once('conect.php');

register then the sections and continue

well that complex ,  its really a good start we were ones there

@MT (and others who can be of help).

I'm hearing about the WAMP Cd for the first time here.
Ive been looking for something like that.
I used to test run my codes directly on the server,
I downloaded the WINLAMP package but there was
download error.
How can I get a copy of the WAMP Cd?
Thanks.

@opensource
OK.I need,can you just supply the download URL.
Thanks

Kindly help me with this code ,problem is its not returning any value and the databse is well set up.if i don't put a where clause it works but once i put the where clause it doesnt return a value
html code is

<form name="form2" method="post" action="parishlist3.php">
                          <select name="parish">
                            <option>ABARANJE </option>
                            <option>ABORU</option>
                            <option>AJEGUNLE</option>
                            <option>ALAGBADO</option>
                            <option>ALAPERE</option>
                            <option>AMAZING GRACE</option>
                            <option>IKOTUN</option>
                            <option>KETU</option>
                            <option>MAFOLUKU</option>
                            <option>OWODE-ELEDE</option>
                            <option>OWORONSOKI</option>
                            <option>GREAT GRACE</option>
                            <option>LEKKI</option>
                            <option>IJERE</option>
                            <option>ORIGANRIGAN</option>
                          </select>
                          <input type="submit" name="Submit2" value="Submit">
                        </form>


and the php code is


   <?php
// Connects to your Database
mysql_connect("localhost", "username", "password") or die(mysql_error());
mysql_select_db("upperroo_parishes") or die(mysql_error());
$data = "SELECT * FROM address WHERE name ='$parish'"
or die(mysql_error());
Print "<table border cellpadding=3>";
while($info = mysql_fetch_array( $data ))
{
Print "<tr>";
Print "<th>Name:</th> <td>".$info['Name'] . "</td> ";
Print "<th>Address:</th> <td>".$info['Address'] . " </td></tr>";
Print "<th>Pastor-In-Charge:</th> <td>".$info['Head'] . "</td> ";
Print "<th>Phone No:</th> <td>".$info['Contact'] . " </td></tr>";
}
Print "</table>";
?>

The issue here is: You MUST declare your variables. $parish has no value, because you have not declared it as a variable containing the user's selection - so your query simply is saying 'where $parish =NOTHING'.

Put this code above your select statement:

$parish=$_POST['parish'];

That should work now, because you have basically said: '$parish now contains whatever the user selected'.

Hope it works out for you.

Nb: Nothing wrong with your select statement - the apostrophes are in order. Just declare the $parish variable as above.

no worries - can u paste the actual error thrown up on your screen? Also, did u change the select statement from the one in your earlier post?

Right, thanks for posting the error. Go back to your select statement, and change:



to:


That should fix it - goodluck!

??

  Congrats, and keep practising. But i want to know which code worked, because there were many suggestions.

Hi guys,ive got this little challenge again.i created an online poll on my site.ive got two challenges,i want the form for voting to open on a small window while the main page i e the index page remains there ,a thing i want to look into later but right now when I'm running the scripts for the view results page,it returns an error

warning:division by zero on line 59,62,65.any way out.thanks

yeah any idea

here is the code,it is for viewing the results of the polls

<?PHP
$question = '';
$answerA = '';
$answerB = '';
$answerC = '';

$imgTagA = '';
$imgWidthA = '0';

$imgTagB = '';
$imgWidthB = '0';

$imgTagC = '';
$imgWidthC = '0';

$imgHeight = '10';
$totalP = '';
$percentA = '';
$percentB = '';
$percentC = '';

$qA = '';
$qB = '';
$qC = '';

if (isset($_GET['Submit2'])) {

      $qNum = $_GET['h1'];

      $user_name = "upperroo_users";
      $password = "preacher";
      $database = "upperroo_surveytest";
      $server = "localhost";

      $db_handle = mysql_connect($server, $user_name, $password);
      $db_found = mysql_select_db($database, $db_handle);

      if ($db_found) {

         $SQL = "SELECT * FROM tblquestions, answers WHERE tblquestions.QID = answers.QID AND answers.QID = '$qNum'";
         $result = mysql_query($SQL);
         $db_field = mysql_fetch_assoc($result);

         $question = $db_field['Question'];
         $answerA = $db_field['A'];
         $answerB = $db_field['B'];
         $answerC = $db_field['C'];

         $qA = $db_field['qA'];
         $qB = $db_field['qB'];
         $qC = $db_field['qC'];

         $imgWidthA = $answerA;
         $imgWidthB = $answerB;
         $imgWidthC = $answerC;

$totalP = $answerA + $answerB + $answerC;

$percentA = (($answerA * 100) / $totalP);
$percentA = floor($percentA);

$percentB = (($answerB * 100) / $totalP);
$percentB = floor($percentB);

$percentC = (($answerC * 100) / $totalP);
$percentC = floor($percentC);

$imgWidthA = $percentA * 2;
$imgWidthB = $percentB * 2;
$imgWidthC = $percentC * 2;


         $imgTagA = "<IMG SRC = 'red.jpg' Height = " . $imgHeight . " WIDTH = " . $imgWidthA. ">";
         $imgTagB = "<IMG SRC = 'red.jpg' Height = " . $imgHeight . " WIDTH = " . $imgWidthB . ">";
         $imgTagC = "<IMG SRC = 'red.jpg' Height = " . $imgHeight . " WIDTH = " . $imgWidthC . ">";

         mysql_close($db_handle);


      }
      else {
         print "database error";
      }


}
else {
   print "no results to display";
}
?>

You seem to forget that you are using post as the method of your post and as such you must have to capture the variables at the server like this

$sex=$_POST['sex'];
$var2=$_POST['var2'];
$var3=$_POST['var3'];

then you clean it  for safe storage like this

$sex=strip_tags(trim($sex));
$var2=strip_tags(trim($var2));
$var3=strip_tags(trim($var3));

then you are on your way to storing it in the database