Jump to content
Stef's Coding Community

bishwadeep

Member
  • Content Count

    27
  • Joined

  • Last visited

Community Reputation

0 Neutral

About bishwadeep

  • Rank
    Member

Profile Information

  • Gender
    Male
  • Location
    Nepal

Contact Methods

  • Facebook
    kc_bishwa@yahoo.com
  • Yahoo
    kc_bishwa@yahoo.com
  1. For code debugging i use a dBug class which you can download at http://dbug.ospinto.com/. I think this is the best help while you code php. Example: include("dBug.php"); $a=array('a','b','c'); new Dbug($a);
  2. Hi This might help you. ob_start(); $db = new PDO('mysql:host=localhost;dbname=<SOMEDB>', '<USERNAME>', 'PASSWORD'); $stmt = $db->prepare("select contenttype, imagedata from images where id=?"); $stmt->execute(array($_GET['id'])); $stmt->bindColumn(1, $type, PDO::PARAM_STR, 256); $stmt->bindColumn(2, $lob, PDO::PARAM_LOB); $stmt->fetch(PDO::FETCH_BOUND); ob_clean(); header("Content-Type: $type"); echo $lob; // fpassthru reports an error that $lob is not a stream so echo is used in place. ob_end_flush();
  3. Hi, Create a memberdetails.php page and then copy and paste the following code. Then modify according to your requirement. <?php //connection.php /*$id = $_GET['id'];*/ $conn = mysql_connect($host, $user, $pass); $selDB = mysql_select_db($db); $sql = "select count(*) from info"; $result = mysql_query($sql); $row = mysql_fetch_row($result); $numRows = $row[0]; /*if (isset($_GET['id'])){ $id = (int)$_GET['id']; }*/ $sql = "select * from info"; $result = mysql_query($sql); while($row = mysql_fetch_assoc($result)){ ?> <table> <td><?php echo stripslashes($row['name']). " ";?> <a href="memberdetails.php?id=<?php echo $row['id'];?>">[View Details]</a> </td> </tr> <?php } ?> memberdetails.php page <?php //memberdetails.php page $id=addslashes($_GET['id']); $sql = "select * from info WHERE id='".$_GET['id']."'"; $result = mysql_query($sql); $row=mysql_fetch_assoc($result); //now display the details in this page as the details are carried in the $row variable. ?>
  4. Hi, You can use javascript validation in that case. Here is a sample for javascript validation. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <script language="javascript"> function Formvalidation(form){ if(form.fname.value==""){ alert("Please Enter First Name"); form.fname.focus(); return false; } if(form.lname.value==""){ alert("Please Enter Last Name"); form.lname.focus(); return false; } //if(form.otherfield.value=="") //continue................. } </script> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> </head> <body> <form id="form1" name="form1" method="post" action=""> <table width="100%" border="0" cellspacing="0" cellpadding="3"> <tr> <td width="23%">First Name</td> <td width="77%"><label for="name"></label> <input type="text" name="fname" id="fname" /></td> </tr> <tr> <td>Last Name</td> <td><label for="email"></label> <input type="text" name="lname" id="lname" /></td> </tr> <tr> <td><input type="submit" name="button" id="button" value="Submit" onclick="return Formvalidation(this.form);"/></td> <td> </td> </tr> </table> </form> </body> </html>
  5. hi $value= $_GET['id']; $query_Recordset1 ="SELECT * FROM colores WHERE id='value'"; I think you missed the $ in 'value'. if this is not an example then this one below is right. $value= $_GET['id']; $query_Recordset1 ="SELECT * FROM colores WHERE id='".$value."'";
  6. bishwadeep

    delete

    Hi you can also validate an email address using regular expressions. if (!eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$", $email)){ echo "Valid Email Address"; }else{ echo "Invalid Email Address"; }
  7. Hi edoplaza, Since I dont have all the files you have used, I could not test it properly, But i think you can change the values in the $expected array to meet your requirements. For example: $expected = array('name', 'telefono', 'email','checkindate', 'checkintime', 'checkoutdate', 'checkouttime','adults', 'under4', 'between4and10','comments'); Change the name to Name and telefono to Telephone Number etc. Then try once and let me know.
  8. Hi Eduardo, I am glad to hear that your problem is solved. Yes I have seen Mt everest from far away and i am planning to go to the Mt everest base camp. Please remember me if any problem arises. regards, Bishwadeep
  9. Email: Check in date: Check out date: Adults: Childs: Comments:
  10. <?php if(isset($_POST['submit'])){ // multiple recipients $to = 'edoplaza@yahoo.com'; $subject = 'Feedback form results'; $message = 'name: '.$_POST['name']." "; $message.= 'Check in date: '.$_POST['checkindate']." "; $message.= 'Check out date: '.$_POST['checkoutdate']." "; $message.= 'Adults: '.$_POST['adults']." "; $message.= 'Childs: '.$_POST['child']." "; $message.= 'Comments: '.$_POST['comments']." "; $headers = 'MIME-Version: 1.0' . "\r\n"; $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; $headers .= 'From: Birthday Reminder ' . "\r\n"; mail($to, $subject, $message, $headers); } ?> Name: Check in date: Check out date: Adults: Childs: Comments:
  11. bishwadeep

    Edit and delete

    Hi nagarajanp, Here is what you want. http://www.weberdev.com/get_example-4392.html
  12. Hi edoplaza, This is because you have test the page several time using the same session. In real time this will not be the case. the user will fill the form once and he will close the browser. if you want to use the page in the realtime mode then you have to clear the browser cookie and session each time after filling the form. Currently you might notice that there might be same sessionid for different records in the database. This is because you are filling the form multiple times in the same user session.
  13. HI edoplaza, I think you have a space before your <? starting tag. This type of warning message generally arises when there is a space before the opening tag. ----------------------------------------------- ELIMINATE SPACE HERE <? ?> -----------------------------------------------
  14. Put your information here: Name: Lastname:
  15. Hi edoplaza, if you want to display the information in the same page where you insert your data then user mysql_insert_id() after you run your insert query which fetches the lates id of data inserted. If you wish to show the information in different pages then you can do the following. <?php session_start(); //add a new row called sessionid in the table and while inserting the value put session_id() for it. //eg: insert into your table (name,address,sessionid) values ("abc","bcd",'".session_id()."'); //then you can take out that record from the database any time until the user closes his browser. //eg: select * from your table where sessionid='".session_id()."'; ?> Remember that this sessionid is valid for only once, this session id is always different for every user and is valid for only one user session.
×
×
  • Create New...