0
votes
1answer
18 views

How to save information related to post in database?

I created a post-to-email plugin and I need to save something in the database when the post is sent so I don't allow users to send it twice. How do I save this in the database? And how can I retrieve ...
0
votes
0answers
28 views

Unserializeing multiple column values that are stored in one database results variable

Lately i have created a custom template to search for data in a database, and also displaying it, by the use of checkboxes. So, a user can select multiple checkboxes to search data on and the query ...
0
votes
0answers
18 views

Best way to define a database with product codes and back-end support?

First let me explain what my wanted situation is: I have a WordPress site where I want the Admin to have access to about 10.000 "product keys". These codes will be inserted in a database of some sort ...
0
votes
1answer
14 views

Why when I create a new post I found 2 record related to this post into the posts database table?

I am very new in WordPress development and I have a doubt about the WP database table named posts I have observe that when I create a new post (into the WP administration panel) are created 2 record ...
0
votes
0answers
13 views

Custom subscription abandonment

I'm using a subscription service through a small third-party company. I've asked them to consider sending emails to users that drop-off from the subscription but they don't want to implement such a ...
0
votes
1answer
28 views

How to pass username into form that sends data to database

I am trying to pass username to database through form: [insert_php] $current_user= wp_get_current_user(); $id= $current_user->user_login; [/insert_php] <input type="hidden" name="id" ...
0
votes
1answer
72 views

Adding data to custom wordpress database table

I have a form on a page that populates the database table: <table border="1"> <tr> <td align="center">Form Input Employees Data</td> </tr> <tr> ...
0
votes
0answers
22 views

How to connect database table to each registered wordpress user.

When registered user visit certain page, I want him to be able to add some 3 column data to a database that can be retrieved for him later. The way I see it implemented is by automatically adding an ...
0
votes
2answers
82 views

Problems with plugin that fetches data from database with ajax

