PHP - Question About Query Software.
Hey, whats going on. i have been using microsoft access for doing all my queries. And they are pretty complex. One query can be the combination of like 8 tables. Do you think Access is the best program to build and run these queries or do you think there is better software out there for building queries. what do you suggest. It seems like Access cant handle very complex queries. A lot of times i have to break the queries down into 3 or 4 queries. i build one, export it to a csv file and then import it back into Access and build a new query on the new imported file. Please let me know what you think.
Similar TutorialsHi I am having troubles inserting item into a table with a primary key in it.
My problem is that every time I added a row into a table without specifying the primary key, mysql will not add it to the next available id.
For example, I have 5 rows initially and I added 10 rows into my table by using the insert into query. However when I delete the 10 rows and add another row in, the id of the additional row will become 16 instead of 6.
FYI, this is a php page that inserts my data into the table.
Okay, So I'm trying to write a query that will update a certain value in my database, but I want it to update only when 3 conditions are met. Basically, I want to update a column of ints in my DB (mysql) from 0 to a 1, if these criteria are met. 0 and 1 are the only values that are valid in this particular column. dbquery("UPDATE times SET approval = '1' WHERE id = '$id' AND time <= '$currentTime' AND project = '$project'"); that is my query. Now, I'm not even sure if THIS part works. It is however, slightly more complicated in that this query is actually embedded in a foreach loop: $result = $_REQUEST["projects"]; $delimiter - ","; $projectArray = explode($delimiter, $result); foreach($projectArray as $project){ dbquery("UPDATE times SET approval = '1' WHERE id = '$id' AND time <= '$currentTime' AND project = '$project'"); } If you can make any sense of that, and if you can point out any glaringly obvious mistakes here, I would appreciate it. If you need any other information let me know. Thank you all for your help. This topic has been moved to MySQL Help. http://www.phpfreaks.com/forums/index.php?topic=322629.0 I have a query: $query ="select * FROM telephone_admin where name Like ' ".$_GET['answer']." ' "; I would like to add % before and after so that the query will search for result which contains the PHP variable $_GET['answer'] before or after, but the problem is how can I add % before or after ' ".$_GET['answer']." ' within the query?? Thanks! This topic has been moved to MySQL Help. http://www.phpfreaks.com/forums/index.php?topic=328883.0 Ok, I know this is a really simple one, but I haven't done any coding for a couple of month and i'm a bit rusty. I'm trying to add a field from a MySQL query to a Google calendar add button link so I can create a dynamic 'add to calendar' button from my gig list. So on the gig list page that echo's all the dates from the database, I want to add the venue name to the 'text' section of the google URL - Code: [Select] <a href=\"http://www.google.com/calendar/event?action=TEMPLATE&text=VENUE HERE&dates=20060101T000000Z/20060101T000000Z&details=gig%20text&location=gig%20town&trp=false&sprop=www.the-guards.co.uk&sprop=name:The%20Guards\" target=\"_blank\"><img src=\"http://www.google.com/calendar/images/ext/gc_button6.gif\" border=0></a> if I echo the field like so - Code: [Select] echo"{$row['gl_venue']}"; I get the correct result - I just can remember how to embed the php within the html, everything i've tried has failed so far. Once i've got this sorted i can go ahead and add the date, location fields etc. Anyone have any experience with something called Moodle at all? I have just been handed it to 'check out', I told them to 'get out'. Rw I'd like to make myself a poker software that plays itself on all sites. What I don't know is how to get the variables names that I need. I need the cards variables name and the buttons name. Any suggestion how I do it? Or if I could read the from the screen somehow. Thanks Hey guys, glad I found this forum! I have written a SMS gateway software using VB6 and would like to port to PHP. Is there a way to write it under windows OS? I m using the dio_* commands in PHP and it works, but I dont want to do infinite loop to read incoming sms... right now I do infinite loop until I received +CMTI and the while loop breaks. This is very redundant and costly, is there any way that PHP has a "timer" feature-like in VB6 to check on incoming sms, like say, every second? Thanks guys! This topic has been moved to Miscellaneous. http://www.phpfreaks.com/forums/index.php?topic=349065.0 This will be somewhat of a brain dump with somewhat vague questions. To summarize it right now, something about "refactoring software" has been bugging me. The length of the process, the work it takes, and the time, and the "no immediately visible results" that it produces.
There have been numerous questions on "do I refactor or rewrite". Depending on circumstances, one choice may work better than another, although historically for working projects (projects people are using continuously), refactoring seemed to do better, since it does not break things as much as rewriting does. And when things break all at once, such as when introducing a rewrite (which most likely has different behavior, UI, feel, workflow, etc. etc.), people tend to get upset. Well, refactoring seems to smooth out the 'upsetness' over a much longer period of time. People change as software changes, and each change is not as abrupt as with a rewrite. There are books written about refactoring software. That process takes time and work, `while not changing the functionality of the software`. Little improvements can be done here and there, but the main point becomes improving the internals of the software without affecting the outside behavior, the user experience. From the business end, *there are no changes!*. We have developers *doing busy work* without showing anything to the business, until perhaps much later. Is that bad? Where I work, I have business people scoff at "what have we been doing" quite regularly, and saying things like "add convertion from one unit system to another? Just put it in!" Which ends up me staring into vastness of legacy code and taking 2-3 weeks to "put it in", what in someone's mind takes a day at the most. But that's cuz maybe I'm slow, but I chose to refactor relevant code first, at least moving View items into respective view containers as a first step. What is the purpose of refactoring software? What, per se does it make better? What expectations can be set? What do I do next time someone says "it is taking too long", other than saying ... cuz I am refactoring! Hello,
I'm looking for server management software, preferably free or low cost. I did some googling but could not come up with a good solution for what I need. I manage a small data center and currently keep all server information (IPs, Rack ID, Client ID, etc) in an excel sheet. Does anyone know of something that I can manage the server information more efficiently?
Thanks
I previously used https://www.phpdoc.org/ (not sure about the part 2 part) but got out of the habit. Wish to change, but had more installation problems than expected. Is it still considered a good solution? If so, any recommendations whether I should install using pear, phar, or other? Thanks I am working on an application and part of the requirements is to restrict the number of users that can log in based on a license. So on install, I will provide a license that allows for 10 user accounts to be created.
If the client requires 50, a different license will be provided that allows 50.
Regards Title: Software Developer Support Lead
About Us:
We are a small, rapidly growing software company based in Wilmington, NC. Our mission is simple: help companies, cities, and school systems save money in bulk fuel acquisition and managing their fleets of vehicles. We are in the fuel industry and we want transparency. We have a diligent, diverse team, which enjoys challenges and the joy of extracting our best in our daily work life.
Who We Are Seeking:
A charismatic individual to serve as a first line of defense for our software team's most valuable product. Ideally you would be happiest when making others happy, especially as it relates to solving elusive problems in code, or logic in a large, web application. If you have high expectations of your work, and that of others, and seek to solve problems at their core, this will be a good fit for you. We strive to deal with difficult problems today so that tomorrow will be a better place.
About The Position:
You will be the primary point of contact between our Operations and Development teams--this means you will have to help refine problems, research code, develop and apply rock-solid solutions, and work well with others in the process. In short, you will be coding, but you will also plan, weighing many potential outcomes, and test the result. You will need to know Linux, MVC frameworks, PHP, MSSQL/MySQL and have a desire to learn: both about technology and from our experiences.
General:
B.S. in Computer Science, or comparable
comfortable in PHP, MySQL/MSSQL, Javascript, jQuery
familiarity with any web framework (Yii experience preferred)
excellent communication skills
explain what is on your mind: with words, pictures, metaphors, UML, etc.
1 or more years of experience desired
Helpful Characteristics:
daily user of Linux (Arch, Fedora, CentOS, for example)
familiarity with vim, tmux
personality traits which would be helpful
methodical in nature
willingness to learn
desire to please
re-enforcing standards, rather than "just get the job done"
ability to work with a team
"Pair Programming" is a daily practice
regular code reviews
group project planning
plan first, act later
asking questions is considered a strength
highly communicative in nature
work with Operations Team to refine the actual problem
determine the source of the problem
propose solution to Software Architect
implement a solution
Please email résumé and cover sheet to development@goenergies.com.
This topic has been moved to Miscellaneous. http://www.phpfreaks.com/forums/index.php?topic=311981.0 This topic has been moved to Miscellaneous. http://www.phpfreaks.com/forums/index.php?topic=306605.0 I Need help Integrating An Video Upload System Into The Mybb Forum Software. I understand You Need ffmeg +jwplayer ive already installed that on my server.But Now I Need A Little Help Integrating And Uploader Into The Software, So It Can Post The Video Into An Thred When My Users Upload. Hello I am a total beginner and don't know first thing about php, but still trying to figure this out. So what I am trying to achieve is, send a http request from a software to my website with a ticket number, is it possible in php to receive that request and show it on a different webpage of the same site? It would be helpful if you can point me to some related articles. |