Jump to content

samXR

Members
  • Posts

    14
  • Joined

  • Last visited

samXR's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. samXR

    What Is This Called?

    hey i got a question.at the side of SQLyog.there is "infomation_schema" , "my_bd" , "mysql" and "test".what is that called?? Then if i click on the plus sign of test..then a few column pop out..What is that called too??i need to execute some php codes with that 'unknown' name..Any help would be great..thanks a lot..
  2. samXR

    How To Extract?

    hey guys..i wanna extract data from the database and put it in the select column..and also where do i put the codes..is it in a new php file or in editor.php.....but i juz could not figure it out..needing help here..thanks...::::::::::::::::::::::::editor.php:::::::::::::::::::::::::::::::::::::<table border="3"><tr><td style="background-color:#6495ED"><b>Selection Criteria</b></td></tr><tr><td><form action="dbm.php" method="post"> Select a Database Name :</br></br><select><option> </option><option> </option></select><input type="submit" value="Go"/ ></form><form action="dbm2.php" method="post"> Select a Table :</br></br><select><option> </option><option> </option></select><input type="submit" value="Go"/ ></form><form action="dbm3.php" method="post"> Select a search field, then enter a search phrase (enter nothing to retrieve all records) :</br></br><select><option> </option><option> </option></select><select><option> </option><option> </option></select><input type="text" /><input type="submit" value="Result"/></form></td></tr>
  3. samXR

    Extract Into Select

    hey guys..i wanna extract data from the database and put it in the select column..and also where do i put the codes..is it in a new php file or in editor.php.....but i juz could not figure it out..needing help here..thanks...::::::::::::::::::::::::editor.php:::::::::::::::::::::::::::::::::::::<table border="3"> <tr> <td style="background-color:#6495ED"><b>Selection Criteria</b></td> </tr> <tr> <td><form action="dbm.php" method="post"> Select a Database Name :</br></br> <select> <option> </option> <option> </option> </select> <input type="submit" value="Go"/ ></form> <form action="dbm2.php" method="post"> Select a Table :</br></br> <select> <option> </option> <option> </option> </select> <input type="submit" value="Go"/ ></form><form action="dbm3.php" method="post"> Select a search field, then enter a search phrase (enter nothing to retrieve all records) :</br></br> <select> <option> </option> <option> </option> </select> <select> <option> </option> <option> </option> </select> <input type="text" /> <input type="submit" value="Result"/> </form> </td> </tr>
  4. samXR

    Button

    hey u have msn or yahoo messenger??
  5. hey guys been trying to figure out how to put the button horizontally side by side..wat i get is it vertically side by side..hope ya all can help..thanks in advace..::::::::::::::::::::::::::::::::::::::::::::::::::::::::<form action="newupdate1.php" method="post"><center><strong>Type in your Admission Number : <input type="text" name="admin" /></strong></center><br/><br/><center><input type="submit" value="SUBMIT"/><form action="newdelete1.php" method="post"><br/><br/><center><input type="submit" value="DELETE"/></center></form>
  6. samXR

    Button

    put the button and a checkbox next to the table..and i want the button to update(going to update.php)
  7. samXR

    Button

    dude, i cannot put a button right next to the table..haha..help here..sorry if stupid question..thanks..:::::::::php codes:::::::::<?php$Name = $_POST['name'];$con = mysql_connect("localhost","root","root");if (!$con) { die('Could not connect: ' . mysql_error()); }mysql_select_db("studentreg", $con);$result = mysql_query("SELECT * FROM particulars WHERE Name='$Name'");echo "<table border='1'><tr><th>Name</th><th>Handphone</th><th>Email</th><th>Admin</th></tr>";while($row = mysql_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row['Name'] . "</td>" ; echo "<td>" . $row['Handphone'] . "</td>"; echo "<td>" . $row['Email'] . "</td>"; echo "<td>" . $row['Admin'] . "</td>"; echo "</tr>"; } echo "</table>"; mysql_close($con);?>
  8. hey guys needing help here....i wanna extract data from the database into the form(update.php)...for example, SAM has inserted his profile..but a few while later he realised that he had inserted the wrong email address...so now...i want update.php to extract his inserted profile to show him what he has inserted in his previous insertion....this is so that it is easier for him to see what he has done previously..any help would be great guys...thank youu youu....::::::::::::::::::::::::::::::::MY FORM::::::::::::::::::::::::::::::<form action="update.php" method="post"><center></br></br></br>Name: <input type="text" name="name" />Hp : <input type="text" name="handphone" />Email : <input type="text" name="email" />Admin : <input type="text" name="admin" /><center></br></br></br></br><input type="submit" value="Update Survey" /></center></form>::::::::::::::::::::::::::::::MY PHP CODES::::::::::::::::::::::::::::<?php$name = $_POST['name'];$handphone = $_POST['handphone'];$email = $_POST['email'];$admin = $_POST['admin'];$con = mysql_connect("localhost","root","root");if (!$con) { die('Could not connect: ' . mysql_error()); }mysql_select_db("studentreg", $con);mysql_query("UPDATE paticulars SET handphone='$handphone',email='$email',admin='$admin' WHERE admin = '$admin' ");echo "<center><strong>Your particulars, $name, have been updated!!</br>Thank you...</strong></center>";mysql_close($con)?>
  9. hey guys need help here...i wanna echo an error if not all the input type is typed...juz couldnt get the codes right...how do i do it..any help would be great..thank you..:::::::::::::::::::::MY HTML CODES:::::::::::::::::::<form action="questions.php" method="post"><center><br/></br><br/>Question: <input type="text" name="question" />Name: <input type="text" name="name" />Admin: <input type="text" name="admin" /></center><br/><br/><br/></br><center><input type="submit" value="Submit Question"/></center></form>::::::::::::::::::::MY PHP CODES:::::::::::::::::::::<?php$name = $_POST['name'];$con = mysql_connect("localhost","root","root");if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("studentreg", $con); $sql="INSERT INTO questions ( question,name, admin)VALUES('$_POST[question]','$_POST[name]','$_POST[admin]')";if (!mysql_query($sql,$con)) { die('Error: Question too long..Sorry.. ' ); } echo "<br/><br/></br></br><center><strong>Your question, $name, will be dealt with seriously.Thank you...</strong></center>"; mysql_close($con)?>
  10. this guy is god to me..haha...he saved my ###### man..thanks again smerny..cheers..

  11. i doin some sort of a online survey for my school project..that particular person need to input their particulars..den answer the survey questions...after that they can either delete or update their submitted answer.."NOW THEY CAN DELETE THEIR PARTICULARS BCOZ OF UR CODES"...hahaha...anyway thanks a gazillion man!!!!!!finally i got it to delete..hahaha..and also i got to update wit ya codes...haha..im realli a beginner dude..thanks a gazillion million billion trillion zillion again smerny...cheers..(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)(",)
  12. hey guys..need ya help here..i new to this php stuff..i can delete/update stuff from the from into the database..but it is only for a specific name..but what i want is to delete/update stuff for any given name...this are the codes...thanks...ur help will be greatly appreciated...cheers...:::::THIS IS MY FORM:::::<form action="delete.php" method="post">Name: <input type="text" name="name"/>Age: <input type="text" name="age" />Hp : <input type="text" name="handphone" />Email : <input type="text" name="email" />Admin : <input type="text" name="admin" /><input type='submit' name='remove' value='Delete' /></form></body></html>:::::THIS IS MY PHP CODES:::::<?php $con = mysql_connect("localhost","root","root");if (!$con){die('Could not connect: ' . mysql_error());}mysql_select_db("studentreg", $con);mysql_query ( "DELETE FROM particulars WHERE name='sam' ");echo "name deleted!!";mysql_close($con)?>
  13. samXR

    Update

    hi hi..can you be more specific bout this>>>>>>>SET column1=value, column2=value2, etc.thank u..i too have this problem..
  14. hey guys..need ya help here..i new to this php stuff..i can delete/update stuff from the from into the database..but it is only for a specific name..but what i want is to delete/update stuff for any given name...this are the codes...thanks...ur help will be greatly appreciated...cheers...:::::THIS IS MY FORM:::::<form action="delete.php" method="post">Name: <input type="text" name="name"/>Age: <input type="text" name="age" />Hp : <input type="text" name="handphone" />Email : <input type="text" name="email" />Admin : <input type="text" name="admin" /><input type='submit' name='remove' value='Delete' /></form></body></html>:::::THIS IS MY PHP CODES:::::<?php $con = mysql_connect("localhost","root","root");if (!$con){die('Could not connect: ' . mysql_error());}mysql_select_db("studentreg", $con);mysql_query ( "DELETE FROM particulars WHERE name='sam' ");echo "name deleted!!";mysql_close($con)?>
×
×
  • Create New...