39,320 Topics
| |
I am trying to search mysql databse and display it in an editable form and then update records. I can search and display data in a form. But when I am trying to update data not going to the database. If any one can help me please have a look … | |
{"session_id":"-4y6g2ck_gEU2mvsFY0oZQ","propid":"7169","avail":"2","calendararray":["2013-11-13","2013-11-20","2013-11-27"]} | |
<?php $con=mysqli_connect("localhost","root","","trial"); if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } if(isset($_POST['submit'])) { $billno=$_POST['billno']; $doa=$_POST['doa']; $dod=$_POST['dod']; $dbcd=$_POST['dbcd']; $acno=$_POST['acno']; $dosub=$_POST['dosub']; $suby=$_POST['suby']; $dop=$_POST['dop']; $credate=$_POST['credate']; $paytype=$_POST['paytype']; $sql="UPDATE cust SET doa ='$doa', dod = '$dod', dbcd='$dbcd', acno='$acno', dosub='$dosub', suby='$suby', dop='$dop', credate='$credate' ** WHERE billno = '$billno'";** print $sql; if (!mysqli_query($con,$sql)) … | |
Hi everybody, my name is Andrea, I'm Italian and I stopped getting dru... OPS! Wrong thread. :D I am a PHP Developer, nice to meet you all! Best | |
<?php $con=mysqli_connect("localhost","root","","trial"); if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } echo "<table border='1' style='border-collapse: collapse;border-color: silver;'>"; echo "<tr style='font-weight: bold;'>"; echo "<td width='200' align='center'>Customer</td><td width='200' align='center'>Amount</td>"; echo "</tr>"; if(isset($_POST['submit'])) { $custype = $_POST['custype']; $from = $_POST['from']; $to = $_POST['to']; echo "<br><br>"; echo " <h2> Grand … | |
Can the database of a phpBB forum be transferred across to run under vBulletin, without losing memberlists, post history and so forth? | |
Sir I have following codes <?php // Connection variables $host = "localhost"; $username = "root"; $password = ""; $db_name = "phonebook"; $con = mysql_connect($host, $username, $password, $db_name); if (!$con) { echo ('<script type="text/javascript">alert("Error Connecting to database")' . mysql_connect_error($con) . '</script>'); } $result = ""; $username = ""; $password = ""; … | |
I want to search data base by input date given by user in php my sql How to do it? Regards | |
While it may certainly seem "lazy" I spend a large portion of my time in javascript and I like the syntax for arrays. I cant seem to figure out if I can "prototype" the array "object" and give it methods that simply returns the appropriate function: i.e. $aMyArr = array(); … | |
How to send email from localhost in php? i have also configured php ini file and send email file but i have the error when i run this program--- Warning: mail() [function.mail]: SMTP server response: 530 5.7.0 Must issue a STARTTLS command first. sy10sm34464318pac.15 - gsmtp in C:\xampp\htdocs\reena\mail.php on line … | |
I am trying to write a multiline string into a text file but it does not appear as multi-line text. Here's my code $hostname = "localhost"; $username = "root"; $password = "sample"; $dbname = "code"; $code = <<< THECODE ; This is the main configuration file for your web app … | |
Hi I am new to PHP I want to create drop down list in form where user can type any other thing if he does not wish to select from drop down. Pl Help Dr Damle | |
Hi , I want to create search field as same like google search but not using API its using database. When i typpe 'R' in input field related to 'R' country name should show in dropdown brom database using php , ajax . Please can you send me the source … | |
Sir, I am using these codes <?php if(isset($_POST['login'])){ require_once("connect.php"); session_start(); // username and password sent from Form $myusername=addslashes($_POST['username']); $mypassword=addslashes($_POST['password']); if(empty($myusername) || empty($mypassword)) { echo '<script>alert("User name and password must not be empty")</script>'; }else{ $query="SELECT name FROM admin WHERE mobile='".$myusername."' and password='".$mypassword. "'"; $result=mysql_query($query); if(!$result) { echo "<script>alert('username, password query is … | |
i want to upload multiple image in php.am getting image path like (image.jpg,image2.jpg,etc..).it is possible to split the path and upload each file to folder...can anyone help me with code. | |
I am using below query for fetching result using union of two tables. I am trying to get total number of records after union of two tables Need Suggestions. ` SELECT a.* FROM svn_headline a where a.newstypeid=2 UNION SELECT b.* FROM svn_crimenews b where b.newstypeid=2 order by newsdatetime desc SELECT … | |
Hi,please help me. I have a textbox called txtUsername, also have one called txtEmpID. what im looking for is a simple way for txtempid can get updated automattically based one what i type in txtusername. Thank you | |
Hello i have a simple question and i need a simple solution I have a javascript file named a pricing.js which contains this content in it var price_arr = new Array('$ 16.95','$ 30.95','$ 49.95','$ 70.95','$ 99.95','$ 109.95','$ 139.95','$ 155.95','$ 199.95','$ 460.95'); but i want to to update this part of … | |
Hello since cereal helped me out with the price and counting in PHP i need just one more thing, to get the names of the products i have tryed different ways to do it by my self but i just cant cause im begginer with PHP language, i have this … | |
Hi, please help me. I want to generate graph based on my data in database. User can pick the date or month or year then the graph will be generate. | |
Hello guys, I am doing a Friend system on my website, and I did the friend request, to accept, but the friends list isn't alright in some part of code because it isn't take the correct id, anyone can help me? 1. <?php 2. 3. $users = $_SESSION['username']; 4. 5. … | |
Hello, i'm new in PHP so i dont know much about it so ill need a little help with this "eazy" problem. I need to calculate the total price of the items on every "checkbox" check. here is my code: <?php $mikrobranova = 3999; $smasina = 4999; $amasina = 9999; … | |
What's wrong with this code: <?php include('include/con_database.php'); $result2 = mysql_query("SELECT * FROM banner ORDER BY DESC"); while ($data2 = mysql_fetch_array($result2)){ echo '<td>'.$data2['images'].'</td>'.'<br>'; } ?> Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\xampp\xampp\htdocs\IndonusaCMS\index.php on line 39 Line 39: while ($data2 = mysql_fetch_array($result2)){ | |
please am new to database management but the question i have a form for my input by new users but i want to get the user name and password from the form to create new priveleges to the database so that when the user log-in the next time his username … | |
( ! ) Parse error: syntax error, unexpected $end in E:\wamp\www\IndonusaCMS\admin\index.php on line 544 IndonusaCMS/admin/index.php ?> </div> </div> </body> </html> <? } ?> Line 544 is the last blank line. What should I do to fix the error? | |
//CODE to handle uploads function do_upload($data) { $objResponse = new xajaxResponse(); $config['upload_path'] = './photos/'; $config['allowed_types'] = 'gif|jpg|png'; $config['max_size'] = '100'; $config['max_width'] = '1030'; $config['max_height'] = '773'; $this->load->library('upload', $config); if ( ! $this->upload->do_upload($data['userfile'])) { $error = array('error' => $this->upload->display_errors()); //$objResponse->Assign("ajax_div", "innerHTML",$this->upload->display_errors()); $objResponse->Assign("ajax_div", "innerHTML",$this->upload->display_errors()); } else { $data = array('upload_data' => $this->upload->data()); … | |
Hello All, I am getting error "*You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1*" on running my php script. My SQL Syntex is: $query = "SELECT (movie_name,movie_year,movie_director,movie_leadactor,movie_type,movie_running_time,movie_cost,movie_takings) FROM movie … | |
<table width="700" border="1" bordercolor="#FFFFFF" bgcolor="#000000"> <tr bgcolor="#FFFF66"> <td height="28" colspan="3" align="center"><strong> My Blood Pressure Data</strong></td> </tr> <tr bgcolor="#FFFFFF"> <td>Date:</td> <td>:</td> <td><?php echo $row["date"];?></td> </tr> <tr bordercolor="#FFFFFF" bgcolor="#FFFFFF"> <td width="170">Select a time(12Hours)</td> <td width="3">:</td> <td><?php echo $row["time"]; ?></td> </tr> <tr bordercolor="#FFFFFF" bgcolor="#FFFFFF"> <td>Systolic mm Hg</td> <td>:</td> <td><?php echo $row["systolic"]; ?> </td> … | |
this is my selection option database from "lecturer" table from subjects No. subject credit_hour capacity 1 (111) AAA 3 20 2 (222) BBB 4 10 3 (333) CCC 3 30 This is my option which is displaying the option using ajax which is testing1.php <?php $conn = mysql_connect('localhost','root','password'); mysql_select_db('lecturer'); if … | |
hey guys so im doing a really simple sign up form but its not working. maybe im doing smtg wrong. form: <form method="post" action="PersonalDetails_Process.php"><!--link to DB--> <br> <h1><center>PERSONAL DETAILS</center></h1> <br> <br> <label>Name <span class="small">Add your name</span> </label> <input type="text" name="name" id="name" required /> <label>Phone <span class="small">Add your phone</span> </label> <input … |
The End.