1,257 Posted Topics
 | UPDATE TABLE_1 LEFT JOIN TABLE_2 ON TABLE_1.COLUMN_1= TABLE_2.COLUMN_2 SET TABLE_1.COLUMN = EXPR WHERE TABLE_2.COLUMN2 IS NULL This is sample query refer following link http://dev.mysql.com/doc/refman/5.0/en/update.html But I would suggest that you should not update address in delivery, that will changes all address in delivery table of same customer even if delivery … |
 | php code can be embeded anywhere in your page u need <?php //in begniing of page you can get values from server and databaase $var1="somevalue" ?> <html> Value is <?php echo $var1; ?> </html> |
 | 1) you just try to find values that it post echo "<pre>"; print_r($_POST); echo "</pre>"; 2) ALSO GIVE NAME TO your text box and use same name when renaming <input type=text name='newname'> . . . $new=$_POST['newname']; 3) I think you have to keep directory name with filenames and ensure that … |
| | https://github.com/PHPOffice/PHPExcel/wiki/User%20Documentation%20Reading%20Spreadsheet%20Files |
| | 1) in your html form , you have to create form elements, with all text boxes and update button 2) on update submit form to say process.php page 3) capture all submited html values using global $_POST or $_GET array 4) write insert/udpate query code in process.php page 5) send … |
| | you run regstate.php?id=28 (chose any value that is valid) in browser, see what is output? Fisrt check problem is in javsccript or ur process page itself |
| | |
 | 1) You must concate $word. In your code u assiging new query $word .= "INSERT INTO relation_mu_and_unit (id_drug, id_unit, priority, value, harga1, harga2, harga3, last_edit) VALUES ( $id_drug,$id_unit, $i, $value, $harga_1, $harga_2, $harga_3, NOW() );"; 2) mysqli expects connection first then query, make sure you create mysqli connection. mysqli_mutli_query($conni, $word) … |
| | You must use single quote around $name "SELECT * FROM asset WHERE name = '$name'" |
| | Here is sample json example, I hope you get something from it. [CODE]<html> <body> <h2>Create Object from JSON String</h3> <p> First Name: <span id="fname"></span><br /> Last Name: <span id="lname"></span><br /> </p> <script type="text/javascript"> var txt = '{"employees":[' + '{"firstName":"John","lastName":"Doe" },' + '{"firstName":"Anna","lastName":"adSmith" },' + '{"firstName":"Peter","lastName":"Jones" }]}'; obj = JSON.parse(txt); document.getElementById("fname").innerHTML=obj.employees[1].firstName … |
| | We do same in our enviroment. Following is our case 1) out of 100% tables in database, we need just 20% tables to show on website.5% are to be updated back to oracle. 2) We create similar data tables in mysql. 3) we set up cron job in php script … |
| | Re: Need Help <?php echo $value='myname'; ?> Name<input type="text" name="text1" value="<?php echo $value; ?> >"> You can learn more on www.w3schools.com |
 | check for syntax error in all php pages you included in ur above php file |
| | instead of span you must use form element like text or hidden hidden is best for your case your element must be in between form tag <form> . . . <type =hidden id=year name =year value='<?php echo date("Y"); ?>'> </form>  |
| | SELECT MemberID, COUNT(MemberID) cnt FROM YourTable GROUP BY MemberID order by cnt desc limit 0,1 |
| | select year(created_at) as year, month(created_at) as month, day(created_at) as day, item_sdb_id, price_per_unit from (select l.item_sdb_id, avg(l.list_price) / sum(l.quantity) as price_per_unit, l.created_at from listings as l inner join purchases as p on l.purchase_id = p.id where l.item_sdb_id and p.created_at > '2013-07-09' group by l.item_sdb_id,l.created_at) as t1 group by year, month, day … |
| | <div class="row" style="margin-left:20px;"> <div class="grid_4"> <div class="da-panel collapsible"> <input type="button" class="btn btn-success" onclick="tableToExcel('testTable', 'W3C Example Table')" value="Export to Excel" style="float:right"> <div class="da-panel-content"> <div class="da-panel-title" style="border-top:1px solid #ccc;border-bottom:1px solid #ccc"> <h3 style="padding-left:10px;font-weight:bold;">Staff Training Information</h3></div> <table class="da-table da-ex-datatable-numberpaging" id="testTable" width="100%"> <thead width="100%"> <tr> <th width="10%">Staff ID</th> <th width="10%">Name</th> <th width="10%">Location</th> <th width="10%">POCT …  |
| | |
| | action="" is missing where is action page which acutally sends mail  |
| | Only you need one query as following $state_id=$_REQUEST['state_id']; $query="select tbl_city.city_name,tbl_states.state_name FROM tbl_city INNER JOIN tbl_states ON AND tbl_city.state_id=tbl_states.state_id where tbl_states.state_id='$state_id' "  |
| | you need to learn embeeding php code with html to show dynamic data. what u mean by google database? |
 | you can create procedure in backend delete from a; delete from b; delete from c; commit; Put that code in proper oracle procedure syntax, also make sure sequence of table must also according to the foreign key relation among them. I mean delete detail table first then master afterwards. |
 | You need to use parsetFloat function everywhere http://www.w3schools.com/jsref/jsref_parsefloat.asp nValue12 = paserFloat(document.getElementById("noofnights6").value); nValue13 = parseInt(document.getElementById("rate6").value); |
