Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
100% Quality Score
Upvotes Received
5
Posts with Upvotes
5
Upvoting Members
4
Downvotes Received
0
Posts with Downvotes
0
Downvoting Members
0
1 Commented Post
0 Endorsements
Ranked #2K
~28.5K People Reached
About Me

WordPress Consultant & PHP Developer

Interests
CSS, XHTML, PHP, C++, Linux, Shell Scripting
PC Specs
2.53GHz Intel Core 2 Duo, Mac OS X (10.7), 4GB RAM, 320GB HD
Favorite Forums
Favorite Tags
php x 105
mysql x 60
pdo x 19
seo x 8
ajax x 7
Member Avatar for joshmac

I have a function that I need help with. The purpose of the function is to sort an array of objects by field. This function was using the PHP function create_function which is now deprecated in PHP 7.2. I've been trying to rewrite the function, but the results return null. …

Member Avatar for jkon
0
467
Member Avatar for EMP01616

help please.. guys this is just the only problem in my program i cant print my data from sql..i need my thesis to finish soon..help please.. heres my code <?php require('fpdf.php'); $fullname = ""; echo $contractno = $_REQUEST['contractno']; echo $sname = $_REQUEST['sname']; echo $fname = $_REQUEST['fname']; echo $mi = $_REQUEST['mi']; …

Member Avatar for cereal
2
7K
Member Avatar for joshmac

Hello, everyone. I need help with something, and I am hoping that someone could point me in the right direction. Since I am not sure what the technique is called, I will try to explain what I need to the best of my ability. I am trying to create a …

Member Avatar for joshmac
0
867
Member Avatar for joshmac

I am hoping that someone can point me in the right direction for this. I have a system that has default .po/.mo files located here: *./app/lang/es_ES/LC_MESSAGES/default.mo/.po*. The system has a plugin system where the plugin's .po/.mo files could be loaded here as an example: *./app/plugins/helpdesk/languages/es_ES/LC_MESSAGES/helpdesk.mo/.po*. As you can see, they …

Member Avatar for joshmac
0
140
Member Avatar for joshmac

I am trying to integrate elFinder and TinyMCE using the advanced method found here: https://github.com/Studio-42/elFinder/wiki/Integration-with-TinyMCE-4.x When I click the image icon in TinyMCE, elFinder will appear in a popup window, and when I double click on a file in elFinder, it should include it in the editor. However, the following …

Member Avatar for Taywin
0
568
Member Avatar for joshmac

As it stands, the data elements are submitted to the database. But I need help figuring out two things: one, is how to show the new deptCode in the dropdown list of deptCodes and two, how can I clear the form after a successful submit? Below is the code that …

Member Avatar for diafol
0
302
Member Avatar for joshmac

