Search DaniWeb - php-mysql

Re: which language do i start leaning in 2025 4 Weeks Ago by Dani …? You will need a backend language such as PHP and a database such as MySQL. I see you also tagged this topic… Multiple MySQL connections + transactions 1 Month Ago by Dani … will work. From within my PHP script, can I write to a database using a MySQL connection in the middle of a… Re: Multiple MySQL connections + transactions 1 Month Ago by Salem …/manual/en/mysqli.select-db.php I think the key word in all of this is &… Re: Multiple MySQL connections + transactions 1 Month Ago by Dani A slightly related question: Is it okay to use PHP's `mysqli::select_db()` function to switch databases in the middle … Re: Multiple MySQL connections + transactions 1 Month Ago by Dani I am already using multiple MySQL connections throughout the project, as well as select_db() in some other places. My question specifically revolved around if anyone can explain why select_db() implicitly committed the transaction, and then when done again to return back to the initial database, it did a rollback instead of commit. Re: Multiple MySQL connections + transactions 1 Month Ago by Reverend Jim As far as I know you can connect to more than one database at a time but you require a separate connection object for each one. Since queries go through the connection object you can't run a query on more than one db at a time. It seems to me that transactions are also connection based so you would have to manually roll back a transaction on A if … Re: Multiple MySQL connections + transactions 1 Month Ago by Reverend Jim In that case I can't suggest anything. I've never had to update multiple databases for any of the systems I set up. Re: Multiple MySQL connections + transactions 1 Month Ago by toneewa You're not suppose to switch databases with a connection mid-transaction. It's by design to rollback because it considers it a change to the session context. XA Transactions can be done if you use the InnoDB storage engine. Create separate PDO connections for each database. I wonder what kind of results you get with autocommit, serializable … Re: Multiple MySQL connections + transactions 1 Month Ago by Dani > If the databases are on the same server and use InnoDB, you can use fully qualified table names, and write to multiple databases on a single connection. That's what I ultimately started doing instead! Thank you so much for a definitive answer to my question. PHP, MySQL & ajax with data on default page 12 Years Ago by johns1982 PHP, MySQL & ajax with data on default page … http://www.daniweb.com/web-development/php/threads/372465/multiple-input-filtering-php-mysql-ajax#post1817022 using code posted by vibhaJ… http://www.w3schools.com/php/php_ajax_database.asp <… php mysql simple form help 14 Years Ago by Xufyan php mysql simple form help whats wrong …text field here is my code [CODE]<?php $name=$_POST['name']; mysql_connect("localhost"…lt;form method="POST" action="<?php echo $_SERVER['PHP_SELF']; ?>"> <…GO"> </form> <?php mysql_query ("INSERT INTO example (name) VALUES('$name… php mysql help 20 Years Ago by androstendione hi im new to php/mysql i have developed a code in asp and converted it to php with asp2php programme. the original … new solution will be a iis php mysql. mysql server works fine iis works fine however the php wont let me connect to the… mysql database i have created..when i connect… Re: php mysql help 20 Years Ago by androstendione …php mysql in php.ini also libmysql.dll is located in c:\windows this is the error from the index.php (phpmyadmin) cannot load mysql… extension, please check PHP Configuration Documentation aside … required with a compatable php/mysql config rather than on a php version that requires a… php mysql 15 Years Ago by jyotidagia could someone point out the error in the followin php/mysql code [code=php]$strSearchVal = $_GET['q']; //database connection.. //... $strSQL = "SELECT DISTINCT area… PHP MYSQL 11 Years Ago by son jo Show me example design PHP/MySQL application involves insert, view, search, delete, update/modify a record from a database Php/MYSQL form ...data insertion and user id retrivel 14 Years Ago by zia zia Hello Guys... I'm a novice in both php/mysql. I'm creating an application and have many…in mind that I am a novice in both php/mysql so please use simple terms to explain. I'm…[CODE] <?php $host="localhost"; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name="… php mysql and pdo 15 Years Ago by whiteyoh … i am to OO. [code]<?php /*** mysql hostname ***/ $hostname = 'localhost'; /*** mysql username ***/ $username = 'root'; /*** mysql password ***/ $password = 'root'; try { $dbh… = new PDO("mysql:host=$hostname;dbname=mysql", $username, $password); /*** echo a message saying we… PHP MySQL Module Generator - Guys Please take a look. It might help you =) 14 Years Ago by MooGeek …kinda new here and lately I'm developing a[B] PHP MySQL Module Generator[/B] that will help us to easily … [url]http://easycode.unoprojects.com/index.html[/url] [B]PHP and MySQL Module Maker[/B] This tool help Developers to create… PHP and MySQL functions in a table such as adding, editing, deleting,… PHP/MySQL errors:-mysql_num_rows(): and mysql_fetch_array(): 16 Years Ago by AliHurworth … I'm struggling to get a relatively simple PHP/MySQL script to work. Basically, I've got …table [icode]mysql_num_rows(): supplied argument is not a valid MySQL result resource [/icode] and [icode]mysql_fetch_array(): supplied …argument is not a valid MySQL result resource [/icode] Now, I get that this … PHP MySQL Booking / Schedule Component 14 Years Ago by scofro …all, I'm looking for some help with a PHP / MySQL scheduling component that our website users will use to …lt;/tr>\n"; } ?> I have a MySQL table called servicearea_dates that is constructed like this: scheduleID, int… by the user. I would like to query the MySQL table for all matches to 'areaCode' up to 60… PHP/MySQL errors:-mysql_num_rows(): and mysql_fetch_array(): 16 Years Ago by AliHurworth … I'm struggling to get a relatively simple PHP/MySQL script to work. Basically, I've got …table [icode]mysql_num_rows(): supplied argument is not a valid MySQL result resource [/icode] and [icode]mysql_fetch_array(): supplied …argument is not a valid MySQL result resource [/icode] Now, I get that this … PHP MYSQL UPDATE 12 Years Ago by singularity~ … to update multiple rows in my database using php and mysql. Here is my php mysql statment: $sql = "UPDATE book_store SET". "… version for the right syntax to use near '= 'PHP and MySQL Web Development', isbn = '0672329166', price = '34.43', quantit' at line … PHP/Mysql Flash problem !!!!1 18 Years Ago by phoenix211984 … trying to write my own php mysql banner advertising system. i have written imported images to the mysql table and i have got… the php code to return normal images files e… how to get the flash image with headers into a php webpage in dreamweaver. i guess the other way of doing… PHP-MySQL: Registration, Leave Request, Inventory Information, etc... 18 Years Ago by srimks … & Date of Travels. I am using PHP-v4.4.4(Win32) & MySQL-v4.0.16 on my Windows XP system… need to integrate with SharePoint 2003 as SharePoint supports both PHP & MySQL. Would anyone like to share resources freely with source… PHP MySQL - Top 50 Rows Between... 14 Years Ago by digiplaystudios Hi There, I currently have a PHP/MySQL query script which displays the top 50 MySQL rows in the table, however, it displays the…-2010 |4 | search 4 |05-29-2010 -------------------------------------[/CODE] My current PHP/MySQL script looks like this (the script that grabs the top… PHP/MySQL chat bot 14 Years Ago by spectralbat Hi guys, I'm in the process of learning PHP. I know the dribs and drabs and can kind of … for a long time and would love to develop a PHP/MySQL chat bot as a learning project for myself. I'd… issue with the former. Is this at all possible with PHP and MySQL or am I getting in too deep here? I… php mysql search with dropdown list 13 Years Ago by sjeggels …I am looking for help to code a php mysql search form with 4 dropdown list. I want… herewith my code so far: <?php include 'dbc.php'; include 'classes/selectbox.php'; ?> <!DOCTYPE html PUBLIC…;>*</span><br /> <?php $mybox = new SelectionBox(); //This is the name… PHP/MySQL Programming 19 Years Ago by cputek2k I bought a book called PHP/MySQL Programming for the absolute beginner by Andy Harris, Premier Press. … refresher on HTML and then goes step by step into PHP and MySQL. Great examples and VERY challenging "homework" assignments… php mysql problem 18 Years Ago by wlinda I've been having this php/mysql problem that I can't seem to be able to …fix. I'm displaying information from a mysql database on my site, but for some of the variables… empty ones are not the ones of concert in the php script, only the one that does sometimes have content and… php/mysql syntax to search for 3 user options 15 Years Ago by pabzzmike hello all, i need help with php/mysql syntax that will search a mysql dbase using 3 user-provided (from web form) options. All… options are contained in drop-down menus. the mysql database has an auto column which is the primary key…