After some answers I have edited my code. This is my plugin structure stpl1 stpl1.php getuser.php In stpl1.php I have the following code: <?php /* Plugin Name: Wordpress Plugin Stijn 1 ...
2
votes
1answer
163 views

Has anyone tried putting PHP ActiveRecord on Wordpress?

I have worked with Ruby on Rails and I was looking for some code that did something close to the wonderfull RoR's ActiveRecord. I stepped by this site. Its PHP-ActiveRecord! I found it amazing, and ...
0
votes
0answers
11 views

How to migrate the posts from an old custom legacy blog to a new WordPress website?

I have to migrate the posts of a very old custom legacy blog made in ASP (the posts are stored in a MySql table) into a new WordPress blog. So I need your help to find the smartest solution to do it, ...
0
votes
1answer
46 views

Adding custom tables to Wordpress

I have a database which has thousands of rows of data in each of the tables. I would like to migrate this database into a Wordpress website. I would like the user to be able to log in to Wordpress ...
1
vote
1answer
61 views

No wp-config.php file on local install of wordpress - site still displays

I've installed Wordpress locally using XAMPP and this step by step guide by Sunny Johal(Fifth post down on that page). The first time I used the step by step and ran all 3 of the SQL codes(UPDATE ...
0
votes
0answers
81 views

Would manually deleting the dumping data fix a “#1062 - Duplicate entry '1' for key 'PRIMARY'” phpMyAdmin error?

I'm new to PHP! I'm trying to import an SQL database file into myPhpAdmin for a WordPress I'm migrating, but I keep getting this error message: SQL query: `-- -- Dumping data for table ...
0
votes
2answers
2k views

phpMyAdmin error #1062 - Duplicate entry '1' for key 'PRIMARY'

I'm new to PHP! I'm trying to import an SQL file using phpMyAdmin through a GoDaddy cPanel(please don't make fun of me) Here's a full readout -- -- Dumping data for table `wp_commentmeta` -- INSERT ...
0
votes
1answer
54 views

phpMyAdmin displays error when importing database

I'm migrating a WordPress for a friend to a different server. I have already backed up all files and was given a copy of the database by the old server admin. The problem is that when I try and import ...
0
votes
0answers
249 views

Check if values exists DB

I am getting nutts with this one. I want to check if the email introduced in the form already exists in the database before creating a new record. But for some reason the email is empty at search ...
0
votes
2answers
73 views

Duplicate domain database to local - How?

I've noticed that my process is rather slow and i'd like to speed it up. I want to be able to duplicate my database from my domain which is blueharlequin.com and work locally thus speeding up the ...
0
votes
0answers
58 views

How to select from a WP table every 10s in a class (OOP)?

I'm trying to select records every ten 10 seconds from columns message and messagetwo from my WordPress table wp_userlogin, but the code is not being executed. I'm calling wp_schedule_event when my ...
0
votes
2answers
718 views

Different database query in function.php using mysqli

I am trying to connect to a database in the function.php using mysqli. The code seems to run fine when it is not on a separate php file not on wordpress. But when I run it on wordpress I get "Connect ...
0
votes
0answers
42 views

Email notifications: Where in database to save user options?

I'm working on an email notifications plugin which sends emails when events happen on my site. So for example, if someone comments on a post, the post author will receive a custom email notification. ...
0
votes
0answers
11 views

Configuration File Safety [duplicate]

I'm new to PHP and WordPress and I've a few questions to ask about database and configuration file security. I hope you answer them. When I try to reach some wp sites config file by typing ...
3
votes
1answer
296 views

Using Vagrant for customizable Wordpress Multi-sites

Background: My partner and I have a goal to create a customizable vagrant project that uses Wordpress multi site, as a local development environment. Ideal Use Case: Various developers on our team ...
0
votes
2answers
1k views

How to return number of found rows from SELECT query

I wrote a function which is supposed to return the number of rows found in a SELECT query but it always either seems to return 0 or an array. I have been messing around with this for about an hour now ...
0
votes
1answer
198 views

Add row to custom database Table and delete all rows older than 1 day

I'm editing a view counter plugin so that it logs the IP of every user that viewed a post. This is to prevent them from refreshing the page and thus creating artificial views. The part I'm having ...
0
votes
0answers
66 views

Get fatal error when using wpdb in jQuery.post target URL

Why am I getting a Fatal error whenever I use wpdb in the target URL of my jQuery.post? Here is my code so far. My process.php is this: <?php $to = 'myemail@gmail.com'; $subject = ...
0
votes
0answers
58 views

Perform database function in target URL using jQuery.post

I have a popup which gets the users input (name and email) and sends it to a process.php so I can send an email. I pretty much have that done. But I need to add a functionality wherein it will also ...
0
votes
1answer
373 views

what is the use of /wp-includes/SimplePie?

I have this location on my server. /home/localhost/public_html/wp-includes/SimplePie. I have not installed samplepie plugin. What is it used for since it is not associated with samplepie plugin. The ...
1
vote
0answers
134 views

How to track a users progress through pages by inserting data into Wordpress Database?

My website users can learn British Sign Language through Video Tuts, Quizzes and games etc. I would like to track the users progress through the pages of the course and add that data to a Wordpress ...
0
votes
1answer
47 views

Querying multiple meta_keys in Wordpress SQL query

Here's my Query... I'm looking to narrow this query down to users of one specific role ("meta_key = 'wp_capabilities' AND meta_value = 'employee'")...how do I add that additional conditional to this ...
1
vote
1answer
45 views

Wordpress not reflecting changed of the database

my problems started when I moved my website to another folder (from /dev/ to /). I have gone through the whole database in order to change all the hardcoded /dev/ into / but I still notice that ...
0
votes
0answers
32 views

Get posts, terms and custom fields in array

I have a multisite and want all posts from post type products I want to query through the database to get all posts belonging to post type "products" i have accomplished this with the following code ...
0
votes
2answers
47 views

Let users register weight each day and save it in DB

I need a way that lets my users register they're weight (kg) and maybe % of bodyfat and save that information on each user in the DB. Then i need a way to output that number again on the logged in ...
0
votes
0answers
136 views

Getting Poster Image (Thumb) of Video Embedded through JW Player in Feed

I am trying to add the poster image of YouTube video I embedded through JW Player in the post in the RSS Feed. Till now I found these: 1. This Code is working when used separately, it is getting the ...
0
votes
1answer
1k views

How to access data in wordpress database externally using php

I want to share data in specific wordpress database tables with an iOS app. The client wants data entry via wordpress form plugins which create their own tables in the wp database. The plugins I've ...
0
votes
0answers
43 views

Send an email to users reminding them about the event 2 days in advance

In my database, I already have the users list and the events list with their dates and times. How do I send an email to the users list reminding them about the event 2 days in advance? I need it to ...
0
votes
1answer
109 views

Save custom meta box data to database

I have a custom post type Events. Under Events, I have a custom meta box which selects the time and data of the event: <?php $meta_boxes[] = array( 'id' => 'event_date_option', 'title' ...
0
votes
2answers
4k views

Simple form that saves to database

I am using a 3rd party service that does a scrub of my database for new entries within a specific table. However I am been unable to find a simple form plugin that submits data to the wordpress ...
0
votes
1answer
319 views

wpdb prepare insert table doesn't work

I followed the introduction to use prepare to insert some data to the table. The code is like this: $wpdb->query( $wpdb->prepare( "INSERT INTO ...
0
votes
1answer
49 views

select a single val though a table in wordpress

The table is like this: category_id category_name category_parent_name I would like to get category_id by using category_name. I searched online, and the code is like below: $ad_cat is the ...
0
votes
1answer
83 views

MySQL database migration to WordPress

I have a MySQL database established for a web application I have been working on in a non WordPress database. This database has many tables with pre-populated rows for foreign keys etc. which took a ...
0
votes
1answer
59 views

Should I use Wordpress to skin a database website?

I am going to start programming a website which allows users to post adverts for aircraft for sale. (Think autotrader for planes). It will be free to use. There are a few websites that do this already ...
0
votes
0answers
176 views

Save Changes function after table is sorted using jquery

I have a simple table, and the jquery works great for sorting. The fields drags an drops perfectly, and updates then and their. Also of course the data in the fields are saved in a array. The data in ...
0
votes
1answer
104 views

How do I display offsite database info on my wordpress site?

I host some online games from my personal computer which the game saves information to my Mysql database. I would like to display live data (if possible) on my hosted Wordpress site. I know the ...
2
votes
2answers
324 views

How to export/import theme customizer settings?

I am wondering if it is possible to export theme customizer settings(theme_mods) to be imported into another install of the same theme. I know that the settings are saved into the database so I am ...
0
votes
0answers
672 views

Host does not allow remote connection, so how do I transfer data to my WordPress site?

I spent the last week trying to get my PHP code on my website to connect to my remote "personal" computer to display some data on a webpage. I just found out today from my web host (ipage) "our ...
0
votes
1answer
138 views

Trying to post information from a remote database to wordpress page

I'm fairly new to Wordpress and looking for some help. Goal: I would like to stream data from my personal computer's Mysql database and display it on a webpage in my offsite Wordpress hosted site. ...
0
votes
0answers
50 views

MySQL Engine vs. Charset

I am attempting to have my plugin create a new table. I am fairly new to SQL. I have found two different method for creating tables: Method I $table_name = $wpdb->prefix . 'cool_table'; $sql = ...
0
votes
1answer
191 views

Creating Database Table vs. Adding MetaData to Post & User

I am creating some event functionality for my wordpress site. Each event will have a set of tickets associated with it. A user who is purchased at least one ticket will additionally have a set of ...
0
votes
1answer
163 views

Query specific posts per user selections from dropdown menus

This may be a little different than most people do. I'm trying to show certain posts that are determined by 4 different "categories." I have a large database table full of "products" (I'm using the WP ...