Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Jun 10th, 2012  |  syntax: None  |  size: 3.62 KB  |  hits: 21  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. php, connecting to database using mysql_connect() problem, how to?
  2. <?php
  3. define("HOST", "localhost");
  4. define("DBUSER", "123");
  5. define("PASS", "123");
  6. define("DB", "123");
  7. $prefix = "";
  8. ############## Make the mysql connection ###########
  9. $conn = mysql_connect(HOST, DBUSER, PASS) or  die('Could not connect !<br />Please contact the site's administrator.');
  10. $db = mysql_select_db(DB) or  die('Could not connect to database !<br />Please contact the site's administrator.');
  11. ?>
  12.        
  13. <?php
  14. session_start();
  15. require_once ('db_connect.php'); // include the database connection
  16. ?>
  17. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
  18. <html xmlns:og="http://ogp.me/ns#" xmlns:fb="http://www.facebook.com/2008/fbml" xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
  19. <html>
  20. <head>
  21.  
  22. </head>
  23. <body>
  24. <div id="wrap">
  25. <script type="text/javascript">
  26. $(function() {
  27. $(".submit").click(function() {
  28. var name = $("#name").val();
  29. var com_type = 1;
  30. var email = $("#email").val();
  31. var comment = $("#comment").val();
  32.     var post_id = $("#post_id").val();
  33. var dataString = 'name='+ name + '&email=' + email + '&comment=' + comment + '&post_id=' + post_id;
  34.  
  35. if(name=='' || email=='' || comment=='')
  36.  {
  37. alert('Please Give Valide Details');
  38.  }
  39. else
  40. {
  41. $("#flash").show();
  42. $("#flash").fadeIn(400).html('<img src="ajax-loader.gif" align="absmiddle">&nbsp;<span class="loading">Loading Comment...</span>');
  43. $.ajax({
  44.     type: "POST",
  45. url: "commentajax.php",
  46. data: dataString,
  47. cache: false,
  48. success: function(html){
  49.  
  50. $("ol#update").append(html);
  51. $("ol#update li:last").fadeIn("slow");
  52. document.getElementById('email').value='';
  53. document.getElementById('name').value='';
  54. document.getElementById('comment').value='';
  55. $("#name").focus();
  56.  
  57. $("#flash").hide();
  58.  
  59. }
  60. });
  61. }
  62. return false;
  63. });
  64. });
  65. </script>
  66. <div id="main">
  67. <ol  id="update" class="timeline">
  68. <?php
  69. $sql=mysql_query("select * from comments where post_id_fk='$post_id'");
  70. while($row=mysql_fetch_array($sql))
  71. {
  72. $name=$row['com_name'];
  73. $com_type=$row['com_type'];
  74. $email=$row['com_email'];
  75. $comment_dis=$row['com_dis'];
  76.  
  77. $lowercase = strtolower($email);
  78. $image = md5( $lowercase );
  79. ?>
  80. <li class="box">
  81. <img src="http://www.gravatar.com/avatar.php?gravatar_id=<?php echo $image; ?>" class="com_img">
  82. <span class="com_name"> <?php echo $name; ?><?php echo $com_type; ?></span> <br />My Comment</li>
  83. <?php
  84. }
  85. ?>
  86. </ol>
  87. <div id="flash" align="left"  ></div>
  88. <div style="margin-left:100px">
  89. <form action="#" method="post">
  90. <input type="hidden" name="post_id" id="post_id" value="<?php echo $post_id; ?>"/>
  91. <input type="text" name="title" id="name"/><span class="titles">Name</span><span class="star">*</span><br />
  92. <input type="text" name="email" id="email"/><span class="titles">Email</span><span class="star">*</span><br />
  93. <textarea name="comment" id="comment"></textarea><br />
  94. <input type="submit" class="submit" value=" Submit Comment " />
  95. </form>
  96. </div>
  97. </div>
  98. </div>
  99. </body>
  100. </html>
  101.        
  102. <?php
  103.  
  104. if($_POST)
  105. {
  106. $name=$_POST['name'];
  107. $name=mysql_real_escape_string($name);
  108. $com_type=$_POST['com_type'];
  109. $name=mysql_real_escape_string($com_type);
  110. $email=$_POST['email'];
  111. $email=mysql_real_escape_string($email);
  112. $comment=$_POST['comment'];
  113. $comment=mysql_real_escape_string($comment);
  114. $post_id=$_POST['post_id'];
  115. $post_id=mysql_real_escape_string($post_id);
  116. $lowercase = strtolower($email);
  117. $image = md5( $lowercase );
  118. mysql_query("insert into comment(com_name,com_type,come_email,com_dis) values ('$name','$com_type','$email','$comment_dis','$post_id')");
  119. }
  120.  
  121. ?>
  122.  
  123. <li class="box">
  124. <img src="http://www.gravatar.com/avatar.php?gravatar_id=
  125. <?php echo $image; ?>"/>
  126. <?php echo $name;?><br />
  127. <?php echo $comment; ?>
  128. </li>
create a new version of this paste RAW Paste Data