Posts by urtrivedi Page 6

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: PHP script performing duplicate inserts

seesion and post are fine, add cookie checking to ur condition

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: PHP Form Handler not detecting $_POST?

I suggest you
1) give name and id to forms
2) put button as simple button and not as submit button
3) on click on button submit speicifi form using javascript

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: PHP script performing duplicate inserts

post submit will onways create admin on on refresh always
but cookies can be different on all refresh

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: Javascript .innerHTML

yes

Web Development html-css javascript

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: PHP script performing duplicate inserts

it happned to me , when i refresh page, as many times i refresh, it inserts, so I used cookie to stop this duplicate inserts

1) on button submit i set cookie variable to 0,
2) on proccess page code, i check if cookie is =0 then allow insert else do not allow
3) after insert set cookie vairalbe to 1, so on refresh, its do not go in insert code.

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: Javascript .innerHTML

you can swap i think,change syntax accordingly pls

var savevalue=document.getElementById("serverData").innerHTML;


document.getElementById("serverData").innerHTML = newvalue;

document.getElementById("serverData").append(savevalue);

Web Development html-css javascript

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: PHP Form Handler not detecting $_POST?

you must also pass manage variable in your post

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: PHP Form Handler not detecting $_POST?

come to shoutbox

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: PHP Form Handler not detecting $_POST?

what is name of ur html file and handler file?

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: Javascript .innerHTML

try to get jquery. append function, it wil add to exiting content

Web Development html-css javascript

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: Update with multiple inner joins

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 was made to old address. So you will loose history, that where were the consigment delivered in past.

It is good to pickup new address from customer table while taking new order and not to change address of past orders.

Databases mysql sql

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: Highcharts with PHP

there is nothing specific about language you use, only you have to loop and echo your data at proper placec using php tags
http://blueflame-software.com/blog/using-highcharts-with-php-and-mysql/

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: How to show excel sheet in HTML DIV tag

you have to use excel library develped in php, then you can data show in divs. refer that link

Web Development html-css

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: What is the code for a Jello Design (HTML)

<img src='your_image.jpg' width=20px height 30px>

UI / UX Design html-css web-design

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: Displaying Data from Mysql to a already designed web page

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>

Web Development html-css mysql php

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: How to show excel sheet in HTML DIV tag

https://github.com/PHPOffice/PHPExcel/wiki/User%20Documentation%20Reading%20Spreadsheet%20Files

Web Development html-css

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: Rename dropdown file

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 web user have permission to access that directory to rename

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: adding dynamic generated textbox value to database

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 back error or sucess message to first page

Web Development mysql php

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: compare and echo

Cereal gave you 100% solution, it will print both check and not checked values

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: id is not passing to another page

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

Web Development javascript php

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: multiple execute query problem

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) ;

3) for multiquery you must keep mysqli_mutli_query($conni,$word) outside for loop

.
.
.
.
      $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() );";
 } // for loops ends here                                                                          
 mysqli_multi_query($conni,$word);

Web Development php sql

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: mysql_num_rows() error

You must use single quote around $name

"SELECT * FROM asset WHERE name = '$name'"

Web Development mysql php

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

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

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: Page not loading, no errors in log

check for syntax error in all php pages you included in ur above php file

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: saving real time data in database

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>

Web Development mysql php

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: How to calculate count result ?

SELECT MemberID, 
         COUNT(MemberID)  cnt
    FROM YourTable 
GROUP BY MemberID
order by cnt desc 
limit 0,1

Web Development php

simplypixie commented: Don't answer someone else's question when they have hijacked a thread -2

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: Trying to sum numerous items in an inner joined query

can you post sample data with 5-10 records and expected sample output from same data. give sample with multiple items with multiple orders with mutliple days

Databases mathematics mysql

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: Exclude Specific row when exporting data from HTML table to excel

