Amaina

I have been cracking my head on this mater in the past couple of days. I am faced with a situaton where i need to write a MySQL equivalent of PHP code to loop through sql select results. The Php code looks like this $query = "SELECT pubid, author FROM …

I have checked everywhere in Daniweb to see if this has been asked before but could not find the question. Forgive me if this is too simple an issue and it is my hope that my question is clear. I have an excel worksheet (see attached) with 4 columns. Column …

My question is related to an [answered question](https://www.daniweb.com/programming/web-development/threads/506078/parsing-xml-to-extract-attributes) that was asked here on the ever reliable forum - Daniweb. I have been trying to insert the parsed data as a string into mysql table in vain. This is what i am trying to do..... From the solution in the link …

I have an xml file that looks like this <?xml version="1.0" encoding="UTF-8" ?> <dates> <date> <Item Name="History" Type="List"> <Item Name="received" Type="Date">2015/12/18 00:00</Item> <Item Name="accepted" Type="Date">2016/03/31 00:00</Item> <Item Name="aheadofprint" Type="Date">2016/04/14 00:00</Item> <Item Name="entrez" Type="Date">2016/04/15 06:00</Item> <Item Name="pubmed" Type="Date">2016/04/15 06:00</Item> <Item Name="medline" Type="Date">2016/04/15 06:00</Item> </Item> </date> <date> <Item Name="History" Type="List"> <Item Name="epublish" …

I have been trying to get my PHP script return two different pages namely: get2015 and get2016. The aim is to have these two pages have pagination links below them. To achieve this i have written two scripts in two different files that look like this: file 1 = functions.php …

I have 2 tables that look like this.(see below). Table one is named tableX and table 2 is named tableY. +-------+---------+ | count | post_id | +-------+---------+ | 3 | 7209 | | 3 | 7210 | | 1 | 7211 | | 1 | 7212 | | 1 | …

My last two questions on this great forum have gone un-answered. It is quite frustrating. The questions are on web development.

This question is very similira to this [one](https://www.daniweb.com/programming/web-development/threads/472324/inserting-a-multidimensional-array-into-db) but with a little twist to it. I have an array that looks like this: Array ( [0] => Array ( [post_id] => 5410 [Issue] => 2010 [_Issue] => field_573d7fa8454e9 [_volume] => field_573d7f79ef9ab [volume] => 530 [_journals] => field_56d3de5ddc04d [pages] => 105-9 …

This question is similar to this [one](https://www.daniweb.com/programming/web-development/threads/371092/notice-undefined-index-id-on-line-26) However, my insert does not involve a form but a direct mysql query that looks like this $query2 = "insert into table(author,title,abstract) values(:author,:title,:abstract) "; $stm=$con->prepare($query2); $stm->bindValue(':author', $author, PDO::PARAM_STR); $stm->bindValue(':title', $title, PDO::PARAM_STR); $stm->bindValue(':abstract', $abstract, PDO::PARAM_STR); $stm->execute(); echo "$author &nbsp $title &nbsp $abstract <br>" In …

I want to insert multiple records to wp_posts table in word press using a mysql query and not the front-end. I also want these new records(that i insert into wp_posts) to insert metadata into wp_postmeta table. My question is how can i do this? How does wp_posts update wp_postmeta if …

I have this code session_start(); $username = $_SESSION['username']; function getUserRole($username, $roleid){ $con=dbConnect(); $query="select * from user inner join userrole on user.id = userrole.userid inner join role on role.id = userrole.roleid where username = $username"; $sql=$con->prepare($query); $sql->bindValue(':username',$username); $sql->bindValue(':roleid',$roleid); $sql->execute(); $row = $sql->fetch(); $username = $row['username']; $roleid = $row['roleid']; if($row > 0){ …

I know this is very basic but i am not able to get the fuction return a string. Instead it is returning the value 1. Below is the code: <?php function getUserRole($username, $roleid){ include "data.php"; $con=dbConnect(); $query="select * from user inner join userrole on user.id = userrole.userid inner join role …

I am at my wits end. I have written this query which is aimed at importing my csv data uinto mysql table 'refs' load data local infile '/home/amaina/Documents/march2016.csv' into table refs fields terminated by ',' enclosed by '"' escaped by '' lines terminated by '\n' ignore 1 rows; My pain …

I'm trying to output/write mysql SELECT results to a text file. The SELECT statement results are three records but when i use fwrite to write these results to a textfile, only one record is written. What can i be possibly be doing wrong? Here is the code snippet <?php include …

I have two mysql tables namely tableA and tableB. tableA +-----------+--------------+---------+ | tableA_id | title| month| +-----------+--------------+---------+ |1 | malaria| january | |2 | pneumonia| january | |3 | HIV| january | |4 | tuberculosis | january | |5 | dengue fever | january | +-----------+--------------+---------+ tableB +-----------+-----------+--------------------+---------------+-----------------+ | tableB_id …

I'm at my wits end, perhaps after working non stop for 7 hrs. I'm trying to develop a simple search engine using Php and Mysql. I have borrowed my idea of doing this from a wonderful [youtube tutorial](https://www.youtube.com/watch?v=OPmBJhhuwSM) by nick frosty. Unlike Nick, i'm not doing this the procedural way …

I'm trying to parse a few references from a file and load them to mysql table but keep on getting this error everytim,e i run the script: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the …

hello folks I'm a greenhorn in PHP so excuse me if i'm being dumb. I have set up a page that is pulling records out of a database table, the user viewing the page is intended the choose a number of the records on the page (using checkboxes) and download …

Hi I am working on a project in CSS and xhtml but when i tested the layout on different browsers i identified a problem in positioning of elements. To be precise, the navigation bar renders well in firefox 11 for ubuntu canonical 1.0 but seems not to work in IE, …

I'm a newbie to C. Just wondering if i can create input forms in C. Can i also work with C and MySQL?? as in can i build a system using C and MySQL I guess what i'm asking is what are the effective uses of C as a programming …

hi guys i just got an ubuntu 10.04 lucida lynx installed on my laptop..id like some links on where i can download free ebooks on linux programming.tnx

Dear friends I am creating a php login/register form to register and authenticate users.My problem is that the form does not submit the data in the form to the database.Please see the code below: [code=php]<?Php session_start(); /****************/ //original Amaina......slowly coming of age// include 'dayta.php'; //connect $link = mysql_connect($database_host, $database_user, $database_password); …