Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by PravinS

  1. check the syntax of INSERT query http://dev.mysql.com/doc/refman/5.6/en/insert.html
  2. input to "mysql_real_escape_string()" function should be string and you have passed array to it, so you are getting this error if possible paste your code here
  3. try using this SQL query SELECT received, SUM(amount) as amt FROM TABLE_NAME GROUP BY received;
  4. if you want to use server side valiation then you can use "filter_var" function to check the email or else you can use javascript email validation http://www.php.net/manual/en/function.filter-var.php
  5. try replacing this code <form action="add_bk_insert.php"> Name <input type="text" name="name"/><br /> E-mail <input type="text" name="email" /><br /> Contact <input type="text" name="contact" /><br /> Requirement <input type="text" name="requirement" /><br /> <input type="submit" value="Submit" name="btnSubmit"/> </form> <?php mysql_connect("localhost","root",""); mysql_select_db("test"); if (isset($_POST['btnSubmit'])) { $name = isset($_POST[name]) ? $_POST[name] : ''; $email_id = isset($_POST[email_id]) ? $_POST[email_id] : ''; $contact = isset($_POST[contact]) ? $_POST[contact] : ''; $requirement = isset($_POST[requirement]) ? $_POST[requirement] : ''; $order = "INSERT INTO sal2 (name,email_id, contact,requirement) VALUES('".$name."','".$email_id."','".$contact."','".$requirement."')"; $result = mysql_query($order); if($result) { echo "Inserted"; //include_once("testimonials.php"); } else{ echo("<br>Input data is fail"); } } ?>
  6. check if mod_rewrite is enabled in php.ini
  7. while uploading files use $_FILES instead of $_POST for file data $fileName = $_POST["uploaded_file"]["name"]; // The file name $fileTmpLoc = $_POST["uploaded_file"]["tmp_name"]; // File in the PHP tmp folder $fileType = $_POST["uploaded_file"]["type"]; // The type of file it is $fileSize = $_POST["uploaded_file"]["size"]; // File size in bytes the above code should be $fileName = $_FILES["uploaded_file"]["name"]; // The file name $fileTmpLoc = $_FILES["uploaded_file"]["tmp_name"]; // File in the PHP tmp folder $fileType = $_FILES["uploaded_file"]["type"]; // The type of file it is $fileSize = $_FILES["uploaded_file"]["size"]; // File size in bytes
  8. may LEFT JOIN will help you $sql="SELECT * FROM tweet LEFT JOIN follow ON tweet.user_id=follow.user_id WHERE follow.user_id = '".$_SESSION['user_id']."' ORDER BY date_time desc";
  9. try using this $num = mysql_num_rows($allusers = mysql_query("SELECT * FROM PMs WHERE `status` = '0' AND ReceiveID ='".$myU->ID."' ORDER BY ID")); $PMs = mysql_num_rows($allusers = mysql_query("SELECT * FROM PMs WHERE `status` = '0' AND LookMessage = '0' AND ReceiveID = '".$myU->ID."' ORDER BY ID"));
  10. try using urlencode() and urldecode() php functions
  11. check this line mail to($to, $subject, $message, $additional_headers); for this refer http://php.net/manual/en/function.mail.php
  12. check this line echo " Thank you $_POST[fname] !! Your registration has been submitted!!"; && $sendEmail; remove "&& $sendEmail;" if you want to concat $sendEmail, then you can use like this echo " Thank you $_POST[fname] !! Your registration has been submitted!!".$sendEmail;
  13. "http://" may be missing, please check that
  14. check highcharts http://www.highcharts.com/demo/
  15. you can check this url for that http://ellislab.com/codeigniter/user-guide/general/models.html#loading
  16. http://ellislab.com/codeigniter/user-guide/database/active_record.html#insert
  17. To, From are reserved words in MySQL, either you can change the column names or use title (``) character around column names, like `To`,`From`
  18. you are getting this error because the "id" field is primary key and autoincremented, there may be any old entry with 153 value
  19. may this will help you http://www.php-guru.in/2013/dynamic-menu-in-php-mysql-javascript/
  20. are you getting error or validation is not working also check your form action, its "success.asp"
  21. you can disable them, which can be visible but cannot be checked
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.