Inserting data in a particular column where login id is already present


Inserting data in a particular column where login id is already present



I want to write an sql command in PHP in which I want to insert a data in a particular column having particular data already present in that row.Here is the image where I want to insert 1_day_device to a particular 1_day_id



image



Also, how can I autodelete a row after a certain time? Like, in the image I want to delete one complete row after one day. I am using PHP for server-side.





Seems like you are looking for replace query
– Arvind
Jul 3 at 3:53


replace





See: dev.mysql.com/doc/refman/5.7/en/event-scheduler.html
– fyrye
Jul 3 at 4:11





What have you tried so far?
– fyrye
Jul 3 at 4:13





I am getting data from two different sources. First, I get 1_day_id from one source then I get 1_day_device from another source. Now "996609" should get "bdb*********" but right now it's in another row. Similarly, for id "1595281" I want to insert "3cf4********" in that row.
– Jeetu Routela
Jul 3 at 4:18




1 Answer
1



I think you are looking for the update query with particular 1_day_id. Try with the below query.


UPDATE your_table_name SET 1_day_device='".$device."' WHERE 1_day_data='".$data."'



For delteting the records please follow this link Delete row from database automatically after 24 hours





Please do not use mysql_** based functions, as they are no longer supported, use mysqli_*** or PDO instead. Additionally please reference the use of prepared statements to avoid SQL injection.
– fyrye
Jul 3 at 4:15



mysql_**


mysqli_***


PDO





ok, I have updated my answer
– shubhangee
Jul 3 at 4:16






By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

-

Popular posts from this blog

api-platform.com Unable to generate an IRI for the item of type

api-platform.com Unable to generate an IRI for the item of type I'm trying to setup my first api-platform instance and have run into some presumably noob questions around IDE. What i'm trying to do is setting up an register and reset entity in order to deal with registrations and password reminders from an app. And then have the entity's passed to a custom controller to do some checks, balances and mails afterwards (haven’t gotten around to that yet). But I keep running into this error when posting to my custom entities: { "@context": "/api/contexts/Error", "@type": "hydra:Error", "hydra:title": "An error occurred", "hydra:description": "Unable to generate an IRI for the item of type "AppXXXUserBundleEntityRegister"", "trace": [ { "namespace": "", "short_class": "", "c
Read more

How to set up datasource with Spring for HikariCP?

How to set up datasource with Spring for HikariCP? Hi I'm trying to use HikariCP with Spring for connection pool. I'm using jdbcTempLate and JdbcdaoSupport. This is my spring configuration file for datasource: <bean id="dataSource" class="com.zaxxer.hikari.HikariDataSource"> <property name="dataSourceClassName" value="oracle.jdbc.driver.OracleDriver"/> <property name="dataSource.url" value="jdbc:oracle:thin:@localhost:1521:XE"/> <property name="dataSource.user" value="username"/> <property name="dataSource.password" value="password"/> </bean> But unfortunately the following error message is generating: Cannot resolve reference to bean 'dataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource'
Read more

Display dokan vendor name on Woocommerce single product pages

Display dokan vendor name on Woocommerce single product pages With woocommerce I am using Dokan plugin and I am trying to display the vendor name, rating and vendor location on single product pages. I tried this code to display vendor name but no luck: //show store name add_action( 'woocommerce_single_product_summary', 'show_store_name', 20 ); function show_store_name() { printf( '<b>Seller Name:</b> <a href="%s">%s</a>', dokan_get_store_url( $author->ID ), $store_info['store_name'] ); } Any help is appreciated. 1 Answer 1 I don't use dokan plugin. Here is the way to get the (post) author ID and to make your code work: add_action( 'woocommerce_single_product_summary', 'display_author_name', 20 ); function display_author_name() { // Get the author ID (the vendor ID) $vendor_id = get_post_field( &#
Read more