<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 Test</th>
              <th width="10%">Initial Training Date</th>
              <th width="10%">Annual Competency Date</th>
              <th width="10%">Competency Type</th>
              <th width="1%">Next Competency Date</th>

            </tr>
          </thead>
          <tbody width="100%">
          <?php 
           include_once('database.php');
           $pdo = Database::connect();
           $sql = 'SELECT * FROM competency';

           foreach ($pdo->query($sql) as $row) {
                    $id = $row['staff_id'];
                    echo '<tr>';
                        echo '<td width="10%">'. $row['staff_id'] . '</td>';
                        $sql1 = "SELECT *FROM staff WHERE StaffID='$id'";
                        foreach($pdo->query($sql1) as $res)
                        {
                            echo '<td width="10%">'. $res['StaffName'] . '</td>';
                        }
                    echo '<td width="10%">'. $row['location'] . '</td>';
                    ?>
                        <td width="10%">
                        <?php
                             $s = $row['poct_test'];
                             $val = explode(" ",$s);
                             for ($i=0; $i<sizeof($val); $i++)
                             {
                                 $v = $val[$i];
                                 echo $v."<br/>";
                             }
                        ?>
                        </td>
                <?php
                    echo '<td width="10%">'. $row['date_of_initial_training'] . '</td>';

                        echo '<td width="10%">'. $row['annual_competency'] . '</td>';
                            echo '<td width="10%">'. $row['type_of_competency'] . '</td>';
                                echo '<td width="1%">'. $row['next_competency'] . '</td>';



                        echo '</td>';
                    echo '</tr>';
           }
           Database::disconnect();
          ?>
          </tbody>
    </table>
        </div>
        </div>
    </div>
</div>

You need to remove line 21 from your code and all lines from line 59 to 67

Web Development html-css javascript javascript-jquery php

mushahidh commented: I just want to exclude the action column when exporting to excel. you didn't get my point. +0

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: Oracle to mysql database mirroring

When we update data from mysql to oracle
We used to kept one flag in mysql table say record_status=U when there in any change in record in mysql
So cron will look for such records where record_status ='U' and only those record is updated in oracle.
After updating oracle this flag is set to NULL

Same way when mysql have new record, record_status is set to I and after inserting such record to oracle flag is again set to NULL

Databases mysql oracle

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: Trying to sum numerous items in an inner joined query

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

I assume that your listing table have multiple entries for item_sdb_id for each day.
So I am diving that day average list price with the total quantity of that day

Databases mathematics mysql

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: How can learn PHP

http://www.w3schools.com

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: How to display data using two tables with same column

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' "

Databases display mysql

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: Password is not going to email

action="" is missing
where is action page which acutally sends mail

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: Oracle to mysql database mirroring

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 (on web interface) (1 script per table). this script connect to both mysql and oracle
3a) small tables are delete completely and all records are updated from oracle to mysql
3b) large tables are checked for update or insert and only those records are updated or inserted to mysql
3c) same way some table are updated from web and oracle depending on last update

4) we schedule all cron script to run at night (once in 24 hours)
5) at last we run one more php script which compares number of records in both databases, if any mismatch found in any table mail is sent to administrator.

Databases mysql oracle

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: how to delete multiple large tables data concurrently ...

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.

Databases oracle

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: data getting from database with checkbox onclick using ajax

post your work so far,
later you cant use jquery to fetch data without reloading whole page

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: How does PHP format a table?

you need to learn embeeding php code with html to show dynamic data.

what u mean by google database?

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: 1064 - You have an error in your SQL syntax

enum needs values to be passed

Web Development mysql php

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: javascript calculation when user did not entered few rows

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);

Web Development javascript

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: Select 2 numbers before a letter - Query Access

u want to insert or select?

Databases

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: Live updating table for elections?

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 which will send request to server every five minutes and updates the result section of your page. And json is good format to send/read

Web Development

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: Array in mysql query

Can you post your table structure.

Instead of join you may try implode, see how it works

Web Development mysql php

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: no error but empty results when table has entry

In the begning of your page add 2 lines, It will show error if any

error_reporting(E_ALL); 
ini_set("display_errors", 1);

Web Development mysql php

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: Local Database but its Online?

you need to have real ip, then firewall and dns seetings

if you can do all this then you can publish your system to online world

Databases

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: Local Database but its Online?

www.0fees.net

this is one of the free domain abailable, register and have your free online server with name like

eospaks.0fees.net

Databases

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: what is the difference?

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.

Web Development javascript

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: Php sessions in all pages error

its loooks like configuration of session in php.ini

session cookies are need to set, session directory must be writable by script and other issues.

you read that link?

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: Php sessions in all pages error

http://stackoverflow.com/questions/8976930/php-session-not-saving

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: Php sessions in all pages error

in other pages where it is not working u say,

After session_start();

add following lines

echo "<pre>";
print_r($_SESSION);
echo "</pre>";

See what is output

Web Development php

urtrivedi 276 Nearly a Posting Virtuoso

11 Years Ago

Re: redirecting to next page

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.

Web Development java-jsp