I am not sure if this is possible or not, but I need help writing a query for a running balance report. I tried a few queries on my own; I've come close but not exactly what I need. For convenience, I've created an sqlfiddle: [Click Here](http://sqlfiddle.com/#!9/caa5c) The report needs …

Member Avatar for joshmac
0
1K
Member Avatar for joshmac

I am trying to come up with a query to track a student cohort based on their start term. I want to see if the number of students that started in 2012 actually go down in 4 years time. For this example I am starting with fall 2012 (12/FA). I …

Member Avatar for joshmac
0
201
Member Avatar for joshmac

I was wondering if the following was possible with a query? If so, can someone give me an example query? I want to print a list of products, group them by color, and then have the totals at the end of each group. | Color | Product | ------------------- | …

Member Avatar for joshmac
0
127
Member Avatar for Phaelax

I'm making a kind of address book thingy and seem to have confused myself on the best way of organizing the tables. At the moment, I have two tables, Contact and Number. Here's a basic representation of my tables: ___________ | Contact | |-----------| | cid | | fname | …

Member Avatar for joshmac
0
129
Member Avatar for msz900

I have an issue in select query. I want to select total_comment From comment table and show it under each post. **What I Try** SELECT SUM(total_comment) AS comment FROM user_comment INNER JOIN post ON user_comment.image_id = post.id WHERE status = 0 **And** SELECT SUM(total_comment) AS comment FROM user_comment WHERE status …

Member Avatar for Santanu.Das
0
226
Member Avatar for joshmac

I am trying to do a check to see if a student meets the prerequisite before they can register for a course section. CourseSecID = 27 (ID of the course section the student wants to register for.) What I am doing is querying the student's acad cred records to see …

Member Avatar for joshmac
0
229
Member Avatar for joshmac

Hello, I need to run a report against a database, and I am having a difficult time thinking of a way to run a particular report. What I need to do is run a report which selects students that have no course registrations for three consecutive semesters. The semester table …

Member Avatar for rch1231
0
183
Member Avatar for vishalonne

Hello Below is the schema with sample data of table es_preadmission ![b3b82faffc743e08d6d6329b3a7b956d](/attachments/large/2/b3b82faffc743e08d6d6329b3a7b956d.JPG "b3b82faffc743e08d6d6329b3a7b956d") I am trying to get the number of male and female students from each categories (GEN, SC,ST,OBC), bpl, sgc, handi,ser_cat class wise. Example class 1 => GEN => Male = 3, class 1 => GEN => Female …

Member Avatar for joshmac
0
524
Member Avatar for joshmac

I am tring to perform a calculation in my query. I've been working on it for hours, so I need another pair of eyes to see what I am missing. Everything in the query is working except for the g.courseFee part. The course fee is not being added to the …

Member Avatar for joshmac
0
208
Member Avatar for joshmac

I have some code that I edited for importing csv into mysql using PDO to bind parameters. I thought it was working before, but tested it again and the issue I have is that only one line (the fourth line) of the csv file is getting imported. The first line …

Member Avatar for joshmac
0
355
Member Avatar for daniel.conlinjr.1

Is there a program for mac that i can use to connect to my mysql Database instead of opening Fire fox and going in and logging in??

Member Avatar for Mark_3
0
349
Member Avatar for joshmac

I am trying to copy data from one database table to another. Below is the MySQL syntax I am working with: $array = []; $q1 = DB::inst()->select( "stu_term" ); foreach($q1 as $r1) { $array[] = $r1; } $bind = [ ":stuID" => $r1['stuID'],"termID" => $r1['termID'],":level" => $r1['level'] ]; $q3 = …

Member Avatar for joshmac
0
199
Member Avatar for joshmac

I have this search method that doesn't seem to work, and I am not sure why. I need an extra pair of eyes to see why my search query brings back false results. Thanks in advance. public function search($data) { $person = $data['person']; $bind = [ ":person" => "%$person%" ]; …

Member Avatar for joshmac
0
938
Member Avatar for joshmac

I am not a jquery guru in any sense, so I am seeking some help with the below code. What I am trying to do, is populate two input fields, based on what is selected from a dropdown field via a database call. When I select a term from the …

Member Avatar for joshmac
0
968
Member Avatar for joshmac

I have a query in which I insert data with json_encode(), and I am trying to receive that data with json_decode(), however, I get an error message that is something like this: stripslashes() expects parameter 1 to be string, array given in I have this database table that has about …

Member Avatar for joshmac
0
596
Member Avatar for joshmac

I few weeks ago, I posted some code that I need help converting to MySQLi, now I need some help converting it to PDO. The code allows you to enter queries and commands and brings back the column headings and the information that I am looking for into a table. …

Member Avatar for joshmac
0
3K
Member Avatar for joshmac

Hello, there is a small php script that I am converting from using mysql to mysqli, but I am having a bit of an issue with mysqli_fetch_fields (this is where I assume the problem lies). Basically it is a form that allows someone to enter free form queries in order …

Member Avatar for joshmac
0
259
Member Avatar for joshmac

I am using a framework, and I am having an issue with getting the results of this particular associative array. All others work except for this one and I am not sure why. This one only returns one result. Here is what I have in my model: public function listStats($id) …

Member Avatar for joshmac
0
222
Member Avatar for joshmac

I am having a devil of a time trying to get my arrays to print right, but I am missing something. I am hoping another set of eyes can help me figure it out. I have this current function: function getArrayUsers($id) { $sql = DB::inst()->query( "SELECT * FROM " . …

Member Avatar for joshmac
0
278
Member Avatar for joshmac

I am getting the error message "Invalid argument supplied for foreach()". I can't see to figure out what. Below is my query. Is there something I'm missing? Thanks public function editRole($id) { $q = $this->_db->query("SELECT * FROM `" . TP . "roles` WHERE `ID` = '" . floatval($id) . "' …

Member Avatar for pritaeas
0
197
Member Avatar for dancks

Hey guys its me again: Basically everything on this page, at least the parts I'm able to test, are working, problem is addproduct.php is supposed to print errors when error checking the form and repopulate the data fields with the previously submitted data. I'm doing this by populating $_SESSION. addproduct.php: …

Member Avatar for gavinflud
0
407
Member Avatar for joshmac

I have a plugins system with update notification. The update notification works, but I made some changes so that the script will execute every hour instead of everytime the page loads. This is handled by the (time() + 3600) being written to a check.cfg file. I wanted to to cut …

Member Avatar for joshmac
0
192
Member Avatar for nil_gh_80

Dear members, I'm in serious problem. I need a tool which can get all content information of a website and at the end these information will produce a CSV. That CSV will be imported in another database...can anyone help me regarding this issue..

Member Avatar for Rockabilly75
0
152
Member Avatar for joshmac

Ok, so I finally was able to convert my framework to the PSR-0 standards, but now I am getting errors in the sample application that I have not been getting before. I am not sure why, so I need a fresh pair of eyes. Any help is greatly appreciated. The …

Member Avatar for joshmac
0
209