I have a simple many-to-one relationship: public class Company { public IEnumerable<User> Users { get; set; } public int Id { get; set; } } public class User { public int CompanyId { get; set; } [Required] public Company Company…
so i want to php artisan migrate:fresh but i get this error Base table or view already exists: 1050 Table 'roles' already exists even if i drop the database from phpmyadmin, clean the cache and create the database again it…
I have a php script that runs every 20 minutes (I use screen on Debian - server side), The php script selects the first row of the Database using LIMIT 1, like: $q = mysqli_query($connection,"SELECT * FROM table_name LIMIT 1");…
I currently retrieve data from a database and store it in a data list. One of those items is a bytes value that is used to display an image. The code works, however, when there is no image available, I…
Essentially I want to order by "title", while grouping movies with the same, non-NULL "series_id" together within that order. Titles where series_id IS NULL should order by title only, while non NULL series_ids should order by "series_order" and be listed…
Here lists a payment history of a customer in a db table CustomerId PayId FeePaid xx-yy-zz 37 0 xx-yy-zz 32 0 xx-yy-zz 31 30.00 xx-yy-zz 28 0 xx-yy-zz 26 0 xx-yy-zz 18 35.99 xx-yy-zz 17 0 xx-yy-zz 16 0 xx-yy-zz…
I have a local WordPress site running on MySQL. I wanted to move it to a server for testing and deployment. In addition to migrating new/changed code and media files, I exported the database from my local machine to a…
I have a DB table named 'affiliate_wp_coupons' where has 3 cols and they are; coupon_id affiliate_id coupon_code I have coupon_code which is coming from a variable, not static. Now I wanted to query the associated affilaite_id value based on the…
I have an associated array saved in my database that Im saving to a variable called response_cost using the Wordpress function get_post_meta. $response_cost = get_post_meta( $postID, $metaKey, true ); The array looks something like this: a:2: { i:0;a:3: {s:4:"type";s:6:"months";s:4:"cost";s:0:"";s:8:"modifier";s:1:"=";} i:1;a:3:…
There are two tables: address and person. person_id (primary key, autoincrement) is a foreign key to address. I am trying to add an address record and person record from the same form but am getting this error. Uncaught Error: Attempt…