Выполнение запросов к базе данных
рейтинг: 9.2/10, голосов: 12
Из всего разнообразия методов класса JDatabase самым основным является query(). Он выполняет запросы напрямую в базу данных, без дополнительных вмешательств со стороны Joomla.
Обычная функция PHP mysql_query обычно вернет ссылку на ресурс, который потом с помощью нескольких действий можно преобразовать в нормальный ответ в виде ассоциативного массива. Метод query(), в отличие от функций PHP, вернет булево значение, по которому можно понять выполнился запрос или нет. Обычно его используют в следующих типах запросов:
- DELETE
- INSERT
- RENAME
- REPLACE
- UPDATE
Хотя никто не запрещает писать там что-нибудь и посложнее. Разберем выше сказанное на практике. Попробуем к примеру выполнить запрос, который удаляет из таблицы «#__mycomponent_foobars» все записи, где ordering больше 4.
// берем ссылку на объект базы данных
$db =& JFactory::getDBO();
// подготовка имен
$tableName = $db->nameQuote('#__mycomponent_foobars');
$columnName = $db->nameQuote('ordering');
// строим SQL
$sql = "DELETE FROM $tableName WHERE $columnName > 4 ";
// предварительно устанавливаем текст запроса
$db->setQuery($sql);
// выполняем запрос и в зависимости от ответа выполняем соответствующее действие
if ($db->query()) {
// успешно выполнился
} else {
// неудача (например, ошибка в синтаксисе SQL)
}
Так, как в случае неудачи мы получим FALSE, то после проверки запроса можно сделать вывод ошибок, например в log-файл.
Очень полезным может оказаться метод JDatabase::getAffectedRows(), который вернет количество строк, к которым был применен последний запрос. Используется следующим образом:
// в случае успеха
$affectRowCount = $db->getAffectedRows();
// выводим сообщение
echo JText::sprintf('DELETED %u RECORDS', $affectRowCount);
т.е получается что по ссылке запустится модуль, а модуль снова вернет нас к ссылке?
You are so cool! I do not suppose I have read anything
like this before. So nice to find someone with a few genuine thoughts on this subject.
Seriously.. thanks for starting this up. This site is one thing that's needed on the web, someone with a little originality!
Hello i am kavin, its my first occasion to commenting
anyplace, when i read this paragraph i thought i could also create comment due to
this sensible piece of writing.
My partner and I stumbled over here from a different
page and thought I might as well check things out.
I like what I see so now i'm following you. Look forward
to checking out your web page for a second time.
Quality articles or reviews is the main to
invite the viewers to visit the site, that's what this website is providing.
What's up, yup this post is truly pleasant and I have learned lot
of things from it regarding blogging. thanks.
I think everything composed was very logical. But, what about this?
suppose you typed a catchier post title?
I mean, I don't want to tell you how to run your blog, but suppose you added a
title that makes people want more? I mean Выполнение запросов к базе данных / Работа с базой данных .:.
Документация Joomla! CMS is a little boring.
You ought to look at Yahoo's front page and see how they write post headlines
to grab viewers to open the links. You might add a
video or a pic or two to get readers excited about
everything've written. In my opinion, it could bring your posts a little livelier.
naturally like your web site however you need to check the spelling on several of your posts.
A number of them are rife with spelling issues and I find it very
bothersome to tell the truth then again I'll surely
come back again.
Hi there to all, how is everything, I think every one is getting more
from this web site, and your views are pleasant designed for new people.
What's up everyone, it's my first pay a quick visit at this
website, and post is really fruitful designed for me,
keep up posting these types of posts.
Thanks , I have just been looking for info approximately this topic for a while and yours is the
greatest I have discovered till now. However, what about the conclusion? Are you certain in regards to
the source?
Master The Curriculum Time Difference Between Feet And Meter In Poetry
Froebel Public School Cutting For Stone Genre
English Language And Literature Journal Super Teacher Reading Comprehension
Physics For Scientists And Engineers Review To Kill A Mockingbird Litcharts Chapter 13
Polytechnic Admission Test 2019 Assam Emotional Intelligence 2.0 Self Management Strategies
Octavia Butler Net Worth Free Audio Books Online Download Harry Potter
Wow! This blog looks exactly like my old one!
It's on a entirely different subject but it has
pretty much the same page layout and design. Outstanding choice of colors!
0mniartist asmr
Right here is the right webpage for anybody who really wants to understand this topic.
You understand a whole lot its almost hard to argue with you (not that
I really would want to…HaHa). You definitely put a new spin on a topic which has been discussed for ages.
Excellent stuff, just wonderful! asmr 0mniartist
Very descriptive article, I enjoyed that bit. Will there be a part
2? asmr 0mniartist
Keep this going please, great job! asmr 0mniartist
whoah this weblog is excellent i love reading
your articles. Stay up the good work! You know, a lot of persons are searching round for this information, you could help them greatly.
0mniartist asmr
Good Books To Read With Your Mom Red White And Royal Blue Review
Z Words In The Lion The Witch And The Wardrobe
The Westing Game Jake Wexler
Interesting Science Articles For Middle School John Green Books
Online Shopping
Plato Republic Literature Autobiography Usain Bolt
I enjoy what you guys tend to be up too. This sort of clever work and exposure!
Keep up the fantastic works guys I've incorporated you guys to my own blogroll.
Wow, great blog article.Really thank you! Really Great.
cccc nursing application deadline role of teacher
as a counsellor
https://100bestczbooks.blogspot.com
pomona college dorms reddit lava my z customisation
https://bestczreada.blogspot.com
Wow, amazing weblog format! How lengthy have you ever been running a blog for?
you make blogging glance easy. The full glance of your website is wonderful, let alone the content material!
I am regular visitor, how are you everybody? This paragraph
posted at this web page is truly good.
Hello my friend! I wish to say that this post
is amazing, great written and include approximately
all vital infos. I would like to look more
posts like this .
Hurrah, that's what I was seeking for, what a stuff!
present here at this web site, thanks admin of this site.
Its like you learn my mind! You seem to know so much approximately
this, like you wrote the e book in it or something.
I believe that you just could do with a few % to pressure the message house a bit, but other than that, this is magnificent blog.
An excellent read. I'll certainly be back.
I’m not that much of a online reader to be honest but your
sites really nice, keep it up! I'll go ahead and bookmark your website to come back later.
Many thanks
We are a bunch of volunteers and starting a new scheme
in our community. Your website provided us with valuable
info to work on. You have performed a formidable task and our whole community shall be thankful to you.
It's not my first time to go to see this website, i am visiting
this website dailly and take pleasant facts from here every day.
If some one desires to be updated with hottest technologies afterward he must be go to see this website and be up to date everyday.
I was recommended this website by my cousin. I am not sure whether this post is written by him as nobody else know
such detailed about my trouble. You are amazing!
Thanks!
Hello my loved one! I wish to say that this post is amazing, nice written and come
with approximately all vital infos. I would like to peer more posts like this .
This site truly has all the information I needed concerning this
subject and didn't know who to ask.
You are so interesting! I don't suppose I've read
through a single thing like this before. So great to
find someone with genuine thoughts on this subject. Seriously..
thanks for starting this up. This website is
something that's needed on the internet, someone with a little originality!
Hello! Do you use Twitter? I'd like to follow you if that would be ok.
I'm undoubtedly enjoying your blog and look forward to new posts.
You've made some decent points there. I looked
on the web for more information about the issue and found most individuals
will go along with your views on this website.
When someone writes an post he/she retains the
image of a user in his/her mind that how a user can understand it.
Thus that's why this article is outstdanding.
Thanks!
Currently it sounds like Movable Type is the top
blogging platform out there right now. (from what
I've read) Is that what you are using on your blog?
Yes! Finally something about a.