| | post your work so far, later you cant use jquery to fetch data without reloading whole page |
| | enum needs values to be passed |
 | |
| | change your line no 10 [code] $i = 0; [/code] set $i to 1 [code] $i=1; [/code] |
| | Can you post your table structure. Instead of join you may try implode, see how it works  |
| | Though once you update data, any new request to your page will present current data only But somebody is monitoring page, then need to refresh the result section automatically. For that jquery request can be sent very few mintes say, 5 mintes. You can set timer function in your page … |
 | In the begning of your page add 2 lines, It will show error if any error_reporting(E_ALL); ini_set("display_errors", 1); |
| | www.0fees.net this is one of the free domain abailable, register and have your free online server with name like eospaks.0fees.net |
 | window.setTimeout(hello,3000); function hello(){ alert("ju"); } Call back function can not be called , what u have written with () is calling function. Just pass name of function. |
 | |
 | I am not sure about jsp, but I put exit statement after header redirection line. <?php header("location:gopage.php"); exit; ?> So Try to exit the page with proper syntax, I hope that will work.  |
 | function validate(form, minlength, maxlength) { var userInput = form.elements[0].value if(userInput.length >= minlength && userInput.length <= maxlength) { return true; } else { alert("Please input between " + minlength + " and " + maxlength + " characters"); return false; } } <-- this is missing |
| | in your login.php , add 2 line before if function, do it show 1 or not $row=mysql_num_rows($result); echo "total rows ->" .$row "<-"; die('stop'); if($row==1)  |
 | |
 | |
| | I think you should have posted this topic to business exchange forum, You wil find good responder in that forum. |
| | http://www.idevelopment.info/data/Oracle/DBA_tips/SQL/SQL_2.shtml |
| | select ProductID , max(case when AttributeID=1 then AttributeValue else null end) Color , max(case when AttributeID=2 then AttributeValue else null end) Size from tblProductAttribute group by ProductID |
| | $sql = mysql_query("SELECT * FROM `Cater Gid` where Cater like '%$term UNION SELECT * FROM `Cater Food` where Cater like '%$term") ; |
 | Re: sum in php You need to focus on javascript /jquery to make it user interactive. Php will play role at the time of loading or saving from /to server. |
| | Re: [PHP] For Loop create 2 dimentional array $ar[0][0]='Driver`s seat'; $ar[0][1]=''; $ar[0][2]=''; $ar[0][3]=''; $ar[0][4]=''; $ar[1][0]='1'; $ar[1][1]='2'; $ar[1][2]=''; $ar[1][3]='3'; $ar[1][4]='4'; $totrows=count($ar); echo "<table>"; for ($i=0;$i<$totrows;$i++) { echo "<tr>"; for($j=0;$j<5;$j++) echo "<td>".$ar[$i][$j]."</td>"; echo "</tr>"; } echo "</table>"; |
| | I suggest simple keep name tag as following for all file input elements, do not give number in html form. This way you will get file upload array in upload_file.php. you can user var_dump to see how file array is built. Accordingly you can write your code. name="userfile[]" ;//correct name="userfile['01']" … |
 | Yes I felt such problem some times back. Refer this link http://www.rgagnon.com/jsdetails/js-0129.html  |
| | Re: Query resolve give your sample data also for some records, so that we can understand what data your columns hold, |
| | SALES http://www.databaseanswers.org/data_models/car_sales/index.htm SERVICE http://www.databaseanswers.org/data_models/car_svc_center/index.htm |
| | In login page you can check time if userid password is fine and time is between 05:00hr to 10:00 hr, allow user to access pages otherwise disallow If there is no login page. You may put same check in all pages  |
 | Re: PDF edit Adobe acrobat professinal allows you to edit using touch up text tool. You can not format like word doucment but minor changes can be done easily. Acrobat Reader will not allow. I am not sure about any other pdf editor software  |
The End.